780954 - upgrade a01 database

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

Server version: 5.0.77-log Source distribution

We should upgrade at least to MySQL 5.1, if not 5.5

Comment 1

[Sheeri Cabral [:sheeri]]

mysql> show databases;
+---------------------------------+
| Database                        |
+---------------------------------+
| information_schema              | 
| input_load_test                 | 
| input_mozilla_com               | 
| mozilla_input_metrics           | 
| mozilla_input_metrics_load_test | 
| mysql                           | 
| snippets_mozilla_com            | 
+---------------------------------+
7 rows in set (0.00 sec)

It's all input, input metrics, and snippets.

Comment 2

[Sheeri Cabral [:sheeri]]

And we have a master/slave configuration, so if everyone's using VIPs, we can go ahead with this.

Comment 3

[Dustin J. Mitchell [:dustin] (he/him)]

Also should be upgraded in puppet to mysql2::server

Comment 4

[Sheeri Cabral [:sheeri]]

Took tp-a01-slave02.phx.mozilla.com out of the load balancer so I can work on this upgrade.

Comment 5

[Sheeri Cabral [:sheeri]]

tp-a01-slave02 has been updated with Percona 5.1, and is importing the database now.

Comment 6

[Sheeri Cabral [:sheeri]]

tp-a01-slave02 is fully upgraded, checksums look good. will let this marinate until next week to make sure it's good before proceeding with more upgrades.

Comment 7

[Sheeri Cabral [:sheeri]]

tp-a01-slave02 is now the master, with slave01 and master01 being the slaves.

Comment 8

[Sheeri Cabral [:sheeri]]

tp-a01-slave01 is now upgraded. Working on tp-a01-master01 now.

Comment 9

[Sheeri Cabral [:sheeri]]

tp-a01-master01 is upgraded. Leaving this open only so I remember to ping an SRE about upgrading these systems tomorrow. (RHEL upgrades).

Comment 10

[Sheeri Cabral [:sheeri]]

I also need to remember to put tp-a01-master01 back as the master, and ensure that checksums are set when I do.

Comment 11

[Sheeri Cabral [:sheeri]]

I have in fact put tp-a01-master01 back as the master and all the a01 cluster machines are up-to-date. Checksums are in place.