欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
MariaDB
您可以在Wikipedia上了解到此条目的英文信息 MariaDB Thanks, Wikipedia. |
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版本上.
目录 |
新闻
- Google 已将 MySQL 迁移 MariaDB。
- 维基百科正式从MySQL迁移到MariaDB数据库 2013.04
- Wikipedia数据库开始从MySQL迁移到MariaDB 2012.12
自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 安装 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
Cassandra
MariaDB的Cassandra存储引擎,允许MariaDB通过标准SQL语法使用Cassandra集群。
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'
书籍
链接
- MariaDB官网
- MariaDB商业
- MariaDB Launchpad
- MariaDB KnowledgeBase
- MariaDB Wiki
- MariaDB Blog
- MariaDB WorkLog
- MariaDB JIRA
- Monty Program
- SkySQL
<discussion>characters_max=300</discussion>