How to keep a WordPress site synchronized between two servers?

4 comments

1. I’ve been doing this successfully with csync and an NDB cluster for years…

   Re other solutions:

   • rsync works too, albeit slower. (Much, much slower; slow enough to rule out any file-based caching.)
   • InnoDB/MyIsam master/slave works too, with HyperDB. But, you’ll end up with a need to manage other stuff, namely auto-increments on write servers, if you need multiple write servers. (NDB is master/master, whereas InooDB or MyISAM cluster are designed and optimized for master/slave setups.)

   Log in to Reply

2. You can mirror the database and the file-system. For File-system you can use rsync, and for the database, for example that level 😉 http://www.mysql.com/products/cluster/

   Log in to Reply

3. This should maybe be handled on a lower level. Have your webserver run on a virtual machine and distribute the container. They call this “cloud” nowadays.

   Log in to Reply

4. Doing MySQL replication isn’t the easiest thing in the world,, and requires another server somewhere.

   I’d be tempted by something like VaultPress (http://vaultpress.com/features/), even if it doesn’t provide true hot stand-by failover.

   Log in to Reply