790391 - Upgrade bouncer database to MySQL 5.1

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

Currently bouncer cluster in phx is on MySQL 5.0. dev/stage isn't really in use for it, seeing if I can upgrade a slave for testing.

Comment 1

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

This should probably also switch to using mysql2::server at the same time (bug 717638)

Comment 2

[Sheeri Cabral [:sheeri]]

Note that dev/stage for bouncer are already upgraded, and brandon savage is developing against 5.1, so this is OK to do.

Comment 3

[Sheeri Cabral [:sheeri]]

taking tp-bouncer01-slave03 aka 10.8.70.64 out of the load balancer.

Comment 4

[Sheeri Cabral [:sheeri]]

tp-bouncer01-slave03 has been upgraded and put in puppet, mysql_upgrade has been run, and checksums have been run to ensure it has the same data as the master.

Taking tp-bouncer01-slave02 out of the load balancer now.

Comment 5

[Sheeri Cabral [:sheeri]]

tp-bouncer01-slave02 is upgraded, verified with checksums, and put back in the load balancer, as is tp-bouncer01-slave01. (and they're in puppet too!)

Comment 6

[Sheeri Cabral [:sheeri]]

tp-bouncer01-master01 is in puppet and upgraded, and back in the mix as the master.
 All slaves are in the load balancer in the RO pool.

Here are the packages on the RHEL server:
Percona-Server-client-51-5.1.65-rel14.0.475.rhel5
Percona-Server-shared-compat-5.5.27-rel29.0.315.rhel5
Percona-Server-server-51-5.1.65-rel14.0.475.rhel5
percona-toolkit-2.1.5-1
Percona-XtraDB-Cluster-devel-5.5.27-23.6.356.rhel5
percona-xtrabackup-2.0.3-470.rhel5
[root@tp-bouncer01-master01 mysql]# rpm -qa | grep -i dbd
perl-DBD-MySQL-3.0007-2.el5

I did a yum install perl-DBD-mysql, then a yum downgrade perl-DBD-mysql, and the installed percona toolkit works with 3.0007.

Comment 7

[Sheeri Cabral [:sheeri]]

see https://mana.mozilla.org/wiki/display/SYSADMIN/MySQL+5.0+to+5.1+Upgrade#MySQL5.0to5.1Upgrade-UpgradeNotesonRHEL5