Updating blat servers

There are two places where blat servers are located. Assemblies that are important (eg. human or mouse) and are expected to get a lot of hits are hosted here at UCSC and will have a blat host name like blat#$ (where # is a number and $ is a letter, for example: blat4a). Assemblies that are going to stay on hgwdev (never to be released publicly) will get a blat server also at UCSC, but on a less important server. They will have a blat host name of blatx. Wherever the blat server is hosted, the steps below will allow you to transfer the pointers to a new machine.

• Do a select statement on dev to make sure that everything is where you expect it to be:

hgwdev: hgsql hgcentraltest
mysql> select * from blatServers where host="blat#" ORDER BY port;
+---------+--------+-------+---------+--------+
| db      | host   | port  | isTrans | canPcr |
+---------+--------+-------+---------+--------+
| apiMel1 | blat12 | 17778 |       1 |      0 |
| apiMel1 | blat12 | 17779 |       0 |      1 |
| monDom1 | blat12 | 17786 |       1 |      0 |
| monDom1 | blat12 | 17787 |       0 |      0 |
| caeRei0 | blat12 | 17790 |       1 |      0 |
| caeRei0 | blat12 | 17791 |       0 |      1 |
+---------+--------+-------+---------+--------+

• Get DNA and protein sequences for a gene for given assembly and paste below for future reference:

DNA

protein

• Open 9 windows: BLAT DNA, BLAT protein, PCR for hgwdev, the RR, and genome-euro (we don't check on beta since it doesn't really matter if blat is working there or not). Make sure that all 9 windows function without errors.

Getting into hgcentral database on dev, beta, RR:

DEV: hgwdev: hgsql hgcentraltest
BETA: hgwbeta: hgsql hgcentralbeta
RR: hgwdev: hgsql -h genome-centdb hgcentral 
          
Statements for changing pointers:
        
update blatServers set host='blat#', port=177## where db='xxxXxx#' and isTrans=1;
update blatServers set host='blat#', port=177## where db='xxxXxx#' and isTrans=0;

**Note that the admins will simiply say:
bosTau3
trans port 17786
untrans port 17787

This means put the trans port number for isTrans=1 and the untrans port number for isTrans=0

• Go to hgcentral on dev and change the pointers for the assembly of interest.
• Go back to the browser, hit back for the 3 windows open on dev, and then click re-submit. Check to see if broken. If not, go on; if yes, troubleshoot until solution is found.
• Repeat step 4 for beta and 4-5 for the RR.
• hgcentral changes are synced from the RR to genome-euro via the pullHgcentral script. See the new assembly release page for more info.
• Ask the buildmeister to rebuild the hgCentral.sql file for mirror sites. The file at http://hgdownload.cse.ucsc.edu/admin/ should be updated. Optional: Some mirrors like to get hgcentral tables via ftp or rsync from ftp://hgdownload.cse.ucsc.edu/mysql/hgcentral/. You can request a push from hgnfs1 --> hgdownload if you want to make the hgcentral info available there immediately (otherwise it will be copied there by a weekly rsync).
• Notify the mirrors (on genome-mirror@soe.ucsc.edu) that we have updated our blatServers. An example genome-mirror new hgcentral.sql (blatServers table update) email is here: https://groups.google.com/a/soe.ucsc.edu/d/msg/genome-mirror/xxMcXbuXq9Y/lGW5fJ95NzMJ If you didn't ask for a push of the mysql tables, you can just say that they will be updated over the weekend.