How can I sync a database driven website to a different server

Posted by tbrandao on Stack Overflow See other posts from Stack Overflow or by tbrandao
Published on 2010-04-02T14:23:08Z Indexed on 2010/04/02 15:03 UTC
Read the original article Hit count: 245

I have a website using cPanel on a dedicated account, I would like to be able to automatically sync the website to a second hosting company or perhaps to a local (in house ) server.

Basically this is a type of replication. The website is database driven (MySQL), so Ideally it would sync everything (content, database, emails etc.) , but most importantly is syncing the website files and its database.

I'm not so much looking for a fail-over solution as an automatic replication solution, so if the primary site (Server) goes off-line, I can manually bring up the replicated site quickly.

I'm familiar with tools like unison and rsync, but most of these only sync file(s) and do not do too well with open database connections.

© Stack Overflow or respective owner

Related posts about server

Related posts about cpanel