924490 - Upgrade buildbot in scl3 to MySQL 5.6

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

Upgrade to MySQL 5.6

Comment 1

[Sheeri Cabral [:sheeri]]

buildbot2 is out of the load balancer. First step is defragging:

mysql> \! ls -lrth /var/lib/mysql/buildbot/steps.MY* /var/lib/mysql/buildbot/builds.MY*
-rw-rw---- 1 mysql mysql  29G Oct 17 08:01 /var/lib/mysql/buildbot/steps.MYI
-rw-rw---- 1 mysql mysql  49G Oct 17 08:01 /var/lib/mysql/buildbot/steps.MYD
-rw-rw---- 1 mysql mysql 2.6G Oct 17 08:01 /var/lib/mysql/buildbot/builds.MYI
-rw-rw---- 1 mysql mysql 1.5G Oct 17 08:01 /var/lib/mysql/buildbot/builds.MYD
mysql> optimize table buildbot.builds; optimize table buildbot.steps;

Comment 2

[Sheeri Cabral [:sheeri]]

the builds defrag is complete, only took 4 minutes:

[[e-mail]3 buildbot]# ls -rlth builds.*
-rw-rw---- 1 mysql mysql 8.8K Mar 20  2012 builds.frm
-rw-rw---- 1 mysql mysql 770M Oct 17 08:05 builds.MYD
-rw-rw---- 1 mysql mysql 1.4G Oct 17 08:05 builds.MYI 

We reclaimed about 2.6G of space there.

Comment 3

[Sheeri Cabral [:sheeri]]

[[e-mail]3 buildbot]# ls -lrth steps.*
-rw-rw---- 1 mysql mysql 8.7K Mar 20  2012 steps.frm
-rw-rw---- 1 mysql mysql  11G Oct 17 09:58 steps.MYI
-rw-rw---- 1 mysql mysql  25G Oct 17 09:58 steps.MYD

We reclaimed 36G of space. Nice!

Comment 4

[Sheeri Cabral [:sheeri]]

buildbot2 has been upgraded and put back into the load balancer.

Comment 5

[Sheeri Cabral [:sheeri]]

The bad news is that we had to fail over buildbot today due to a tree closure (see bug 928521).

The good news is we can do maintenance on this machine now!

Comment 6

[Sheeri Cabral [:sheeri]]

Committed revision 76771 to be puppetized with MySQL 5.6.

Comment 7

[Sheeri Cabral [:sheeri]]

buildbot1 has been upgraded and is back in the load balancer as read-only.