Database Setup

Upsilon uses the MySQL database. Put it in a container, install it natively, or however you like! There is lots of documentation on the web about how to setup a MySQL Database.

Once it is installed, we need to set a upsilon database and import the schema, and initial data.

If you are running on a Linux machine (without containers);

Make sure the upsilon-database-sql package is installed.

user@host: yum install upsilon-database-sql

Go into the database setup directory, and setup some environment variables;

root@host: cd /usr/share/upsilon-database-sql/
root@host: export UP_DATABASE_USER=myuser
root@host: export UP_DATABASE_PASS=mypassword
root@host: export UP_DATABASE_HOST=localhost

Currently the database name must be upsilon.

root@host: mysql -u $UP_DATABASE_USER -p $UP_DATABASE_PASS -e 'CREATE DATABASE upsilon' -h $UP_DATABASE_HOST

Run the database migrations

The updb program can now populate the initial database.

user@host: ./updb

You will get output something like this;

INFO[0000] conf: {Database:{User:myuser Pass:mypassword Host:localhost Name:upsilon} IsLoaded:true Force:0}
INFO[0000] db: mysql://upsilon:upsilon@tcp(upsilon)/upsilon
INFO[0000] Migrations directory: /home/xconspirisist/sandbox/upsilon-database-sql/mysql/migrations
...etc...

The database should now be ready to use. Note that the updb tool is used during upgrades too.