[wp-hackers] Percona Server and WordPress

[Nicholas Ciske]

Jeremy,

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

http://thoughtrefinery.com/
nick at thoughtrefinery.com
@nciske

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