{"id":21010,"date":"2016-12-14T07:59:35","date_gmt":"2016-12-14T13:59:35","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=21010"},"modified":"2023-05-30T01:26:14","modified_gmt":"2023-05-30T06:26:14","slug":"set-up-mysql-cluster-on-ubuntu","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/","title":{"rendered":"How to set up MySQL Cluster on Ubuntu"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-24812\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg\" alt=\"How to set up MySQL Cluster on Ubuntu\" width=\"1200\" height=\"600\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg 1200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-768x384.jpg 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-1024x512.jpg 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-860x430.jpg 860w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-680x340.jpg 680w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-500x250.jpg 500w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-400x200.jpg 400w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-200x100.jpg 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu-50x25.jpg 50w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p>We&#8217;ll show you, how to set up MySQL Cluster on Ubuntu. The MySQL NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (Network DataBase). We will use a total of 4 virtual servers, one for the management, one SQL node and two data nodes:<!--more--><\/p>\n<ul>\n<li>172.16.1.1 &#8211; management VPS<\/li>\n<li>172.16.1.2 &#8211; <a href=\"https:\/\/www.rosehosting.com\/mysql-hosting.html\">SQL VPS<\/a><\/li>\n<li>172.16.1.3 &#8211; data1 VPS<\/li>\n<li>172.16.1.4 &#8211; data2 VPS<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"size-full wp-image-21012 alignnone\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/mysql-cluster.png\" alt=\"mysql cluster\" width=\"450\" height=\"260\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/mysql-cluster.png 450w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/mysql-cluster-150x87.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/mysql-cluster-300x173.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/mysql-cluster-400x231.png 400w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/mysql-cluster-200x116.png 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/mysql-cluster-50x29.png 50w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69fc0a5211821\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69fc0a5211821\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#1-Install-and-Configure-MySQL-Cluster-on-the-Management-VPS\" >1. Install and Configure MySQL Cluster on the Management VPS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#2-Install-and-Configure-MySQL-Cluster-on-the-SQL-VPS\" >2. Install and Configure MySQL Cluster on the SQL VPS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#3-Install-and-Configure-MySQL-Cluster-on-the-Data-VPSes\" >3. Install and Configure MySQL Cluster on the Data VPSes<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1-Install-and-Configure-MySQL-Cluster-on-the-Management-VPS\"><\/span>1. Install and Configure MySQL Cluster on the Management VPS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Download the <a href=\"https:\/\/dev.mysql.com\/downloads\/cluster\/\">latest version of MySQL Cluster<\/a> to a directory of your virtual server and extract it using the following commands:<\/p>\n<pre>cd \/opt\/\nwget http:\/\/dev.mysql.com\/get\/Downloads\/MySQL-Cluster-7.5\/mysql-cluster-gpl-7.5.4-linux-glibc2.5-x86_64.tar.gz -O mysql-cluster.tar.gz\ntar -xvzf mysql-cluster.tar.gz -C \/opt\/\nmv mysql-cluster-* mysql<\/pre>\n<p>Run the following commands:<\/p>\n<pre>cd \/opt\/mysql\/\ncp bin\/ndb_mgm* \/usr\/local\/bin\/\nchmod 755 \/usr\/local\/bin\/ndb_mgm*<\/pre>\n<p>Create a directory named &#8216;mysql-cluster&#8217;<\/p>\n<pre>mkdir -p \/var\/lib\/mysql-cluster\/<\/pre>\n<p>Then, create a new configuration named &#8216;config.ini&#8217;:<\/p>\n<pre>vi \/var\/lib\/mysql-cluster\/config.ini<\/pre>\n<p>add the following lines to it:<\/p>\n<pre>[ndbd default]\nNoOfReplicas=2\n# Memory to allocate for data storage\nDataMemory=2G   \n# Memory to allocate for index storage\nIndexMemory=512M   \n\n[mysqld default]\n \n[ndb_mgmd default]\n \n[tcp default]\n \n# Management VPS\n[ndb_mgmd]\n# Enter the hostname or IP address of the Management VPS\nhostname=172.16.1.1\n\n# SQL VPS\n[mysqld]\n# Enter the hostname or IP address of the SQL VPS\nhostname=172.16.1.2\n \n# Data1 VPS\n[ndbd]\n# Enter the hostname or IP address of the Data1 VPS\nhostname=172.16.1.3\nDataDir= \/var\/lib\/mysql-cluster\n \n# Data2 VPS\n[ndbd]\n# Enter the hostname or IP address of the Data2 VPS\nhostname=172.16.1.4\nDataDir=\/var\/lib\/mysql-cluster<\/pre>\n<p>Do not forget to change the hostnames\/IP addresses according to your actual server hostnames\/IP addresses.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2-Install-and-Configure-MySQL-Cluster-on-the-SQL-VPS\"><\/span>2. Install and Configure MySQL Cluster on the SQL VPS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Check if there are MySQL packages already installed:<\/p>\n<pre>dpkg -l | grep mysql\n\nrc  libmysqlclient18:amd64               5.5.49-0ubuntu0.14.04.1                  amd64        MySQL database client library\nii  mysql-client                         5.7.16-0ubuntu0.16.04.1                  all          MySQL database client (metapackage depending on the latest version)\nii  mysql-client-5.7                     5.7.16-0ubuntu0.16.04.1                  amd64        MySQL database client binaries\nii  mysql-client-core-5.7                5.7.16-0ubuntu0.16.04.1                  amd64        MySQL database core client binaries\nii  mysql-common                         5.7.16-0ubuntu0.16.04.1                  all          MySQL database common files, e.g. \/etc\/mysql\/my.cnf\nii  mysql-server                         5.7.16-0ubuntu0.16.04.1                  all          MySQL database server (metapackage depending on the latest version)\nrc  mysql-server-5.5                     5.5.49-0ubuntu0.14.04.1                  amd64        MySQL database server binaries and system database setup\nii  mysql-server-5.7                     5.7.13-0ubuntu0.16.04.2                  amd64        MySQL database server binaries and system database setup\nii  mysql-server-core-5.7                5.7.13-0ubuntu0.16.04.2                  amd64        MySQL database server binaries<\/pre>\n<p>Remove these packages and their configurations using:<\/p>\n<pre>apt-get purge mysql-c* mysql-s*<\/pre>\n<p>Or, remove packages and configuration files listed by the &#8216;dpkg -l | grep mysql&#8217; command above using:<\/p>\n<pre>apt-get purge mysql-client mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server mysql-server-5.5 mysql-server-5.7 mysql-server-core-5.7 libmysqlclient18<\/pre>\n<p>Download the latest version of MySQL Cluster available at &#8216;http:\/\/dev.mysql.com\/downloads\/cluster\/&#8217; to the opt directory of your virtual server and extract it using the following commands:<\/p>\n<pre>cd \/opt\/\nwget http:\/\/dev.mysql.com\/get\/Downloads\/MySQL-Cluster-7.5\/mysql-cluster-gpl-7.5.4-linux-glibc2.5-x86_64.tar.gz -O mysql-cluster.tar.gz\ntar -xvzf mysql-cluster.tar.gz -C \/opt\/\nRun the following commands:<\/pre>\n<pre>mv mysql-cluster-* mysql\nmv mysql \/usr\/local\/\ncd \/usr\/local\/mysql\/\nmv bin\/* \/usr\/local\/bin\/\nrm -rf bin\/\nln -s \/usr\/local\/bin \/usr\/local\/mysql\/\ncp support-files\/mysql.server \/etc\/init.d\/mysql\nsystemctl enable mysql\nmysqld --initialize\nchown -R root:mysql \/usr\/local\/mysql\/\nchown -R mysql \/usr\/local\/mysql\/data\/<\/pre>\n<p>Edit the MySQL configuration file (\/etc\/my.cnf):<\/p>\n<pre>vi \/etc\/my.cnf<\/pre>\n<p>add the following lines:<\/p>\n<pre>[mysqld]\ndatadir=\/usr\/local\/mysql\/data\nsocket=\/tmp\/mysql.sock\nuser=mysql\n\nndbcluster\nndb-connectstring=172.16.1.1\n\n[mysql_cluster]\n\nndb-connectstring=172.16.1.1\n\n[mysqld_safe]\nlog-error=\/var\/log\/mysqld.log\npid-file=\/var\/run\/mysqld\/mysqld.pid<\/pre>\n<p>Log in to the management VPS via SSH and run the following command:<\/p>\n<pre>ndb_mgmd -f \/var\/lib\/mysql-cluster\/config.ini --configdir=\/var\/lib\/mysql-cluster\/<\/pre>\n<p>In order to configure ndb_mgmd to start on boot, add the following command to &#8216;\/etc\/rc.local&#8217;:<\/p>\n<pre>vi \/etc\/rc.local<\/pre>\n<p>and add:<\/p>\n<pre>ndb_mgmd -f \/var\/lib\/mysql-cluster\/config.ini --configdir=\/var\/lib\/mysql-cluster\/<\/pre>\n<p>before the &#8216;exit 0&#8217; line and save the file.<br \/>\nStart the MySQL service on the SQL VPS:<\/p>\n<pre>service mysql start<\/pre>\n<p>In order to improve the security of your MySQL installation, run:<\/p>\n<pre>\/usr\/local\/mysql\/bin\/mysql_secure_installation<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"3-Install-and-Configure-MySQL-Cluster-on-the-Data-VPSes\"><\/span>3. Install and Configure MySQL Cluster on the Data VPSes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Check if there are MySQL packages already installed using:<\/p>\n<pre>dpkg -l | grep mysql<\/pre>\n<p>Remove them, including the configuration files:<\/p>\n<pre>apt-get purge mysql-client mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server mysql-server-5.5 mysql-server-5.7 mysql-server-core-5.7 libmysqlclient18<\/pre>\n<p>Download and extract the latest version of MySQL Cluster to the opt directory on the data1 VPS:<\/p>\n<pre>cd \/opt\/\nwget http:\/\/dev.mysql.com\/get\/Downloads\/MySQL-Cluster-7.5\/mysql-cluster-gpl-7.5.4-linux-glibc2.5-x86_64.tar.gz -O mysql-cluster.tar.gz\ntar -xvzf mysql-cluster.tar.gz -C \/opt\/<\/pre>\n<p>Run the following commands:<\/p>\n<pre>mv mysql-cluster-* mysql\nmv mysql \/usr\/local\/\nchown -R root:mysql \/usr\/local\/mysql\/\ncd \/usr\/local\/mysql\/\nmv bin\/* \/usr\/local\/bin\/\nrm -rf bin\/\nln -s \/usr\/local\/bin \/usr\/local\/mysql\/<\/pre>\n<p>Edit the MySQL configuration file:<\/p>\n<pre>vi \/etc\/my.cnf<\/pre>\n<p>add the following lines:<\/p>\n<pre>[mysqld]\ndatadir=\/usr\/local\/mysql\/data\nsocket=\/tmp\/mysql.sock\nuser=mysql\n\nndbcluster\nndb-connectstring=172.16.1.1\n\n[mysql_cluster]\n\nndb-connectstring=172.16.1.1\n\n[mysqld_safe]\nlog-error=\/var\/log\/mysqld.log\npid-file=\/var\/run\/mysqld\/mysqld.pid<\/pre>\n<p>Run the following commands:<\/p>\n<pre>mkdir \/var\/lib\/mysql-cluster\nchown -R mysql \/var\/lib\/mysql-cluster\ncd \/var\/lib\/mysql-cluster\nndbd --initial\necho \"ndbd\" &gt; \/etc\/init.d\/ndbd\nchmod 755 \/etc\/init.d\/ndbd<\/pre>\n<p>Repeat the same procedure on the Data2 VPS.<\/p>\n<p>In order to check the MySQL cluster status, run the following command on the management VPS:<\/p>\n<pre>ndb_mgm -e show<\/pre>\n<p>The output should look like this:<\/p>\n<pre>Connected to Management Server at: localhost:1186\nCluster Configuration\n---------------------\n[ndbd(NDB)]\u00a0\u00a0\u00a0\u00a0 2 node(s)\nid=3\u00a0\u00a0\u00a0 @172.16.1.3\u00a0 (mysql-5.7.16 ndb-7.5.4, Nodegroup: 0, *)\nid=4\u00a0\u00a0\u00a0 @172.16.1.4\u00a0 (mysql-5.7.16 ndb-7.5.4, Nodegroup: 0)\n\n[ndb_mgmd(MGM)] 1 node(s)\nid=1\u00a0\u00a0\u00a0 @172.16.1.1\u00a0 (mysql-5.7.16 ndb-7.5.4)\n\n[mysqld(API)]\u00a0\u00a0 1 node(s)\nid=2\u00a0\u00a0\u00a0 @172.16.1.2\u00a0 (mysql-5.7.16 ndb-7.5.4)\n<\/pre>\n<p>That is it. The setup of the MySQL cluster is now complete.<\/p>\n<hr \/>\n<p>Of course, you don\u2019t have to set up MySQL Cluster on Ubuntu,\u00a0 if you use one of our <a href=\"https:\/\/www.rosehosting.com\/mysql-hosting.html\">MySQL VPS Hosting<\/a> services, in which case you can simply ask our expert Linux admins to <strong>set up MySQL Cluster<\/strong> for you. They are available 24&#215;7 and will take care of your request immediately. For more updates, you can read <a href=\"https:\/\/www.rosehosting.com\/blog\/mariadb-mysql-auto-lustering-with-load-balancing-and-replication-for-high-availability-and-performance\/\">MariaDB\/MySQL Auto-\u0421lustering with Load Balancing and Replication for High Availability and Performance<\/a>.<\/p>\n<p><strong><span style=\"color: #ff0000;\">PS<\/span>.<\/strong> If you liked this post on how to set up MySQL Cluster on Ubuntu, please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We&#8217;ll show you, how to set up MySQL Cluster on Ubuntu. The MySQL NDB Cluster integrates the standard MySQL server &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to set up MySQL Cluster on Ubuntu\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#more-21010\" aria-label=\"Read more about How to set up MySQL Cluster on Ubuntu\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":24812,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1701,13,1698],"tags":[39,59],"class_list":["post-21010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-networking-and-domains","category-tutorials","category-ubuntu","tag-mysql","tag-ubuntu","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to set up MySQL Cluster on Ubuntu | RoseHosting<\/title>\n<meta name=\"description\" content=\"How to set up MySQL Cluster on Ubuntu | RoseHosting\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/\" \/>\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 MySQL Cluster on Ubuntu\" \/>\n<meta property=\"og:description\" content=\"How to set up MySQL Cluster on Ubuntu | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-14T13:59:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-30T06:26:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to set up MySQL Cluster on Ubuntu\",\"datePublished\":\"2016-12-14T13:59:35+00:00\",\"dateModified\":\"2023-05-30T06:26:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/\"},\"wordCount\":492,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg\",\"keywords\":[\"mysql\",\"ubuntu\"],\"articleSection\":[\"Databases\",\"Networking and Domains\",\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/\",\"name\":\"How to set up MySQL Cluster on Ubuntu | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg\",\"datePublished\":\"2016-12-14T13:59:35+00:00\",\"dateModified\":\"2023-05-30T06:26:14+00:00\",\"description\":\"How to set up MySQL Cluster on Ubuntu | RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg\",\"width\":1200,\"height\":600,\"caption\":\"How to set up MySQL Cluster on Ubuntu\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/set-up-mysql-cluster-on-ubuntu\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to set up MySQL Cluster on Ubuntu\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RoseHosting\",\"https:\\\/\\\/x.com\\\/rosehosting\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/rosehosting\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\\\/\\\/www.rosehosting.com\",\"https:\\\/\\\/www.facebook.com\\\/rosehosting.helpdesk\"],\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/author\\\/jwilson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to set up MySQL Cluster on Ubuntu | RoseHosting","description":"How to set up MySQL Cluster on Ubuntu | RoseHosting","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:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/","og_locale":"en_US","og_type":"article","og_title":"How to set up MySQL Cluster on Ubuntu","og_description":"How to set up MySQL Cluster on Ubuntu | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2016-12-14T13:59:35+00:00","article_modified_time":"2023-05-30T06:26:14+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to set up MySQL Cluster on Ubuntu","datePublished":"2016-12-14T13:59:35+00:00","dateModified":"2023-05-30T06:26:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/"},"wordCount":492,"commentCount":2,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg","keywords":["mysql","ubuntu"],"articleSection":["Databases","Networking and Domains","Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/","url":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/","name":"How to set up MySQL Cluster on Ubuntu | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg","datePublished":"2016-12-14T13:59:35+00:00","dateModified":"2023-05-30T06:26:14+00:00","description":"How to set up MySQL Cluster on Ubuntu | RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/12\/How-to-set-up-MySQL-Cluster-on-Ubuntu.jpg","width":1200,"height":600,"caption":"How to set up MySQL Cluster on Ubuntu"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/set-up-mysql-cluster-on-ubuntu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to set up MySQL Cluster on Ubuntu"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/21010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=21010"}],"version-history":[{"count":3,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/21010\/revisions"}],"predecessor-version":[{"id":45806,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/21010\/revisions\/45806"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/24812"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=21010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=21010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=21010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}