Mariadb vs mysql performance

Mariadb vs mysql performanceUntitled part

performance.hansmaetaMariadb database better performance thanmysql.MariaDB is a relational database management system(RDBMS).It is a fork (an independent development on the copy of MySQL's source code)of the MySQL relational database management system. MariaDBisintended to remain free. Development is led by a community of some of theoriginal developers of MYSQL. The community had tofork MariaDB due to conflicts over itsacquisition and ownership by Oracle Corporation. The initial release was done 9years ago(2009). MariaDB is written in C, C++, Perl and Bash. MariaDB workswith a variety of operating systems which include Unix, Linux, Windows, Solaris,MacOS and BSD.On the other hand, MySQL is an open-sourcerelational database management system and is owned by the Oracle Corporation.Besides the fact that MySQL is open-source, paid editions are available. Thepaid editions are better and have additional functionalities. MySQL wasinitially released 23years ago(1995). The RDBMS is written in C, and C++ andworks on the following operating systems: FreeBSD, Solaris, macOS and Linux.MariaDB is arguably better in performancecompared to MySQL. The following are reasons and properties of MariaDB thatdeem it better in performance compared to MySqL.1.Mariadb is open to public codecontributors:Mysql hides behind largebatches post-releases which is done a relatively long time. Mysql updates arebased on contributions from only Oracle developers. The updates are closed topublic opinion and discussion. Hence, mysql's development does not benefit fromthe user's opinion or views. Mariadb on the other hand is completely open andallows contributor developers from the public. Mariadb corporation is also moreactive in producing post-releases and documentations.2.Mariadb is co-ordinated andfast in its release of security releases and upgrades:Mysql releases updates andbug fixes each two months. However, the security releases and the release fixesare made after three months. This makes the current mysql not synched with thecurrent version and makes it hard for administrators to do patch management andback porting. On the other hand, mariadb releases its security releases and fixesannouncements at the same time with its upgrade.3.Mariadb is way ahead onadditional features and updates.The latest update ofmysql; mysql 5.7 looks juicier and better with added functionalities such asthe GIS support. However, for these new features of the mysql 5.7, mariadb hasalready had versions with these features in the past.4.Mariadb has plugins and storageengines integrated in the official release:Mariadb comes with avariety of storage plugins and storage engines such as Cassandra and Connectstorage engines, Spider, TokuDB. The plugins and storage engines come as partof the official release of mariadb hence are easy to use. However for mysql, theplugins and storage engines are available as third parties hence may take timeto integrate and become hard to use5.Other better performancerelated features:Mariadb has other features that are clearly way better than those of mysql. Theseinclude: a much improved query optimizer, faster web server back-end responsesamongst other performance related features.With these reasons, mariadb has been provenin real-life situations to be better in performance compared to mysql. Mostcompanies have moved their internal and external servers to run on mariadb.