Closed Bug 477099 Opened 15 years ago Closed 15 years ago

Ensure mysql slaves are locked to read-only mode

Categories

(mozilla.org Graveyard :: Server Operations, task)

Product:
mozilla.org Graveyard
Component:
Server Operations
Platform:
All
Other
Type:
task
Priority:
Not set
Severity:
minor

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: justdave, Assigned: justdave)

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
Flags: needs-downtime+
Whiteboard: 02/17/2009
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.
Group: infra
Done.
Status: NEW → RESOLVED
Closed: 15 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.