All use of Scientific Computing and Data resources in publications and presentations must acknowledge Mount Sinai’s CTSA funding award. Click here

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

Database Services

Minerva provides efficient and reliable database services, suitable for standalone use or integration with our web services. These databases are tailored to store scientific data, supporting datasets up to 50 GiB in size.

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

Other databases:
Minerva team has limited capacity to host custom database servers, particularly for applications that require highly specific software versions or specialized configurations—such as Oracle SQL Server. Availability of such database servers is extremely constrained and assessed on a case-by-case basis. If you require this type of setup, please submit a request by emailing hpchelp@hpc.mssm.edu.

MariaDB/MySQL Database

MariaDB is a robust fork of the MySQL relational database management system, engineered to ensure high compatibility with MySQL. It provides seamless drop-in replacement capabilities, featuring identical library binaries, precise matching with MySQL APIs, and equivalent command structures for effortless integration.

Compatibility & Differences Between MariaDB and MySQL

There are two networks can connect to the MariaDB database:

Internal Network (within Minerva HPC cluster only): On the login nodes li04e01-04, web server web02-03, or compute nodes, you can connect to the database using the internal network, data1.chimera.hpc.mssm.edu (172.28.7.78).

External Network (campus network or VPN regardless of Minerva HPC cluster connection): On your laptop or other computing devices, connect use data1.hpc.mssm.edu (10.95.46.229)

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 user accounts are not currently synchronized with Minerva user accounts. To request a new database or user account, please submit a ticket via email to hpchelp@hpc.mssm.edu.

 

External Links

MariaDB Tutorial
MariaDB Documentation