Upgrade b2 cluster in scl3 to MySQL 5.1 and put into puppet

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
6 years ago
4 years ago

People

(Reporter: sheeri, Unassigned)

Tracking

Details

(Whiteboard: [2012q4])

(Reporter)

Description

6 years ago
Currently b2 is MySQL 5.0.
(Reporter)

Comment 1

6 years ago
And it's not innodb_file_per_table, not with a 24 Gb ibdata file!
(Reporter)

Comment 2

6 years ago
Took tp-b02-slave01 out of the load balancer, downtime'd in nagios for 2.5 hours, stopped the slave and am doing a mysqldump --all-databases now.

When that's done, I will remove the MySQL packages, move aside the /var/lib/mysql and /var/lib/mysql-innodb directories and then upgrade to Percona 5.1 by putting into puppet, and then importing the export and doing a mysql_upgrade.
(Reporter)

Comment 3

6 years ago
ack, this should really be in bug 790409!
(Reporter)

Comment 4

6 years ago
That's odd, b2-db1 is up to date, but b2-db2 is not:

mysql> select @@hostname, @@version;
+----------------------------+--------------------+
| @@hostname                 | @@version          |
+----------------------------+--------------------+
| b2-db1.db.scl3.mozilla.com | 5.1.65-rel14.0-log |
+----------------------------+--------------------+
1 row in set (0.00 sec)

mysql> select @@hostname, @@version;
+----------------------------+------------+
| @@hostname                 | @@version  |
+----------------------------+------------+
| b2-db2.db.scl3.mozilla.com | 5.0.77-log | 
+----------------------------+------------+
1 row in set (0.00 sec)

I just double-checked, and b2-db2 is just a regular slave. Moving b2-db2 to be out of the load balancer pool.
(Reporter)

Comment 5

6 years ago
b2-db2 is upgraded; both b2-db1 and b2-db2 are in puppet as well. Huzzah!
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.