Hi all I've one webserver with a mysql server. Now I wan't to set up a backup webserver with a backup mysql server. Now I need a howto. If the master webserver is not online, the loadbalancer put the users to the backupwebserver. He must be every time synced with the masterwebserver. If he is down and someone makes changes in its database, the backupwebserver must sync it back to the master webserver. Thanks admins
You mix the terms web, mysql and mailserver in your post. Do you want to sync a webserver or a mailserver or a database server? Aditionally your post title is talking about mysql replication which is only relkevant for a databse server. This are 3 different tasks, so I need to know exactly what you want to mirror to give you some hints on how to achieve this.
Thanks Till. I've correct ist. : Master MYSQLServer --> Backup MYSQL Server Replication: Master MYSQLServer <----> Backup MYSQL Server Databases: all of the MYSQL Server Thanks admins
Ok. In this case there are two options available as far as I know: 1) Master / master replication, so that every change in the master gets written to the slave and every chnage in the slave gets written to the master automatically. You can even use both servers at the same time r.g. for loadbalancing. Falko has written a few tutorials about this topic. 2) Use a mysql cluster server for all website databases of the master and the slave server: http://www.mysql.com/products/database/cluster/faq.html http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html
