1 / 11

MariaDB vs MySQL: Is MariaDB the same as MySQL?

When it comes to MariaDB vs MySQL, understanding the differences will help you to make the right choice on which DB suits your application best. Not only that, migrating data between these two databases needs a thorough understanding of where they differ and how. In this PPT, we will evaluate the commonalities and the areas of differentiation between the two databases.

optimizdbaca
Download Presentation

MariaDB vs MySQL: Is MariaDB the same as MySQL?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MariaDB vs MySQL: Is MariaDB the same as MySQL?

  2. Understanding The Differences Between MariaDB & MySQL • MySQL database was released in 1995, and today, it’s one of the most widely used databases by small companies and enterprises alike. MariaDB, on the other hand, is a fork of MySQL. A small group of developers decided to add more features and capabilities to the MySQL database, which MariaDB is all about. When it comes to MariaDB vs MySQL, understanding the differences will help you to make the right choice on which DB suits your application best.

  3. MariaDB Vs MySQL • Both MariaDB and MySQL are open-source software. However, MySQL has proprietary code in their enterprise edition. Even though the expectations are for these two DBs to be similar, their gap has increased over the years. 

  4. What’s still shared between MariaDB & MySQL? • The DB Protocols and the exposed APIs are same between MariaDB and MySQL. Underlying components and technologies vary, but the abstraction layer that forms the APIs has remained the same. MariaDB developers actively use core features from the MySQL database to maintain uniformity. These code merges are the reason why there are several similarities to date. 

  5. Major Differences Between MariaDB & MySQL • MariaDBcomes with three main encryption key management options. They are: file key management, AWS key management, and Eperi key management plugins. While the AWS key management comes out of the box in MariaDB, most plugins in MySQL are present only in the enterprise version.  • MySQL database comes with a powerful editor and client software called the MySQL Shell. The MySQL Shell uses the MySQL X protocol to communicate with the database which is not supported by MariaDB. Thus the shell cannot be used with MariaDB as of today. However, MariaDB supports the MySQL command line client. Most of the time, we use the CLI to connect with either of the databases. 

  6. Handling Threads  • MySQL databases come with a static number of threads that it uses to handle the queries. However the paid Enterprise version of MySQL supports thread pooling. On the other hand MariaDB is much more flexible. We get thread pool based connections by default. This enables us to execute queries much more efficiently and manage the CPU load well.

  7. Native JSON Support • The database doesn’t store the JSON as strings anymore. This is a massive advantage to MySQL in the MySQL vs MariaDB race. However MariaDB hasn’t implemented this because they argue that it doesn't add much to the query performance.

  8. Database Usage Of MariaDB Vs MySQL • MySQL is controlled by Oracle Corporation. This has led to the initiation of the MySQL Enterprise edition that offers much more capabilities than the community edition MySQL database. • MariaDB is entirely open source. Because of this, all features released by MariaDB are available to everyone free of cost. This is a very promising feature for many companies who need high flexibility with their databases. 

  9. Storage Engines • MySQL and MariaDB both support InnoDB which is one of the most widely used storage engines out there. But  it is not the only one. MariaDB for example supports XtraDB which is a fork of InnoDB but has been enhanced for performance. Overall MariaDB supports a much larger variety of database engines when compared to MySQL. 

  10. Conclusion • Both the databases are used by large enterprises.While companies like Github, Facebook, and Netflix use MySQL, companies such as Google, Wikipedia, and CregsList have chosen MariaDB server. So, both databases are powerful but cater to different needs and we need to evaluate our requirements before choosing the right one. 

More Related