Kaivos - A relational database service

When to use a database?

Relational databases provide an efficient tool to manage structured data that keeps changing and which contains data that needs to be accessed with complex queries. Client-server-based SQL databases (e.g. MySQL, MariaDB, PostgreSQL) can not be effectively run in HPC computing environments like Mahti or Puhti. If you need to use relational databases in CSC computing environment, you should use a database running in some external server.

It is fairly simple to set up your own SQL server using Pukki DBaaS, or a Virtual Machine running in cPouta. Setting up your own database server this way gives you full access to the database. Note that using cPouta requires that you know how to manage a database server.

Kaivos - just add data

Another option is to use kaivos.csc.fi database service that is hosted by CSC. This service is intended for users who want to use their own MySQL/MariaDB databases in CSC computing environment without managing their own database server. The service is in this sense similar to Pukki DBaaS, which supports PostgreSQL databases.

In this guide you can find information about getting started with Kaivos and instructions for using it. The actual SQL command language is not discussed in this document in detail. Please use the MariaDB manual or some of the many SQL guides published for an introduction to SQL databases.

Do you find this page useful?

Yes

Thank you for your feedback!

No

Thank you! Your feedback is appreciated.

Please let us know how we could improve this page by contacting us or by creating an issue in GitHub. You can also edit this page yourself and contribute your improvements by creating a pull request.