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]