[et_pb_section fb_built=”1″ fullwidth=”on” _builder_version=”4.9.0″ _module_preset=”default”][et_pb_fullwidth_menu menu_id=”15″ menu_style=”centered” fullwidth_menu=”on” active_link_color=”#d80b8c” dropdown_menu_line_color=”#221f72″ _builder_version=”4.9.0″ _module_preset=”default” menu_font=”|600|||||||” menu_text_color=”#FFFFFF” menu_font_size=”16px” background_color=”#221f72″ sticky_position=”top”][\/et_pb_fullwidth_menu][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.22″][et_pb_row _builder_version=”4.9.0″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px||||false|false”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text admin_label=”Breadcrumb” _builder_version=”4.9.0″ _module_preset=”default”]<\/p>\n
Scientific Computing and Data<\/a>\u00a0\/\u00a0High Performance Computing<\/a> \/ Documentation<\/a> \/ Database: MariaDB<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.9.0″ header_font=”|600|||||||” header_text_color=”#221f72″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_margin=”10px||20px||false|false”]<\/p>\n 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.<\/p>\n MySQL database:<\/u><\/b> Other databases:<\/u><\/b> [\/et_pb_text][et_pb_text _builder_version=”4.9.0″ header_font=”|600|||||||” header_text_color=”#221f72″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”]<\/p>\n 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.<\/p>\n Compatibility & Differences Between MariaDB and MySQL<\/a><\/p>\n There are two networks can connect to the MariaDB database:<\/p>\n Internal Network <\/strong>(within\u00a0Minerva HPC cluster only):<\/em>\u00a0On 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)<\/strong>.<\/p>\n External Network <\/strong>(campus network or VPN regardless of Minerva HPC cluster connection)<\/em>:<\/strong> On your laptop or other computing devices, connect use data1.hpc.mssm.edu (10.95.46.229)<\/strong><\/p>\n To access within minerva, without chimera.hpc.mssm.edu is OK:<\/p>\n To access within campus network, eg on your laptop, use data1.hpc.mssm.edu, .hpc.mssm.edu is needed:<\/p>\n To backup your database, do<\/p>\n 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<\/a>.<\/p>\n <\/p>\n MariaDB Tutorial<\/a> <\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Scientific Computing and Data\u00a0\/\u00a0High Performance Computing \/ Documentation \/ Database: MariaDBDatabase 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 […]<\/p>\n","protected":false},"author":624,"featured_media":0,"parent":35,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-11341","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/pages\/11341","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/users\/624"}],"replies":[{"embeddable":true,"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/comments?post=11341"}],"version-history":[{"count":13,"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/pages\/11341\/revisions"}],"predecessor-version":[{"id":11796,"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/pages\/11341\/revisions\/11796"}],"up":[{"embeddable":true,"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/pages\/35"}],"wp:attachment":[{"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/media?parent=11341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Database Services<\/h1>\n
Currently, MySQL relational database service is provided using MariaDB 11.0.1. At this moment, there is no backup for the databases.<\/p>\n
Minerva team has limited capacity to host custom database servers, particularly for applications that require highly specific software versions or specialized configurations\u2014such 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<\/a>.<\/p>\nMariaDB\/MySQL Database<\/span><\/h2>\n
\n
$ mysql -h data1 -u userid -p your_database<\/code><\/pre>\n<\/blockquote>\n\n
$ mysql -h data1.hpc.mssm.edu -u userid -p your_database<\/code><\/pre>\n<\/blockquote>\n\n
$ mysqldump<\/span> -<\/span>u userid<\/span> \u2013p your_database [<\/span>tablename<\/span>] -h data1<\/span> ><\/span> [<\/span>dumpfilename<\/span>.<\/span>sql<\/span>]<\/span><\/pre>\n<\/blockquote>\nExternal Links<\/h1>\n
MariaDB Documentation<\/a><\/p>\n