Closed Bug 829762 Opened 11 years ago Closed 11 years ago

dev2.db.phx1 data discrepancy post moving the server to a new power grid.

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: bjohnson, Unassigned)

References

Details

After working on 821752 today, dev2 reported some data indiscrepancies.

Rerunning the checksum solved most of them, however 91 remain. We plan on hotcopying the database over Monday morning.

If this is a problem for anyone, please update this ticket and we can move up the urgency.
Resynced dev2 with dev1 this morning.

- Pulled dev2 out of the load balancer.
- InnoDB hot copied the data over.
- Fixed slave master log position
- checked alerts with nagios
- Waited for slave to catch up to master
- Re-added dev2 to Load Balancer.
- Confirmed threads were coming through on dev2.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.