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: 247
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