Pushing trackDb: Difference between revisions

From genomewiki
Jump to navigationJump to search
(Initial cut.)
No edit summary
Line 10: Line 10:


== Files ==
== Files ==
The two index files are kept in /gbdb.  Since that 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).
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.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.
*/data/trix/$db_trackDb_public.ixx on hgwbeta should become /gbdb/$db/trackDb.ixx on hgnfs1.


The cv.ra file is not database-specific (check -- IS THIS TRUE?).  In the future we will have alpha/beta/public versions of it.
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:
This should be pushed from hgwbeta --> RR:

Revision as of 18:52, 28 October 2010

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