{"id":4097,"date":"2017-06-20T19:37:50","date_gmt":"2017-06-20T19:37:50","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2017\/06\/20\/what-is-mariadb\/"},"modified":"2023-12-22T14:59:40","modified_gmt":"2023-12-22T19:59:40","slug":"what-is-mariadb","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/","title":{"rendered":"What is MariaDB?"},"content":{"rendered":"<p><a href=\"\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png\" rel=\"lightbox-0\"><img decoding=\"async\" width=\"306\" height=\"123\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png\" class=\"optimized-lcp-image\" alt=\"MariaDB logo\" loading=\"eager\" fetchpriority=\"high\" sizes=\"(max-width: 768px) 100vw, 768px\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png 306w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo-300x121.png 300w\"><\/a><\/p>\n<div style=\"clear: both;\"><\/div>\n<p><strong>MariaDB<\/strong> is an open source relational database management system based on MySQL. It is a fork or developmental derivative of MySQL and provides a replacement for MySQL as well. The database was developed after MySQL was acquired by the Oracle Corporation. One of MariaDB\u2019s strengths is that it focuses on security for the database with the MariaDB team continually finding and fixing security issues for both MySQL and MariaDB. In terms of compatibility, MariaDB is made to be a database solution where you can move a MySQL database directly into the MariaDB system easily.<\/p>\n<h2>What are the advantages of using MariaDB?<\/h2>\n<p>Aside from the better security, MariaDB also has improved performance, better query optimizers, faster joins, and PAM support (Pluggable Authentication Modules \u2013 see <a href=\"https:\/\/www.kernel.org\/pub\/linux\/libs\/pam\/whatispam.html\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">What is PAM<\/a> for further information). MariaDB also supports far more storage engines. These include ColumnStore, Aria, Spider, Cassandra and others. There also far fewer bugs and warnings in MariaDB and a variety of extensions available. Finally, the makers of MariaDB are dedicated to keeping the code of MariaDB open source.<\/p>\n<h2>MariaDB Versioning<\/h2>\n<p>The versions of MariaDB are identical to MySQL through version 5.5. It offers all of the MySQL 5.5 features. After version 5.5, MariaDB versions start at 10. This is to indicate that not all of the features from MySQL will be imported. The current stable release of MariaDB is 10.2.<\/p>\n<h2>Can I use MariaDB with my InMotion Subscription?<\/h2>\n<p>Yes, but currently only VPS or <a href=\"https:\/\/www.inmotionhosting.com\/dedicated-servers\">Dedicated web hosting<\/a> accounts can install MariaDB. <a href=\"\/support\/amp\/obtain-root-access\/\">Root access<\/a> is required to install MariaDB yourself. Note that once you upgrade to MariaDB,you will not be able to downgrade to the older version without doing a complete restoration of a backup of your entire installation.<\/p>\n<h2>For more information on MariaDB<\/h2>\n<p>The development of MariaDB is a community effort. For more information please see <a href=\"https:\/\/mariadb.com\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">the MariaDB Website<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB is an open source relational database management system based on MySQL. It is a fork or developmental derivative of MySQL and provides a replacement for MySQL as well. The database was developed after MySQL was acquired by the Oracle Corporation. One of MariaDB\u2019s strengths is that it focuses on security for the database with<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/\"> Read More ><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4305],"tags":[],"class_list":["post-4097","post","type-post","status-publish","format-standard","hentry","category-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is MariaDB? | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Learn about MariaDB and how it is different from MySQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is MariaDB? | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Learn about MariaDB and how it is different from MySQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-20T19:37:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-22T19:59:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b\"},\"headline\":\"What is MariaDB?\",\"datePublished\":\"2017-06-20T19:37:50+00:00\",\"dateModified\":\"2023-12-22T19:59:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/\"},\"wordCount\":306,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png\",\"articleSection\":[\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/\",\"name\":\"What is MariaDB? | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png\",\"datePublished\":\"2017-06-20T19:37:50+00:00\",\"dateModified\":\"2023-12-22T19:59:40+00:00\",\"description\":\"Learn about MariaDB and how it is different from MySQL\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png\",\"width\":306,\"height\":123,\"caption\":\"MariaDB logo\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is MariaDB?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/arn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is MariaDB? | InMotion Hosting","description":"Learn about MariaDB and how it is different from MySQL","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/","og_locale":"en_US","og_type":"article","og_title":"What is MariaDB? | InMotion Hosting","og_description":"Learn about MariaDB and how it is different from MySQL","og_url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2017-06-20T19:37:50+00:00","article_modified_time":"2023-12-22T19:59:40+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png","type":"","width":"","height":""}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b"},"headline":"What is MariaDB?","datePublished":"2017-06-20T19:37:50+00:00","dateModified":"2023-12-22T19:59:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/"},"wordCount":306,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png","articleSection":["Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/","url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/","name":"What is MariaDB? | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png","datePublished":"2017-06-20T19:37:50+00:00","dateModified":"2023-12-22T19:59:40+00:00","description":"Learn about MariaDB and how it is different from MySQL","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/06\/mariadb-logo_maria-db-logo.png","width":306,"height":123,"caption":"MariaDB logo"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"What is MariaDB?"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/arn\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":4305,"name":"Working with Databases","slug":"databases","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=4097"}],"version-history":[{"count":3,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4097\/revisions"}],"predecessor-version":[{"id":108532,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4097\/revisions\/108532"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=4097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=4097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=4097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}