Skip to content

mariadb.hpc.ut.ee

mariadb.hpc.ut.ee is a MariaDB (MySQL) database cluster maintained by the UTHPC center. It is primarily used by websites and applications hosted in UTHPC center's web cluster or Kubernetes.

Important

The old MySQL cluster (mariadb.cs.ut.ee) will be shut down in June 2026 and databases will be moved to the new cluster (mariadb.hpc.ut.ee). Databases that are not being actively used (for example, databases with no traffic for several months) are backed up and will be restored upon customer's request.

Creating a database

If you need a database for your website (hosted in UTHPC web cluster) or Kubernetes application, you can mark the need in the request form.

If you only need a database, please contact support@hpc.ut.ee.

Database access limitations

For security reasons, databases are usually not directly accessible to users. If a database is used by a website, only the web cluster hosting the application is allowed to access the database.

If you need to access your database directly, you can make an SSH tunnel (described below) through the web cluster or request broader database access within the University of Tartu network.

Important

Databases in mariadb.hpc.ut.ee can only be accessed within the University of Tartu network (or VPN), even if you request broader access.

Accessing databases in mariadb.hpc.ut.ee

If your database access is restricted to the web cluster, you can use an SSH tunnel through one of the web cluster nodes (for example web1.hpc.ut.ee) to manage your database directly.

Note: The credentials of the web cluster user and the database are not the same - use the correct credentials at every step.

Using DBeaver

DBeaver is a database management tool that has SSH tunneling functionality built into it. To connect to your website's database using DBeaver, follow the guide:

  1. Make a new database connection (button at the top-left corner or Ctrl+Shift+N)
  2. Select MariaDB and click Next >

  3. On the Main page, enter the database credentials:

    3.1 Server host: mariadb.hpc.ut.ee

    3.2 Port: 3306

    3.3 Database, username and password

  4. Find the + button in the top-right corner - click on it and select SSH

  5. Enter your SSH credentials:

    5.1 Host/IP: web1.hpc.ut.ee

    5.2 User Name: your website's SSH username

    5.3 Authentication Method: Password

    5.4 Password: your SSH password (for the web cluster)

Note: You can disable the Save credentials option for both of the passwords - the application will ask for passwords every time you connect.

  1. Click Test connection to see if everything is correct. You can also use Test tunnel configuration for debugging.

  2. Click Finish. Now the database is saved as a data source and can be accessed from the SQL button on the main screen.

Manual SSH tunneling

If you prefer to use another client application (or terminal), you could make an SSH tunnel. This forwards traffic from your local port (for example localhost:3306) to mariadb.hpc.ut.ee through a web cluster node.

  1. Open a terminal

  2. Use ssh -L 3306:mariadb.hpc.ut.ee:3306 <username>@web1.hpc.ut.ee and leave the terminal open

    2.1 You can use any other local port if needed - just replace the number before :mariadb.hpc.ut.ee.

  3. Now you can access your database with a database client on localhost:3306 or 127.0.0.1:3306.