-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]
