Ever since the MySQL 5.1 came out the MySQL have evolved. Many operations over the database have been optimized, the system for searching data has been improved to look trough smaller volumes at the same query. We reacted to this development by deploying newer versions of the MySQL database. MariaDB is a split off branch of MySQL founded by original MySQL developers. When we were deciding which database we would use, we have engaged in extensive tests of performance based on which MariaDB 10.1. has been chosen as a clear winner.
Why to use MariaDB 10.1. ?
1. It is fully compatible with MySQL 5.1.
2. It can optimize vast majority of subqueries.
3. Is equipped with better query cache – knows how to remember often used query and thus return them much faster.
4. Has higher performance in ORDER BY type of operations
5. Has Percona XtraDB ako as replacement of standard InnoDB.
MariaDB 10.1 details
1. Administration of MariaDB 10.1 (phpmyadmin): https://db101.websupport.sk/.
2. Administration MySQL databases (Adminer): http://adminer.websupport.sk/.
3. To use in php scripts for MariaDB 10.1: :/tmp/mariadb101.sock
4. MariaDB 10.1 server: mariadb101.websupport.sk, port: 3312