单机部署PXC
2024-10-19 03:36:21
在一台机器上安装PXC
Linux：centos 7 IP：192.168.30.221
PXC版本：Percona-XtraDB-Cluster-5.7.17-rel13-29.20.3.Linux.x86_64.ssl101.tar.gz
PXC节点：①192.168.30.221:3306 cluster_address：4030
②192.168.30.221:3307 cluster_address：5030
③192.168.30.221:3308 cluster_address：6030
yum -y install rsync
1、将二进制包解压，添加mysql账号，做软连接：
mkdir /opt/mysql
cd /opt/mysql
tar zxvf /data/src/Percona-XtraDB-Cluster-5.7.17-rel13-29.20.3.Linux.x86_64.ssl101.tar.gz
cd /usr/local
ln -s /opt/mysql/Percona-XtraDB-Cluster-5.7.17-rel13-29.20.3.Linux.x86_64.ssl101/ mysql
groupadd mysql
useradd -M -g mysql -s /sbin/nologin/ -d /usr/local/mysql mysql
2、新建文件夹请授权：
mkdir -p /data/mysql/mysql_3306/{data,logs,tmp}
mkdir -p /data/mysql/mysql_3306/logs/binlog
mkdir -p /data/mysql/mysql_3307/{data,logs,tmp}
mkdir -p /data/mysql/mysql_3307/logs/binlog
mkdir -p /data/mysql/mysql_3308/{data,logs,tmp}
mkdir -p /data/mysql/mysql_3308/logs/binlog
chown -R mysql:mysql /data/mysql/
chown -R mysql:mysql /usr/local/mysql
3、配置文件my.cnf
3306：
default_storage_engine=Innodb
innodb_locks_unsafe_for_binlog=1
#pxc on a single physical box
wsrep_cluster_address='gcomm://192.168.30.221:5030,192.168.30.221:6030'
wsrep_provider=/usr/local/mysql/lib/libgalera_smm.so
wsrep_sst_receive_address=192.168.30.221:4020
wsrep_node_incoming_address=192.168.30.221
wsrep_slave_threads=2
wsrep_cluster_name=pxc_sampson
wsrep_provider_options = "gmcast.listen_addr=tcp://192.168.30.221:4030;"
wsrep_sst_method=rsync
wsrep_sst_auth=sst:sampson
wsrep_node_name=node3306
innodb_autoinc_lock_mode=2
3307：
default_storage_engine=Innodb
innodb_locks_unsafe_for_binlog=1
#pxc on a single physical box
wsrep_cluster_address='gcomm://192.168.30.221:4030,192.168.30.221:6030'
wsrep_provider=/usr/local/mysql/lib/libgalera_smm.so
wsrep_sst_receive_address=192.168.30.221:5020
wsrep_node_incoming_address=192.168.30.221
wsrep_slave_threads=2
wsrep_cluster_name=pxc_sampson
wsrep_provider_options = "gmcast.listen_addr=tcp://192.168.30.221:5030;"
wsrep_sst_method=rsync
wsrep_sst_auth=sst:sampson
wsrep_node_name=node3307
innodb_autoinc_lock_mode=2
3308：
default_storage_engine=Innodb
innodb_locks_unsafe_for_binlog=1
#pxc on a single physical box
wsrep_cluster_address='gcomm://192.168.30.221:4030,192.168.30.221:5030'
wsrep_provider=/usr/local/mysql/lib/libgalera_smm.so
wsrep_sst_receive_address=192.168.30.221:6020
wsrep_node_incoming_address=192.168.30.221
wsrep_slave_threads=2
wsrep_cluster_name=pxc_sampson
wsrep_provider_options = "gmcast.listen_addr=tcp://192.168.30.221:6030;"
wsrep_sst_method=rsync
wsrep_sst_auth=sst:sampson
wsrep_node_name=node3308
innodb_autoinc_lock_mode=2
4、启动主节点：
cd /usr/local/mysql
bin/mysqld_safe --defaults-file= /data/mysql/mysql_3306/my.cnf --wsrep-new-cluster
在error.log里看到
[Note] WSREP: Shifting JOINED -> SYNCED (TO: 7)
[Note] WSREP: Waiting for SST/IST to complete.
[Note] WSREP: New cluster view: global state: f71affa6-2b55-11e7-b8db-6afbe908670d:7, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
则启动成功，登录mysql -uroot -p
主节点添加账号：
grant usage on *.* to 'pxc-monitor'@'%' identified by 'pxc-monitor';
grant all privileges on *.* to 'sst'@'%' identified by 'sampson';
5、启动剩下的两个节点：
bin/mysqld_safe --defaults-file=/data/mysql/mysql_3307/my.cnf
查看对应的error.log，能看到
[Note] WSREP: Shifting JOINER -> JOINED (TO: 7)
[Note] WSREP: Member 1.0 (node3307) synced with group.
[Note] WSREP: Shifting JOINED -> SYNCED (TO: 7)
[Note] WSREP: Synchronized with group, ready for connections
则表示node启动并加入cluster集群成功。
bin/mysqld_safe --defaults-file=/data/mysql/mysql_3308/my.cnf
6、查看节点个数：
mysql> show global status like 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| wsrep_cluster_size | 3 |
+--------------------+-------+
1 row in set (0.02 sec)
最新文章
- 前端模块化：RequireJS
- Complete the Sequence[HDU1121]
- vs2015社区版不支持installshield
- 百度ue富文本编辑器setContent方法报错初始化加载内容失败解决办法
- NDK debug模式
- python中列表 元组 字符串如何互相转换
- c# 刻度：毫米 英寸 像素转换
- Direct3D 使用质地
- 二维离散平稳小波分解swt2
- Cocos2d-x 的“HelloWorld” 深入分析
- asp.net中listview下嵌套gridview
- 解读web服务器与php的工作原理
- L1-Day1
- Building QGIS from source - step by step （开发文档翻译1）
- XAML属性赋值转换之谜（WPF XAML语法解密）
- DMA Stream/Channel Outputting via GPIOC[0..7]
- 微服务之springCloud-docker-feign(四)
- 【刷题】LOJ 6000 「网络流 24 题」搭配飞行员
- n人围圈报数,报3出圈
- Demo—cookie电商购物车