Configure and Use a MariaDB Database on MyDB

This pathway will show you how to configure a MariaDB (MySQL) database on MyDB and connect to it using the command line tools on a rhino/gizmo node.

MyDB supports other databases- postgres, mongodb, and neo4j. Refer to the main mydb documentation for more information on those DBMS’s

Pre-requisites

A workstation, HutchNet ID, access to the internet and campus network, and browser

If you are unfamiliar with any of these terms, hover over them to find more information.

• rhino The login node (actually several nodes) of the Fred Hutch high performance computing cluster.

• mysql A relational database management system.

• db4sci An opensource project managing database services on-demand. A Database as a Service system.

• mydb mydb here is the SciComp maintained implementation of db4sci.

• gizmo The name of the Fred Hutch high performance computing cluster’s computing nodes.

Steps

Log in to MyDB

Browse to https://mydb.fredhutch.org/login and enter your HutchNet ID

Create the Database Container

Follow the instructions here to configure an instance of a MariaDB container. Record the username, password, and port in a secure location.

Start a Session on a Rhino

Start a shell on rhino with SSH or NoMachine.

Load the MariaDB Module

Load the MariaDB module with the command ml MariaDB.

Connect to the Database

Use the command you recieved when you created the database container to connect to the database. Detailed documentation on using your database is available here.

Where to go from here

Alternate Tools

Any tool that can connect to MySQL will most likely work with a MariaDB. MySQL Workbench is a very popular tool. Other graphical interfaces can be found here

Thinking Securely

• TLS and SSL aren’t currently supported- if you have an “in transit” requirement contact SciComp
• The password option can take the password as an argument- this is not advisable as the password will be shown in the process tables and is therefore available to anyone on the system.