[mysql-zrm-users] Stop Slave
Mathieu Bruneau
rounoff at argontechnologies.ca
Sun Nov 19 10:41:32 PST 2006
Heya,
One of the thing I don't like at the moment for backing up a database
(using a replicate slave) is that you cut all connection to the master
with STOP SLAVE.
Since what we only need to do is prevent write to the database, I think
it could be envisageable to issue simply a STOP SLAVE IO_THREAD to
simply cut the IO_THREAD from playing the sql.
This has a simple advantage that the binlog are still transferred from
the master and in the infortunate event that your master _burn_ you
still have access to your binlog to play them. (Small chance but hey!)
The syntax for STOP SLAVE IO_THREAD seems to be the same since 4.0 so I
think it's possibly a feature/option that could be usefull! I prefer to
talk about it in here before actually posting it as a feature request
inside bugzilla!
Feel free to discuss if you think there could be reason not to! Regards,
--
Math
aka ROunofF
======
argontechnologies.ca
More information about the mysql-zrm-users
mailing list