Why did you change from MySQL to mariadb?

Source: Internet
Author: User
Tags percona percona server
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 ...

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.