Research Hub DB

A docker image for the Research Hub database. This Docker image runs MySQL, seeds the database and automatically backs up the database daily.

MySQL and Cron are run via Supervisord. Cron runs a script that dumps the MySQL database into the /data/ folder, which you can mount onto the host filesystem.

Running the database container locally

Follow the instructions for running the database container locally in Research Hub Deploy project.

You should place the database spreadsheet in config/db/database.xlsx in the cloned Deploy project directory.

To build the database container:

./hubby build db

To run the database container:

./hubby up db

You can then examine the database using the MySQL client:

./hubby compose exec db bash
mysql -p

You can find the MySQL account password in the Deploy project.

If you make changes to the spreadsheet, you will need to run the following commands in order for the database container to reseed with the changed data:

./hubby cleandb
./hubby up db

You will be prompted for your sudo password on the cleandb step.