{"id":35647,"date":"2023-12-01T05:11:01","date_gmt":"2023-12-01T05:11:01","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/faq\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous\/"},"modified":"2026-02-19T12:05:30","modified_gmt":"2026-02-19T12:05:30","slug":"how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous","title":{"rendered":"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?"},"content":{"rendered":"<h2 class=\"ack-h2\">How to Set up MariaDB Galera Cluster- Multi-primary Synchronous?<\/h2>\n<p>Setting up a <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/database\/mariadb-multi-region-galera-cluster-hosting\" target=\"_blank\" rel=\"noopener\">MariaDB Galera Cluster<\/a> in a multi-primary synchronous configuration is a powerful way to achieve high availability and data redundancy. We will guide you through creating a robust and scalable database cluster that ensures your data remains highly available and consistent.<\/p>\n<p>Galera works by copying actions in a certain way. It copies the information in the database and details about locks used when the action was done. Each node checks the copied actions against others, and the actions are applied if there are no conflicts. Then, the action is considered done, and each node keeps it in the database.<\/p>\n<p>This method is also known as almost simultaneous copying because it seems things are happening together, but they happen separately on each node.<\/p>\n<p>In AccuWeb.Cloud, the Galera Cluster can automatically turn on when making the environment. It usually has 2 ProxySQL load balancers and 3 MariaDB instances.<\/p>\n<p>For Galera Cluster to work, your databases need to meet some rules. The important ones to remember when making tables are:<\/p>\n<ul class=\"ack-ul\">\n<li><b>Use InnoDB Storage:<\/b> Keep your data in InnoDB <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/storage\" target=\"_blank\" rel=\"noopener\">storager<\/a> to ensure things work smoothly.<\/li>\n<li><b>Primary Keys:\u00a0<\/b>Every table you want to copy must have a special main key. It can be a single column or a few columns together.<\/li>\n<\/ul>\n<p>You can find the complete list of these rules in the official documents.<\/p>\n<h2 class=\"ack-h2\">Setting Up MariaDB Galera Cluster<\/h2>\n<p><b>Step 1.<\/b> Go to the AccuWeb.Cloud dashboard.<\/p>\n<p><b>Step 2.<\/b>\u00a0Click &#8220;<b>New Environment<\/b>&#8221; &amp; pick the MariaDB server from the options.<\/p>\n<p>Let\u2019s learn how to connect your<\/p>\n<p><b>Step 3.<\/b>\u00a0Turn on &#8220;<b>Auto-Clustering<\/b>&#8221; and select the\u00a0<b>Galera<\/b>\u00a0option.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-2-1.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28555 size-full\" title=\"Auto-Clustering\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-2-1.png\" alt=\"Auto-Clustering\" width=\"975\" height=\"608\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-2-1.png 975w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-2-1-300x187.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-2-1-768x479.png 768w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-2-1-600x374.png 600w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/p>\n<p><b>Step 4. <\/b>If you want more databases, you can add them by clicking <strong>&#8220;+&#8221;<\/strong> in the <strong>&#8220;Horizontal Scaling&#8221;<\/strong> section.<\/p>\n<div class=\"article-space\"><\/div>\n<div class=\"ack-formula\"><b>Note:<\/b> If you want, leave out the ProxySQL layer from the cluster setup before installing by using the right switch. Remember, if you do this now, you can&#8217;t add the proxy layer later. The same goes the other way \u2013 if you skip it now, you can&#8217;t add it after.<\/div>\n<div class=\"article-extra-space\"><\/div>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-3-1.png\"><img decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28556 size-full\" title=\"Horizontal Scaling\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-3-1.png\" alt=\"Horizontal Scaling\" width=\"884\" height=\"595\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-3-1.png 884w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-3-1-300x202.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-3-1-768x517.png 768w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-3-1-600x404.png 600w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/a><\/p>\n<p>After a few minutes, your chosen setup will be ready with all the connections.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-4-1.png\"><img decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28557 size-full\" title=\"Connections\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-4-1.png\" alt=\"Connections\" width=\"1272\" height=\"613\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-4-1.png 1272w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-4-1-300x145.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-4-1-1024x493.png 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-4-1-768x370.png 768w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-4-1-600x289.png 600w\" sizes=\"(max-width: 1272px) 100vw, 1272px\" \/><\/a><\/p>\n<p>You can keep an eye on the health of the cluster nodes using the Orchestrator admin panel. You can access it with the login details sent to you by email when you set up the ProxySQL Load Balancer. The cluster members will be shown as separate clusters on the panel, each with one instance inside.<\/p>\n<h2 class=\"ack-h2\">Connecting Your Application to MariaDB Galera Cluster<\/h2>\n<p>Let&#8217;s learn how to connect your<a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/application\/java-hosting\" target=\"_blank\" rel=\"noopener\"> Java web application<\/a> to the MariaDB Galera Cluster using the ProxySQL load balancer as the starting point. If you want to connect different kinds of applications, you can follow the linked guide.<\/p>\n<p>When you create each main node in the <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/database\/mariadb-cluster\" target=\"_blank\" rel=\"noopener\">MariaDB cluster<\/a>, you&#8217;ll get an email with phpMyAdmin access details. This can be handy for debugging or doing manual tasks on the databases.<\/p>\n<p><strong>Step 1.<\/strong>\u00a0First, log in to phpMyAdmin using the URL, username, and password given in the email. Pick the <strong>&#8220;test&#8221;<\/strong> database on the left side. You&#8217;ll notice no tables on the right side in the <strong>&#8220;test&#8221;<\/strong> database.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-5-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28558 size-full\" title=\"phpMyAdmin\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-5-1.png\" alt=\"phpMyAdmin\" width=\"961\" height=\"396\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-5-1.png 961w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-5-1-300x124.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-5-1-768x316.png 768w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-5-1-600x247.png 600w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/a><\/p>\n<p><strong>Step 2.<\/strong> Go back to the AccWeb.Cloud dashboard. We&#8217;re using a separate environment with a Tomcat 9 application server for this example. We need to make a database configuration file for our test application. Click on the <strong>&#8220;Config&#8221;<\/strong> icon next to your compute node, then go to the <strong>\/opt\/tomcat\/temp<\/strong> directory and make a file named <strong>&#8220;mydb.cfg&#8221;<\/strong> using the built-in file manager.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-6-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28559 size-full\" title=\"&quot;mydb.cfg&quot;\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-6-1.png\" alt=\"&quot;mydb.cfg&quot;\" width=\"1279\" height=\"614\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-6-1.png 1279w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-6-1-300x144.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-6-1-1024x492.png 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-6-1-768x369.png 768w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-6-1-600x288.png 600w\" sizes=\"(max-width: 1279px) 100vw, 1279px\" \/><\/a><\/p>\n<p><strong>Step 3.<\/strong>\u00a0Add the following lines to the <strong>&#8220;mydb.cfg&#8221;<\/strong> file and fill in the details with the entry point credentials like in the picture:<\/p>\n<div class=\"article-space\"><\/div>\n<pre><code class=\"language-javascript\">\r\nhost=jdbc:mariadb:\/\/{connect_URL}\/{db_name}?usePipelineAuth=false\r\nusername={user}\r\npassword={password}\r\ndriver=org.mariadb.jdbc.Driver<\/code><\/pre>\n<div class=\"article-space\"><\/div>\n<ul class=\"ack-ul\">\n<li><strong>{connect_URL}<\/strong> is the link to your DB cluster load balancer (like the ProxySQL node).<\/li>\n<li><strong>{db_name}<\/strong> is the name of the database. We chose <strong>&#8220;test&#8221;<\/strong> before.<\/li>\n<li>usePipelineAuth is for faster connection creation. It should be &#8220;false&#8221; for ProxySQL.<\/li>\n<li><strong>{user}<\/strong> and <strong>{password}<\/strong> are the database credentials from the email.<\/li>\n<\/ul>\n<p><strong>Step 1.<\/strong> Download the test application using one of the links below and put it on the Tomcat server <a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-7-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28560 size-full\" title=\"Tomcat server\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-7-1.png\" alt=\"Tomcat server\" width=\"430\" height=\"256\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-7-1.png 430w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-7-1-300x179.png 300w\" sizes=\"(max-width: 430px) 100vw, 430px\" \/><\/a><\/p>\n<h4 class=\"ack-h4\">Remember<\/h4>\n<p><strong>Step 2. <\/strong>For the best compatibility with the proxy layer, use the latest JDBC connector for MariaDB. Put the connectors in<strong> \/opt\/tomcat\/webapps\/ROOT\/WEB-INF\/lib\/.<\/strong><\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-8-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28561 size-full\" title=\"JDBC connector for MariaDB\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-8-1.png\" alt=\"JDBC connector for MariaDB\" width=\"792\" height=\"510\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-8-1.png 792w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-8-1-300x193.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-8-1-768x495.png 768w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-8-1-600x386.png 600w\" sizes=\"(max-width: 792px) 100vw, 792px\" \/><\/a><\/p>\n<p>Restart the application server to apply the <strong>mydb.cfg<\/strong> changes by clicking &#8220;<strong>Restart Nodes.<\/strong>&#8221;<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-9-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28562 size-full\" title=\"Restart Nodes\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-9-1.png\" alt=\"Restart Nodes\" width=\"1279\" height=\"614\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-9-1.png 1279w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-9-1-300x144.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-9-1-1024x492.png 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-9-1-768x369.png 768w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-9-1-600x288.png 600w\" sizes=\"(max-width: 1279px) 100vw, 1279px\" \/><\/a><\/p>\n<p>If you plan to make custom user accounts after cluster installation, add them to the <strong>MySQL_users<\/strong> table on each ProxySQL node. Otherwise, you won&#8217;t be able to connect via the proxy layer. Here&#8217;s how:<\/p>\n<div class=\"article-space\"><\/div>\n<pre><code class=\"language-javascript\">\r\n$ MYSQL_PWD=admin mysql -h 127.0.0.1 -P6032 -uadmin -e\r\n\"INSERT INTO mysql_users (username,password,default_hostgroup)\r\nVALUES ('&lt;username&gt;', '&lt;password&gt;', 2);\"<\/code><\/pre>\n<div class=\"article-extra-space\"><\/div>\n<pre><code class=\"language-javascript\">\r\n$ MYSQL_PWD=admin mysql -h 127.0.0.1 -P6032 -uadmin -e\r\n\"LOAD MYSQL USERS TO RUNTIME; SAVE MYSQL USERS TO DISK;\"<\/code><\/pre>\n<div class=\"article-space\"><\/div>\n<p>Replace &lt;username&gt; and &lt;password&gt; with the new database account&#8217;s credentials.<\/p>\n<p><strong>Step 4. <\/strong>After the deployment, click <strong>&#8220;Open in Browser&#8221;<\/strong> next to your application server. Click <strong>&#8220;Create test table in your database&#8221;<\/strong> in the app window.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-10-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28563 size-full\" title=\"Create test table in your database\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-10-1.png\" alt=\"Create test table in your database\" width=\"566\" height=\"152\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-10-1.png 566w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-10-1-300x81.png 300w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/a><\/p>\n<p><strong>Step 5.<\/strong> To make sure the connection is working and a new table was created, go back to the <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/database\/mysql-hosting\" target=\"_blank\" rel=\"noopener\">MySQL<\/a> admin panel.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-11-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28564 size-full\" title=\"MySQL admin panel\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-11-1.png\" alt=\"MySQL admin panel\" width=\"773\" height=\"289\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-11-1.png 773w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-11-1-300x112.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-11-1-768x287.png 768w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-11-1-600x224.png 600w\" sizes=\"(max-width: 773px) 100vw, 773px\" \/><\/a><\/p>\n<p>You&#8217;ll see the table named {date-time of creation}. To check if replication works, go through all the phpMyAdmin panels in the cluster to verify data availability using the same credentials.<\/p>\n<div class=\"article-space\"><\/div>\n<div class=\"ack-formula\"><strong>Important Note:<\/strong> In AccuWeb.Cloud, all MariaDB nodes have phpMyAdmin panels. Just click &#8220;<strong>Open in Browser<\/strong>&#8221; to access it for each database node.<\/div>\n<div class=\"article-extra-space\"><\/div>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-12-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-28565 size-full\" title=\"Open in Browser\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-12-1.png\" alt=\"Open in Browser\" width=\"652\" height=\"259\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-12-1.png 652w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-12-1-300x119.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/09\/word-image-28539-12-1-600x238.png 600w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/a><\/p>\n<p>Great job! With a few easy steps, you&#8217;ve connected your web application to the DB cluster and done a basic task using a single entry point. Now, you have a highly available and dependable <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/database\/mariadb-multi-region-galera-cluster-hosting\" target=\"_blank\" rel=\"noopener\">MariaDB Galera Cluster<\/a> set up automatically in minutes, along with user-friendly management tools.<\/p>\n<div class=\"cta-btn-top-space ack-extra-image-space\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"38668\" class=\"elementor elementor-38668\" data-elementor-settings=\"{&quot;ha_cmc_init_switcher&quot;:&quot;no&quot;}\" data-elementor-post-type=\"elementor_library\">\n\t\t\t        <section class=\"elementor-section elementor-top-section elementor-element elementor-element-882321f elementor-section-boxed elementor-section-height-default elementor-section-height-default ct-header-fixed-none ct-row-max-none\" data-id=\"882321f\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n            \n                        <div class=\"elementor-container elementor-column-gap-default \">\n                    <div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7cc79cc\" data-id=\"7cc79cc\" data-element_type=\"column\">\n        <div class=\"elementor-widget-wrap elementor-element-populated\">\n                    \n        \t\t<div class=\"elementor-element elementor-element-e31b40f elementor-widget elementor-widget-shortcode\" data-id=\"e31b40f\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><\/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 class=\"cta-btn-bottom-space\"><\/div>\n","protected":false},"author":1,"featured_media":52879,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","class_list":["post-35647","faq","type-faq","status-publish","has-post-thumbnail","hentry","faq_topics-kb","faq_topics-product-documentation","faq_topics-tutorial-series","faq_topics-tutorials"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.10 (Yoast SEO v24.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to set up MariaDB Galera Cluster- Multi-primary Synchronous?<\/title>\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\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?\" \/>\n<meta property=\"og:description\" content=\"How to Set up MariaDB Galera Cluster- Multi-primary Synchronous? Setting up a MariaDB Galera Cluster in a multi-primary synchronous configuration is a powerful way to achieve high availability and data redundancy. We will guide you through creating a robust and scalable database cluster that ensures your data remains highly available and consistent. Galera works by [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous\" \/>\n<meta property=\"og:site_name\" content=\"AccuWeb Cloud\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-19T12:05:30+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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#article\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous\"},\"author\":{\"name\":\"Jilesh Patadiya\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\"},\"headline\":\"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?\",\"datePublished\":\"2023-12-01T05:11:01+00:00\",\"dateModified\":\"2026-02-19T12:05:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous\"},\"wordCount\":927,\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#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\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous\",\"url\":\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous\",\"name\":\"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#primaryimage\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"datePublished\":\"2023-12-01T05:11:01+00:00\",\"dateModified\":\"2026-02-19T12:05:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#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\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accuweb.cloud\/resource\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?\"}]},{\"@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 &amp; 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":"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?","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\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous","og_locale":"en_US","og_type":"article","og_title":"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?","og_description":"How to Set up MariaDB Galera Cluster- Multi-primary Synchronous? Setting up a MariaDB Galera Cluster in a multi-primary synchronous configuration is a powerful way to achieve high availability and data redundancy. We will guide you through creating a robust and scalable database cluster that ensures your data remains highly available and consistent. Galera works by [&hellip;]","og_url":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous","og_site_name":"AccuWeb Cloud","article_modified_time":"2026-02-19T12:05:30+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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#article","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous"},"author":{"name":"Jilesh Patadiya","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58"},"headline":"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?","datePublished":"2023-12-01T05:11:01+00:00","dateModified":"2026-02-19T12:05:30+00:00","mainEntityOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous"},"wordCount":927,"publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#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\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous","url":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous","name":"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/#website"},"primaryImageOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#primaryimage"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","datePublished":"2023-12-01T05:11:01+00:00","dateModified":"2026-02-19T12:05:30+00:00","breadcrumb":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/articles\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#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\/how-to-set-up-mariadb-galera-cluster-multi-primary-synchronous#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accuweb.cloud\/resource\/"},{"@type":"ListItem","position":2,"name":"How to set up MariaDB Galera Cluster- Multi-primary Synchronous?"}]},{"@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 &amp; 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\/35647","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=35647"}],"version-history":[{"count":11,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/35647\/revisions"}],"predecessor-version":[{"id":53515,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/35647\/revisions\/53515"}],"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=35647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}