5 open source compatible solutions outside of the standard MySQL database

MySQL is one of the most popular free and open source applications, serving as the database backbone for thousands of websites. However, many developers felt the need to split it into other projects, with each branch project having its own specialization. These needs, coupled with Oracle's concerns about slow growth of the core product, resulted in the emergence of sub-projects that many developers were interested in. Projects and branches. In addition, in order to meet the needs of special business, MySQL is sometimes not fully qualified, which requires the development of new solutions. At the same time, in order to be compatible with the upgrade and maintenance of old business systems, new technical solutions are mostly MySQL-compatible solutions based on MySQL implementation. Here is a summary of the well-known MySQL-compatible solutions at home and abroad for readers’ reference. The specific contents are as follows:

1. Percona Server# of the leading MySQL consulting company Percona

##Percona Server is a database product using the XtraDB storage engine released by the leading MySQL consulting company Percona. It is developed by the original author of the XtraDB storage engine and released under the GPL open source license. It provides users with the ability to swap out MySQL installations And the ability to swap into the Percona Server product. Percona Server is fully compatible with MySQL, and developers can migrate between the two without changing any code in the software. From its official website, we learned that Percona Server has the characteristics of high scalability, high performance, high reliability, diagnosis and management. The Percona team also states that Percona Server is the version closest to the official MySQL enterprise distribution, and therefore is different from other forks that have changed a lot of the basic core MySQL code. However, one drawback of Percona Server is that Percona manages the code itself and does not accept contributions from external developers, ensuring in this way that they have absolute control over the functionality included in the product.

　2. Another work of the father of MySQL, MariaDB

MariaDB is a branch version of MySQL based on the Maria storage engine. It is a free database developed by a company founded by Michael Widenius, the author of MySQL. And released under the GPL V2 open source license. It is very similar to the Percona product, but attempts to provide more performance improvements than standard MySQL, so more underlying code changes were made. MariaDB leverages the XtraDB engine directly from Percona and also provides the standard storage engines provided by MySQL, namely MyISAM and InnoDB. Therefore, MariaDB can be considered as an extension set of MySQL, which not only provides all the features provided by MySQL, but also provides additional features. MariaDB also claims to be a MySQL replacement, so switching from MySQL to MariaDB can be done without any basic code changes.

3. WebScaleSQL of four large Internet companies

WebScaleSQL is a general branch of MySQL adapted from the MySQL 5.6 community version by Facebook, Google, LinkedIn, and Twitter, and is based on the GPL open source agreement release. WebScaleSQL is a customized version of MySQL specially created for large network companies to cope with and solve the challenges brought by massive data. This is a leap forward for MySQL technology. The WebScaleSQL project is the work of a team of MySQL engineers from these four companies, and because it is open source, other interested individuals and companies can customize it based on their own resources and scale. Facebook also announced the contributions its engineers have made to the WebScaleSQL branch, including built-in testing systems, a complete stress test suite, an automated performance testing prototype, and modified MySQL problem architecture code and performance improvements.

4. InnoSQL from NetEase

InnoSQL is a branch version of the MySQL database developed by NetEase. It is released under the GPL V2 open source agreement and the project is hosted on GitHub. The functions of InnoSQL are fully compatible with the MySQL database. Users cannot feel the difference between InnoSQL and MySQL databases at all. However, the InnoSQL database itself solves some problems that currently exist in the MySQL database, such as master-slave database synchronization inconsistency, XA distributed transaction loss, Various issues such as reduced multi-threaded connection performance. InnoSQL has the characteristics of high performance, high availability, easy operation, maintenance and management, and open source. Using InnoSQL can ensure the normal operation of data replication, maximum utilization of software and hardware resources, and stable operation of the database under high concurrent threads. According to tests by relevant people, when using the flashcache feature, InnoSQL is 5 to 6 times faster than ordinary MySQL and 2 to 3 times faster than Facebook MySQL flashcache.

5. MySQL/Galera with multi-master function

MySQL/Galera is a branch version of MySQL and is released based on the GPL open source agreement. MySQL/Galera is implemented based on the InnoDB storage engine and can be used to create synchronized multi-master MySQL (InnoDB) clusters. MySQL/Galera has true multi-master functionality, so the same table can be modified simultaneously in different nodes. MySQL/Galera also has high availability, committed transactions are never lost, read and write operations can be expanded as needed, automatic deletion of failed nodes, automatic joining of nodes, row-level concurrent replication and triggering, stored procedures and user customization Functions are transparent features.

In addition to the above open source solutions that are compatible with standard MySQL, there are also unopen source solutions such as MemSQL, which is claimed to be the world's fastest distributed relational database founded by former Facebook engineers, and Aurora, the enterprise-level relational database recently produced by Amazon.

The above is the content of 5 open source compatibility solutions outside the standard MySQL database. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!