This site is now 100% read-only, and retired.

Have you any experience with MariaDB?

Posted by Steve on Tue 25 Jun 2013 at 09:35

Recently there have been many alternatives presented to MySQL, with MariaDB looking like a great alternative due to its drop-in nature, and increased performance.

Have any of our readers used this in large scale deployments? I'd be curious to know if it lives up to the hype and does indeed perform well.

This site uses a pair of MySQL servers running in a Master-Slave deployment, and I aim to upgrade them shortly. Initially I'll update the slave, and if all proceeds well the master.

Although the site is "busy" the databases are no longer the single point of contention so I suspect I'll not notice any significant improvement although I will be keeping an eye upon the load graphs just to be sure that things aren't immediately worse.

I do manage some very large and heavily loaded MySQL instances but as they're so large they're precisely the ones I can't mess around with arbitrarily. So testing at scale is a little hard, and any feedback from users would be useful to hear.



Re: Have you any experience with MariaDB?
Posted by Anonymous (190.183.xx.xx) on Wed 26 Jun 2013 at 21:53
For me, worked as promised: drop-in replacement.
Is in use in online medical prescription authorization, with hundred of transaccion by minute. The real improvement is in the auduting process that involves large listings coming from some MONSTRUOUS querys that now (finally) are processed by al cores.

[ Parent ]

Re: Have you any experience with MariaDB?
Posted by Anonymous (113.71.xx.xx) on Fri 5 Jul 2013 at 08:17
I prefer postgresql. I've found it to be more robust in that it's far less likely to suffer from strange performance quirks that are a huge pain and resource drain to track down.

If you've got apps that are specifically developed and tested around mysql and mariadb, that's great, go ahead and use it..

But if you're running apps that are tested and built around something like Oracle's DBMS, Microsoft SQL, or whatever else, and you migrate to something like MySQL/mariaDB, the performance quirks of MySQL/mariaDB are enough to make you go absolutely nuts.

I've found postgresql to be *FAR* more friendly to migrate to for apps written around other dbms software. As long as your db indexes are sane, you can expect pretty consistent performance with postgresql.

[ Parent ]

Re: Have you any experience with MariaDB?
Posted by Anonymous (24.104.xx.xx) on Mon 8 Jul 2013 at 19:00
Its a drop in replacement, but I found some of the MySQL Workbench stuff worked only about 95%. (Mainly the MySQL administrative stuff had some hickups.) Also, I want a recent benchmark with MariaDB latest stable and MySQL latest stable done. (I haven't this yet, maybe I just didn't look hard enough.) It does sound great if Oracle is going to be evil with MySQL though.

[ Parent ]