From: ewen fortune (ewen.fortunegmail.com)
Date: Wed Jan 14 2009 - 16:20:08 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

On Wed, Jan 14, 2009 at 3:00 PM, John Daisley
<john.daisleymypostoffice.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.fortunegmail.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]