[wp-hackers] Percona Server and WordPress

[Kevinjohn Gallagher]

[people don't like it when i actually write things, so here's links with answer to your questions]

http://monty-says.blogspot.com/2009/02/time-to-move-on.html
http://www.theregister.co.uk/2009/12/29/save_mysql_campaign/
http://kb.askmonty.org/en/mariadb-versus-mysql
I also found this interesting:
http://www.odbms.org/blog/2011/09/mariadb-the-new-mysql-interview-with-michael-monty-widenius/



> Date: Fri, 9 Mar 2012 11:22:02 -0500
> From: wp-hackers at thecodecave.com
> To: wp-hackers at lists.automattic.com
> Subject: Re: [wp-hackers] Percona Server and WordPress
> 
> 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 :)
> >
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers