RE: Hot standby database question

2003-12-25 Thread Ugo Bellavance
> -Message d'origine- > De : Jim Richardson [mailto:[EMAIL PROTECTED] > Envoye : Thursday, December 25, 2003 10:18 AM > A : [EMAIL PROTECTED] > Objet : Hot standby database question > > > > I would like to set up two systems, a primary, and a backup, in

Hot standby database question

2003-12-25 Thread Jim Richardson
I would like to set up two systems, a primary, and a backup, in physically seperate locations. I want the backup to be synced with the primary, and if the primary goes down, dns will resolve to the backup, so it needs to be able to start processing transactions immediately. I am new to MySQL, and