Ensure mysql slaves are locked to read-only mode

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
--
minor
RESOLVED FIXED
9 years ago
2 years ago

People

(Reporter: justdave, Assigned: justdave)

Tracking

Bug Flags:
needs-downtime +

Details

(Whiteboard: 02/17/2009)

The slave databases are supposed to be locked via configuration to be read-only, so that it's not possible to write to them except via replication.  I've recently discovered that some of them aren't, and this can cause problems with applications that misbehave and write to the wrong DB handle, causing slaves to be out-of-sync, and we'd never know there was a problem because no error would be generated until some day maybe a write to the master hits a duplicate key or something.
Assignee: server-ops → justdave

Updated

9 years ago
Flags: needs-downtime+
Whiteboard: 02/17/2009

Comment 1

9 years ago
I think this is on for tonight - start time, downtime estimate?
7pm pacific, no downtime expected, it's a runtime change.  Just announcing it so people know to file bugs if they notice anything funny after it's been done.

Updated

9 years ago
Group: infra
Done.
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.