What are the benefits of switching from MySQL to mariadb?
Reply content:
What are the benefits of switching from MySQL to mariadb?
Why would you change it? MySQL is now the world's largest database vendor Oracle responsible for maintenance development, the prospects are very good, ranked second only to Oracle:
Http://db-engines.com/en/ranking
If Oracle shuts down MySQL, it will only make mariadb and Percona smooth. Oracle has been painstaking for so long that it's not so stupid.
However, some people are worried, so Redhat from RHEL7 began to replace MySQL with MARIADB. Facebook/google/linkedin/twitter/alibaba is a co-maintained open source MySQL branch Webscalesql:
Https://github.com/webscalesql
Before MySQL was nationalized Oracle, Oracle had acquired the InnoDB engine, and Percona server's improved xtradb was also based on InnoDB.
Linux on Percona is a good choice, following the official MySQL version, in addition to improving MySQL, but also to absorb community patches. For example xtradb is Percona for InnoDB, Percona also provides a built-in tokutek development of large data transaction storage engine TOKUDB version. Percona also offers some of the enterprise-class MySQL OPS tools, such as Percona-toolkit, and InnoDB, xtradb hot Backup tool xtrabackup, Zabbix templates, and more.
MySQL is again lost: After Wikipedia, Google also migrated to MARIADB:
Http://www.csdn.net/article/2013-09-16/2816944-google-mariadb-mysql-mi ...
The general advantages are as follows:
Free commercial Use (MySQL is the Community Edition and Enterprise Edition, thanks to Oracle)
Maria Storage Engine
PBXT Storage Engine
XtraDB Storage Engine
Federatedx Storage Engine
Faster replication Query Processing
Thread pool
Run faster
More extended function Modules
Support for Unicode sorting
Migration reference: http://cnzhx.net/blog/mysql-migrate-to-mariadb/
There's also a cluster solution MariaDB Galera Cluster interested in and can expand the learning
CENTOS7 directly built-in mariadb, and the same syntax
Centos7 the default to replace MySQL with MARIADB.
I do not want to toss, since the default is this, I used ...