Take the tour ×  Question has been asked before about how to
synchronize files as well as the database between two Wordpress
installations.  For the database level, the answer is usually to
basically dump one database and insert it onto another server.
The problem with this is that you end up losing any changes that
have potentially been made on the prod server. For instance,
usage metrics, comments, etc...  With this in mind, I was
starting to wonder whether the it would be possible to extend
the Wordpress ORM so that you can generate deltas and then
inject those into the prod site.  Has anyone tried this, looking
into it, or have any ideas or comments ?  share|improve this
question I have looked into it, yes, but haven't accomplished
much. If you could point to a proof-of-concept with another CMS
platform, I'm sure we could rejigger it for WordPress. –  EAMann
Jul 29 '11 at 15:36 How about replication? –  kovshenin Aug 2
'11 at 12:38 Well replication with mysql would require some form
of master-master repli