NERSCPowering Scientific Discovery Since 1974

MySQL

Description and Overview

MySQL is a very popular open-source relational database. It is widely used and NERSC provides a set of database nodes for users that wish to set up a MySQL database.

Requesting a MySQL Database

Users can request a MySQL database for their project using this form.

How to Use MySQL 

The mysql command line client is available at NERSC on Edison and Cori, and can be used to directly connect to a MySQL database via the command line. 

On a NERSC system, type the following commands to use the mysql command line client:

% mysql yourdb -u dbuser -h scidb1.nersc.gov -p

Replace yourdb and dbuser with the name of the database and user provided to you by NERSC.
You may need to replace scidb1 with scidb2.

Documentation

Extensive on-line documentation is available. For questions about MySQL at NERSC please contact consult@nersc.gov.

Availability

mysql is available on login to Edison and Cori, you do not need to load a module.

PackagePlatformCategoryVersionModuleInstall DateDate Made Default
mysql genepool applications/ services 5.0.96 mysql/5.0.96 2012-07-30 2012-07-30
mysql genepool applications/ services 5.0.96_1 mysql/5.0.96_1 2013-12-06 2013-12-17
mysql genepool applications/ services 5.1.69 mysql/5.1.69 2013-06-03
mysql genepool applications/ services 5.5.25a mysql/5.5.25a 2012-07-30
mysql genepool applications/ services 5.6.14 mysql/5.6.14 2014-12-23
mysql genepool_sl6 applications/ services 5.0.96_1 mysql/5.0.96_1 2015-02-24 2015-02-24
mysql genepool_sl6 applications/ services 5.1.69 mysql/5.1.69 2015-02-24
mysql genepool_sl6 applications/ services 5.5.25a mysql/5.5.25a 2015-02-24
mysql genepool_sl6 applications/ services 5.6.14 mysql/5.6.14 2015-02-24
mysql genepool_sl72 applications/ services 5.5.25a mysql/5.5.25a 2017-08-16
mysql genepool_sl72 applications/ services 5.5.56 mysql/5.5.56 2017-08-16
mysql genepool_sl72 applications/ services 5.6.14 mysql/5.6.14 2016-11-10
mysql genepool_sl72 applications/ services 5.6.36 mysql/5.6.36 2017-08-16
mysql genepool_sl72 applications/ services 5.7.19 mysql/5.7.19 2017-08-16
MySQL pdsf_sl6 other/ general 1.0 test/1.0 2016-09-12
MySQL pdsf_sl6 other/ general 5.6.12 mysql/5.6.12 2013-06-17
MySQL pdsf_sl6 other/ general 5.6.14 mysql/5.6.14 2016-09-12 2016-09-12
mysql phoebe applications/ services 5.0.96 mysql/5.0.96 2012-07-18 2013-06-26
mysql phoebe applications/ services 5.1.69 mysql/5.1.69 2013-06-18
mysql phoebe applications/ services 5.5.25a mysql/5.5.25a 2012-07-18 2012-07-18

There is also a python mysql module.