Menu
I was asked to check Mariadb as Centos does not provider MySQL 5.5 for the moment. I have read that xtradb servers as a drop in for innodb.
What are the advantages of using one or the other because if they were equal, they would not have been called the same name?
Do you think that I should switch to Mariadb? What kind of problems I might face in the future because of updates if any.
I know that the founder of MySQL is behind Mariadb, and Oracle is managing MySQL now. It seems a bit tricky as a tricky decision.
Thank you in advance for your opinion,
Update, I asked the question here, because google did not display any recent updates. Only some old comparisons published prior to 2012
338
InnoDB is a good general transaction storage engine, and, from MariaDB 10.2, the best choice in most cases. It is the default storage engine from MariaDB 10.2. For earlier releases, XtraDB was a performance enhanced fork of InnoDB and is usually preferred.
InnoDB has row-level locking. MyISAM only has full table-level locking. InnoDB has what is called referential integrity which involves supporting foreign keys (RDBMS) and relationship constraints, MyISAM does not (DMBS). InnoDB supports transactions, which means you can commit and roll back.
When you omit the ENGINE option, the default storage engine is used. The default engine is InnoDB in MySQL 5.7. You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my. cnf configuration file.
XtraDB is InnoDB with several patches added. The patches themselves stem from Google, Facebook and others. XtraDB is maintained by Percona and the heart of Percona Server.
You may think of Percona as a distributor who collects, coordinates and maintains patches and distributes an enhanced version of the MySQL server.
A feature comparison between stock MySQL and Percona Server can be seen here:
http://www.percona.com/software/percona-server/feature-comparison
The XtraDB engine is also shipped as default InnoDB implementation in MariaDB. MariaDB includes also stock InnoDB as pluggable storage engine, so you can chose.
Benchmarks show that XtraDB scales better on massively parallel architectures and especially XtraDB is much better suited for write-heavy workload. The InnoDB engine in MySQL 5.6 will incorporate many of the features and advantages that have so far been available in XtraDB only.
172
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
