{"id":35627,"date":"2021-03-08T12:08:00","date_gmt":"2021-03-08T18:08:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=35627"},"modified":"2022-06-03T03:32:12","modified_gmt":"2022-06-03T08:32:12","slug":"mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/","title":{"rendered":"MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication for High Availability and Performance"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"742\" height=\"372\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png\" alt=\"mariadb\/mysql auto-\u0441lustering with load balancing and replication for high availability and performance\" class=\"wp-image-35816\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance-300x150.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance-150x75.png 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/figure>\n\n\n\n<p>These days high availability and database clustering are very important for highly loaded production applications. If your server is down for a fraction of time, you are losing customers and money. Therefore making a database environment highly available has typically one of the highest priorities. Set up a highly available cluster is not easier for any developers and system administrators.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p><a href=\"https:\/\/www.rosehosting.com\/managed-cloud-hosting.html\">RoseHosting cloud platform<\/a> provides MariaDB\/MySQL clustering out-of-the-box to make your application highly available.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-features-of-mariadb-mysql-clustering\">Features of MariaDB\/MySQL Clustering<\/h3>\n\n\n\n<p><strong>high availability with pre-configured replication options:<\/strong> You have three options for replication, Master-Slave, Master-Master, and Galera.<br><strong>scalability and autodiscovery:<\/strong> New nodes are added automatically during horizontal scaling with all required configurations. So you don&#8217;t need to do anything manually.<br><strong>efficient load balancing: <\/strong>Each cluster comes with two ProxySQL nodes that are used for load balancing and also enables automatic splitting of read\/write requests,<br><strong>automated failover:<\/strong> Exclude those nodes automatically from the cluster which are temporarily unavailable. Once the connections are restored, they have added automatically.<\/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-69f036afcadff\" 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-69f036afcadff\"  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-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#Setup-Clustering-for-MariaDBMySQL-Databases\" >Setup Clustering for MariaDB\/MySQL Databases<\/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-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#Create-Database-Cluster-Access-Credentials\" >Create Database Cluster Access Credentials<\/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-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#Access-Cluster-Components\" >Access Cluster Components<\/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-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#What-Replication-Type-to-Choose\" >What Replication Type to Choose?<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-setup-clustering-for-mariadb-mysql-databases\"><span class=\"ez-toc-section\" id=\"Setup-Clustering-for-MariaDBMySQL-Databases\"><\/span>Setup Clustering for MariaDB\/MySQL Databases<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this section, we will show you how to enable auto-clustering for your <a href=\"https:\/\/www.rosehosting.com\/mariadb-hosting.html\">MariaDB<\/a> and MySQL databases in RoseHosting Cloud.<\/p>\n\n\n\n<p>First, log in to RoseHosting cloud platform 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\/02\/how-to-setup-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png\" alt=\"how to setup mariadb\/mysql auto-\u0441lustering with load balancing and replication \" class=\"wp-image-35683\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/how-to-setup-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/how-to-setup-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-300x155.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/how-to-setup-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-150x77.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/how-to-setup-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-768x397.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now, click on the <strong>NEW ENVIRONMENT<\/strong> to create a new environment for MariaDB clustering. You should see the following screen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"525\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/setting-up-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png\" alt=\"setting up mariadb mysql auto \u0441lustering with load balancing and replication\" class=\"wp-image-35863\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/setting-up-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/setting-up-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-300x154.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/setting-up-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-150x77.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/setting-up-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-768x394.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now, select the <strong>MariaDB or MySQL<\/strong> database, define your Scaling limit, Reserved cloudlets, enable the Auto-Clustering option and select <strong>Master-Slave<\/strong>.<\/p>\n\n\n\n<p>There are different replication schemes for MariaDB and MySQL:<\/p>\n\n\n\n<p><strong>MariaDB:<\/strong> You can choose Master-Slave, Master-Master or Galera.<br><strong>MySQL:<\/strong> You can choose Master-Slave or Master-Master.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-create-database-cluster-access-credentials\"><span class=\"ez-toc-section\" id=\"Create-Database-Cluster-Access-Credentials\"><\/span>Create Database Cluster Access Credentials<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>By default, RoseHosting cloud creates database access credentials automatically. But, you can also create your own database credentials.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"530\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/ultimate-guide-to-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png\" alt=\"ultimate guide to mariadb mysql auto \u0441lustering with load balancing and replication \" class=\"wp-image-35864\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/ultimate-guide-to-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/ultimate-guide-to-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-300x155.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/ultimate-guide-to-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-150x78.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/ultimate-guide-to-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-768x398.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>To create database credentials, click on the <strong>Variables<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"971\" height=\"542\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-setting-up-layers.png\" alt=\"mariadb\/mysql auto-\u0441lustering with load balancing and replication setting up layers\" class=\"wp-image-35687\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-setting-up-layers.png 971w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-setting-up-layers-300x167.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-setting-up-layers-150x84.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-setting-up-layers-768x429.png 768w\" sizes=\"(max-width: 971px) 100vw, 971px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"970\" height=\"542\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png\" alt=\"layer settings for mariadb\/mysql auto-\u0441lustering with load balancing and replication\" class=\"wp-image-35689\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png 970w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-300x168.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-150x84.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-768x429.png 768w\" sizes=\"(max-width: 970px) 100vw, 970px\" \/><\/figure>\n\n\n\n<p>Now, click on the <strong>Add<\/strong> button and provide your database username, password then click on the <strong>Apply<\/strong> button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"975\" height=\"607\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/container-layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-2.png\" alt=\"container layer settings for mariadb\/mysql auto-\u0441lustering with load balancing and replication\" class=\"wp-image-35693\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/container-layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-2.png 975w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/container-layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-2-300x187.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/container-layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-2-150x93.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/container-layer-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-2-768x478.png 768w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/figure>\n\n\n\n<p><br>Next, click on the <strong>Create<\/strong> button to deploy the cluster. You should see your MariaDB cluster in the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"437\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/cluster-components-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png\" alt=\"cluster components for mariadb\/mysql auto-\u0441lustering with load balancing and replication\" class=\"wp-image-35695\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/cluster-components-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/cluster-components-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-300x128.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/cluster-components-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-150x64.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/cluster-components-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-768x328.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-access-cluster-components\"><span class=\"ez-toc-section\" id=\"Access-Cluster-Components\"><\/span>Access Cluster Components<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Once the cluster has been deployed successfully, you should receive an email with all credentials required to access phpMyAdmin at Master Node, Cluster Orchestrator Panel and database cluster Entry Point.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"461\" height=\"580\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/setup-components-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png\" alt=\"setup components for mariadb\/mysql auto-\u0441lustering with load balancing and replication\" class=\"wp-image-35697\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/setup-components-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png 461w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/setup-components-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-238x300.png 238w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/setup-components-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-119x150.png 119w\" sizes=\"(max-width: 461px) 100vw, 461px\" \/><\/figure>\n\n\n\n<p><strong>phpMyAdmin Interface<\/strong><\/p>\n\n\n\n<p>You can access the phpMyAdmin as shown below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"564\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/php-myadmin-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png\" alt=\"php myadmin for mariadb\/mysql auto-\u0441lustering with load balancing and replication\" class=\"wp-image-35699\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/php-myadmin-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/php-myadmin-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-300x165.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/php-myadmin-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-150x83.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/php-myadmin-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-768x423.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Here, you can create, delete and manage your databases.<\/p>\n\n\n\n<p><strong>Entry Point for Connections to MySQL Cluster<\/strong><\/p>\n\n\n\n<p>On the MariaDB cluster dashboard, click on the <strong>Web<\/strong> <strong>SSH<\/strong> button to access the MariaDB console as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"528\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/dashboard-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png\" alt=\"dashboard for mariadb\/mysql auto-\u0441lustering with load balancing and replication\" class=\"wp-image-35701\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/dashboard-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/dashboard-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-300x155.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/dashboard-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-150x77.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/dashboard-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-768x396.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Here, you can run <strong>host<\/strong> command followed by <strong>proxy.mariadb.rosehosting.us<\/strong> to check the cluster nodes IP address.<\/p>\n\n\n\n<p><strong>Cluster Orchestrator Panel<\/strong><\/p>\n\n\n\n<p>You can access the Cluster Orchestrator Panel using the credentials received in the mail.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"433\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-11.png\" alt=\"orchestrator panel for mariadb\/mysql auto-\u0441lustering with load balancing and replication\" class=\"wp-image-35641\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-11.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-11-300x127.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-11-150x63.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-11-768x325.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=\"420\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/orchestrator-panel-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png\" alt=\"orchestrator panel settings for mariadb mysql auto \u0441lustering with load balancing and replication\" class=\"wp-image-35702\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/orchestrator-panel-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/orchestrator-panel-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-300x123.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/orchestrator-panel-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-150x62.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/orchestrator-panel-settings-for-mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-768x315.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>From here, you can manage your cluster, review the cluster topology information and replication problems. You can also check the health state and newly added database node using the panel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-replication-type-to-choose\"><span class=\"ez-toc-section\" id=\"What-Replication-Type-to-Choose\"><\/span>What Replication Type to Choose?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In RoseHosting cloud platform, there are three replication schemes available for databases. A brief explanation of each is shown below:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-master-slave-mariadb-mysql-replication\">Master-Slave MariaDB\/MySQL Replication<\/h3>\n\n\n\n<p>If you want good consistency, but no automatic failover then Master-slave replication is the best option. In Master-slave replication, data from one database server to be replicated to one or more database nodes. The master node is responsible for write operations while all read operations are performed by the Slave node.<\/p>\n\n\n\n<p><strong>Features<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Backups<\/li><li>Scale-out<\/li><li>Spreading the load<\/li><li>Increasing the performance<\/li><li>Security<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-master-master-mariadb-mysql-replication\">Master-Master MariaDB\/MySQL Replication<\/h3>\n\n\n\n<p>Master-master replication is a method of database replication that allows data to be stored by a group of computers, and updated by any member of the group. Compared to Master-Slave replication, Master-Master replication provides load balancing and failover. In Master-Master replication, data to be copied from either server to the other one. This will allows us to perform MySQL read or writes from either server.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-mariadb-galera\">MariaDB Galera<\/h3>\n\n\n\n<p>MariaDB Galera Cluster is a synchronous multi-master cluster for MariaDB and supports the XtraDB\/InnoDB storage engines. It has the ability to scale-out read and write transactions. Nodes can be added automatically in the Galera cluster. One of the greatest advantages of Galera is to provide protection against data loss without any delay in replication.<\/p>\n\n\n\n<p>Of course, you don&#8217;t have to install and configure all of the above if you use our <a href=\"https:\/\/www.rosehosting.com\/managed-cloud-hosting.html\">Managed Cloud Hosting<\/a>, in which case you can ask our support technicians to install and configure MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication for High Availability and Performance.<\/p>\n\n\n\n<p>If you liked this tutorial, please share it with your friends on social medias.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>These days high availability and database clustering are very important for highly loaded production applications. If your server is down &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication for High Availability and Performance\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#more-35627\" aria-label=\"Read more about MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication for High Availability and Performance\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":35816,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1705,4],"tags":[1440,296,39],"class_list":["post-35627","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-load-balancing","category-rosehosting","tag-load-balancing","tag-mariadb","tag-mysql","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.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication<\/title>\n<meta name=\"description\" content=\"Here&#039;s a simple guide to MariaDB\/MySQL Auto-\u0421lustering with Load Balancing, Replication for High Availability And Performance\" \/>\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-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication\" \/>\n<meta property=\"og:description\" content=\"Here&#039;s a simple guide to MariaDB\/MySQL Auto-\u0421lustering with Load Balancing, Replication for High Availability And Performance\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/\" \/>\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-03-08T18:08:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:32:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png?v=1616006748\" \/>\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\/png\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication\" \/>\n<meta name=\"twitter:description\" content=\"Here&#039;s a simple guide to MariaDB\/MySQL Auto-\u0421lustering with Load Balancing, Replication for High Availability And Performance\" \/>\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=\"6 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-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"MariaDB\\\/MySQL Auto-\u0421lustering with Load Balancing and Replication for High Availability and Performance\",\"datePublished\":\"2021-03-08T18:08:00+00:00\",\"dateModified\":\"2022-06-03T08:32:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/\"},\"wordCount\":776,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png\",\"keywords\":[\"load balancing\",\"mariadb\",\"mysql\"],\"articleSection\":[\"Databases\",\"Load Balancing\",\"RoseHosting Platform\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/\",\"name\":\"MariaDB\\\/MySQL Auto-\u0421lustering with Load Balancing and Replication\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png\",\"datePublished\":\"2021-03-08T18:08:00+00:00\",\"dateModified\":\"2022-06-03T08:32:12+00:00\",\"description\":\"Here's a simple guide to MariaDB\\\/MySQL Auto-\u0421lustering with Load Balancing, Replication for High Availability And Performance\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png\",\"width\":742,\"height\":372,\"caption\":\"mariadb\\\/mysql auto-\u0441lustering with load balancing and replication for high availability and performance\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB\\\/MySQL Auto-\u0421lustering with Load Balancing and Replication for High Availability and Performance\"}]},{\"@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\/MySQL Auto-\u0421lustering with Load Balancing and Replication","description":"Here's a simple guide to MariaDB\/MySQL Auto-\u0421lustering with Load Balancing, Replication for High Availability And Performance","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-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/","og_locale":"en_US","og_type":"article","og_title":"MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication","og_description":"Here's a simple guide to MariaDB\/MySQL Auto-\u0421lustering with Load Balancing, Replication for High Availability And Performance","og_url":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2021-03-08T18:08:00+00:00","article_modified_time":"2022-06-03T08:32:12+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png?v=1616006748","type":"image\/png"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_title":"MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication","twitter_description":"Here's a simple guide to MariaDB\/MySQL Auto-\u0421lustering with Load Balancing, Replication for High Availability And Performance","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication for High Availability and Performance","datePublished":"2021-03-08T18:08:00+00:00","dateModified":"2022-06-03T08:32:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/"},"wordCount":776,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png","keywords":["load balancing","mariadb","mysql"],"articleSection":["Databases","Load Balancing","RoseHosting Platform"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/","url":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/","name":"MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png","datePublished":"2021-03-08T18:08:00+00:00","dateModified":"2022-06-03T08:32:12+00:00","description":"Here's a simple guide to MariaDB\/MySQL Auto-\u0421lustering with Load Balancing, Replication for High Availability And Performance","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/02\/mariadb-mysql-auto-\u0441lustering-with-load-balancing-and-replication-for-high-availability-and-performance.png","width":742,"height":372,"caption":"mariadb\/mysql auto-\u0441lustering with load balancing and replication for high availability and performance"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication for High Availability and Performance"}]},{"@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\/35627","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=35627"}],"version-history":[{"count":23,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/35627\/revisions"}],"predecessor-version":[{"id":35900,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/35627\/revisions\/35900"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/35816"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=35627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=35627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=35627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}