All users were logged out of Bugzilla on October 13th, 2018

upgrade stage*.db.scl3 from MySQL-5.0

RESOLVED FIXED

Status

RESOLVED FIXED
6 years ago
4 years ago

People

(Reporter: dustin, Assigned: scabral)

Tracking

Details

(Whiteboard: [2012q4])

These are RHEL5 systems running MySQL-5.0.  That's not compatible with the mysql2::server class, and they should be upgraded anyway.
(Assignee)

Updated

6 years ago
Assignee: server-ops-database → dustin
Blocks: 790300
Sheeri, what's the best way to do this, and what should I upgrade to?  Can the stage cluster run on a single node?  Is manual failover about the same as for a cluster with >2 servers?  Who do I need to talk to about a maintenance window on this cluster?
(Assignee)

Comment 2

6 years ago
Upgrade to Percona 5.1.

https://mana.mozilla.org/wiki/display/SYSADMIN/MySQL+5.0+to+5.1+Upgrade

The installing the Percona server section should probably be updated to "use puppet" - it's like steps 17-18, and there's still some manual stuff like "remove the old packages first.

Stage can run on a single node, so take stage2 out of the load balancer. Part of the instructions is to export with mysqldump and import, so you'll want to stop any slaves (e.g. if stage1 is a slave of stage2, we should disable that for the duration of the upgrade).

Once stage2 is upgraded and put back into the load balancer, we should wait a few days or a week so that any issues can be uncovered. To upgrade stage1, take it out of the load balancer, stop mysql and use xtrabackup to hot copy stage2 to it. I think that's covered on the page I linked to, actually.
(Assignee)

Updated

6 years ago
Whiteboard: [2012q4]
(Assignee)

Comment 3

6 years ago
I'm working on stage2 right now, due to buildbot staging being on the machine (supposedly) and trying to get scalebase up in front of it, but I want to make sure the machine is standardized before I do that.
Assignee: dustin → scabral
(Assignee)

Comment 4

6 years ago
stage2 is upgraded and in puppet now.
(Assignee)

Comment 5

6 years ago
Got good checksums, so I will be upgrading stage1 and copying the data there now.
(Assignee)

Comment 6

6 years ago
stage1 is upgraded, puppetized and has the backup!
Status: NEW → RESOLVED
Last Resolved: 6 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.