{"id":661,"date":"2021-05-08T02:43:00","date_gmt":"2021-05-07T19:43:00","guid":{"rendered":"https:\/\/rotreein.com\/?p=661"},"modified":"2025-01-05T19:09:00","modified_gmt":"2025-01-05T12:09:00","slug":"config-innodb-cluster-on-mysql","status":"publish","type":"post","link":"https:\/\/rotreein.com\/?p=661","title":{"rendered":"Deploy MySQL InnoDB Cluster"},"content":{"rendered":"\n<p>In this article, we&#8217;ll explore the step-by-step process of deploying an InnoDB Cluster on MySQL, empowering you to harness the full potential of this robust database solution<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Configure-instance\">Configure instance<\/h3>\n\n\n\n<p>We have three instances for the build cluster. Each instance must be configured individually before joining the InnoDB cluster to achieve fault tolerance. Please repeat this process for each instance<\/p>\n\n\n\n<pre data-mode=\"php\" data-theme=\"github\" data-fontsize=\"14\" data-lines=\"Infinity\" class=\"wp-block-simple-code-block-ace\">MySQL  JS > dba.configureLocalInstance(\"root@localhost:3306\");<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"632\" src=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-1-1024x632.png\" alt=\"\" class=\"wp-image-702\" srcset=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-1-1024x632.png 1024w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-1-300x185.png 300w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-1-768x474.png 768w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-1-1536x948.png 1536w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-1-2048x1263.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<pre data-mode=\"php\" data-theme=\"github\" data-fontsize=\"14\" data-lines=\"Infinity\" class=\"wp-block-simple-code-block-ace\">MySQL  JS > shell.connect(\"clusteradmin@centos-mysql-cluster-01:3306\");<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"288\" src=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-2-1024x288.png\" alt=\"\" class=\"wp-image-703\" srcset=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-2-1024x288.png 1024w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-2-300x84.png 300w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-2-768x216.png 768w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-2-1536x432.png 1536w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-2-2048x576.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-large-font-size\"><br><sup><strong>Create Cluster<\/strong><\/sup><\/p>\n\n\n\n<pre data-mode=\"php\" data-theme=\"tomorrow\" data-fontsize=\"14\" data-lines=\"Infinity\" class=\"wp-block-simple-code-block-ace\">MySQL  JS > cluster = dba.createCluster('mysql_playground_cluster');<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"2104\" height=\"636\" src=\"https:\/\/rotreein.com\/wp-content\/uploads\/2025\/01\/image-5.png\" alt=\"\" class=\"wp-image-841\"\/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading has-medium-font-size\" id=\"Join-\/-Add-new-instance--to-Cluster\">Join \/ Add new instance to Cluster<\/h2>\n\n\n\n<pre data-mode=\"php\" data-theme=\"tomorrow\" data-fontsize=\"14\" data-lines=\"Infinity\" class=\"wp-block-simple-code-block-ace\">MySQL JS > cluster.addInstance('clusteradmin@centos-mysql-cluster-02:3306');<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"667\" src=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-061327-1024x667.png\" alt=\"\" class=\"wp-image-666\" srcset=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-061327-1024x667.png 1024w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-061327-300x195.png 300w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-061327-768x500.png 768w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-061327-1536x1001.png 1536w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-061327-2048x1335.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<pre data-mode=\"php\" data-theme=\"tomorrow\" data-fontsize=\"14\" data-lines=\"Infinity\" class=\"wp-block-simple-code-block-ace\">MySQL  JS > cluster.addInstance('clusteradmin@centos-mysql-cluster-03:3306');<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063402-1024x506.png\" alt=\"\" class=\"wp-image-667\" srcset=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063402-1024x506.png 1024w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063402-300x148.png 300w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063402-768x379.png 768w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063402-1536x759.png 1536w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063402-2048x1012.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<p>A cluster has been created with 3 nodes ( can tolerate up )<\/p>\n\n\n\n<pre data-mode=\"php\" data-theme=\"tomorrow\" data-fontsize=\"14\" data-lines=\"Infinity\" class=\"wp-block-simple-code-block-ace\">MySQL  JS > var cluster = dba.getCluster();\nMySQL  JS > cluster.status()<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063610-1024x506.png\" alt=\"\" class=\"wp-image-668\" srcset=\"https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063610-1024x506.png 1024w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063610-300x148.png 300w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063610-768x379.png 768w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063610-1536x759.png 1536w, https:\/\/rotreein.com\/wp-content\/uploads\/2024\/05\/image-20231226-063610-2048x1012.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we&#8217;ll explore the step-by-step process of deploying an InnoDB Cluster on MySQL, empowering you to harness the full potential of this robust database solution Configure instance We have three instances for the build cluster. Each instance must be configured individually before joining the InnoDB cluster to achieve fault tolerance. Please repeat this&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/rotreein.com\/index.php?rest_route=\/wp\/v2\/posts\/661"}],"collection":[{"href":"https:\/\/rotreein.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rotreein.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rotreein.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rotreein.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=661"}],"version-history":[{"count":33,"href":"https:\/\/rotreein.com\/index.php?rest_route=\/wp\/v2\/posts\/661\/revisions"}],"predecessor-version":[{"id":836,"href":"https:\/\/rotreein.com\/index.php?rest_route=\/wp\/v2\/posts\/661\/revisions\/836"}],"wp:attachment":[{"href":"https:\/\/rotreein.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rotreein.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rotreein.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}