Anyone have any ideas about this? Thanks, Richard
-----Original Message----- From: Richard Bewley [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 7:10 PM To: [EMAIL PROTECTED] Subject: More database replication Hi, I have a "mission critical" database, that I want to be redundant, so I'm using, as discussed in another thread, the Cisco LocalDirector, two mysql machines, and db replication. mySQL version 4.0.16, compiled from source. Should I make both servers both master and slave, or will this cause problems? Would it be better, to make one primary server master, and just have a slave as a "failover" db server for the LocalDirector to send traffic to only if the primary is down? Also, the problem I've come across is, I have gotten replication setup correctly, and it works, but only when I type mysql> LOAD DATA FROM MASTER; I'd rather have it automatically be replicating rather than have to run that command every time, or rather than having a cron job do it, which I see as messy at best. Any suggestions? Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]