[wp-hackers] Percona Server and WordPress

[Brian Layman]

Oh interesting....

I'd not heard of MariaDB before...
"MariaDB is primarily driven by developers at Monty Program, a company 
founded by Michael "Monty" Widenius, the original author of MySQL"

It's curious why these changes aren't added to the MySQL core if they 
make such a significant difference...

Brian Layman


On 3/9/2012 10:29 AM, Jeremy Clarke wrote:
> We switched to http://mariadb.org/ rather than Percona Server, but the
> underlying software is almost entirely the same, both are packages of all
> the wonderful open-source patches that just don't make it into the core
> MySQL. In either case, the really mind-blowing performance gains come from
> XtraDB, which is the replacement for the core InnoDB engine of MySQL.
>
> Preparing and implementing the switch was time consuming and there was some
> brief downtime while me and an expert figured out the config changes to
> make (there are a couple of config variables that needed changing to make
> it work right) but otherwise the transition was smooth. No WP related
> issues as far as I can tell, it's pretty much totally compatible in terms
> of actual SQL.
>
> The performance gains I got were tremendous. Load went from static around 6
> to more like 2 and stopped spiking the way it did before. Our upgrade was
> from MySQL 5.0.x. to the 5.1.x branch of MariaDB, so the actual MySQL
> upgrade could have also played a part, but the change was so drastic I
> believe it was XtraDB making the difference (the same kind of improvements
> are described for people just switching within a major MySQL branch).
>
> IMHO this is the future of MySQL. I hope the hosts of the world start
> switching :)
>