{"id":4202,"date":"2023-05-12T21:59:11","date_gmt":"2023-05-12T19:59:11","guid":{"rendered":"https:\/\/tech.lobobrothers.com\/cluster-mysql-8-centos\/"},"modified":"2025-01-30T17:49:58","modified_gmt":"2025-01-30T16:49:58","slug":"cluster-mysql-8-centos","status":"publish","type":"post","link":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/","title":{"rendered":"Cluster Mysql 8 in Centos"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

INSTALL CLUSTER MYSQL NDB 8 CENTOS<\/strong><\/h2>\n

Good afternoon, we have been a bit lost due to lack of time and we have not written for many months, but we are back, this time with a topic with little information in Spanish.<\/p>\n

We are going to see how to set up a mysql ndb 8<\/strong> cluster with 2 management, 2 mysql and 4 data nodes, in a clean installation of centos 7 where we will add a second disk for the cluster part separating it from the OS.<\/p>\n

To do this we are going to take some common first steps in the 8 virtual machines in this case, which we will use.<\/p>\n

COMMON STEPS<\/strong><\/p>\n

1. We create the LVM of the secondary disk,<\/strong> for this<\/p>\n

fdisk \/dev\/sdb<\/p>\n

Please note that your disk may have another name, run fdisk -l to find out what the disk label is<\/p>\n

I’m not going to go into much detail on this as there are many tutorials, but it would basically be typing the following keys from the interactive menu that appears. m n p 1 t 8e w (it looks like a hieroglyph but you will be able to decipher it)<\/p>\n

Continue running<\/p>\n

pvcreate \/dev\/sdb1<\/p>\n

vgcreate data \/dev\/sdb1<\/p>\n

lvcreate -l 100%FREE –name data data<\/p>\n

mkfs.ext4 \/dev\/data\/data<\/p>\n

mkdir -pv \/data<\/p>\n

mount \/dev\/data\/data \/data<\/p>\n

With this we will have our disk mounted in \/data, now we put it in the fstab so that it mounts it at startup.<\/p>\n

nano \/etc\/fstab<\/p>\n

and we add to the end of the file<\/p>\n

\/dev\/data\/data \/data ext4 defaults 0 0<\/p>\n

We save and ready<\/p>\n

2. Disable ipv6<\/strong><\/p>\n

nano \/etc\/default\/grub<\/p>\n

We modified the line GRUB_CMDLINE_LINUX…., for this other one<\/p>\n

GRUB_CMDLINE_LINUX=”ipv6.disable=1 crashkernel=auto rhgb quiet”<\/p>\n

We save, exit and execute<\/p>\n

grub2-mkconfig -o \/boot\/grub2\/grub.cfg<\/p>\n

We reboot the machine.<\/p>\n

3. Disable firewalld<\/strong><\/p>\n

This part is up to the consumer, but we are going to make it easy and disable the machine’s firewall, since in production this should also be protected by a perimeter firewall for the front end, since as we will see later we are going to use two cards, one for synchronization and another to attack the database.<\/p>\n

systemctl stop firewalld<\/p>\n

systemctl disable firewalld<\/p>\n

systemctl mask –now firewalld<\/p>\n

3. Disable selinux<\/strong><\/p>\n

nano \/etc\/selinux\/config<\/p>\n

and we add<\/p>\n

SELINUX=disabled<\/p>\n

We save and exit.<\/p>\n

With this we would have already completed the part common to all machines, we move on to the different components.<\/p>\n

MANAGEMENT<\/strong><\/p>\n

We will set up two management machines in case one fails.<\/p>\n

We will download and install all the necessary software, indicating that we are going to download 8.0.20 because I don’t see the higher versions as stable as this one and they cause many problems during the installation.<\/p>\n

yum -y update<\/p>\n

yum -y install nano wget net-tools<\/p>\n

yum -y install epel-release<\/p>\n

yum -y install perl-Class-MethodMaker<\/p>\n

yum -y install perl-Data-Dumper<\/p>\n

yum -y install perl-DBI<\/p>\n

yum -y remove mariadb-libs<\/p>\n

cd ~<\/p>\n

wget https:\/\/cdn.mysql.com\/archives\/mysql-cluster-gpl-8.0\/mysql-cluster-community-8.0.20-1.el7.x86_64.rpm-bundle.tar<\/p>\n

tar -xvf mysql-cluster-community-8.0.20-1.el7.x86_64.rpm-bundle.tar<\/p>\n

rpm -Uvh mysql-cluster-community-management-server-8.0.20-1.el7.x86_64.rpm<\/p>\n

rpm -Uvh mysql-cluster-community-common-8.0.20-1.el7.x86_64.rpm<\/p>\n

rpm -Uvh mysql-cluster-community-libs-8.0.20-1.el7.x86_64.rpm<\/p>\n

rpm -Uvh mysql-cluster-community-client-8.0.20-1.el7.x86_64.rpm<\/p>\n

We create the necessary directories<\/p>\n

mkdir -p \/var\/lib\/mysql-cluster<\/p>\n

mkdir -p \/data\/logs<\/p>\n

And we edit the configuration file, where we will take into account the following scenario, we will communicate all the machines internally through a dedicated network card with the range 172.17.110.0\/24 and the management and the mysql will have another card with addressing 172.17.120.0\/24 for example to attack them, so we do not produce any interference in the internal communication of the cluster.<\/p>\n

nano \/var\/lib\/mysql-cluster\/config.ini<\/p>\n

And we leave it like that<\/p>\n

[ndb_mgmd default]
\n# Directory for MGM node log files
\nDataDir=\/data\/logs<\/p>\n

[ndb_mgmd]
\n#Management Node 1
\nHostName=172.17.110.10
\nNodeId=1<\/p>\n

[ndb_mgmd]
\n#Management Node 2
\nHostName=172.17.110.11
\nNodeId=2<\/p>\n

[ndbd default]
\nNoOfReplicas=2 # Number of replicas
\nDataMemory=1G # Memory allocate for data storage
\n#Directory for Data Node
\nDataDir=\/data<\/p>\n

[mysqld]
\n#SQL Node 1
\nHostName=172.17.110.20
\nNodeId=3<\/p>\n

[mysqld]
\n#SQL Node 2
\nHostName=172.17.110.21
\nNodeId=4<\/p>\n

[ndbd]
\n#Data Node 1
\nHostName=172.17.110.31
\nNodeId=11<\/p>\n

[ndbd]
\n#Data Node 2
\nHostName=172.17.110.32
\nNodeId=12<\/p>\n

[ndbd]
\n#Data Node 3
\nHostName=172.17.110.33
\nNodeId=13<\/p>\n

[ndbd]
\n#Data Node 4
\nHostName=172.17.110.34
\nNodeId=14<\/p>\n

I’m going to explain this file so that you understand what we’re doing but there’s a lot more that’s in the official documentation<\/a>.<\/p>\n

In the part [ndb_mgmd default] We put what is global to the management nodes, that is, so as not to have to write twice since it will be the same in both.<\/p>\n

We created a [ndb_mgmd] for each management, where the data that changes will go, such as the hostname and the ID, which cannot be repeated because it is what identifies who is who.<\/p>\n

Same for data nodes, we have the global part [ndbd default] and the individual part [ndbd]<\/p>\n

And finally the mysql with [mysqld]<\/p>\n

There is a lot of configuration depending on the scenario, such as the number of replicas, DataMemory, RedoBuffer, MaxNoofTables, …. as I said, it is better to look at the official documentation depending on the scenario because we would never finish the post hahaha.<\/p>\n

With this we could start this first management by executing<\/p>\n

ndb_mgmd –ndb-nodeid=1 –config-file=\/var\/lib\/mysql-cluster\/config.ini<\/p>\n

We are telling it the corresponding id number that we have put in the config and where said config is.<\/p>\n

Now we have to do the same in node 2, except for the last part where we will indicate that it is id 2, that is, after doing everything and creating the config file, we execute.<\/p>\n

ndb_mgmd –ndb-nodeid=2 –config-file=\/var\/lib\/mysql-cluster\/config.ini<\/p>\n

Where, as you can see, we have changed the id.<\/p>\n

We execute ndb_mgm and then write show, we will see that both are ok.<\/p>\n

DATA NODES<\/strong><\/p>\n

We download and install what is necessary<\/p>\n

yum -y remove mariadb-libs<\/p>\n

cd ~<\/p>\n

wget https:\/\/cdn.mysql.com\/archives\/mysql-cluster-gpl-8.0\/mysql-cluster-community-8.0.20-1.el7.x86_64.rpm-bundle.tar<\/p>\n

tar -xvf mysql-cluster-community-8.0.20-1.el7.x86_64.rpm-bundle.tar<\/p>\n

rpm -Uvh mysql-cluster-community-data-node-8.0.20-1.el7.x86_64.rpm<\/p>\n

We edit the my.cnf<\/p>\n

nano \/etc\/my.cnf<\/p>\n

Remaining as follows<\/p>\n

[mysqld]
\nndbcluster
\nndb-connectstring=172.17.110.10 # IP address of Management Node 1
\nndb-connectstring=172.17.110.11 # IP address of Management Node 2<\/p>\n

[mysql_cluster]
\nndb-connectstring=172.17.110.10 # IP address of Management Node 1
\nndb-connectstring=172.17.110.11 # IP address of Management Node 2<\/p>\n

We are indicating who the management previously created with all the configuration are.<\/p>\n

We create the directory<\/p>\n

mkdir -p \/data\/logs<\/p>\n

Already defined globally in the management configuration files and we start the node with<\/p>\n

ndbd<\/p>\n

Do this for each data node.<\/p>\n

MYSQL NODE<\/strong><\/p>\n

Finally the mysql, we install everything necessary<\/p>\n

yum -y install epel-release<\/p>\n

yum -y install perl-Class-MethodMaker<\/p>\n

yum -y install perl-Data-Dumper<\/p>\n

yum -y install perl-DBI<\/p>\n

yum -y remove mariadb-libs<\/p>\n

rpm -Uvh mysql-cluster-community-common-8.0.20-1.el7.x86_64.rpm<\/p>\n

rpm -Uvh mysql-cluster-community-libs-8.0.20-1.el7.x86_64.rpm<\/p>\n

rpm -Uvh mysql-cluster-community-client-8.0.20-1.el7.x86_64.rpm<\/p>\n

rpm -Uvh mysql-cluster-community-server-8.0.20-1.el7.x86_64.rpm<\/p>\n

and we edit the my.cnf<\/p>\n

nano \/etc\/my.cnf<\/p>\n

Remaining as follows<\/p>\n

[mysqld]
\nndbcluster
\nndb-connectstring=172.17.110.10 # IP address of Management Node 1
\nndb-connectstring=172.17.110.11 # IP address of Management Node 2
\ndefault_storage_engine=ndbcluster # Define default Storage Engine used by MySQL<\/p>\n

#[mysql_cluster]
\n#ndb-connectstring=172.17.110.10 # IP address of Management Node 1
\n#ndb-connectstring=172.17.110.11 # IP address of Management Node 2<\/p>\n

The same as before, we are telling you who are the managers who have all the configuration and the engine that we are going to use in this case ndb<\/p>\n

We create the directory<\/p>\n

mkdir -p \/var\/lib\/mysql-cluster<\/p>\n

And we start the service<\/p>\n

service mysqld start<\/p>\n

This on both nodes.<\/p>\n

After this we can check the status of the cluster again with<\/p>\n

ndb_mgm<\/p>\n

show<\/p>\n

I hope this helps, if you have any questions, please leave a comment.<\/p>\n

Have a nice weekend.<\/p>\n

TL<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

INSTALL CLUSTER MYSQL NDB 8 CENTOS Good afternoon, we have been a bit lost due to lack of time and we have not written for many months, but we are back, this time with a topic with little information in Spanish. We are going to see how to set up a mysql ndb 8 cluster […]<\/p>\n","protected":false},"author":2,"featured_media":3673,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,50],"tags":[],"class_list":["post-4202","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux-world","category-open-source"],"yoast_head":"\nCluster Mysql 8 in Centos - LBT<\/title>\n<meta name=\"description\" content=\"How to install a mysql ndb 8 cluster on centos 7 with 2 management, 2 mysql and 4 data nodes with the basic options\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cluster Mysql 8 in Centos - LBT\" \/>\n<meta property=\"og:description\" content=\"How to install a mysql ndb 8 cluster on centos 7 with 2 management, 2 mysql and 4 data nodes with the basic options\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog sobre linux y el mundo opensource\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/LoboBrothers\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-12T19:59:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-30T16:49:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"TL\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TL\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/\"},\"author\":{\"name\":\"TL\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/person\/11c359ab9896aa196007651fa6208beb\"},\"headline\":\"Cluster Mysql 8 in Centos\",\"datePublished\":\"2023-05-12T19:59:11+00:00\",\"dateModified\":\"2025-01-30T16:49:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/\"},\"wordCount\":1286,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg.webp\",\"articleSection\":[\"Linux World\",\"Open Source\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/\",\"url\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/\",\"name\":\"Cluster Mysql 8 in Centos - LBT\",\"isPartOf\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg.webp\",\"datePublished\":\"2023-05-12T19:59:11+00:00\",\"dateModified\":\"2025-01-30T16:49:58+00:00\",\"description\":\"How to install a mysql ndb 8 cluster on centos 7 with 2 management, 2 mysql and 4 data nodes with the basic options\",\"breadcrumb\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#primaryimage\",\"url\":\"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg.webp\",\"contentUrl\":\"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg.webp\",\"width\":1920,\"height\":1280,\"caption\":\"Cluster Mysql Centos\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/tech.lobobrothers.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cluster Mysql 8 in Centos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#website\",\"url\":\"https:\/\/tech.lobobrothers.com\/en\/\",\"name\":\"Tech LBT\",\"description\":\"Como apasionados de la tecnolog\u00eda y amantes del open source creamos este blog con art\u00edculos interesantes obre linux, cloud, open source, criptomonedas y ciberseguridad\",\"publisher\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/tech.lobobrothers.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#organization\",\"name\":\"Lobo Brothers Technology\",\"url\":\"https:\/\/tech.lobobrothers.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2019\/06\/logo_red.png\",\"contentUrl\":\"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2019\/06\/logo_red.png\",\"width\":110,\"height\":50,\"caption\":\"Lobo Brothers Technology\"},\"image\":{\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/LoboBrothers\/\",\"https:\/\/www.linkedin.com\/company\/lobobrothers\/about\/?viewAsMember=true\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/person\/11c359ab9896aa196007651fa6208beb\",\"name\":\"TL\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a2d3b9e0b67bd28fe8248346c09cbe07?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a2d3b9e0b67bd28fe8248346c09cbe07?s=96&d=mm&r=g\",\"caption\":\"TL\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cluster Mysql 8 in Centos - LBT","description":"How to install a mysql ndb 8 cluster on centos 7 with 2 management, 2 mysql and 4 data nodes with the basic options","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:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/","og_locale":"en_US","og_type":"article","og_title":"Cluster Mysql 8 in Centos - LBT","og_description":"How to install a mysql ndb 8 cluster on centos 7 with 2 management, 2 mysql and 4 data nodes with the basic options","og_url":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/","og_site_name":"Blog sobre linux y el mundo opensource","article_publisher":"https:\/\/www.facebook.com\/LoboBrothers\/","article_published_time":"2023-05-12T19:59:11+00:00","article_modified_time":"2025-01-30T16:49:58+00:00","og_image":[{"width":1920,"height":1280,"url":"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg","type":"image\/jpeg"}],"author":"TL","twitter_card":"summary_large_image","twitter_misc":{"Written by":"TL","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#article","isPartOf":{"@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/"},"author":{"name":"TL","@id":"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/person\/11c359ab9896aa196007651fa6208beb"},"headline":"Cluster Mysql 8 in Centos","datePublished":"2023-05-12T19:59:11+00:00","dateModified":"2025-01-30T16:49:58+00:00","mainEntityOfPage":{"@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/"},"wordCount":1286,"commentCount":0,"publisher":{"@id":"https:\/\/tech.lobobrothers.com\/en\/#organization"},"image":{"@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#primaryimage"},"thumbnailUrl":"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg.webp","articleSection":["Linux World","Open Source"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/","url":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/","name":"Cluster Mysql 8 in Centos - LBT","isPartOf":{"@id":"https:\/\/tech.lobobrothers.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#primaryimage"},"image":{"@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#primaryimage"},"thumbnailUrl":"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg.webp","datePublished":"2023-05-12T19:59:11+00:00","dateModified":"2025-01-30T16:49:58+00:00","description":"How to install a mysql ndb 8 cluster on centos 7 with 2 management, 2 mysql and 4 data nodes with the basic options","breadcrumb":{"@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#primaryimage","url":"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg.webp","contentUrl":"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2023\/05\/cluster-mysql-centos.jpg.webp","width":1920,"height":1280,"caption":"Cluster Mysql Centos"},{"@type":"BreadcrumbList","@id":"https:\/\/tech.lobobrothers.com\/en\/cluster-mysql-8-centos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/tech.lobobrothers.com\/en\/"},{"@type":"ListItem","position":2,"name":"Cluster Mysql 8 in Centos"}]},{"@type":"WebSite","@id":"https:\/\/tech.lobobrothers.com\/en\/#website","url":"https:\/\/tech.lobobrothers.com\/en\/","name":"Tech LBT","description":"Como apasionados de la tecnolog\u00eda y amantes del open source creamos este blog con art\u00edculos interesantes obre linux, cloud, open source, criptomonedas y ciberseguridad","publisher":{"@id":"https:\/\/tech.lobobrothers.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tech.lobobrothers.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/tech.lobobrothers.com\/en\/#organization","name":"Lobo Brothers Technology","url":"https:\/\/tech.lobobrothers.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2019\/06\/logo_red.png","contentUrl":"https:\/\/tech.lobobrothers.com\/wp-content\/uploads\/2019\/06\/logo_red.png","width":110,"height":50,"caption":"Lobo Brothers Technology"},"image":{"@id":"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/LoboBrothers\/","https:\/\/www.linkedin.com\/company\/lobobrothers\/about\/?viewAsMember=true"]},{"@type":"Person","@id":"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/person\/11c359ab9896aa196007651fa6208beb","name":"TL","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tech.lobobrothers.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a2d3b9e0b67bd28fe8248346c09cbe07?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a2d3b9e0b67bd28fe8248346c09cbe07?s=96&d=mm&r=g","caption":"TL"}}]}},"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/posts\/4202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/comments?post=4202"}],"version-history":[{"count":0,"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/posts\/4202\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/media\/3673"}],"wp:attachment":[{"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/media?parent=4202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/categories?post=4202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.lobobrothers.com\/en\/wp-json\/wp\/v2\/tags?post=4202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}