Apr. 29th, 2009

mark: A photo of Mark kneeling on top of the Taal Volcano in the Philippines. It was a long hike. (Default)
[staff profile] mark
When doing a global master change...

* don't forget MogileFS
* stop all jobs, if anybody is still up with the old config (TheSchwartz workers!) they will continue writing to the old master
* take the old master hard-offline and leave it that way to flush out any bad behavers? at least monitor show processlist
* don't forget all slaves (mailserver slave)

Todo: figure out if there's a way to put a MySQL server fully read-only (except for replication?), I know there's a read-only config file option but I don't think it works as expected.

Profile

dw_dev: The word "develop" using the Swirly D logo.  (Default)
Dreamwidth Open Source Development

March 2026

S M T W T F S
1234567
8910 11121314
15161718192021
22232425262728
293031    

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Mar. 14th, 2026 11:36 am
Powered by Dreamwidth Studios