{"id":2348,"date":"2014-02-24T08:34:29","date_gmt":"2014-02-24T13:34:29","guid":{"rendered":"http:\/\/blog.funio.com\/en\/?p=2348"},"modified":"2014-02-24T10:22:10","modified_gmt":"2014-02-24T15:22:10","slug":"we-like-our-databases-open-mariadb-replaces-mysql","status":"publish","type":"post","link":"https:\/\/blog.funio.com\/en\/2014\/02\/we-like-our-databases-open-mariadb-replaces-mysql\/","title":{"rendered":"We Like Our Databases Open: MariaDB Replaces MySQL"},"content":{"rendered":"

Since December 5th 2013, we have been replacing MySQL with MariaDB. This may seem like a sudden modification, but in fact, we have been contemplating this switchover for a while, and finally took the opportunity to do the seamless replacement at the same time we upgraded PHP<\/a> on all our servers.<\/p>\n

Why MariaDB?<\/h2>\n

First, a bit of history: in April 2009, Oracle acquired Sun Microsystems (the company who owned MySQL). Uncertainty brewed in the developer community, which led the original founder of MySQL and a strong open-source believer, Michael “Monty” Widenius, to create a “drop-in” replacement called MariaDB. Therefore, the initial goal of MariaDB is to be 100% compatible with MySQL, and then add new features, clear up bugs (as usual) and improve performances.<\/p>\n

Secondly, Funio has been setting up servers for many years now, and unfortunately we could not always keep the MySQL version up to date on our older servers. With the implementation of MariaDB, all our servers are now standardized with the same, most recent production ready version of MariaDB (5.5).<\/p>\n

No Impact<\/h2>\n

For our customers, this switchover means no impact, no behavioural change and nothing lost. Our everyday shared hosting customers will probably never notice the change, especially since MariaDB is a drop-in replacement of MySQL, which means that it responds to the same calls, architecture and programming.<\/p>\n

We’ve already rolled out the switchover to MariaDB; have you noticed any negatives or positives?<\/p>\n

But Really\u2026 Why Switching?<\/h2>\n

Because we have a use for MariaDB features, especially when it comes to performance. If database performances are superior, our customers also benefit from the change. Here are some of the elements we considered and convinced us to go forward:<\/p>\n