Pushing trackDb

From genomewiki
Revision as of 18:52, 28 October 2010 by Rhead (talk | contribs)
Jump to navigationJump to search

Starting with v243 CGIs and the release of the Track Search feature, every time we push the trackDb table, we need to also push the index files that go with it (.ix and .ixx), the cv.ra file, and the metaDb table. With the ThreeStateTrackDb already making things complicated, and with files needing a storage location that is a special case on hgwbeta, we need a standard way to push "everything that needs to be pushed when trackDb goes out". We'll include the hgFindSpec table, as it is often forgotten (it has nothing to do with Track Search).

Tables

These should be pushed from mysqlbeta --> mysqlrr:

  • trackDb_public (and renamed trackDb)
  • metaDb_public (and renamed metaDb)
  • hgFindSpec_public (and renamed hgFindSpec)

Files

The two index files are kept in /gbdb/$db/. Since gbdb/ is a shared location between hgwbeta and the RR, the files have to have a special location on hgwbeta (the location is specified with the browser.trixPath variable in hg.conf).

  • /data/trix/$db_trackDb_public.ix on hgwbeta should become /gbdb/$db/trackDb.ix on hgnfs1.
  • /data/trix/$db_trackDb_public.ixx on hgwbeta should become /gbdb/$db/trackDb.ixx on hgnfs1.

The cv.ra file is not database-specific. In the future we will have alpha/beta/public versions of it. For now:

This should be pushed from hgwbeta --> RR:

  • /usr/local/apache/cgi-bin/encode/cv.ra