Replication and failover question

2003-12-09 Thread junk
I'm thinking about doing this: Setting up 2 mysql servers each replicating to the other (each a slave of the other). Code the connect/j connection creation to try one server on connect. If it fails, connect to the other server. Both servers are writeable, but my code is never talking to more than

mysql crashes when the slave is started with incorrect master info

2002-10-29 Thread junk
>Description: When a slave is pointing to a non-existing master, doing "slave start/slave stop" will sometimes cause the MySQL server to crash >How-To-Repeat: mysql> change master to master_host='bogus', master_log_file=''; Query OK, 0 rows affected (0.00 sec)