[wp-hackers] Percona Server and WordPress

Nicholas Ciske nick at thoughtrefinery.com
Thu Mar 15 19:03:14 UTC 2012


Have you written up the config changes & process of getting MariaDB set-up anywhere? I didn't see anything on your blog, but I'd love to know what it would take to implement MariaDB on my server.

Nick Ciske
Minneapolis WordPress Development

nick at thoughtrefinery.com

On Mar 15, 2012, at 1:23 PM, wp-hackers-request at lists.automattic.com wrote:

> Message: 1
> Date: Fri, 9 Mar 2012 10:29:08 -0500
> From: Jeremy Clarke <jer at simianuprising.com>
> Subject: Re: [wp-hackers] Percona Server and WordPress
> To: wp-hackers at lists.automattic.com
> Message-ID:
> ??? <CAAHgzDOGAGr1jiUo3VxmrA-fnSe2beEBvouHSYW-rVp_Jvk1Tw at mail.gmail.com>
> Content-Type: text/plain; charset=windows-1252
> 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 :)
> -- 
> Jeremy Clarke ? jeremyclarke.org
> Code and Design ? globalvoicesonline.org

More information about the wp-hackers mailing list