Hello.
I'm using MySQL-3.23.38 on 5 RedHat 7.1/7.2 servers composed by one master 
and 4 mysql slave, every write is made on the master and then replicated to 
the slave.
The problem is that if one client crash or must be rebooted i've to:

- on the mysql master stop mysql, delete binlogfile, tar all the data in a 
file and then restart mysql
- on ALL the mysql slave stop mysql, delete all data, get the tar file from 
the master and the restart mysql

so i've to restart all mysql slave even if only one is really "crash", if i 
don't do this i loose the syncronization between master and slave (as shown 
in the mysql.log).
As your experience what do you do when a mysql slave "crash" and loose the 
sync? I would like to use a method to restart only the crashed client without 
touch other's slave and without restart master.

I could make a backup script that get all the data from the the master (like 
mysqlhotcopy) without restart nothing, but what about the binlog file? i 
could FLUSH them in the server but then other slave will loose the sync ....
I appreciate any help or suggestion.

Best Regards.
-- 
Davide Giunchi.
Membro del FoLUG (Forlí Linux User Group) - http://folug.linux.it
GPG Key available on http://www.keyserver.net 
Fingerprint: 8075 363A B4FA 0196 FEEC  AF9C 19A9 66C7 CDAB D0D5

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to