MySQL migration: 4.x to 5.0

During the late summer of 2009, we are migrating the UCSC Genome Browser MySQL server from v4.x to v5.0. This page will be used to discuss and track that migration.

The Process:

• Turn off GenBank updates on the RR, hgwbeta, and hgwdev machines [Mark]
• Load all databases from hgdownload to mysqlrr, which will load as MySQL v5.0 [Hiram]
• Sync mysqlrr to mysqlbeta, which is also running MySQL 5.0 [Erich]
  • Verify that the conversion worked and the new tables match the old tables [Hiram]

At this point there is a moratorium on push requests and on CGI releases

• Point one RR machine that's not in the pool (hgw2) to look at mysqlrr [admins]
  • Test hgw2 using mysqlrr [qa]
• Convert "extra" tables from hgsqlbeta (4.x to 5.0) and place on mysqlbeta (e.g. qapushq, random not-already-pushed tables) [admins]
• Point hgwbeta to mysqlbeta [admins]
  • Test hgwbeta using mysqlbeta [qa]
• Convert tables on hgwdev from MySQL 4.x to 5.0 [admins]
• Point the other 7 RR machines to mysqlrr [admins]

At this point, we can resume push requests and CGI releases

• Turn on GenBank updates on the RR, hgwbeta, hgwdev [Mark]