{"id":37586,"date":"2021-07-02T12:30:00","date_gmt":"2021-07-02T17:30:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=37586"},"modified":"2024-03-06T05:10:23","modified_gmt":"2024-03-06T11:10:23","slug":"mariadb-galera-cluster-replication","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/","title":{"rendered":"MariaDB Galera Cluster Replication"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"742\" height=\"372\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication.jpg\" alt=\"MariaDB Galera Cluster Replication\" class=\"wp-image-37593\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication-150x75.jpg 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/figure><\/div>\n\n\n\n<p>MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster for the MariaDB database. Clustering is a technology that provides high availability to your database by distributing the changes among multiple database nodes. If one of the database nodes fails others are quickly available to continue serving.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p><strong>Features of Galera Cluster<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Provides synchronous replication so if one of the nodes crashed not data is lost.<\/li><li>True multi-master. This means you can read and write on any node.<\/li><li>Provides multi-threaded slave to handle any workload.<\/li><li>Provision new node automatically. You don&#8217;t need to backup and copy the database to a new node.<\/li><li>Supports InnoDB.<\/li><li>Hot standby. This means there is no downtime of failover.<\/li><li>Supports multi-cloud and multi-region deployments.<\/li><\/ul>\n\n\n\n<p>In this guide, we will show you how to deploy a MariaDB Galera cluster on the RoseHosting Cloud Platform.<\/p>\n\n\n\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-69d7dbb2ed74b\" 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-69d7dbb2ed74b\"  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-galera-cluster-replication\/#Install-MariaDB-Galera-Cluster\" >Install MariaDB Galera Cluster<\/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-galera-cluster-replication\/#Access-phpMyAdmin\" >Access phpMyAdmin<\/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-galera-cluster-replication\/#Create-a-Tomcat-Environment-and-Deploy-a-Test-Application\" >Create a Tomcat Environment and Deploy a Test Application<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#Test-Your-Application\" >Test Your Application<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-install-mariadb-galera-cluster\"><span class=\"ez-toc-section\" id=\"Install-MariaDB-Galera-Cluster\"><\/span>Install MariaDB Galera Cluster<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First, log in to the RoseHosting cloud platform using the URL https:\/\/app.rosehosting.cloud as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-rosehosting-cloud-platform-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37677\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-rosehosting-cloud-platform-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-rosehosting-cloud-platform-mariadb-galera-cluster-300x155.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-rosehosting-cloud-platform-mariadb-galera-cluster-150x77.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-rosehosting-cloud-platform-mariadb-galera-cluster-768x397.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Click on the <strong>NEW ENVIRONMENT<\/strong> to create a new environment for MariaDB Galera. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"639\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/new-environment-for-mariadb-galera.png\" alt=\"\" class=\"wp-image-37679\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/new-environment-for-mariadb-galera.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/new-environment-for-mariadb-galera-300x187.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/new-environment-for-mariadb-galera-150x94.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/new-environment-for-mariadb-galera-768x479.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Here, select the MariaDB, Enable auto-clustering, Enable Add ProxySQL, Define your environment name and click on the <strong>Create<\/strong> button. After few minutes, your environment has been created as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"346\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-clustering.png\" alt=\"\" class=\"wp-image-37682\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-clustering.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-clustering-300x101.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-clustering-150x51.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-clustering-768x260.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You should also receive an email with access credentials of PhpMyAdmin and Orchestrator admin panel.<\/p>\n\n\n\n<p>You can monitor the health of the cluster nodes by accessing the Orchestrator admin panel as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"273\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37680\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-300x80.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-150x40.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-768x205.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-access-phpmyadmin\"><span class=\"ez-toc-section\" id=\"Access-phpMyAdmin\"><\/span>Access phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After the creation of the MariaDB Galera cluster, you should receive an email with the phpMyAdmin access URL and credentials.<\/p>\n\n\n\n<p>Now, log in to the phpMyAdmin admin console using the URL and credential received via email:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"339\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-phpmyadmin-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37683\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-phpmyadmin-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-phpmyadmin-mariadb-galera-cluster-300x99.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-phpmyadmin-mariadb-galera-cluster-150x50.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/log-in-phpmyadmin-mariadb-galera-cluster-768x254.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>In the left pane, click on the <strong>test<\/strong> database. In the right pane, you should see that there are no tables in the database test.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-create-a-tomcat-environment-and-deploy-a-test-application\"><span class=\"ez-toc-section\" id=\"Create-a-Tomcat-Environment-and-Deploy-a-Test-Application\"><\/span>Create a Tomcat Environment and Deploy a Test Application<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this guide, we will make a connection from the Java application to the Galera Cluster using ProxySQL. So you will need to create a new environment for the Tomcat application.<\/p>\n\n\n\n<p>On the RoseHosting dashboard, click on the <strong>NEW ENVIRONMENT<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"639\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/create-tomcat-environment-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37684\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/create-tomcat-environment-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/create-tomcat-environment-mariadb-galera-cluster-300x187.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/create-tomcat-environment-mariadb-galera-cluster-150x94.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/create-tomcat-environment-mariadb-galera-cluster-768x479.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Select Tomcat application, Define your environment name and click on the <strong>Create<\/strong> button. Once the Tomcat environment has been created, you should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"331\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37820\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-mariadb-galera-cluster-300x97.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-mariadb-galera-cluster-150x48.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-mariadb-galera-cluster-768x248.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Next, you will need to create a database config file for the Tomcat test application.<\/p>\n\n\n\n<p>To do so, click on the Config icon inside your Tomcat application then click on the <strong>temp<\/strong> in the left-pane and create a new file <strong>mydb.cfg<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"327\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/database-config-tomcat-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37821\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/database-config-tomcat-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/database-config-tomcat-mariadb-galera-cluster-300x96.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/database-config-tomcat-mariadb-galera-cluster-150x48.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/database-config-tomcat-mariadb-galera-cluster-768x245.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"408\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-database-config-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37831\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-database-config-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-database-config-mariadb-galera-cluster-300x120.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-database-config-mariadb-galera-cluster-150x60.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-database-config-mariadb-galera-cluster-768x306.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Write the following content in the <strong>mydb.cfg<\/strong> file:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">host=jdbc:mariadb:\/\/proxy.replication.rosehosting.us:3306\/test?usePipelineAuth=false\nusername=jelastic-8162166\npassword=PprrhpkeGglrT1AbW720\ndriver=org.mariadb.jdbc.Driver\n<\/pre>\n\n\n\n<p><strong>Where:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Host<\/strong> is the URL of the ProxySQL node that you received in your email.<\/li><li><strong>username and password<\/strong> are the credentials of ProxySQL node that you received in your email.<\/li><\/ul>\n\n\n\n<p>Now, click on the <strong>Save<\/strong> button to save the mydb.cfg file.<\/p>\n\n\n\n<p>Next, you will need to deploy a test application on the Tomcat server.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"290\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/deploy-test-application-tomcat-server-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37822\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/deploy-test-application-tomcat-server-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/deploy-test-application-tomcat-server-mariadb-galera-cluster-300x85.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/deploy-test-application-tomcat-server-mariadb-galera-cluster-150x42.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/deploy-test-application-tomcat-server-mariadb-galera-cluster-768x218.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>On the Tomcat environment, click on the URL icon in the Deployments section. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"360\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-deployments-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37823\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-deployments-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-deployments-mariadb-galera-cluster-300x105.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-deployments-mariadb-galera-cluster-150x53.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-environment-deployments-mariadb-galera-cluster-768x270.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now, copy and paste the following link based on your Tomcat version then click on the <strong>Deploy<\/strong> button.<\/p>\n\n\n\n<p><strong>For Apache Tomcat 9 and below use the following URL:<\/strong><br>https:\/\/download.jelastic.com\/public.php?service=files&amp;t=40b1bd6e376db56df1945fade1cbd851&amp;download<\/p>\n\n\n\n<p><strong>For Apache Tomcat 10 use the following URL:<\/strong><br>https:\/\/download.jelastic.com\/public.php?service=files&amp;t=0ce6e86db89238ddb43ba18d5a89bbea&amp;download<\/p>\n\n\n\n<p>Once the test application has been deployed, you should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"294\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-test-application-deployed-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37824\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-test-application-deployed-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-test-application-deployed-mariadb-galera-cluster-300x86.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-test-application-deployed-mariadb-galera-cluster-150x43.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-test-application-deployed-mariadb-galera-cluster-768x221.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now, click on the <strong>Restart Nodes<\/strong> button next to your Tomcat application to apply the changes.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"312\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/restart-nodes-tomcat-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37825\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/restart-nodes-tomcat-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/restart-nodes-tomcat-mariadb-galera-cluster-300x91.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/restart-nodes-tomcat-mariadb-galera-cluster-150x46.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/restart-nodes-tomcat-mariadb-galera-cluster-768x234.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-test-your-application\"><span class=\"ez-toc-section\" id=\"Test-Your-Application\"><\/span>Test Your Application<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Once the Tomcat server is restarted, click on the Open in Browser next to the Tomcat application as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"244\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-application-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37685\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-application-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-application-mariadb-galera-cluster-300x71.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-application-mariadb-galera-cluster-150x36.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/tomcat-application-mariadb-galera-cluster-768x183.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>You should see the Java test application on the following page:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"873\" height=\"444\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/java-test-application-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37827\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/java-test-application-mariadb-galera-cluster.png 873w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/java-test-application-mariadb-galera-cluster-300x153.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/java-test-application-mariadb-galera-cluster-150x76.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/java-test-application-mariadb-galera-cluster-768x391.png 768w\" sizes=\"(max-width: 873px) 100vw, 873px\" \/><\/figure>\n\n\n\n<p>Click on the <strong>Create test table in your database<\/strong>. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"755\" height=\"368\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/create-test-table-in-database-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37828\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/create-test-table-in-database-mariadb-galera-cluster.png 755w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/create-test-table-in-database-mariadb-galera-cluster-300x146.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/create-test-table-in-database-mariadb-galera-cluster-150x73.png 150w\" sizes=\"(max-width: 755px) 100vw, 755px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>This will create a new table in the <strong>test<\/strong> database on the MariaDB Galera cluster.<\/p>\n\n\n\n<p>To verify whether a new table is created or not. Access your phpMyAdmin interface and click on the <strong>test<\/strong> database. You should see a new table with the name (Current date and time).<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"474\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/phpmyadmin-test-database-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37829\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/phpmyadmin-test-database-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/phpmyadmin-test-database-mariadb-galera-cluster-300x139.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/phpmyadmin-test-database-mariadb-galera-cluster-150x69.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/phpmyadmin-test-database-mariadb-galera-cluster-768x356.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>To test the replication between all nodes, access the phpMyAdmin panels of all nodes using the same credentials.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"305\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/test-replication-between-nodes-mariadb-galera-cluster.png\" alt=\"\" class=\"wp-image-37830\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/test-replication-between-nodes-mariadb-galera-cluster.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/test-replication-between-nodes-mariadb-galera-cluster-300x89.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/test-replication-between-nodes-mariadb-galera-cluster-150x45.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/test-replication-between-nodes-mariadb-galera-cluster-768x229.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Congratulations! You have successfully deployed a highly available and reliable MariaDB Galera cluster on the RoseHosting Cloud platform.<\/p>\n\n\n\n<p>Of course, you don\u2019t have to&nbsp;do it by yourself, if you use one of our&nbsp;<a href=\"https:\/\/www.rosehosting.com\/mariadb-hosting.html\">MariaDB Hosting services<\/a>, in which case you can simply ask our friendly customer support for expertise. They are available<strong> 24\/7<\/strong>, all year round, and will take care of the deployment and configuration immediately.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster for the &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"MariaDB Galera Cluster Replication\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#more-37586\" aria-label=\"Read more about MariaDB Galera Cluster Replication\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":37593,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702],"tags":[41,296,1636],"class_list":["post-37586","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","tag-database","tag-mariadb","tag-mariadb-galera-cluster","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.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>MariaDB Galera Cluster Replication | RoseHosting<\/title>\n<meta name=\"description\" content=\"MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster.\" \/>\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-galera-cluster-replication\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB Galera Cluster Replication\" \/>\n<meta property=\"og:description\" content=\"MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster for the MariaDB database. Read about it in our guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/\" \/>\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-07-02T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-06T11:10:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication.jpg\" \/>\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:description\" content=\"MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster for the MariaDB database. Read about it in our guide.\" \/>\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=\"8 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-galera-cluster-replication\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"MariaDB Galera Cluster Replication\",\"datePublished\":\"2021-07-02T17:30:00+00:00\",\"dateModified\":\"2024-03-06T11:10:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/\"},\"wordCount\":810,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/mariadb-galera-cluster-replication.jpg\",\"keywords\":[\"database\",\"mariadb\",\"MariaDB Galera Cluster\"],\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/\",\"name\":\"MariaDB Galera Cluster Replication | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/mariadb-galera-cluster-replication.jpg\",\"datePublished\":\"2021-07-02T17:30:00+00:00\",\"dateModified\":\"2024-03-06T11:10:23+00:00\",\"description\":\"MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/mariadb-galera-cluster-replication.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/mariadb-galera-cluster-replication.jpg\",\"width\":742,\"height\":372,\"caption\":\"MariaDB Galera Cluster Replication\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-galera-cluster-replication\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB Galera Cluster Replication\"}]},{\"@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 Galera Cluster Replication | RoseHosting","description":"MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster.","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-galera-cluster-replication\/","og_locale":"en_US","og_type":"article","og_title":"MariaDB Galera Cluster Replication","og_description":"MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster for the MariaDB database. Read about it in our guide.","og_url":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2021-07-02T17:30:00+00:00","article_modified_time":"2024-03-06T11:10:23+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_description":"MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster for the MariaDB database. Read about it in our guide.","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"MariaDB Galera Cluster Replication","datePublished":"2021-07-02T17:30:00+00:00","dateModified":"2024-03-06T11:10:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/"},"wordCount":810,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication.jpg","keywords":["database","mariadb","MariaDB Galera Cluster"],"articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/","url":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/","name":"MariaDB Galera Cluster Replication | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication.jpg","datePublished":"2021-07-02T17:30:00+00:00","dateModified":"2024-03-06T11:10:23+00:00","description":"MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/mariadb-galera-cluster-replication.jpg","width":742,"height":372,"caption":"MariaDB Galera Cluster Replication"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-galera-cluster-replication\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MariaDB Galera Cluster Replication"}]},{"@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\/37586","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=37586"}],"version-history":[{"count":5,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/37586\/revisions"}],"predecessor-version":[{"id":48219,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/37586\/revisions\/48219"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/37593"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=37586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=37586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=37586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}