{"id":47125,"date":"2024-07-25T12:06:20","date_gmt":"2024-07-25T12:06:20","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=47125"},"modified":"2026-02-18T07:30:47","modified_gmt":"2026-02-18T07:30:47","slug":"master-master-slave-replication-auto-clustering","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering","title":{"rendered":"MariaDb\/MySQL Auto-Clustering Replication"},"content":{"rendered":"

MariaDB\/MySQL Auto-Clustering Replication<\/h2>\n

Today, we\u2019ll continue discussing database auto-clustering and focus on two common data replication types for MariaDB and MySQL: Master-Slave and Master-Master replication. We\u2019ll see how each helps solve performance issues, set up backups, and reduce system failures, all in a simple clustered solution that can be installed in just a few clicks.<\/p>\n

Master-Slave Replication<\/h2>\n

Master-Slave replication is ideal for situations with many read requests and few write requests, as it helps share the read load across multiple database servers. We have created a setup with pre-configured replication for these needs.<\/p>\n

\"Master-Slave<\/a><\/p>\n

You can easily install this replication setup using the AccuWeb.Cloud topology wizard, which includes the Auto-Clustering feature. This offers benefits like automatic discovery of new nodes, horizontal scaling<\/a> without downtime, and an easy-to-use management interface.<\/p>\n

\"Horizontal<\/a><\/p>\n

All necessary configurations are applied automatically, including:<\/strong><\/p>\n

– Asynchronous master-slave replication is set up across all database instances, with the first created MariaDB or MySQL container acting as the master, while all other nodes (including any added later) serve as slaves.<\/p>\n

– The environment includes dedicated ProxySQL load balancers, which handle incoming traffic and distribute it across the database nodes.<\/p>\n

By default, each balancer has 8 cloudlets (equal to 1 GiB of RAM and 3.2 GHz of CPU) for automatic scaling. <\/a>You can choose to exclude this laye<\/a>r from the cluster before installation.<\/p>\n

\"Add<\/a><\/p>\n

Remember, you cannot add or remove ProxySQL after setup. After creation, the cluster will look like this:<\/p>\n

\"Cluster<\/a><\/p>\n

Note:<\/strong> If the master node goes down, you must manually promote a slave<\/a> to become the master. If a slave node fails, ProxySQL will redirect read requests to the master, and the cluster will continue to function.<\/p>\n

You can access the Orchestrator panel (using the credentials from the email you received) to check the replication status, view the cluster topology, and monitor the health of all nodes.<\/p>\n

\"the<\/a><\/p>\n

As shown, there is one container assigned as master, and the others are assigned as slaves, meaning the master-slave replication has been successfully configured by AccuWeb.Cloud platform.<\/p>\n

Master-Master Replication<\/h2>\n

Master-master replication helps balance the writing load and makes recovery easier if one master node fails, ensuring better availability. In AccuWeb.Cloud, this setup is configured so that two database nodes act as masters.<\/p>\n

When scaling out, extra slave nodes are added to improve reading performance and evenly distribute the replication workload. These slaves are first added to one master node, and then to the other, so they are balanced.<\/p>\n

\"Master-Master<\/a><\/p>\n

After setup, you can access the Orchestrator panel (using the credentials from the email you received) to check the replication status.<\/p>\n

\"the<\/a><\/p>\n

As shown, there are two containers assigned as masters, and replication is successfully configured.<\/p>\n

You can also scale out the cluster by adding more slave database servers using the topology wizard.<\/p>\n

\"Scale<\/a><\/p>\n

Please note that for production environments, it\u2019s best to scale manually during maintenance periods or when there\u2019s low load.<\/p>\n

If you want to enable automatic horizontal scaling<\/a> for your database, set higher trigger intervals based on the amount of data to avoid continuous scaling actions.<\/p>\n

\"\"<\/a><\/p>\n

Horizontal scaling for both setups is done by cloning an existing slave node. If there are any differences, the new database will catch up on data using binlog replay and join the cluster.<\/p>\n

This cloning process ensures that the binlog won\u2019t expire, allowing for quick scaling.<\/p>\n

That\u2019s it! Improve your project by integrating an automatically configured MariaDB\/MySQL database cluster with the most popular replication type already set up for you.<\/p>\n

\t\t
\n\t\t\t
\n \n
\n
\n
\n \n \t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t <\/div>\n <\/div>\n <\/div>\n <\/section>\n \t\t<\/div>\n\t\t<\/div>\n
<\/div>\n","protected":false},"author":1,"featured_media":52879,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","class_list":["post-47125","faq","type-faq","status-publish","has-post-thumbnail","hentry","faq_topics-databases","faq_topics-mmp-high-availability-cluster","faq_topics-kb","faq_topics-master-master-slave-replication","faq_topics-mongodb","faq_topics-mysql-mariadb-percona","faq_topics-product-documentation"],"yoast_head":"\nMariaDb\/MySQL Auto-Clustering Replication<\/title>\n<meta name=\"description\" content=\"Discover how master-master-slave replication in MariaDB\/MySQL auto-clustering shares the read load and simplifies backups.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDb\/MySQL Auto-Clustering Replication\" \/>\n<meta property=\"og:description\" content=\"Discover how master-master-slave replication in MariaDB\/MySQL auto-clustering shares the read load and simplifies backups.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering\" \/>\n<meta property=\"og:site_name\" content=\"AccuWeb Cloud\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-18T07:30:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#article\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering\"},\"author\":{\"name\":\"Jilesh Patadiya\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\"},\"headline\":\"MariaDb\/MySQL Auto-Clustering Replication\",\"datePublished\":\"2024-07-25T12:06:20+00:00\",\"dateModified\":\"2026-02-18T07:30:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering\"},\"wordCount\":584,\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"inLanguage\":\"en-US\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering\",\"url\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering\",\"name\":\"MariaDb\/MySQL Auto-Clustering Replication\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#primaryimage\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"datePublished\":\"2024-07-25T12:06:20+00:00\",\"dateModified\":\"2026-02-18T07:30:47+00:00\",\"description\":\"Discover how master-master-slave replication in MariaDB\/MySQL auto-clustering shares the read load and simplifies backups.\",\"breadcrumb\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#primaryimage\",\"url\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"contentUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accuweb.cloud\/resource\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDb\/MySQL Auto-Clustering Replication\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\",\"url\":\"https:\/\/accuweb.cloud\/resource\/\",\"name\":\"AccuWeb Cloud\",\"description\":\"Cutting Edge Cloud Computing\",\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/accuweb.cloud\/resource\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\",\"name\":\"AccuWeb.Cloud\",\"url\":\"https:\/\/accuweb.cloud\/resource\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg\",\"contentUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg\",\"width\":156,\"height\":87,\"caption\":\"AccuWeb.Cloud\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\",\"name\":\"Jilesh Patadiya\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g\",\"caption\":\"Jilesh Patadiya\"},\"description\":\"Jilesh Patadiya, the visionary Co-Founder and Chief Technology Officer (CTO) behind AccuWeb.Cloud. Founder & CTO at AccuWebHosting.com. He shares his web hosting insights on the AccuWeb.Cloud blog. He mostly writes on the latest web hosting trends, WordPress, storage technologies, and Windows and Linux hosting platforms.\",\"sameAs\":[\"https:\/\/accuweb.cloud\/resource\",\"https:\/\/www.facebook.com\/accuwebhosting\",\"https:\/\/www.instagram.com\/accuwebhosting\/\",\"https:\/\/www.linkedin.com\/company\/accuwebhosting\/\",\"https:\/\/x.com\/accuwebhosting\",\"https:\/\/www.youtube.com\/c\/Accuwebhosting\"],\"url\":\"https:\/\/accuweb.cloud\/resource\/author\/accuwebadmin\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MariaDb\/MySQL Auto-Clustering Replication","description":"Discover how master-master-slave replication in MariaDB\/MySQL auto-clustering shares the read load and simplifies backups.","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:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering","og_locale":"en_US","og_type":"article","og_title":"MariaDb\/MySQL Auto-Clustering Replication","og_description":"Discover how master-master-slave replication in MariaDB\/MySQL auto-clustering shares the read load and simplifies backups.","og_url":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering","og_site_name":"AccuWeb Cloud","article_modified_time":"2026-02-18T07:30:47+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#article","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering"},"author":{"name":"Jilesh Patadiya","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58"},"headline":"MariaDb\/MySQL Auto-Clustering Replication","datePublished":"2024-07-25T12:06:20+00:00","dateModified":"2026-02-18T07:30:47+00:00","mainEntityOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering"},"wordCount":584,"publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","inLanguage":"en-US"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering","url":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering","name":"MariaDb\/MySQL Auto-Clustering Replication","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/#website"},"primaryImageOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#primaryimage"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","datePublished":"2024-07-25T12:06:20+00:00","dateModified":"2026-02-18T07:30:47+00:00","description":"Discover how master-master-slave replication in MariaDB\/MySQL auto-clustering shares the read load and simplifies backups.","breadcrumb":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#primaryimage","url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","contentUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/accuweb.cloud\/resource\/articles\/master-master-slave-replication-auto-clustering#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accuweb.cloud\/resource\/"},{"@type":"ListItem","position":2,"name":"MariaDb\/MySQL Auto-Clustering Replication"}]},{"@type":"WebSite","@id":"https:\/\/accuweb.cloud\/resource\/#website","url":"https:\/\/accuweb.cloud\/resource\/","name":"AccuWeb Cloud","description":"Cutting Edge Cloud Computing","publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/accuweb.cloud\/resource\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/accuweb.cloud\/resource\/#organization","name":"AccuWeb.Cloud","url":"https:\/\/accuweb.cloud\/resource\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/","url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg","contentUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg","width":156,"height":87,"caption":"AccuWeb.Cloud"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58","name":"Jilesh Patadiya","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g","caption":"Jilesh Patadiya"},"description":"Jilesh Patadiya, the visionary Co-Founder and Chief Technology Officer (CTO) behind AccuWeb.Cloud. Founder & CTO at AccuWebHosting.com. He shares his web hosting insights on the AccuWeb.Cloud blog. He mostly writes on the latest web hosting trends, WordPress, storage technologies, and Windows and Linux hosting platforms.","sameAs":["https:\/\/accuweb.cloud\/resource","https:\/\/www.facebook.com\/accuwebhosting","https:\/\/www.instagram.com\/accuwebhosting\/","https:\/\/www.linkedin.com\/company\/accuwebhosting\/","https:\/\/x.com\/accuwebhosting","https:\/\/www.youtube.com\/c\/Accuwebhosting"],"url":"https:\/\/accuweb.cloud\/resource\/author\/accuwebadmin"}]}},"_links":{"self":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/47125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/types\/faq"}],"author":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/comments?post=47125"}],"version-history":[{"count":10,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/47125\/revisions"}],"predecessor-version":[{"id":52999,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/47125\/revisions\/52999"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/media\/52879"}],"wp:attachment":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/media?parent=47125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}