MySQL Replication

runt

2[H]4U
2FA
Joined
Mar 16, 2000
Messages
2,443
Not sure if this is the right spot but here we go. Basically, I have two VPSes. I want each one to be a backup for the other (so one is primary for one site and the other is primary for another site). But, I want the MySQL databases between them to be replicas and to also be able to pull any changes back to the master when it comes back online. Is this possible?
 
master-master is bad. If you have two DBs, for separate apps (sites), and one machine is master and the other is slave for each, that can work.. But doing master-master for each app is bad news.
 
MySQL replication is NOT a backup.

Never implied it was. I have AutoMySQLBackup running nightly on my VPSes. I then use rsync to pull the dumps to my home server. Which is then backed up to Crashplan.
 
Back
Top