Is there anyone know how to do "mysql database replication" with appfog ? In simple word, just want to use 2 databases sync (2 locations) and set one as master database, and other one as slave. if master server down, instantly slave server should act as master database. Actually databases are hosted on 2 shared servers. because lack of the space provided by appfog. 🙂
Mysql database replication (failover solution)
MySQLreplication
Related Question
- MySQL error 1593 on replication between 5.0.92 and 5.5.42
- MySQL: Recover Master from Slave after failover
- Mysql – master-master replication or master slave replication
- MySQL Solution to Sync 3 servers data
- MYSQL database failover
- Mysql – How to re-sync the Mysql DB if some Masters have different database incase of MySQL Group replication
- Mysql – Failover in MySQL Chain Replication
Best Answer
Facebook's DBA YOSHINORI MATSUNOBU has developed MHA :
The project link : http://code.google.com/p/mysql-master-ha/
Max.