Loading…
This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
Visit the main conference website:  http://galaxyproject.org/gcc2016
View analytic
Sunday, June 26 • 12:30pm - 3:00pm
The Galaxy Database Schema

Sign up or log in to save this to your schedule and see who's attending!

Running a production Galaxy server, you some times end up in with a situation, where you manually need to interact with the database. e.g. you need to change the state of a job to 'error'. This is always a very risky adventure. Or a not-at-all risky situation: you want to extract usage information, which can not be gathered using the given report tools. For both cases, you need a good understanding of the Galaxy database schema. Learn some of the design concepts of the database, which parts of the schema are stable, and which will be changing in the foreseeable future. Also, some advice will be given on how to migrate a production Galaxy server running on MySQL to PostgreSQL.

Session Document

Prerequisites:
  • Experience maintaining a production Galaxy server Basic knowledge of relational databases and SQL statements.
 

Instructors
avatar for Dave Clements

Dave Clements

Training and Outreach Coordinator, Galaxy Project, Johns Hopkins University
avatar for Hans-Rudolf Hotz

Hans-Rudolf Hotz

Friedrich Miescher Institute for Biomedical Research


Attendees (14)