{"id":2478,"date":"2018-09-01T18:49:21","date_gmt":"2018-09-01T18:49:21","guid":{"rendered":"http:\/\/dbtut.com\/?p=2478"},"modified":"2018-12-06T13:17:21","modified_gmt":"2018-12-06T13:17:21","slug":"mysql-galera-cluster-for-high-availability-solution","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/","title":{"rendered":"Mysql Galera Cluster for High Availability Solution"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><strong>Steps to Install &amp; Configure MySQL 3-Node Galera Cluster on CENTOS<\/strong><\/p>\n<p><strong>Step 1: Enabling the Galera Cluster yum repositories.<\/strong><\/p>\n<pre class=\"lang:default decode:true  \">vi \/etc\/yum.repos.d\/galera.repo\r\n\r\n[galera]\r\nname = Galera\r\nbaseurl = http:\/\/releases.galeracluster.com\/galera-3\/centos\/7\/x86_64\/\r\ngpgkey = http:\/\/releases.galeracluster.com\/GPG-KEY-galeracluster.com\r\ngpgcheck = 1\r\n\r\n[mysql-wsrep]\r\nname = MySQL-wsrep\r\nbaseurl = http:\/\/releases.galeracluster.com\/mysql-wsrep-5.7.21-25.14\/centos\/7\/x86_64\/\r\ngpgkey = http:\/\/releases.galeracluster.com\/GPG-KEY-galeracluster.com\r\ngpgcheck = 1<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 2: Install Galera and the prerequisite packages.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">yum -y install galera-3 mysql-wsrep-5.7 rsync lsof policycoreutils-python firewalld<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 3: Enable the Galera service to start at boot.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">systemctl enable mysqld<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 4: Enable the service to start at boot &amp; Start the firewalld service.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">systemctl enable firewalld\r\nsystemctl start firewalld<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 5: Configure firewall exceptions to allow both replication and remote MySQL connections and reload the firewall.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">firewall-cmd --zone=public --add-service=mysql \u2013permanent\r\nfirewall-cmd --zone=public --add-port=3306\/tcp --permanent\r\nfirewall-cmd --zone=public --add-port=4444\/tcp --permanent\r\nfirewall-cmd --zone=public --add-port=4567\/tcp --permanent\r\nfirewall-cmd --zone=public --add-port=4567\/udp --permanent\r\nfirewall-cmd --zone=public --add-port=4568\/tcp --permanent\r\nfirewall-cmd \u2013reload<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 6: Configure SELinux to permissive mode for MySQL.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">semanage port -a -t mysqld_port_t -p tcp 4567\r\nsemanage port -a -t mysqld_port_t -p udp 4567\r\nsemanage port -a -t mysqld_port_t -p tcp 4568\r\nsemanage port -a -t mysqld_port_t -p tcp 4444\r\nsemanage permissive -a mysqld_t<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 7: Let us Configure my.cnf file.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">cp \/etc\/my.cnf \/etc\/my.cnf.bak\r\nvi \/etc\/my.cnf\r\n\r\n[mysqld]\r\ndatadir=\/var\/lib\/mysql\r\nsocket=\/var\/lib\/mysql\/mysql.sock\r\nuser=mysql\r\nbinlog_format=ROW\r\nbind-address=0.0.0.0\r\ndefault_storage_engine=innodb\r\ninnodb_autoinc_lock_mode=2\r\ninnodb_flush_log_at_trx_commit=0\r\ninnodb_buffer_pool_size=128M\r\nwsrep_provider=\/usr\/lib64\/galera-3\/libgalera_smm.so\r\nwsrep_provider_options=\"gcache.size=300M; gcache.page_size=300M\"\r\nwsrep_cluster_name=\"GaleraCluster\"\r\nwsrep_cluster_address=\"gcomm:\/\/10.1.0.11:3306,10.1.0.12:3306,10.1.0.13:3306\"\r\nwsrep_sst_method=rsync\r\nserver_id=1\r\nwsrep_node_address=\"10.1.0.11\"\r\nwsrep_node_name=\"node_aplha\"\r\n\r\n[mysql_safe]\r\nlog-error=\/var\/log\/mysqld.log\r\npid-file=\/var\/run\/mysqld\/mysqld.pid<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 8: Repeat the above steps on each MySQL node that will participate in the MySQL Cluster. Be sure to alter the below fields in the \/etc\/my.cnf file to reflect the correct IP address and hostname that is applicable to each node.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">server_id=1\r\nwsrep_node_address=\"10.1.0.11\"\r\nwsrep_node_name=\"node_aplha\"\r\n\r\nserver_id=2\r\nwsrep_node_address=\"10.1.0.12\"\r\nwsrep_node_name=\"node_beta\"\r\n\r\nserver_id=3\r\nwsrep_node_address=\"10.1.0.13\"\r\nwsrep_node_name=\"node_gamma\"<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 9 : Create the mysqld.log and give the mysql account the appropriate permissions on each node of the Galera Cluster.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">touch \/var\/log\/mysqld.log\r\nchown mysql:mysql \/var\/log\/mysqld.log<\/pre>\n<p>&nbsp;<\/p>\n<p>Starting MySQL Cluster for the first time<\/p>\n<p><strong>Step 10: Start the MySQL on the first node, i.e node_alpha. <\/strong><\/p>\n<pre class=\"lang:default decode:true \">\/usr\/bin\/mysqld_bootstrap<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 11: After you installed MySQL 5.7 you will need to find the temporary password from \/var\/log\/mysqld.log to login as root.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">grep 'temporary password' \/var\/log\/mysqld.log<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 12: Login to MySQL and run the below query to confirm the number of nodes in the cluster.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">mysql -u root -p\r\nmysql&gt; SHOW 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<p>&nbsp;<\/p>\n<p><strong>Step 13: Start MySQL on the other member nodes, node_beta and node_gamma. Notice the command to start the MySQL service is different on subsequent member nodes.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">systemctl start mysqld<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 14: Login to MySQL and run the below query again to confirm the number of nodes in the cluster has increased.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">mysql -u root -p\r\nmysql&gt; SHOW 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<p>&nbsp;<\/p>\n<p><strong>Step 15 : Let\u2019s ensure all three node IPs are currently listed in wsrep_incoming_addresses. Disconnected nodes are normally removed from the replication automatically.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">mysql&gt; SHOW STATUS LIKE 'wsrep%';\r\n+-----------------------------------------------------------------------------+\r\n| Variable_name | Value |\r\n+-----------------------------------------------------------------------------+\r\n| wsrep_incoming_addresses | 10.1.0.11:3306,10.1.0.12:3306,10.1.0.13:3306 |<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Step 16 : Let\u2019s create a mysql user for State Snapshot Transfer(SST) and add below parameters in my.cnf file <\/strong><\/p>\n<pre class=\"lang:default decode:true \">mysql -uroot -p\r\nmysql &gt; grant all on *.* to galera@'%' identified by 'passwd';\r\nmysql &gt; flush privileges.\r\nmysql &gt; exit\r\n\r\nvi \/ete\/my.cnf\r\n\r\nwsrep_sst_method=rsync\r\nwsrep_sst_auth=galera:passwd<\/pre>\n<p>&nbsp;<\/p>\n<p>At last restart the cluster nodes.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2478\" class=\"pvc_stats all  \" data-element-id=\"2478\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Steps to Install &amp; Configure MySQL 3-Node Galera Cluster on CENTOS Step 1: Enabling the Galera Cluster yum repositories. vi \/etc\/yum.repos.d\/galera.repo [galera] name = Galera baseurl = http:\/\/releases.galeracluster.com\/galera-3\/centos\/7\/x86_64\/ gpgkey = http:\/\/releases.galeracluster.com\/GPG-KEY-galeracluster.com gpgcheck = 1 [mysql-wsrep] name = MySQL-wsrep baseurl = http:\/\/releases.galeracluster.com\/mysql-wsrep-5.7.21-25.14\/centos\/7\/x86_64\/ gpgkey = http:\/\/releases.galeracluster.com\/GPG-KEY-galeracluster.com gpgcheck = 1 &nbsp; Step 2: Install Galera and the &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2478\" class=\"pvc_stats all  \" data-element-id=\"2478\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":154,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-2478","post","type-post","status-publish","format-standard","","category-mysql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mysql Galera Cluster for High Availability Solution - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Mysql Galera Cluster for High Availability Solution\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mysql Galera Cluster for High Availability Solution - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Mysql Galera Cluster for High Availability Solution\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-01T18:49:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-06T13:17:21+00:00\" \/>\n<meta name=\"author\" content=\"Sarthak Tomar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sarthak Tomar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/\"},\"author\":{\"name\":\"Sarthak Tomar\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/1c6d3863eb88b421469b3ea589e50454\"},\"headline\":\"Mysql Galera Cluster for High Availability Solution\",\"datePublished\":\"2018-09-01T18:49:21+00:00\",\"dateModified\":\"2018-12-06T13:17:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/\"},\"wordCount\":325,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MySQL-MariaDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/\",\"name\":\"Mysql Galera Cluster for High Availability Solution - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-09-01T18:49:21+00:00\",\"dateModified\":\"2018-12-06T13:17:21+00:00\",\"description\":\"Mysql Galera Cluster for High Availability Solution\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mysql Galera Cluster for High Availability Solution\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/1c6d3863eb88b421469b3ea589e50454\",\"name\":\"Sarthak Tomar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/09643837ecbd9e1b1a6ee630708df8f15810fa85e3a68005fde663f930cff5b4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/09643837ecbd9e1b1a6ee630708df8f15810fa85e3a68005fde663f930cff5b4?s=96&d=mm&r=g\",\"caption\":\"Sarthak Tomar\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/sarthaktomar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mysql Galera Cluster for High Availability Solution - Database Tutorials","description":"Mysql Galera Cluster for High Availability Solution","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:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/","og_locale":"en_US","og_type":"article","og_title":"Mysql Galera Cluster for High Availability Solution - Database Tutorials","og_description":"Mysql Galera Cluster for High Availability Solution","og_url":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/","og_site_name":"Database Tutorials","article_published_time":"2018-09-01T18:49:21+00:00","article_modified_time":"2018-12-06T13:17:21+00:00","author":"Sarthak Tomar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sarthak Tomar","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/"},"author":{"name":"Sarthak Tomar","@id":"https:\/\/dbtut.com\/#\/schema\/person\/1c6d3863eb88b421469b3ea589e50454"},"headline":"Mysql Galera Cluster for High Availability Solution","datePublished":"2018-09-01T18:49:21+00:00","dateModified":"2018-12-06T13:17:21+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/"},"wordCount":325,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MySQL-MariaDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/","url":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/","name":"Mysql Galera Cluster for High Availability Solution - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-09-01T18:49:21+00:00","dateModified":"2018-12-06T13:17:21+00:00","description":"Mysql Galera Cluster for High Availability Solution","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/mysql-galera-cluster-for-high-availability-solution\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Mysql Galera Cluster for High Availability Solution"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/1c6d3863eb88b421469b3ea589e50454","name":"Sarthak Tomar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09643837ecbd9e1b1a6ee630708df8f15810fa85e3a68005fde663f930cff5b4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09643837ecbd9e1b1a6ee630708df8f15810fa85e3a68005fde663f930cff5b4?s=96&d=mm&r=g","caption":"Sarthak Tomar"},"url":"https:\/\/dbtut.com\/index.php\/author\/sarthaktomar\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/154"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=2478"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2478\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=2478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=2478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=2478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}