MariaDB Galera Cluster and MariaDB MaxScale Installation on CentOS<\/title>\n<meta name=\"description\" content=\"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\" \/>\n<meta property=\"og:description\" content=\"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\" \/>\n<meta property=\"og:url\" content=\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\" \/>\n<meta property=\"og:site_name\" content=\"The WebScale Database Infrastructure Operations Experts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-06T12:20:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-06T14:01:14+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"MinervaDB Corporation\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/WebScaleDBA\" \/>\n<meta name=\"twitter:site\" content=\"@webscaledba\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"MinervaDB Corporation\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\"},\"author\":{\"name\":\"MinervaDB Corporation\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce\"},\"headline\":\"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\",\"datePublished\":\"2019-06-06T12:20:27+00:00\",\"dateModified\":\"2019-06-06T14:01:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\"},\"wordCount\":797,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"keywords\":[\"MariaDB\",\"MariaDB Galera Cluster\",\"MariaDB MaxScale\"],\"articleSection\":[\"Galera Cluster\",\"MariaDB\",\"MariaDB Galera Cluster\",\"MariaDB MaxScale\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\",\"url\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\",\"name\":\"MariaDB Galera Cluster and MariaDB MaxScale Installation on CentOS\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/#website\"},\"datePublished\":\"2019-06-06T12:20:27+00:00\",\"dateModified\":\"2019-06-06T14:01:14+00:00\",\"description\":\"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\",\"breadcrumb\":{\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/minervadb.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/minervadb.com\/#website\",\"url\":\"https:\/\/minervadb.com\/\",\"name\":\"The WebScale Database Infrastructure Operations Experts\",\"description\":\"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations\",\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/minervadb.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/minervadb.com\/#organization\",\"name\":\"MinervaDB\",\"url\":\"https:\/\/minervadb.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"contentUrl\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"width\":200,\"height\":200,\"caption\":\"MinervaDB\"},\"image\":{\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/webscaledba\",\"https:\/\/www.linkedin.com\/company\/minervadb\/\",\"https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce\",\"name\":\"MinervaDB Corporation\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g\",\"caption\":\"MinervaDB Corporation\"},\"description\":\"Independent and vendor neutral consulting, support, remote DBA services and training for MySQL, MariaDB, Percona Server, PostgreSQL and ClickHouse with core expertize in performance, scalability and high availability . We are an virtual corporation, all of us work from home on multiple timezones and stay connected via Email, Skype, Google Hangouts, Phone and IRC supporting over 250 customers worldwide\",\"sameAs\":[\"https:\/\/minervadb.com\",\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/WebScaleDBA\"],\"url\":\"http:\/\/minervadb.com\/index.php\/author\/minervadb\/\"}]}<\/script>\n","yoast_head_json":{"title":"MariaDB Galera Cluster and MariaDB MaxScale Installation on CentOS","description":"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","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":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/","og_locale":"en_US","og_type":"article","og_title":"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","og_description":"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","og_url":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/","og_site_name":"The WebScale Database Infrastructure Operations Experts","article_publisher":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_author":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_published_time":"2019-06-06T12:20:27+00:00","article_modified_time":"2019-06-06T14:01:14+00:00","og_image":[{"width":200,"height":200,"url":"http:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg","type":"image\/jpeg"}],"author":"MinervaDB Corporation","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/WebScaleDBA","twitter_site":"@webscaledba","twitter_misc":{"Written by":"MinervaDB Corporation","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#article","isPartOf":{"@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/"},"author":{"name":"MinervaDB Corporation","@id":"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce"},"headline":"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","datePublished":"2019-06-06T12:20:27+00:00","dateModified":"2019-06-06T14:01:14+00:00","mainEntityOfPage":{"@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/"},"wordCount":797,"commentCount":2,"publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"keywords":["MariaDB","MariaDB Galera Cluster","MariaDB MaxScale"],"articleSection":["Galera Cluster","MariaDB","MariaDB Galera Cluster","MariaDB MaxScale"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/","url":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/","name":"MariaDB Galera Cluster and MariaDB MaxScale Installation on CentOS","isPartOf":{"@id":"https:\/\/minervadb.com\/#website"},"datePublished":"2019-06-06T12:20:27+00:00","dateModified":"2019-06-06T14:01:14+00:00","description":"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","breadcrumb":{"@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minervadb.com\/"},{"@type":"ListItem","position":2,"name":"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS"}]},{"@type":"WebSite","@id":"https:\/\/minervadb.com\/#website","url":"https:\/\/minervadb.com\/","name":"The WebScale Database Infrastructure Operations Experts","description":"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations","publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minervadb.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/minervadb.com\/#organization","name":"MinervaDB","url":"https:\/\/minervadb.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/","url":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","contentUrl":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","width":200,"height":200,"caption":"MinervaDB"},"image":{"@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/webscaledba","https:\/\/www.linkedin.com\/company\/minervadb\/","https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce","name":"MinervaDB Corporation","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/person\/image\/","url":"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g","contentUrl":"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g","caption":"MinervaDB Corporation"},"description":"Independent and vendor neutral consulting, support, remote DBA services and training for MySQL, MariaDB, Percona Server, PostgreSQL and ClickHouse with core expertize in performance, scalability and high availability . We are an virtual corporation, all of us work from home on multiple timezones and stay connected via Email, Skype, Google Hangouts, Phone and IRC supporting over 250 customers worldwide","sameAs":["https:\/\/minervadb.com","https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/https:\/\/twitter.com\/WebScaleDBA"],"url":"http:\/\/minervadb.com\/index.php\/author\/minervadb\/"}]}},"_links":{"self":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/2374"}],"collection":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/comments?post=2374"}],"version-history":[{"count":15,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/2374\/revisions"}],"predecessor-version":[{"id":2392,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/2374\/revisions\/2392"}],"wp:attachment":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/media?parent=2374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/categories?post=2374"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/tags?post=2374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

Deprecated: Function Yoast\WP\SEO\Conditionals\Schema_Blocks_Conditional::get_feature_flag is deprecated since version Yoast SEO 20.5 with no alternative available. in /home1/minerho3/public_html/wp-includes/functions.php on line 6078

Deprecated: Function Yoast\WP\SEO\Conditionals\Schema_Blocks_Conditional::get_feature_flag is deprecated since version Yoast SEO 20.5 with no alternative available. in /home1/minerho3/public_html/wp-includes/functions.php on line 6078

Deprecated: Function Yoast\WP\SEO\Conditionals\Schema_Blocks_Conditional::get_feature_flag is deprecated since version Yoast SEO 20.5 with no alternative available. in /home1/minerho3/public_html/wp-includes/functions.php on line 6078

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/minerho3/public_html/wp-includes/functions.php:6078) in /home1/minerho3/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831
{"id":2374,"date":"2019-06-06T12:20:27","date_gmt":"2019-06-06T12:20:27","guid":{"rendered":"http:\/\/minervadb.com\/?p=2374"},"modified":"2019-06-06T14:01:14","modified_gmt":"2019-06-06T14:01:14","slug":"installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos","status":"publish","type":"post","link":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/","title":{"rendered":"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS"},"content":{"rendered":"

Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS<\/span><\/h1>\n

This blog is aimed to help anyone who is interested in setting-up 3 node MariaDB Galera Cluster with MariaDB MaxScale for building highly available \/ reliable, fault-tolerant and self-healing MariaDB infrastructure operations. \u00a0We have not tried to explain MariaDB Galera Cluster and MariaDB MaxScale Architecture or internals in this post. MariaDB documentation on both MariaDB Galera Cluster and MariaDB MaxScale is neat and direct , You can read the same here – https:\/\/mariadb.com\/kb\/en\/library\/galera-cluster\/\u00a0<\/a>\u00a0<\/span> (MariaDB Galera Cluster<\/em>) and https:\/\/mariadb.com\/kb\/en\/mariadb-maxscale-20-setting-up-mariadb-maxscale\/ \u00a0<\/a><\/span>\u00a0 (MariaDB MaxScale).\u00a0<\/em>If you are building maximum availability Database Infrastructure Operations on MariaDB stack, it’s worth investing and exploring MariaDB Galera Cluster and MariaDB MaxScale.<\/p>\n

\n
\n
Table of Contents<\/p>\n

Nodes<\/th>	IP address <\/th>\n<\/tr>\n<\/thead>\n
MariaDB Galera Cluster Node 1 <\/td>	192.168.56.101<\/td>\n<\/tr>\n
MariaDB Galera Cluster Node 2<\/td>	192.168.56.102<\/td>\n<\/tr>\n
MariaDB Galera Cluster Node 3<\/td>	192.168.56.103<\/td>\n<\/tr>\n
MariaDB MaxScale<\/td>	192.168.56.104<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n <\/span>LINUX Configuration<\/span><\/h3>\n Disable SELinux and the Linux firewall (which is firewalld in CentOS and RedHat 7.0 and up, and not iptables) and also set the hostname.<\/p>\n <\/span>Disable SELinux<\/span><\/h3>\n We recommend disabling SELinux unless your IT security demands SELinux, You disable \/ enable SELinux through the file\u00a0\/etc\/selinux\/config<\/em>, \u00a0looks something like this:<\/p>\n # This file controls the state of SELinux on the system.\r\n# SELINUX= can take one of these three values:\r\n# enforcing - SELinux security policy is enforced.\r\n# permissive - SELinux prints warnings instead of enforcing.\r\n# disabled - No SELinux policy is loaded.\r\nSELINUX=disabled\r\n# SELINUXTYPE= can take one of these two values:\r\n# targeted - Targeted processes are protected,\r\n# minimum - Modification of targeted policy. Only selected processes are protected.\r\n# mls - Multi Level Security protection.\r\nSELINUXTYPE=targeted\r\n<\/pre>\n <\/span>Disable firewalld<\/span><\/h3>\n Firewalld is a standard service that is disabled using the systemctl command:<\/p>\n $ sudo systemctl disable firewalld<\/pre>\n <\/span>Configuring hostname<\/span><\/h3>\n We recommend configuring hostname to tell which server you are connecting to when using MariaDB MaxScale, Please follow the steps appropriately for your infrastructure \/ IP:<\/p>\n $ sudo hostname node101<\/pre>\n <\/span>MariaDB Repository Installation<\/span><\/h2>\n Before we install the software we need to set up the MariaDB repository on all 4 servers:<\/p>\n $ curl -sS https:\/\/downloads.mariadb.com\/MariaDB\/mariadb_repo_setup \| sudo bash<\/pre>\n Having run this on the four servers, let us now go on with installing MariaDB Galera server on the three nodes where this is appropriate, in the case here we are looking at nodes 192.168.56.101, 192.168.56.102 and 192.168.56.103 On these three nodes run this:<\/p>\n $ sudo yum -y install MariaDB-server<\/pre>\n When this is completed, we should have MariaDB Server installed. The next thing to do then is to install MariaDB MaxScale on the instance 192.168.56.104 :<\/p>\n $ sudo yum -y install maxscale<\/pre>\n We recommend our customers to install MariaDB client programs on the MariaDB MaxScale instance (192.168.56.104) for good reasons, Though there are blogs which says it’s optional<\/p>\n $ sudo yum -y install MariaDB-client<\/pre>\n Configuring MariaDB Galera Cluster \u00a0<\/span><\/h1>\n In this blog we are only mentioning about the minimal settings to make MariaDB Galera Cluster working with MariaDB MaxScale, Here we are not talking about how to make MariaDB Galera Cluster optimal and Scalable, The settings below make MariaDB Galera Cluster fully operational,\u00a0We have to edit the file \/etc\/my.cnf.d\/server.cnf<\/em> and we have to adjust the Galera specific settings on the nodes 192.168.56.101, 192.168.56.102 and 192.168.56.103. Edit the [galera] section to look like this on all three nodes:<\/p>\n [galera]\r\n# Mandatory settings\r\nwsrep_on=ON\r\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so\r\nwsrep_cluster_address=gcomm:\/\/192.168.56.101,192.168.56.102,192.168.56.103\r\nbinlog_format=row\r\ndefault_storage_engine=InnoDB\r\ninnodb_autoinc_lock_mode=2<\/pre>\n <\/span>Starting MariaDB Galera Cluster<\/span><\/h2>\n To start a Galera Cluster from scratch we run a process called a bootstrap, and the reason this is a bit different from the usual MariaDB startup is that for HA reasons a node in a cluster attaches to one or more other nodes in the cluster, but for the first node, this is not possible. This is not complicated though, there is a script that is included with MariaDB Server that manages this, but remember that this script is only to be used when the first node in a Cluster is started with no existing nodes in it. In this case, on 192.168.56.101 run:<\/p>\n $ sudo galera_new_cluster<\/pre>\n Confirm MariaDB is running successfully:<\/p>\n $ ps -f -u mysql \| more\r\nUID PID PPID C STIME TTY TIME CMD\r\nmysql 1411 1 0 18:33 ? 00:00:00 \/usr\/sbin\/mysqld --wsrep-new-cluster --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1<\/pre>\n Confirm the status of Galera Cluster:<\/p>\n $ mysql -u root\r\nWelcome to the MariaDB monitor. Commands end with ; or g.\r\nYour MariaDB connection id is 10\r\nServer version: 10.3.15-MariaDB MariaDB Server\r\n \r\nCopyright (c) 2000, 2019, Oracle, MariaDB Corporation Ab and others.\r\n \r\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\r\n \r\nMariaDB [(none)]> show global status like 'wsrep_cluster_size';\r\n+--------------------+-------+\r\n\| Variable_name \| Value \|\r\n+--------------------+-------+\r\n\| wsrep_cluster_size \| 1 \|\r\n+--------------------+-------+\r\n1 row in set (0.00 sec)<\/pre>\n <\/span>Start MariaDB instance \u00a0in 192.168.56.102<\/span><\/h3>\n $ sudo systemctl start mariadb.service<\/pre>\n We should now have 2 nodes running in the cluster, let\u2019s check it out from the MariaDB command line on 192.168.56.101:<\/p>\n MariaDB [(none)]> show global status like 'wsrep_cluster_size';\r\n+--------------------+-------+\r\n\| Variable_name \| Value \|\r\n+--------------------+-------+\r\n\| wsrep_cluster_size \| 2 \|\r\n+--------------------+-------+\r\n1 row in set (0.00 sec)<\/pre>\n <\/span>Start MariaDB instances in 192.168.56.103<\/span><\/h3>\n $ sudo systemctl start mariadb.service<\/pre>\n Check the cluster size on 192.168.56.101 again:<\/p>\n MariaDB [(none)]> show global status like 'wsrep_cluster_size';\r\n+--------------------+-------+\r\n\| Variable_name \| Value \|\r\n+--------------------+-------+\r\n\| wsrep_cluster_size \| 3 \|\r\n+--------------------+-------+\r\n1 row in set (0.00 sec)<\/pre>\n The wsrep_cluster_size is 3 , So have successfully added all the three nodes to the Galera Cluster<\/p>\n <\/span>Configuring MariaDB for MariaDB MaxScale<\/span><\/h3>\n First we need to set up a user that MariaDB MaxScale use to attach to the cluster to get authentication data. On 192.168.56.101, using the MariaDB command line as the database root user:<\/p>\n $ mysql -u root\r\nWelcome to the MariaDB monitor. Commands end with ; or g.\r\nYour MariaDB connection id is 11\r\nServer version: 10.3.15-MariaDB MariaDB Server\r\n \r\nCopyright (c) 2000, 2019, Oracle, MariaDB Corporation Ab and others.\r\n \r\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\r\n \r\nMariaDB [(none)]> create user 'dbuser1'@'192.168.56.104' identified by 'My@PAssword';\r\nQuery OK, 0 rows affected (0.01 sec)\r\n \r\nMariaDB [(none)]> grant select on mysql.user to 'dbuser1'@'192.168.56.104';\r\nQuery OK, 0 rows affected (0.01 sec)<\/pre>\n we need some extra privileges for table and database level grants:<\/p>\n MariaDB [(none)]> grant select on mysql.db to 'dbuser1'@'192.168.56.104';\r\nQuery OK, 0 rows affected (0.01 sec)\r\n \r\nMariaDB [(none)]> grant select on mysql.tables_priv to 'dbuser1'@'192.168.56.104';\r\nQuery OK, 0 rows affected (0.00 sec)\r\n \r\nMariaDB [(none)]> grant show databases on . to 'dbuser1'@'192.168.56.104';\r\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n <\/span>MariaDB MaxScale Configuration<\/span><\/h3>\n MariaDB \u00a0MaxScale configure file is located in \/etc\/maxscale.cnf \u00a0.\u00a0<\/em>we have copied below the “MaxScale.cnf<\/strong>” used in our lab:<\/p>\n # Globals\r\n[maxscale]\r\nthreads=1\r\n \r\n# Servers\r\n[server1]\r\ntype=server\r\naddress=192.168.56.101\r\nport=3306\r\nprotocol=MySQLBackend\r\n \r\n[server2]\r\ntype=server\r\naddress=192.168.56.102\r\nport=3306\r\nprotocol=MySQLBackend\r\n \r\n[server3]\r\ntype=server\r\naddress=192.168.56.103\r\nport=3306\r\nprotocol=MySQLBackend\r\n \r\n# Monitoring for the servers\r\n[Galera Monitor]\r\ntype=monitor\r\nmodule=galeramon\r\nservers=server1,server2,server3\r\nuser=dbuser1\r\npasswd=My@PAssword\r\nmonitor_interval=1000\r\n \r\n# Galera router service\r\n[Galera Service]\r\ntype=service\r\nrouter=readwritesplit\r\nservers=server1,server2,server3\r\nuser=dbuser1\r\npasswd=My@PAssword\r\n \r\n# MaxAdmin Service\r\n[MaxAdmin Service]\r\ntype=service\r\nrouter=cli\r\n \r\n# Galera cluster listener\r\n[Galera Listener]\r\ntype=listener\r\nservice=Galera Service\r\nprotocol=MySQLClient\r\nport=3306\r\n \r\n# MaxAdmin listener\r\n[MaxAdmin Listener]\r\ntype=listener\r\nservice=MaxAdmin Service\r\nprotocol=maxscaled\r\nsocket=default<\/pre>\n Starting MariaDB MaxScale<\/strong><\/p>\n $ sudo systemctl start maxscale.service<\/pre>\n Connecting to MariaDB Galera Cluster from MariaDB MaxScale:<\/strong><\/p>\n $ mysql -h 192.168.56.104 -u dbuser1 -pMy@PAssword\r\nWelcome to the MariaDB monitor. Commands end with ; or g.\r\nYour MySQL connection id is 4668\r\nServer version: 10.0.0 3.1.5-maxscale MariaDB Server\r\n \r\nCopyright (c) 2000, 2019, Oracle, MariaDB Corporation Ab and others.\r\n \r\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\r\n \r\nMySQL [(none)]><\/pre>\n You can see that we are connected to MariaDB MaxScale now, but which server in the MariaDB Galera Cluster we are connected to? Let’s confirm that now:<\/p>\n MySQL [(none)]> show variables like 'hostname';\r\n+---------------+---------+\r\n\| Variable_name \| Value \|\r\n+---------------+---------+\r\n\| hostname \| node101 \|\r\n+---------------+---------+\r\n1 row in set (0.00 sec)<\/pre>\n let\u2019s stop MariaDB server on 192.168.56.101 and see what happens. On 192.168.56.101 run the following command:<\/p>\n $ sudo systemctl stop mariadb.service<\/pre>\n Now login from MariaDB MaxScale command prompt and check which MariaDB instance are we connecting to:<\/p>\n $ mysql -h 192.168.56.104 -u dbuser1 -pMy@PAssword\r\nWelcome to the MariaDB monitor. Commands end with ; or g.\r\nYour MySQL connection id is 4668\r\nServer version: 10.0.0 2.1.5-maxscale MariaDB Server\r\n \r\nCopyright (c) 2000, 2019, Oracle, MariaDB Corporation Ab and others.\r\n \r\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\r\n \r\nMySQL [(none)]> show variables like 'hostname';\r\n+---------------+---------+\r\n\| Variable_name \| Value \|\r\n+---------------+---------+\r\n\| hostname \| node102 \|\r\n+---------------+---------+\r\n1 row in set (0.00 sec)<\/pre>\n We are connecting to “node102” (192.168.56.102<\/strong>) because “node1” (192.168.56.101) is not available<\/p>\n <\/span>Conclusion<\/span><\/h3>\n To conclude this post we have successfully installed and configured 3 node MariaDB Galera Cluster with single node MariaDB MaxScale.<\/p>\n","protected":false},"excerpt":{"rendered":" Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS This blog is aimed to help anyone who is interested in setting-up 3 node MariaDB Galera Cluster with MariaDB MaxScale […]<\/a><\/p>\n<\/div>","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[172,92,174,173],"tags":[96,175,176],"yoast_head":"\nMariaDB Galera Cluster and MariaDB MaxScale Installation on CentOS<\/title>\n<meta name=\"description\" content=\"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\" \/>\n<meta property=\"og:description\" content=\"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\" \/>\n<meta property=\"og:url\" content=\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\" \/>\n<meta property=\"og:site_name\" content=\"The WebScale Database Infrastructure Operations Experts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-06T12:20:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-06T14:01:14+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"MinervaDB Corporation\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/WebScaleDBA\" \/>\n<meta name=\"twitter:site\" content=\"@webscaledba\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"MinervaDB Corporation\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\"},\"author\":{\"name\":\"MinervaDB Corporation\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce\"},\"headline\":\"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\",\"datePublished\":\"2019-06-06T12:20:27+00:00\",\"dateModified\":\"2019-06-06T14:01:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\"},\"wordCount\":797,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"keywords\":[\"MariaDB\",\"MariaDB Galera Cluster\",\"MariaDB MaxScale\"],\"articleSection\":[\"Galera Cluster\",\"MariaDB\",\"MariaDB Galera Cluster\",\"MariaDB MaxScale\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\",\"url\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\",\"name\":\"MariaDB Galera Cluster and MariaDB MaxScale Installation on CentOS\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/#website\"},\"datePublished\":\"2019-06-06T12:20:27+00:00\",\"dateModified\":\"2019-06-06T14:01:14+00:00\",\"description\":\"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\",\"breadcrumb\":{\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/minervadb.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/minervadb.com\/#website\",\"url\":\"https:\/\/minervadb.com\/\",\"name\":\"The WebScale Database Infrastructure Operations Experts\",\"description\":\"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations\",\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/minervadb.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/minervadb.com\/#organization\",\"name\":\"MinervaDB\",\"url\":\"https:\/\/minervadb.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"contentUrl\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"width\":200,\"height\":200,\"caption\":\"MinervaDB\"},\"image\":{\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/webscaledba\",\"https:\/\/www.linkedin.com\/company\/minervadb\/\",\"https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce\",\"name\":\"MinervaDB Corporation\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g\",\"caption\":\"MinervaDB Corporation\"},\"description\":\"Independent and vendor neutral consulting, support, remote DBA services and training for MySQL, MariaDB, Percona Server, PostgreSQL and ClickHouse with core expertize in performance, scalability and high availability . We are an virtual corporation, all of us work from home on multiple timezones and stay connected via Email, Skype, Google Hangouts, Phone and IRC supporting over 250 customers worldwide\",\"sameAs\":[\"https:\/\/minervadb.com\",\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/WebScaleDBA\"],\"url\":\"http:\/\/minervadb.com\/index.php\/author\/minervadb\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MariaDB Galera Cluster and MariaDB MaxScale Installation on CentOS","description":"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","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":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/","og_locale":"en_US","og_type":"article","og_title":"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","og_description":"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","og_url":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/","og_site_name":"The WebScale Database Infrastructure Operations Experts","article_publisher":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_author":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_published_time":"2019-06-06T12:20:27+00:00","article_modified_time":"2019-06-06T14:01:14+00:00","og_image":[{"width":200,"height":200,"url":"http:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg","type":"image\/jpeg"}],"author":"MinervaDB Corporation","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/WebScaleDBA","twitter_site":"@webscaledba","twitter_misc":{"Written by":"MinervaDB Corporation","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#article","isPartOf":{"@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/"},"author":{"name":"MinervaDB Corporation","@id":"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce"},"headline":"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","datePublished":"2019-06-06T12:20:27+00:00","dateModified":"2019-06-06T14:01:14+00:00","mainEntityOfPage":{"@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/"},"wordCount":797,"commentCount":2,"publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"keywords":["MariaDB","MariaDB Galera Cluster","MariaDB MaxScale"],"articleSection":["Galera Cluster","MariaDB","MariaDB Galera Cluster","MariaDB MaxScale"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/","url":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/","name":"MariaDB Galera Cluster and MariaDB MaxScale Installation on CentOS","isPartOf":{"@id":"https:\/\/minervadb.com\/#website"},"datePublished":"2019-06-06T12:20:27+00:00","dateModified":"2019-06-06T14:01:14+00:00","description":"Step-by-step installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS","breadcrumb":{"@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/minervadb.com\/index.php\/2019\/06\/06\/installation-and-configuration-of-mariadb-galera-cluster-and-mariadb-maxscale-on-centos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minervadb.com\/"},{"@type":"ListItem","position":2,"name":"Installation and configuration of 3 node MariaDB Galera Cluster and MariaDB MaxScale on CentOS"}]},{"@type":"WebSite","@id":"https:\/\/minervadb.com\/#website","url":"https:\/\/minervadb.com\/","name":"The WebScale Database Infrastructure Operations Experts","description":"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations","publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minervadb.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/minervadb.com\/#organization","name":"MinervaDB","url":"https:\/\/minervadb.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/","url":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","contentUrl":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","width":200,"height":200,"caption":"MinervaDB"},"image":{"@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/webscaledba","https:\/\/www.linkedin.com\/company\/minervadb\/","https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce","name":"MinervaDB Corporation","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/person\/image\/","url":"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g","contentUrl":"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g","caption":"MinervaDB Corporation"},"description":"Independent and vendor neutral consulting, support, remote DBA services and training for MySQL, MariaDB, Percona Server, PostgreSQL and ClickHouse with core expertize in performance, scalability and high availability . We are an virtual corporation, all of us work from home on multiple timezones and stay connected via Email, Skype, Google Hangouts, Phone and IRC supporting over 250 customers worldwide","sameAs":["https:\/\/minervadb.com","https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/https:\/\/twitter.com\/WebScaleDBA"],"url":"http:\/\/minervadb.com\/index.php\/author\/minervadb\/"}]}},"_links":{"self":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/2374"}],"collection":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/comments?post=2374"}],"version-history":[{"count":15,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/2374\/revisions"}],"predecessor-version":[{"id":2392,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/2374\/revisions\/2392"}],"wp:attachment":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/media?parent=2374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/categories?post=2374"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/tags?post=2374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}