All users were logged out of Bugzilla on October 13th, 2018
These are RHEL5 systems running MySQL-5.0. That's not compatible with the mysql2::server class, and they should be upgraded anyway.
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?
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.
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
stage2 is upgraded and in puppet now.
Got good checksums, so I will be upgrading stage1 and copying the data there now.
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.