MariaDB and y SQL

Being an alternative to MySQL, its number one priority is to maintain a complete compatibility with the previous system of MySQL, so that the possible migrations of this with MariaDB are of a clean form and without problems. Added to this, MariaDB brings a number of interesting advantages:

• Advantages of MariaDB

  • New more efficient storage engines. Aria and XtraDB come to replace MyISAM and InnoDB respectively. It is worth highlighting the higher performance of Aria, when it receives complex queries and has to make temporary tables, these are cached in memory instead of being written to disk.
  • Statistics for indexes and tables that can help optimize the database. New system tables are added to collect this information.
  • In general, many improvements to increase performance and efficiency with respect to MySQL.

• Disadvantages of MariaDB

  • The migration of a very tested and reliable system such as MySQL . Although absolute compatibility is guaranteed, and a large stable and powerful system, we must assess whether today my system deserves to be transferred to MariaDB.

It’s worth moving to MariaDB

So, is it worth it ?. Each one must assess whether it is worth migrating or not. Yes, for a new project that you have planned to do in MySQL, you should think a lot if it is not better to start with the new and powerful MariaDB. If you still doubt, enter your website and delve into the new possibilities it offers.