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]