Departmental Database Service

The Department provides a centralised database service with MySQL/MariaDB and PostgreSQL instances. It is hosted on a Fedora 24 server running on two six-core Xeon processors with 64 GB of RAM and a 1 TB RAID-10 disk system.

Setting up a database

You can request access to the server by sending an email to ithelp@stats.ox.ac.uk as for a normal help request. We will need the following information:
    •    Your user name
    •    Whether you wish to use MySQL/MariaDB or PostgreSQL
    •    The name of your database
    •    The desktop from which you intend to access the database

We will email you to let you know when your account and database have been created.

Accessing your database

If you are a Linux user we will configure the stunnel software for you on the desktop you specify. You will then be able to log in with the appropriate command:

MySQL/MariaDB: mysql -h hostname -u username -p
PostgreSQL: psql -h localhost -d database -U username -W

where hostname is the name of your desktop, database is the name of your database and username is your database username.

If you are a Windows user we will install and configure stunnel for you and you can access your database via a client of your choosing.  

Backups

The databases are backed up daily. If you need to know more about restoring database data please email ithelp@stats.ox.ac.uk with the name of the server and the point in time that you would like to recover from.