MySQL migration: 4.x to 5.0: Difference between revisions
From genomewiki
Jump to navigationJump to search
(mysql convesion) |
No edit summary |
||
| Line 3: | Line 3: | ||
The Process: | The Process: | ||
* Turn off GenBank updates on the RR, hgwbeta, and hgwdev machines [Mark] | * 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] | ** 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''' | '''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] | * Point one RR machine that's not in the pool (hgw2) to look at mysqlrr [admins] | ||
** Test hgw2 using mysqlrr [qa] | ** 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] | * 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] | * Point hgwbeta to mysqlbeta [admins] | ||
** Test hgwbeta using mysqlbeta [qa] | ** Test hgwbeta using mysqlbeta [qa] | ||
Revision as of 23:21, 18 August 2009
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]
