{"id":11341,"date":"2025-08-02T15:42:09","date_gmt":"2025-08-02T19:42:09","guid":{"rendered":"https:\/\/labs.icahn.mssm.edu\/minervalab\/?page_id=11341"},"modified":"2026-11-19T14:03:53","modified_gmt":"2026-11-19T19:03:53","slug":"database-mariadb","status":"publish","type":"page","link":"https:\/\/labs.icahn.mssm.edu\/minervalab\/documentation\/database-mariadb\/","title":{"rendered":"Database: MariaDB"},"content":{"rendered":"<p>[et_pb_section bb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.9.0&#8243; _module_preset=&#8221;default&#8221; next_background_color=&#8221;#000000&#8243;][et_pb_fullwidth_menu menu_id=&#8221;15&#8243; menu_style=&#8221;centered&#8221; fullwidth_menu=&#8221;on&#8221; active_link_color=&#8221;#d80b8c&#8221; dropdown_menu_line_color=&#8221;#221f72&#8243; _builder_version=&#8221;4.9.0&#8243; _module_preset=&#8221;default&#8221; menu_font=&#8221;|600|||||||&#8221; menu_text_color=&#8221;#FFFFFF&#8221; menu_font_size=&#8221;16px&#8221; background_color=&#8221;#221f72&#8243; sticky_position=&#8221;top&#8221; \/][\/et_pb_section][et_pb_section bb_built=&#8221;1&#8243; _builder_version=&#8221;3.22&#8243; prev_background_color=&#8221;#000000&#8243;][et_pb_row _builder_version=&#8221;4.9.0&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; custom_padding=&#8221;0px||||false|false&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Breadcrumb&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_pattern_color=&#8221;rgba(0,0,0,0.2)&#8221; background_mask_color=&#8221;#ffffff&#8221; text_text_shadow_horizontal_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; text_text_shadow_vertical_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_vertical_length_tablet=&#8221;0px&#8221; text_text_shadow_blur_strength=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_blur_strength_tablet=&#8221;1px&#8221; link_text_shadow_horizontal_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; link_text_shadow_vertical_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_vertical_length_tablet=&#8221;0px&#8221; link_text_shadow_blur_strength=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ul_text_shadow_horizontal_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ul_text_shadow_vertical_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ul_text_shadow_blur_strength=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ol_text_shadow_horizontal_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ol_text_shadow_vertical_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ol_text_shadow_blur_strength=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_blur_strength_tablet=&#8221;1px&#8221; quote_text_shadow_horizontal_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; quote_text_shadow_vertical_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_vertical_length_tablet=&#8221;0px&#8221; quote_text_shadow_blur_strength=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_text_shadow_horizontal_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_text_shadow_vertical_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_text_shadow_blur_strength=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_2_text_shadow_horizontal_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_2_text_shadow_vertical_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_2_text_shadow_blur_strength=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_3_text_shadow_horizontal_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_3_text_shadow_vertical_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_3_text_shadow_blur_strength=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_4_text_shadow_horizontal_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_4_text_shadow_vertical_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_4_text_shadow_blur_strength=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_5_text_shadow_horizontal_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_5_text_shadow_vertical_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_5_text_shadow_blur_strength=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_6_text_shadow_horizontal_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_6_text_shadow_vertical_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_6_text_shadow_blur_strength=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_blur_strength_tablet=&#8221;1px&#8221; box_shadow_horizontal_tablet=&#8221;0px&#8221; box_shadow_vertical_tablet=&#8221;0px&#8221; box_shadow_blur_tablet=&#8221;40px&#8221; box_shadow_spread_tablet=&#8221;0px&#8221; custom_css_free_form=&#8221;#breadcrumb {||  list-style: none;||  display: inline-block;||  margin-left: 0px;||}||#breadcrumb .icon {||  font-size: 14px;||}||#breadcrumb li {||  float: left;||}||#breadcrumb li a {||  color: #fff;||  display: block;||  background: #3498db;||  text-decoration: none;||  position: relative;||  height: 20px;||  line-height: 20px;||  padding: 0 10px 0 5px;||  text-align: center;||  margin-right: 23px;||}||#breadcrumb li:nth-child(even) a {||  background-color: #2980b9;||}||#breadcrumb li:nth-child(even) a:before {||  border-color: #2980b9;||  border-left-color: transparent;||}||#breadcrumb li:nth-child(even) a:after {||  border-left-color: #2980b9;||}||#breadcrumb li:first-child a {||  padding-left: 15px;||  -moz-border-radius: 4px 0 0 4px;||  -webkit-border-radius: 4px;||  border-radius: 4px 0 0 4px;||}||#breadcrumb li:first-child a:before {||  border: none;||}||#breadcrumb li:last-child a {||  padding-right: 15px;||  -moz-border-radius: 0 4px 4px 0;||  -webkit-border-radius: 0;||  border-radius: 0 4px 4px 0;||}||#breadcrumb li:last-child a:after {||  border: none;||}||#breadcrumb li a:before, #breadcrumb li a:after {||  content: %22%22;||  position: absolute;||  top: 0;||  border: 0 solid #3498db;||  border-width: 10px 10px;||  width: 0;||  height: 0;||}||#breadcrumb li a:before {||  left: -20px;||  border-left-color: transparent;||}||#breadcrumb li a:after {||  left: 100%;||  border-color: transparent;||  border-left-color: #3498db;||}||#breadcrumb li a:hover {||  background-color: #1abc9c;||}||#breadcrumb li a:hover:before {||  border-color: #1abc9c;||  border-left-color: transparent;||}||#breadcrumb li a:hover:after {||  border-left-color: #1abc9c;||}||#breadcrumb li a:active {||  background-color: #16a085;||}||#breadcrumb li a:active:before {||  border-color: #16a085;||  border-left-color: transparent;||}||#breadcrumb li a:active:after {||  border-left-color: #16a085;||}||&#8221; vertical_offset_tablet=&#8221;0&#8243; horizontal_offset_tablet=&#8221;0&#8243; z_index_tablet=&#8221;0&#8243;]<\/p>\n<ul id=\"breadcrumb\">\n<li><a href=\"https:\/\/labs.icahn.mssm.edu\/minervalab\"><img decoding=\"async\" style=\"width: 16px;margin-top: 2px\" src=\"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-content\/uploads\/sites\/342\/2026\/10\/home.png\"><\/a><\/li>\n<li><a href=\"https:\/\/labs.icahn.mssm.edu\/minervalab\"><img decoding=\"async\" style=\"width: 16px;margin-top: 2px\" src=\"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-content\/uploads\/sites\/342\/2026\/10\/doc2.png\"> <span style=\"top: -4px;position: relative;font-size: 11px\">Scientific Computing and Data<\/span><\/a><\/li>\n<li><a href=\"https:\/\/labs.icahn.mssm.edu\/minervalab\/documentation\/\"><img decoding=\"async\" style=\"width: 16px;margin-top: 2px\" src=\"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-content\/uploads\/sites\/342\/2026\/10\/doc2.png\"> <span style=\"top: -4px;position: relative;font-size: 11px\">Documentation<\/span><\/a><\/li>\n<li><a href=\"https:\/\/labs.icahn.mssm.edu\/minervalab\/documentation\/database-mariadb\/\"><img decoding=\"async\" style=\"width: 16px;margin-top: 2px\" src=\"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-content\/uploads\/sites\/342\/2026\/10\/doc2.png\"> <span style=\"top: -4px;position: relative;font-size: 11px\">Database: MariaDB<\/span><\/a><\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; header_font=&#8221;|600|||||||&#8221; header_text_color=&#8221;#221f72&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; custom_margin=&#8221;10px||20px||false|false&#8221; background_pattern_color=&#8221;rgba(0,0,0,0.2)&#8221; background_mask_color=&#8221;#ffffff&#8221; text_text_shadow_horizontal_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; text_text_shadow_vertical_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_vertical_length_tablet=&#8221;0px&#8221; text_text_shadow_blur_strength=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_blur_strength_tablet=&#8221;1px&#8221; link_text_shadow_horizontal_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; link_text_shadow_vertical_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_vertical_length_tablet=&#8221;0px&#8221; link_text_shadow_blur_strength=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ul_text_shadow_horizontal_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ul_text_shadow_vertical_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ul_text_shadow_blur_strength=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ol_text_shadow_horizontal_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ol_text_shadow_vertical_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ol_text_shadow_blur_strength=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_blur_strength_tablet=&#8221;1px&#8221; quote_text_shadow_horizontal_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; quote_text_shadow_vertical_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_vertical_length_tablet=&#8221;0px&#8221; quote_text_shadow_blur_strength=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_text_shadow_horizontal_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_text_shadow_vertical_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_text_shadow_blur_strength=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_2_text_shadow_horizontal_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_2_text_shadow_vertical_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_2_text_shadow_blur_strength=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_3_text_shadow_horizontal_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_3_text_shadow_vertical_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_3_text_shadow_blur_strength=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_4_text_shadow_horizontal_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_4_text_shadow_vertical_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_4_text_shadow_blur_strength=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_5_text_shadow_horizontal_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_5_text_shadow_vertical_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_5_text_shadow_blur_strength=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_6_text_shadow_horizontal_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_6_text_shadow_vertical_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_6_text_shadow_blur_strength=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_blur_strength_tablet=&#8221;1px&#8221; box_shadow_horizontal_tablet=&#8221;0px&#8221; box_shadow_vertical_tablet=&#8221;0px&#8221; box_shadow_blur_tablet=&#8221;40px&#8221; box_shadow_spread_tablet=&#8221;0px&#8221; custom_css_free_form=&#8221;.airms-new-doc {||  &#8211;ink-900: #212070;||  &#8211;ink-700: #3a3a52;||  &#8211;ink-500: #6f7086;||  &#8211;line: #e4e4ee;||  &#8211;line-soft: #efeff6;||  &#8211;bg-page: #fbfbfd;||  &#8211;bg-card: #ffffff;||  &#8211;bg-subtle: #f5f5fa;||  &#8211;accent-600: #dc298d;||  &#8211;accent-500: #dc298d;||  &#8211;accent-100: #fbdeee;||  &#8211;accent-050: #fdf0f7;||  &#8211;indigo-100: #e4e4f2;||  &#8211;indigo-050: #f2f2f9;||  &#8211;code-bg: #1b1b3a;||  &#8211;code-text: #e6e6f0;||  &#8211;code-line: rgba(255,255,255,0.08);||  &#8211;font-body: %22Open Sans%22, -apple-system, BlinkMacSystemFont, %22Segoe UI%22, Helvetica, Arial, sans-serif;||  &#8211;font-mono: %22SFMono-Regular%22, %22JetBrains Mono%22, Consolas, Menlo, monospace;||  &#8211;radius-lg: 14px;||  &#8211;radius-md: 8px;||  width: 100%;||  padding: 0 8px;||  background: var(&#8211;bg-page);||  color: var(&#8211;ink-700);||  font-family: var(&#8211;font-body);||  font-size: 16px;||  line-height: 1.65;||  -webkit-font-smoothing: antialiased;||}||||.airms-new-doc *,||.airms-new-doc *::before,||.airms-new-doc *::after {||  box-sizing: border-box;||}||||.airms-new-doc p br,||.airms-new-doc li br,||.airms-new-doc .note br,||.airms-new-doc .callout br {||  display: none;||}||||.airms-new-doc .site-header {||  padding: 40px 0 8px;||}||||.airms-new-doc .brand-tag {||  display: inline-flex;||  align-items: center;||  font-size: 12.5px;||  font-weight: 600;||  color: #212070;||  background: var(&#8211;indigo-100);||  padding: 5px 12px;||  border-radius: 999px;||  letter-spacing: 0.2px;||  margin-bottom: 14px;||}||||.airms-new-doc .brand-title {||  margin: 0;||  color: var(&#8211;ink-900);||  font-size: 32px;||  font-weight: 700;||  letter-spacing: -0.6px;||  line-height: 1.2;||}||||.airms-new-doc .intro {||  padding: 14px 0 30px;||  border-bottom: 1px solid var(&#8211;line);||}||||.airms-new-doc .doc-section {||  border-bottom: 1px solid var(&#8211;line);||}||||.airms-new-doc .doc-section:last-of-type {||  border-bottom: none;||}||||.airms-new-doc .doc-section summary {||  list-style: none;||  cursor: pointer;||  padding: 22px 0;||  display: flex;||  align-items: baseline;||  gap: 8px;||  font-size: 26px;||  font-weight: 700;||  color: var(&#8211;ink-900);||  position: relative;||}||||.airms-new-doc .doc-section summary::-webkit-details-marker {||  display: none;||}||||.airms-new-doc .doc-section summary::after {||  content: %22%22;||  margin-left: auto;||  align-self: center;||  width: 10px;||  height: 10px;||  border-right: 2px solid var(&#8211;ink-500);||  border-bottom: 2px solid var(&#8211;ink-500);||  transform: rotate(45deg);||  transition: transform 0.2s ease;||  flex: none;||}||||.airms-new-doc .doc-section%91open%93 summary::after {||  transform: rotate(-135deg);||  border-color: var(&#8211;accent-600);||}||||.airms-new-doc .doc-section summary:hover {||  color: var(&#8211;accent-600);||}||||.airms-new-doc .section-body {||  padding: 0 0 28px;||}||||.airms-new-doc .eyebrow {||  display: inline-block;||  font-family: var(&#8211;font-body);||  font-size: 26px;||  font-weight: 700;||  color: var(&#8211;ink-900);||  letter-spacing: 0;||}||||.airms-new-doc .intro-eyebrow {||  display: block;||  font-family: var(&#8211;font-body);||  font-size: 26px;||  font-weight: 700;||  color: var(&#8211;ink-900);||  letter-spacing: 0;||  margin-bottom: 10px;||}||||.airms-new-doc h3 {||  color: var(&#8211;ink-900);||  font-size: 15px;||  font-weight: 600;||  margin: 24px 0 10px;||  line-height: 1.3;||}||||.airms-new-doc p {||  margin: 0 0 16px;||  color: var(&#8211;ink-700);||}||||.airms-new-doc .section-body &gt; p:last-child {||  margin-bottom: 0;||}||||.airms-new-doc a {||  color: var(&#8211;accent-600);||  text-decoration: none;||  background-image: linear-gradient(var(&#8211;accent-500), var(&#8211;accent-500));||  background-repeat: no-repeat;||  background-size: 100% 1px;||  background-position: 0 100%;||}||||.airms-new-doc a:hover {||  color: var(&#8211;ink-900);||  background-image: linear-gradient(#212070, #212070);||}||||.airms-new-doc strong {||  font-weight: 600;||  color: var(&#8211;ink-900);||}||||.airms-new-doc ul,||.airms-new-doc ol {||  margin: 0 0 16px;||  padding-left: 22px;||}||||.airms-new-doc li {||  margin-bottom: 9px;||}||||.airms-new-doc li:last-child {||  margin-bottom: 0;||}||||.airms-new-doc li ul,||.airms-new-doc li ol {||  margin-top: 9px;||  margin-bottom: 0;||}||||.airms-new-doc ul &gt; li::marker {||  color: var(&#8211;accent-500);||}||||.airms-new-doc ol &gt; li::marker {||  color: var(&#8211;accent-500);||  font-weight: 600;||}||||.airms-new-doc .callout {||  margin: 20px 0 16px;||  padding: 18px 22px;||  border-radius: var(&#8211;radius-md);||}||||.airms-new-doc .callout p:last-child {||  margin-bottom: 0;||}||||.airms-new-doc .callout-accent {||  background: var(&#8211;indigo-050);||  border: 1px solid var(&#8211;indigo-100);||  border-left: 3px solid var(&#8211;accent-500);||}||||.airms-new-doc .callout-warning {||  background: #fef9ee;||  border: 1px solid #fae8be;||  border-left: 3px solid #d97706;||}||||.airms-new-doc .callout-warning strong {||  color: #78350f;||}||||.airms-new-doc .callout-accent strong {||  color: var(&#8211;ink-900);||}||||.airms-new-doc .callout-subtle {||  background: var(&#8211;bg-subtle);||  border: 1px solid var(&#8211;line-soft);||}||||.airms-new-doc .callout-subtle h3 {||  margin-top: 0;||}||||.airms-new-doc .callout-subtle ul {||  margin-bottom: 0;||}||||.airms-new-doc .note {||  background: var(&#8211;bg-subtle);||  border: 1px solid var(&#8211;line);||  border-left: 3px solid #212070;||  padding: 14px 18px;||  margin: 0 0 16px;||  border-radius: 0 var(&#8211;radius-md) var(&#8211;radius-md) 0;||  color: var(&#8211;ink-700);||}||||.airms-new-doc code {||  font-family: var(&#8211;font-mono);||  background: var(&#8211;bg-subtle);||  color: #b81f77;||  padding: 2px 6px;||  border-radius: 4px;||  font-size: 0.87em;||  border: 1px solid var(&#8211;line);||}||||.airms-new-doc .code-block {||  background: var(&#8211;code-bg);||  border-radius: var(&#8211;radius-md);||  margin: 14px 0 22px;||  overflow: hidden;||  box-shadow: 0 8px 24px rgba(33, 32, 112, 0.18);||}||||.airms-new-doc .code-block-header {||  display: flex;||  align-items: center;||  gap: 6px;||  padding: 8px 10px 8px 14px;||  border-bottom: 1px solid var(&#8211;code-line);||}||||.airms-new-doc .code-lang {||  font-family: var(&#8211;font-mono);||  font-size: 11px;||  color: #9b9bc0;||  text-transform: uppercase;||  letter-spacing: 1px;||}||||.airms-new-doc .code-block pre {||  margin: 0;||  padding: 16px 18px 18px;||  font-family: var(&#8211;font-mono);||  font-size: 13.5px;||  line-height: 1.7;||  color: var(&#8211;code-text);||  white-space: pre-wrap;||  word-break: break-word;||  overflow-x: auto;||}||||.airms-new-doc .code-block pre code {||  background: none;||  border: none;||  padding: 0;||  color: inherit;||}||||.airms-new-doc .code-block a {||  color: #f6a3d0;||  background-image: linear-gradient(#f6a3d0, #f6a3d0);||}||||.airms-new-doc .table-wrap {||  overflow-x: auto;||  margin: 14px 0 4px;||  border-radius: var(&#8211;radius-md);||  border: 1px solid var(&#8211;line);||}||||.airms-new-doc table {||  width: 100%;||  border-collapse: collapse;||  font-size: 14px;||}||||.airms-new-doc th {||  background: var(&#8211;indigo-050);||  color: var(&#8211;ink-900);||  font-weight: 600;||  text-align: left;||  padding: 12px 16px;||  font-size: 12px;||  text-transform: uppercase;||  letter-spacing: 0.5px;||  border-bottom: 1px solid var(&#8211;indigo-100);||}||||.airms-new-doc td {||  padding: 12px 16px;||  border-top: 1px solid var(&#8211;line-soft);||  vertical-align: top;||  color: var(&#8211;ink-700);||}||||.airms-new-doc tbody tr:hover {||  background: var(&#8211;bg-subtle);||}||||.airms-new-doc .doc-footer {||  padding: 24px 0 8px;||  text-align: center;||  color: var(&#8211;ink-500);||  font-size: 13px;||}||||@media (max-width: 520px) {||  .airms-new-doc .brand-title { font-size: 24px; }||  .airms-new-doc .doc-section summary { font-size: 21px; }||  .airms-new-doc .eyebrow,||  .airms-new-doc .intro-eyebrow { font-size: 21px; }||}||&#8221; vertical_offset_tablet=&#8221;0&#8243; horizontal_offset_tablet=&#8221;0&#8243; z_index_tablet=&#8221;0&#8243;]<\/p>\n<div class=\"airms-new-doc\">\n<h1>Database Services<\/h1>\n<p>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<p><b><u>MySQL database:<\/u><\/b><\/p>\n<p>Currently, MySQL relational database service is provided using MariaDB 11.0.1. At this moment, there is no backup for the databases.<\/p>\n<p><b><u>Other databases:<\/u><\/b><\/p>\n<p>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 <a href=\"mailto:hpchelp@hpc.mssm.edu\">hpchelp@hpc.mssm.edu<\/a>.<\/p>\n<\/div>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; header_font=&#8221;|600|||||||&#8221; header_text_color=&#8221;#221f72&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; background_pattern_color=&#8221;rgba(0,0,0,0.2)&#8221; background_mask_color=&#8221;#ffffff&#8221; text_text_shadow_horizontal_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; text_text_shadow_vertical_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_vertical_length_tablet=&#8221;0px&#8221; text_text_shadow_blur_strength=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_blur_strength_tablet=&#8221;1px&#8221; link_text_shadow_horizontal_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; link_text_shadow_vertical_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_vertical_length_tablet=&#8221;0px&#8221; link_text_shadow_blur_strength=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ul_text_shadow_horizontal_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ul_text_shadow_vertical_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ul_text_shadow_blur_strength=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ol_text_shadow_horizontal_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ol_text_shadow_vertical_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ol_text_shadow_blur_strength=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_blur_strength_tablet=&#8221;1px&#8221; quote_text_shadow_horizontal_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; quote_text_shadow_vertical_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_vertical_length_tablet=&#8221;0px&#8221; quote_text_shadow_blur_strength=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_text_shadow_horizontal_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_text_shadow_vertical_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_text_shadow_blur_strength=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_2_text_shadow_horizontal_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_2_text_shadow_vertical_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_2_text_shadow_blur_strength=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_3_text_shadow_horizontal_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_3_text_shadow_vertical_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_3_text_shadow_blur_strength=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_4_text_shadow_horizontal_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_4_text_shadow_vertical_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_4_text_shadow_blur_strength=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_5_text_shadow_horizontal_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_5_text_shadow_vertical_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_5_text_shadow_blur_strength=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_6_text_shadow_horizontal_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_6_text_shadow_vertical_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_6_text_shadow_blur_strength=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_blur_strength_tablet=&#8221;1px&#8221; box_shadow_horizontal_tablet=&#8221;0px&#8221; box_shadow_vertical_tablet=&#8221;0px&#8221; box_shadow_blur_tablet=&#8221;40px&#8221; box_shadow_spread_tablet=&#8221;0px&#8221; vertical_offset_tablet=&#8221;0&#8243; horizontal_offset_tablet=&#8221;0&#8243; z_index_tablet=&#8221;0&#8243;]<\/p>\n<div class=\"airms-new-doc\">\n<h2><span style=\"color: #221f72\">MariaDB\/MySQL Database<\/span><\/h2>\n<p>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<p><a href=\"https:\/\/mariadb.com\/docs\/release-notes\/community-server\/about\/compatibility-and-differences\/mariadb-vs-mysql-compatibility\">Compatibility &amp; Differences Between MariaDB and MySQL<\/a><\/p>\n<p>There are two networks can connect to the MariaDB database:<\/p>\n<p><strong>Internal Network <\/strong><em>(within&nbsp;Minerva HPC cluster only):<\/em>&nbsp;On the login nodes li04e01-04, web server web02-03, or compute nodes, you can connect to the database using the internal network,<strong> data1.chimera.hpc.mssm.edu (172.28.7.78)<\/strong>.<\/p>\n<p><strong>External Network <\/strong><em>(campus network or VPN regardless of Minerva HPC cluster connection)<\/em><strong>:<\/strong> On your laptop or other computing devices, connect use <strong>data1.hpc.mssm.edu (10.95.46.229)<\/strong><\/p>\n<p>To access within minerva, without chimera.hpc.mssm.edu is OK:<\/p>\n<blockquote>\n<pre><code> $ mysql -h data1 -u userid -p your_database<\/code><\/pre>\n<\/blockquote>\n<p>To access within campus network, eg on your laptop, use data1.hpc.mssm.edu, .hpc.mssm.edu is needed:<\/p>\n<blockquote>\n<pre><code> $ mysql -h data1.hpc.mssm.edu -u userid -p your_database<\/code><\/pre>\n<\/blockquote>\n<p>To backup your database, do<\/p>\n<blockquote>\n<pre><span class=\"crayon-v\">$ mysqldump<\/span> <span class=\"crayon-o\">-<\/span><span class=\"crayon-i\">u userid<\/span> \u2013p your_database <span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">tablename<\/span><span class=\"crayon-sy\">] -h data1<\/span> <span class=\"crayon-o\">&gt;<\/span> <span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">dumpfilename<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">sql<\/span><span class=\"crayon-sy\">]<\/span><\/pre>\n<\/blockquote>\n<p>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 <a href=\"mailto:hpchelp@hpc.mssm.edu\">hpchelp@hpc.mssm.edu<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h1>External Links<\/h1>\n<p><a href=\"https:\/\/www.tutorialspoint.com\/mariadb\/index.htm\">MariaDB Tutorial<\/a><br \/> <a href=\"https:\/\/mariadb.com\/kb\/en\/library\/documentation\/\">MariaDB Documentation<\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Scientific Computing and Data Documentation Database: MariaDB Database ServicesMinerva 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 [&hellip;]<\/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":19,"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/pages\/11341\/revisions"}],"predecessor-version":[{"id":16294,"href":"https:\/\/labs.icahn.mssm.edu\/minervalab\/wp-json\/wp\/v2\/pages\/11341\/revisions\/16294"}],"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}]}}