MariaDB

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
(Cassandra)
(链接)
(未显示1个用户的21个中间版本)
第71行: 第71行:
 
  brew update
 
  brew update
 
  brew upgrade mariadb
 
  brew upgrade mariadb
 +
 +
==解决方案==
 +
[[文件:MariaDB-Galera-Cluster.png|right]]
 +
*[https://mariadb.com/products/solutions/oltp-database-tx MariaDB TX] for [[OLTP]]
 +
*[https://mariadb.com/products/solutions/olap-database-ax MariaDB AX] for [[OLAP]]
 +
*[https://mariadb.com/kb/en/mariadb/what-is-mariadb-galera-cluster/ MariaDB Galera Cluster]
 +
*[[Galera Cluster]] [https://github.com/codership/galera Galera @ GitHub]
 +
*[https://www.howtoforge.com/tutorial/how-to-setup-haproxy-as-load-balancer-for-mariadb-on-centos-7/ How to setup HAProxy as Load Balancer for MariaDB on CentOS 7]
  
 
==Cassandra==
 
==Cassandra==
[http://www.infoq.com/cn/news/2012/11/Cassandra-SE MariaDB的Cassandra存储引擎],允许MariaDB通过标准SQL语法使用[[Apache Cassandra|Cassandra]]集群。
+
*[https://mariadb.com/kb/en/library/cassandra/ MariaDB Cassandra Storage Engine]
 +
*[http://www.infoq.com/cn/news/2012/11/Cassandra-SE MariaDB的Cassandra存储引擎],允许MariaDB通过标准SQL语法使用[[Apache Cassandra|Cassandra]]集群。
 +
 
 +
==Amazon==
 +
*[https://aws.amazon.com/cn/rds/mariadb/ Amazon RDS for MariaDB]
  
 
==管理==
 
==管理==
 +
*[[Sequel Pro]]
 
*[[HeidiSQL]]
 
*[[HeidiSQL]]
 +
*[[DBeaver]]
  
 
==[[.NET]]==
 
==[[.NET]]==
第108行: 第122行:
 
==书籍==
 
==书籍==
 
*[http://www.amazon.cn/gp/product/B00V4B2L0Q 《MariaDB原理与实现》]
 
*[http://www.amazon.cn/gp/product/B00V4B2L0Q 《MariaDB原理与实现》]
 +
 +
==用户==
 +
*[http://tdsql.org/ TDSQL]腾讯金融级分布式数据库
 +
*[http://galeracluster.com/2017/06/china-mobile-intel-deploy-galera-for-1000-node-openstack-cloud/ China Mobile & Intel Deploy Galera for 1000-Node OpenStack Cloud] [http://galeracluster.com/2017/04/39-of-openstack-users-run-galera-cluster-in-production-for-openstack-components-according-to-recent-survey/ 39% of OpenStack users run Galera Cluster in production for OpenStack components according to recent survey]
 +
 +
==图集==
 +
<gallery>
 +
image:mariadb-foss-success.png|MariaDB Foundation
 +
image:MariaDB-TX-for-OLTP.png|MariaDB TX for OLTP
 +
image:MariaDB-AX-for-OLAP.png|MariaDB AX for OLAP
 +
image:MariaDB-Galera-Cluster-on-OpenStack-April-2017.png|OpenStack
 +
image:mariadb-cassandra-storage-engine.png|Cassandra存储引擎
 +
</gallery>
  
 
==链接==
 
==链接==
第114行: 第141行:
 
*[https://github.com/MariaDB/server https://github.com/MariaDB MariaDB @ GitHub]
 
*[https://github.com/MariaDB/server https://github.com/MariaDB MariaDB @ GitHub]
 
*[https://launchpad.net/maria MariaDB Launchpad]
 
*[https://launchpad.net/maria MariaDB Launchpad]
*[http://kb.askmonty.org/ MariaDB KnowledgeBase]
+
*[https://mariadb.com/resources/blog/ Official MariaDB Blog]
*[http://askmonty.org/wiki MariaDB Wiki]
+
*[https://mariadb.com/kb/ MariaDB KnowledgeBase]
*[http://askmonty.org/blog/ MariaDB Blog]
+
*[http://askmonty.org/worklog/ MariaDB WorkLog]
+
 
*[https://mariadb.atlassian.net MariaDB JIRA]
 
*[https://mariadb.atlassian.net MariaDB JIRA]
 
*[http://montyprogram.com/ Monty Program]
 
*[http://montyprogram.com/ Monty Program]
第126行: 第151行:
 
[[category:database]]
 
[[category:database]]
 
[[category:c++]]
 
[[category:c++]]
 +
[[category:huihoo]]

2020年8月6日 (四) 15:51的版本

Wikipedia-35x35.png 您可以在Wikipedia上了解到此条目的英文信息 MariaDB Thanks, Wikipedia.
Mariadb-90x90.gif

Mariadb, a MySQL branch with the Maria storage engine

MariaDB is a community developed branch of MySQL. It's a branch of MySQL (ie, we are keeping our code in sync with MySQL) and contains in addition the Maria storage engine, updated version of other storage engines and extensions.

版本策略:目前所有MariaDB发行版都基于 MySQL 5.1. 当 MySQL 5.5 或 MySQL 5.6 变成 RC , 将切换到 MariaDB beta 版并基于RC版本上.

Mariadb-mysql.jpg

目录

新闻

自http://blog.mariadb.org/feed/加载RSS失败或RSS源被墙

10.1

10.0

5.5

MariaDB 5.5.30 包含 MariaDB 5.3.12 和 MySQL 5.5.30

5.4

5.3

MariaDB 5.3 将基于 MySQL 5.1 或 MySQL 5.6

5.2

MariaDB 5.2 基于 MySQL 5.1

主要的新功能有:

  • Storage-engine-specific CREATE TABLE
  • Pluggable Authentication
  • Segmented Key Cache; Speeds up MyISAM tables a LOT!
  • Extended User Statistics
  • Virtual Columns
  • New storage engines: OQGRAPH and Sphinx.
  • Speed optimizations

5.1

MariaDB 5.1 基于 MySQL 5.1

主要的新功能有:

  • XtraDB a drop-in replacement for InnoDB based on the InnoDB_plugin. This is enabled by default and gives you the speed comparable to MySQL 5.5 today.
  • New storage engines: PBXT, FederatedX (drop-in replacement for Federated) and Aria.
  • Pool of Threads: Allows you to have 100,000+ connections.
  • Table elimination: Optimizer enhancement.
  • More information in the logs for better troubleshooting.
  • Speed optimizations

OS X

brew info mariadb
brew install mariadb // 通过 Homebrew 安装, brew services start mariadb 和 brew services stop mariadb
unset TMPDIR
cd /usr/local/Cellar/mariadb/10.0.14_1/
mysql_install_db
mysql.server start
mysql_secure_installation
mysql -u root -p
MariaDB [(none)]> select @@version;
+-----------------+
| @@version       |
+-----------------+
| 10.0.14-MariaDB |
+-----------------+
1 row in set (0.00 sec)

升级

brew update
brew upgrade mariadb

解决方案

MariaDB-Galera-Cluster.png

Cassandra

Amazon

管理

.NET

MaxScale

Debian

apt-get install python-software-properties
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
add-apt-repository 'deb http://mirrors.hustunique.com/mariadb/repo/10.1/debian wheezy main'
apt-get update
apt-get install mariadb-server mariadb-client
mysql -V

选择其它仓库:Setting up MariaDB Repositories

编译

cd $maria-source-dir 
BUILD/autorun.sh
./configure
make
sudo make install
sudo chown -R mysql /usr/local/mysql/
sudo scripts/mysql_install_db --user=mysql
sudo /usr/local/mysql/bin/mysqld_safe --port=3307 --user=mysql &
./bin/mysqladmin -uroot password 'password'

书籍

用户

图集

链接

分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱