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

June 2025

S M T W T F S
1234567
89101112 1314
15161718192021
22232425262728
2930     

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 5th, 2025 12:06 am
Powered by Dreamwidth Studios