centos7 安装 mysql集群7.5.25

mysql-cluster7.5.25 下载地址：

# https://dev.mysql.com/downloads/cluster/
https://cdn.mysql.com//Downloads/MySQL-Cluster-7.5/mysql-cluster-community-7.5.25-1.el7.x86_64.rpm-bundle.tar

安装软件（每台服务器都要执行此操作）：

# 下载
yum -y install wget
wget https://cdn.mysql.com//Downloads/MySQL-Cluster-7.5/mysql-cluster-community-7.5.25-1.el7.x86_64.rpm-bundle.tar
# 解压
tar -xvf mysql-cluster-community-7.5.25-1.el7.x86_64.rpm-bundle.tar
# 安装
yum -y install epel-release
yum -y install libaio
yum -y install perl-Data-Dumper
yum -y install perl-Class-MethodMaker
yum -y install perl-DBI
yum -y install net-tools
yum -y remove mariadb-libs
rpm -Uvh mysql-cluster-community-data-node-7.5.25-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-common-7.5.25-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-libs-7.5.25-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-client-7.5.25-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-server-7.5.25-1.el7.x86_64.rpm
rpm -Uvh mysql-cluster-community-management-server-7.5.25-1.el7.x86_64.rpm

管理节点配置（192.168.1.11）:

1. 创建数据文件夹：
   mkdir -p /var/lib/mysql-cluster
2. 创建配置文件：
   vim /var/lib/mysql-cluster/config.ini

   [ndb_mgmd default]
   DataDir=/var/lib/mysql-cluster
   [ndbd default]
   NoOfReplicas=2
   DataMemory=256M
   IndexMemory=128M
   DataDir=/var/lib/mysql-cluster
   [ndb_mgmd]
   HostName=192.168.1.11
   [ndbd]
   HostName=192.168.1.12
   [ndbd]
   HostName=192.168.1.13
   [mysqld]
   HostName=192.168.1.12
   [mysqld]
   HostName=192.168.1.13

3. 启动：

   # ndb_mgmd --config-file=/var/lib/mysql-cluster/config.ini --initial
   ndb_mgmd --config-file=/var/lib/mysql-cluster/config.ini

4. 查看连接状态：
   ndb_mgm -e show

数据/sql节点配置（192.168.1.12/192.168.1.13）：

1. 创建数据文件夹：
   mkdir -p /var/lib/mysql-cluster
2. 创建配置文件：
   vim /etc/my.cnf

   [mysqld]
   skip-grant-tables
   ndbcluster
   ndb-connectstring=192.168.1.11
   default_storage_engine=ndbcluster
   [mysql_cluster]
   ndb-connectstring=192.168.1.11

3. 启动：

   # ndbd --initial
   # 启动数据节点
   ndbd
   # 启动sql节点
   systemctl start mysqld

4. 修改mysql密码：
   1. 无密码进入：
      mysql
   2. 修改密码：
      UPDATE mysql.user SET authentication_string=PASSWORD("123456") WHERE user="root";
   3. 移除 /etc/my.cnf 中的 skip-grant-tables 字段（略）
   4. 重启 mysql：
      systemctl restart mysqld
   5. 设置新密码：

      SET GLOBAL validate_password_policy = 0;
      SET GLOBAL validate_password_length = 6;  # 密码长度为 6
      ALTER USER USER() IDENTIFIED BY "123456";

   6. 测试：

      # 192.168.1.12
      CREATE DATABASE test;
      # 192.168.1.13
      SHOW DATABASES;