All use of Scientific Computing and Data resources in our publications and presentations must acknowledge CTSA. Click here

Scientific Computing and Data / High Performance Computing / Documentation / Database: MariaDB

Database Services

The Scientific Computing group is providing basic database services. These can be used in conjunction with the web services or separately to hold science results of limited size, 50 GiB.

MySQL database:
Currently, MySQL relational database service is provided using MariaDB 10.1. At this moment, there is no backup for the databases.

Other databases:
The Scientific Computing group has very limited capacity to host custom database servers for applications which require deep levels of specific versions of packages or other custom software, such as Oracle SQL Server. DB server availability is very limited and evaluated on a case-by-case basis. Please submit a ticket with your request by emailing hpchelp@hpc.mssm.edu.

 

MariaDB/MySQL Database

MariaDB is a fork of the MySQL relational database management system. It intends to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.

Compatibility & Differences Between MariaDB and MySQL

There are two networks can connect to the MariaDB database:

Internal Network: Inside Minerva HPC cluster (usually, on the login nodes li03c01-04, web server web01, and compute nodes, you can connect to the database using the internal network, data1.chimera.hpc.mssm.edu (172.28.4.160).

External Network: On your laptop or other campus computers, connect use data1.hpc.mssm.edu (10.95.46.73)

To access within minerva, without chimera.hpc.mssm.edu is OK:

 $ mysql -h data1 -u userid -p your_database

To access within campus network, eg on your laptop, use data1.hpc.mssm.edu, .hpc.mssm.edu is needed:

 $ mysql -h data1.hpc.mssm.edu -u userid -p your_database

To backup your database, do

$ mysqldump -u userid –p your_database [tablename] -h data1 > [dumpfilename.sql]

Database users are not synchronized with Minerva users at this time. To create users and databases, please submit a ticket by emailing hpchelp@hpc.mssm.edu.

 

External Links

MariaDB Tutorial
MariaDB Documentation