I need to create an application where i will be requiring a backup server like when one server fails i can switch automatically to the other server hosted somewhere else , now the data needs to be consistent on both the servers, one sol is i keep automated backups on the primary server and restore it by a script on the backup server
You want replication, which will automatically keep your data up-to-date between two servers in near-real-time. See http://dev.mysql.com/doc/refman/5.0/en/replication.html Note: You will need to configure master-master replication if you want to start writing to the other server if the master fails, otherwise your data will be inconsistent.
but i need to know how will i switch between servers and if i use domain names instead of ips how will i make immediate switch.
You probably shouldn't use DNS entries for an application that requires immediate fail-over; configure your application to connect to an IP address, then change this IP address if you have to fail over to the backup server. -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
