> -----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 > 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 to SQL in general, I *think* I can do the first > part (stay in sync with the primary) by making the backup a slave, and > replicating the DB on a constant basis. But will the slave DB happily > start accepting transactions when stuff starts coming in from the > webserver? or do I have to do something to allow that in MySQL? > > As an aside, a recommendation on good beginner and intermediate level > MySQL books would be appreciated. I want to RTFM, but I want to make > sure it *is* the Fine manual :)
The first reference is the mysql reference manual available online at www.mysql.com. I am reading "Mysql enterprise solutions" from Alexander Sasha Pachev (Wiley) and MySQL, from Paul Dubois (developper's library) and they're both good. > > Oh, and seasons greetings to all, yes I'm working on Christmas, it's a > startup, what can I say... > > -- > Jim Richardson http://www.eskimo.com/~warlock > Quantum mechanics: The dreams stuff are made of. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]