MySQL migration: 4.x to 5.0

From genomewiki
Revision as of 22:45, 17 August 2009 by Ann (talk | contribs) (mysql convesion)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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]
  • Copy all databases on hgdownload, convert from MySQL v4.0 to MySQL v5.0, and place on mysqlrr [Hiram]
    • 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

  • Sync mysqlrr to mysqlbeta [Erich]
  • 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 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]
Retrieved from "https://genomewiki.ucsc.edu/index.php?title=MySQL_migration:_4.x_to_5.0&oldid=8251"