MySQL Cluster实验记录

MySQL Cluster实验记录

1、YUM方式安装MySQL Cluster

1.1 YUM方式安装MySQL Cluster

系统资源及组件规划：

节点名称	系统名称	CPU/内存	网卡	磁盘	IP地址	OS
MGMTNode	master	2C/4G	ens33	64G	192.168.0.10	CentOS7
SQLNode1	sqlnode1	2C/4G	ens33	64G	192.168.0.11	CentOS7
SQLNode2	sqlnode2	2C/4G	ens33	64G	192.168.0.12	CentOS7
DATANode1	datanode1	2C/4G	ens33	64G	192.168.0.13	CentOS7
DATANode2	datanode2	2C/4G	ens33	64G	192.168.0.14	CentOS7

安装基本软件：

yum -y install vim lrzsz wget net-tools bash-completion yum-utils

设置NTP：

yum -y install chrony

systemctl start chronyd

systemctl enable chronyd

systemctl status chronyd

chronyc sources

设置SELinux、防火墙：

systemctl stop firewalld

systemctl disable firewalld

setenforce 0

sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/g’ /etc/selinux/config

设置YUM源：

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo

yum -y install mysql80-community-release-el7-3.noarch.rpm

yum repolist enabled | grep “mysql.*-community.*”

yum-config-manager --enable mysql-cluster-8.0-community

yum repolist enabled | grep “mysql.*-community.*”

安装MySQL Cluster组件及依赖包：

管理节点：

yum -y install perl perl-Class-MethodMaker perl-DBI libaio numactl

yum -y install mysql-cluster-community-management-server
mysql-cluster-community-client

SQL节点：

yum -y install mysql-cluster-community-server

数据节点：

yum -y install mysql-cluster-community-data-node mysql-cluster-community-client

在管理节点上创建目录：

mkdir /etc/mysql-cluster

mkdir /var/lib/mysql

在管理节点上编辑MySQL Cluster配置文件：

cat > /etc/mysql-cluster/config.ini << EOF

[ndbd default]

noofreplicas=2

[ndb_mgmd]

nodeid=10

hostname=192.168.0.10

datadir=/var/lib/mysql

[mysqld]

nodeid=11

hostname=192.168.0.11

[mysqld]

nodeid=12

hostname=192.168.0.12

[ndbd]

nodeid=13

hostname=192.168.0.13

datadir=/var/lib/mysql

[ndbd]

nodeid=14

hostname=192.168.0.14

datadir=/var/lib/mysql

EOF