Web Hosting Talk







View Full Version : Progresive synk of mysql


kaliman
03-31-2005, 10:27 PM
Hi
I have 2 vps in different. Each one runs a dynamic site.
I'd like to syncronyze the mysql in both in a simple and economic way.
As the second site is just for backup, it can be updated every hour or something.

I hear about the synk cron jobs, but I do not know if they are incremental.

Thanks for any assistance!

error404
04-01-2005, 04:57 PM
Perhaps replication is what you're looking for, depending on how active your database is: http://dev.mysql.com/doc/mysql/en/replication-howto.html

joyfield
04-03-2005, 01:58 PM
And using MySQL replikation your databases does not have to be connected all the time. It can be disconnected and when connected again the replication will catch up.
But MySQL replication is only one way :(