{"id":38969,"date":"2021-10-11T12:30:00","date_gmt":"2021-10-11T17:30:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=38969"},"modified":"2023-01-05T03:01:40","modified_gmt":"2023-01-05T09:01:40","slug":"mariadb-as-a-service-in-rosehosting-cloud-platform","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/","title":{"rendered":"MariaDB-as-a-Service in RoseHosting Cloud Platform"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"742\" height=\"372\" class=\"wp-image-39011\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg\" alt=\"mariadb as a service in rh cloud platform\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform-150x75.jpg 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Do you know what is MariaDB and what the purpose of the MariaDB service is? Don\u2019t worry, we will explain and dig deeper into the meaning of it, and what can be achieved using this type of service.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"alignright size-large is-resized\"><img decoding=\"async\" class=\"wp-image-39028\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-saas-in-rosehosting-cloud-platform-1024x835.png?v=1632483101\" alt=\"mariadb saas in rosehosting cloud platform\" width=\"153\" height=\"125\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-saas-in-rosehosting-cloud-platform-1024x835.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-saas-in-rosehosting-cloud-platform-300x245.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-saas-in-rosehosting-cloud-platform-150x122.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-saas-in-rosehosting-cloud-platform-768x626.png 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-saas-in-rosehosting-cloud-platform.png 1293w\" sizes=\"(max-width: 153px) 100vw, 153px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>MariaDB is one of the most popular open-source database servers in the world. Designed by the MySQL developers, MariaDB offers fastness, scalability, and robustness. It has a reach storage engine and many tools designed as replacements for MySQL. As a service, MariaDB is offered by our <a href=\"https:\/\/www.rosehosting.com\/managed-cloud-hosting.html\" target=\"_blank\" rel=\"noreferrer noopener\">RoseHosting Cloud<\/a> platform and more about the installation, configuration and benefits will be explained in the next few paragraphs. Let\u2019s start!<\/p>\r\n\r\n\r\n\r\n<p><!--more--><\/p>\r\n\r\n\r\n\r\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69c9df6b35717\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69c9df6b35717\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#The-complexity-of-the-configuration-of-MariaDB\" >The complexity of the configuration of MariaDB<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#MariaDB-as-a-Service-in-RoseHosting-Cloud-Platform\" >MariaDB-as-a Service in RoseHosting Cloud Platform<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#Database-Replication-Scheme\" >Database Replication Scheme<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-the-complexity-of-the-configuration-of-mariadb\"><span class=\"ez-toc-section\" id=\"The-complexity-of-the-configuration-of-MariaDB\"><\/span><strong>The complexity of the configuration of MariaDB<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>In standard hosting, you have a virtual private server and access to it. If you want to install and configure MariaDB you have to do multiple steps such as installing from scratch, configure it and optimize it according to the need of the application. Also, it is very important to make some strategy for daily or weekly backup of the databases as well in case something went wrong.<\/p>\r\n\r\n\r\n\r\n<p>Let\u2019s say that everything is OK, and suddenly your server crashes and you face downtime. Ok, that is not a very big problem you will revert the database from the backup and everything will be ok. If somehow this happens again, then the next step will be another virtual server with replication of the MariaDB and load balancer. Do you know how much time you lose during this most common scenario? Now you see how hard was to install configure, optimize, do the backup strategy, revert the database from backup, make another installation, and all from scratch. All these steps took a couple of hours to be completed, and the downtime was very long.<\/p>\r\n\r\n\r\n\r\n<p>Do not worry, we have a solution for this and the solution is only a few clicks away, on our RoseHosting Cloud Platform. In the next paragraph, we will explain what is MariaDB-as-a-Service result of and how it changes the complexity of the configuration.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-mariadb-as-a-service-in-rosehosting-cloud-platform\"><span class=\"ez-toc-section\" id=\"MariaDB-as-a-Service-in-RoseHosting-Cloud-Platform\"><\/span><strong>MariaDB-as-a Service in RoseHosting Cloud Platform<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>As years were passing by, with MariaDB hosting there were too many issues with the configuration of replica databases, their optimization, and configuration. Also, big-sized databases were a very big problem for restoration and there was a downtime that sometimes costumers made without their websites accessible a couple of hours. Downtime is not what the customers want neither the hosting companies. That is why this solution is now available as an option in our RoseHosting Cloud platform.<\/p>\r\n\r\n\r\n\r\n<p>There are a couple of benefits that MariaDB offers on our RoseHosting Cloud platform:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>Simplified installation<\/strong> \u2013 One-click installation, against step by step<\/li>\r\n<li><strong>Multiple Choices<\/strong> \u2013 Three different MariaDB replication schemes, SQL load balancing, and easy scalability.<\/li>\r\n<li><strong>Optimization<\/strong> \u2013 Already optimized databases according to the needs of the application.<\/li>\r\n<li><strong>Reliability<\/strong> \u2013 Multiple database instances that eliminate the risk of downtime.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-database-replication-scheme\"><span class=\"ez-toc-section\" id=\"Database-Replication-Scheme\"><\/span><strong>Database Replication Scheme<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>As we said previously RoseHosting Cloud platform offers three different replication schemes of MariaDB like primary-secondary replication, primary-primary, and Galera cluster replication. In this paragraph, we will explain in more detail what are the main differences between these replications.<\/p>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\" id=\"h-primary-secondary-replication\"><strong>Primary-Secondary Replication:<\/strong><\/h4>\r\n\r\n\r\n\r\n<p>With this replication are provisioned two nodes, one is primary and another one secondary. For load balancing servers are provisioned two ProxySQL servers. For this topology are inherent the following lines of parameters:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">Server-id = {nodeId}\r\nbinlog_format = mixed\r\nlog-bin = mysql-bin\r\nLog-slave-updates = ON\r\nexpire_logs_days = 7\r\nrelay-log = \/var\/lib\/mysql\/mysql-relay-bin\r\nrelay-log-index = \/var\/lib\/mysql\/mysql-relay-bin.index\r\nreplicate-wild-ignore-table = performance_schema.%\r\nreplicate-wild-ignore-table = information_schema.%\r\nreplicate-wild-ignore-table = mysql.%<\/pre>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\" id=\"h-primary-primary-replication\"><strong>Primary-Primary Replication:<\/strong><\/h4>\r\n\r\n\r\n\r\n<p>With this replication are provisioned two database nodes, and two of them are working as primary nodes. For load balancing servers are provisioned two ProxySQL servers. This topology is used when the application needs writing and reading from the database and the following lines of parameters are inherent:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">server-id = {nodeId}\r\nbinlog_format = mixed\r\nauto-increment-increment = 2\r\nAuto-increment-offset = {1 or 2}\r\nlog-bin = mysql-bin\r\nlog-slave-updates\r\nexpire_logs_days = 7\r\nrelay-log = \/var\/lib\/mysql\/mysql-relay-bin\r\nrelay-log-index = \/var\/lib\/mysql\/mysql-relay-bin.index\r\nreplicate-wild-ignore-table = performance_schema.%\r\nreplicate-wild-ignore-table = information_schema.%\r\nreplicate-wild-ignore-table = mysql.%<\/pre>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\" id=\"h-galera-cluster-replication\"><strong>Galera Cluster Replication:<\/strong><\/h4>\r\n\r\n\r\n\r\n<p>For this replication, we have three database nodes of MariaDB and like previous replications two ProxySQL nodes for load balancing. This is suitable for geographically distanced regions. For this topology are inherent the following lines of parameters:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">server-id = {nodeId}\r\nbinlog_format = ROW\r\n# Galera Provider Configuration\r\nwsrep_on = ON\r\nwsrep_provider = \/usr\/lib64\/galera\/libgalera_smm.so\r\n# Galera Cluster Configuration\r\nwsrep_cluster_name = cluster\r\nwsrep_cluster_address = gcomm:\/\/{node1},{node2},{node3}\r\nwsrep-replicate-myisam = 1\r\n# Galera Node Configuration\r\nWsrep_node_address = {node.ip}\r\nWsrep_node_name = {node.name}<\/pre>\r\n\r\n\r\n\r\n<p>This tutorial was an explanation of what is MariaDB as a service and what makes it popular against the traditional MariaDB hosting. We manage to provide you with some important information about MariaDB replication schemes and of course if there are any unclear configuration issues you can always contact our RoseHosting support. We are available 24\/7 to help you.<\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" class=\"wp-image-39036\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-mysql-as-a-service-in-rosehosting-cloud-platform.png\" alt=\"\" width=\"153\" height=\"153\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-mysql-as-a-service-in-rosehosting-cloud-platform.png 348w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-mysql-as-a-service-in-rosehosting-cloud-platform-300x300.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-mysql-as-a-service-in-rosehosting-cloud-platform-150x150.png 150w\" sizes=\"(max-width: 153px) 100vw, 153px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p>If you liked this post on what is MariaDB as a service in <a href=\"https:\/\/www.rosehosting.com\/managed-cloud-hosting.html\" target=\"_blank\" rel=\"noreferrer noopener\">RoseHosting Cloud<\/a>, please do not forget to share with your friends on the social networks, or you can leave a comment in the comments section. Thanks for your time!<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Do you know what is MariaDB and what the purpose of the MariaDB service is? Don\u2019t worry, we will explain &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"MariaDB-as-a-Service in RoseHosting Cloud Platform\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#more-38969\" aria-label=\"Read more about MariaDB-as-a-Service in RoseHosting Cloud Platform\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":39011,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,4,1707],"tags":[1951,296,1952],"class_list":["post-38969","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-rosehosting","category-web-servers","tag-as-a-service","tag-mariadb","tag-rh-cloud-platform","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>MariaDB-as-a-Service in RH Cloud Platform | RoseHosting<\/title>\n<meta name=\"description\" content=\"Find out why MariaDB-as-a-Service is best for a simple installation, optimization, and database reliability.\" \/>\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.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB-as-a-Service in RH Cloud Platform | RoseHosting\" \/>\n<meta property=\"og:description\" content=\"Find out why MariaDB-as-a-Service is best for a simple installation, optimization, and database reliability.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-11T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-05T09:01:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg?v=1632482057\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"MariaDB-as-a-Service in RH Cloud Platform | RoseHosting\" \/>\n<meta name=\"twitter:description\" content=\"Find out why MariaDB-as-a-Service is best for a simple installation, optimization, and database reliability.\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"MariaDB-as-a-Service in RoseHosting Cloud Platform\",\"datePublished\":\"2021-10-11T17:30:00+00:00\",\"dateModified\":\"2023-01-05T09:01:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/\"},\"wordCount\":752,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg\",\"keywords\":[\"as a service\",\"mariadb\",\"rh cloud platform\"],\"articleSection\":[\"Databases\",\"RoseHosting Platform\",\"Web Servers\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/\",\"name\":\"MariaDB-as-a-Service in RH Cloud Platform | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg\",\"datePublished\":\"2021-10-11T17:30:00+00:00\",\"dateModified\":\"2023-01-05T09:01:40+00:00\",\"description\":\"Find out why MariaDB-as-a-Service is best for a simple installation, optimization, and database reliability.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg\",\"width\":742,\"height\":372,\"caption\":\"mariadb as a service in rh cloud platform\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB-as-a-Service in RoseHosting Cloud Platform\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MariaDB-as-a-Service in RH Cloud Platform | RoseHosting","description":"Find out why MariaDB-as-a-Service is best for a simple installation, optimization, and database reliability.","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.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/","og_locale":"en_US","og_type":"article","og_title":"MariaDB-as-a-Service in RH Cloud Platform | RoseHosting","og_description":"Find out why MariaDB-as-a-Service is best for a simple installation, optimization, and database reliability.","og_url":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2021-10-11T17:30:00+00:00","article_modified_time":"2023-01-05T09:01:40+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg?v=1632482057","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_title":"MariaDB-as-a-Service in RH Cloud Platform | RoseHosting","twitter_description":"Find out why MariaDB-as-a-Service is best for a simple installation, optimization, and database reliability.","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"MariaDB-as-a-Service in RoseHosting Cloud Platform","datePublished":"2021-10-11T17:30:00+00:00","dateModified":"2023-01-05T09:01:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/"},"wordCount":752,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg","keywords":["as a service","mariadb","rh cloud platform"],"articleSection":["Databases","RoseHosting Platform","Web Servers"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/","url":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/","name":"MariaDB-as-a-Service in RH Cloud Platform | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg","datePublished":"2021-10-11T17:30:00+00:00","dateModified":"2023-01-05T09:01:40+00:00","description":"Find out why MariaDB-as-a-Service is best for a simple installation, optimization, and database reliability.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/09\/mariadb-as-a-service-in-rh-cloud-platform.jpg","width":742,"height":372,"caption":"mariadb as a service in rh cloud platform"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-as-a-service-in-rosehosting-cloud-platform\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MariaDB-as-a-Service in RoseHosting Cloud Platform"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/38969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=38969"}],"version-history":[{"count":44,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/38969\/revisions"}],"predecessor-version":[{"id":44637,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/38969\/revisions\/44637"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/39011"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=38969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=38969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=38969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}