Re: Best practices for restarting MySQL

[Ed 678901]

Rick,

Thanks for that feedback, this is the kind of advice I'm looking for.

Especially

> * For graceful shutdowns, use SET readonly=1 (and do _not_ connect as 'root'). This prevents writes -- by providing an error to the INSERT/UPDATE/etc statement.
> * For graceful shutdowns, use SET max_connections=1. This will give errors for new connections and "reconnect" attempts by the application.

Graceful shutdowns is really what I should be searching for, and those two points are great tips I am not currently doing.

Have a good one!

Ed