Hi,
On Wed, Jan 14, 2009 at 3:00 PM, John Daisley
john.dais...@mypostoffice.co.uk wrote:
Hi,
Probably a simple question for someone who knows :)
Is there a way to force MySQLD to restart after it has finished processing
all current transactions?
I seem to remember from the bit of Oracle work I did in the past we could
do a Transactional Restart in Oracle 10g which caused the server to stop
accepting new requests and restart when it has processed all current
transactions. I now need to do a similar thing with MySQL 5.0, is this
possible?
Right, under Oracle you can do SHUTDOWN TRANSACTIONAL
There is no such command available with MySQL but you can do the
basically the same thing.
Reduce the max_connections variable to 1, this will prevent any new
non-super connections.
Optionally set the server to read_only to prevent any existing
non-super connections from initiating new updates.
View the processlist, once all the transactions have completed you can
kill the connections and issue a shutdown.
It would also be handy if I could get it to do this 'transactional
retstart' and when it comes back up force the slave to do the same, but
we'll get one working first! Its needed so we can apply updates etc to the
box without disrupting database access.
Its not exactly what oracle is doing, but at least you can control access.
Cheers,
Ewen
Thanks in advance for any help.
Regards
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=ewen.fort...@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org