mysql-Cluster实现高可用

安装配置管理节点
将下载后的包上传至服务器/usr/local下

解压

tar xvf mysql-cluster-gpl-7.5.4-linux-glibc2.5-x86_64.tar.gz

将需要的文件取出

cd mysql-cluster-gpl-7.5.4-linux-glibc2.5-x86_64

cp bin/ndb_mgm* /usr/local/bin

cd /usr/local/bin

chmod +x ndb_mgm*

新建配置文件并且初始化管理节点

mkdir /var/lib/mysql-cluster

mkdir /usr/local/mysql

vi /var/lib/mysql-cluster/config.ini

下面是配置文件

[ndbd default]

Options affecting ndbd processes on all data nodes:

NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the “world” database takes up
# only about 500KB, this should be more than enough for
# this example NDB Cluster setup.
ServerPort=2202 # This the default value; however, you can use any
# port that is free for all the hosts in the cluster
# Note1: It is recommended that you do not specify the port
# number at all and simply allow the default value to be used
# instead
# Note2: The port was formerly specified using the PortNumber
# TCP parameter; this parameter is no longer available in NDB
# Cluster 7.5.

[ndb_mgmd]

Management process options:

HostName=192.168.0.10 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files

[ndbd]

Options for data node “A”:

                            # (one [ndbd] section per data node)

HostName=192.168.0.30 # Hostname or IP address
NodeId=2 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node’s data files

[ndbd]

Options for data node “B”:

HostName=192.168.0.40 # Hostname or IP address
NodeId=3 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node’s data files

[mysqld]

#SQL node options:
HostName=192.168.0.20 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)

• Hide code
  [ndbd default]
  NoOfReplicas=2
  DataMemory=512M
  IndexMemory=18M

[ndb_mgmd]
HostName=192.168.75.129
DataDir=/var/lib/mysql-cluster

[ndbd]
HostName=192.168.75.128
DataDir=/var/lib/mysql-cluster

[ndbd]
HostName=192.168.75.130
DataDir=/var/lib/mysql-cluster

[mysqld]
[mysqld]
使用配置文件初始化管理节点

#/usr/local/bin/ndb_mgmd -f /var/lib/mysql-cluster/config.ini --initial

出现MySQL Cluster Management Server mysql-5.7.16 ndb-7.5.4

然后就能使用ndbd进去管理了(如果ndbd命令不行，就使用在/usr/local/bin目录下使用ndb_mgm命令)

ndbd

ndb_mgm>show（使用show命令查看管理情况

安装配置数据和mysql节点
新增用户组mysql和用户msyql

#groupadd mysql

useradd -g mysql -s /bin/false mysql

新建文件夹并赋予权限

mkdir /var/lib/mysql-cluster

#chown root:mysql /var/lib/mysql-cluste

r

将下载后的包上传至服务器/usr/local下

解压 # tar xvf mysql-cluster-gpl-7.5.4-linux-glibc2.5-x86_64.tar.gz

创建链接方便访问

ln -s /usr/local/mysql-cluster-gpl-7.5.4-linux-glibc2.5-x86_64 /usr/local/mysql

初始化数据库(这里要注意，如果你安装的版本和我的不同，数据库初始化的命令使不同的，很多之前的版本会使用：scripts/mysql_install_db --user=mysql来初始化，这个已经被mysql在新的版本中废弃了，所以需要使用下面的命令安装，如果你需要安装别的版本请参考mysql官网的对应版本的安装命令。)

进入刚才创建的目录下

cd /usr/local/mysql 如果下方这个命令无法使用，那么就进入bin目录下使用./mysqld --initialize进行初始化，总之正常安装mysql如何初始化就如何进行安装就可以了，这里还可以设置安装数据库的data目录等参数这里就不多解释了，网上安装mysql5.7的教程很多。 # mysqld --initialize 如果初始化成功之后，系统会提示一个随机生成的数据库密码，此时需要记住这个密码，之后登录数据库需要使用这个密码！！！ 修改权限 # chown -R root . # chown -R mysql data # chgrp -R mysql . # cp support-files/mysql.server /etc/rc.d/init.d/ # chmod +x /etc/rc.d/init.d/mysql.server # chkconfig --add mysql.server

配置数据节点

vi /etc/my.cnf

[mysqld]
ndbcluster
ndb-connectstring=192.168.75.129

[mysql_cluster]
ndb-connectstring=192.168.75.129

启动和关闭
启动mysql集群。启动顺序为：管理节点→数据节点→SQL节点。

启动的命令上面都有，删去–initial即可

关闭时只需要关闭管理节点，后面的数据节点会同时被关闭，mysql就和原来一样即可

管理节点关闭命令：ndb_mgm -e shutdown