1:部署内存存储服务
1.1 问题
具体操作如下:
- 部署redis服务器
- 创建redis集群
- 配置网站服务器
- 测试配置
1.2 方案
克隆7台虚拟机配置要求如表-1所示。
表-1
1.3 步骤
实现此案例需要按照如下步骤进行。
步骤一:部署redis服务器(6台都要配置)
分别做如下配置
第1步 安装redis软件并做初始化配置
第2步 停止按照初始化配置启动的Redis服务
第3步 修改主配置文件(启用集群功能)
第4步 启动redis服务 并查看端口号
重要说明:6台Redis服务器内存里不允许有数据; Redis服务不能设置连接密码
- [root@host51 ~]# yum -y install gcc
- [root@host51 ~]# tar -xf redis-4.0.8.tar.gz
- [root@host51 ~]# cd redis-4.0.8/
- [root@host51 ~]# make && make install
- [root@host51 ~]# ./utils/install_server.sh 遇到提示就回车
- [root@host51 ~]# /etc/init.d/redis_6379 stop
- [root@host51 ~]# vim /etc/redis/6379.conf
- bind 192.168.88.51
- port 6379
- cluster-enabled yes #启用集群功能
- cluster-config-file nodes-6379.conf 保存集群信息的配置文件
- cluster-node-timeout 5000 集群中主机的连接超时时间
- [root@host51 ~]#
- [root@host51 ~]# /etc/init.d/redis_6379 start
- [root@host51 ~]# netstat -utnlp | grep redis-server
- tcp 0 0 192.168.88.51:16379 0.0.0.0:* LISTEN 4249/redis-server 1
- tcp 0 0 192.168.88.51:6379 0.0.0.0:* LISTEN 4249/redis-server 1
- [root@host52 ~]# yum -y install gcc
- [root@host52 ~]# tar -xf redis-4.0.8.tar.gz
- [root@host52 ~]# cd redis-4.0.8/
- [root@host52 ~]# make && make install
- [root@host52 ~]# ./utils/install_server.sh 遇到提示就回车
- [root@host52 ~]# /etc/init.d/redis_6379 stop
- [root@host52 ~]# sed -n '70p;93p;815p;823p;829p' /etc/redis/6379.conf
- bind 192.168.88.52
- port 6379
- cluster-enabled yes #启用集群功能
- cluster-config-file nodes-6379.conf 保存集群信息的配置文件
- cluster-node-timeout 5000 集群中主机的连接超时时间
- [root@host52 ~]#
- [root@host52 ~]# /etc/init.d/redis_6379 start
- [root@host52 ~]# netstat -utnlp | grep redis-server
- tcp 0 0 192.168.88.52:16379 0.0.0.0:* LISTEN 4249/redis-server 1
- tcp 0 0 192.168.88.52:6379 0.0.0.0:* LISTEN 4249/redis-server 1
3)配置host53主机
- [root@host53 ~]# yum -y install gcc
- [root@host53 ~]# tar -xf redis-4.0.8.tar.gz
- [root@host53 ~]# cd redis-4.0.8/
- [root@host53 ~]# make && make install
- [root@host53 ~]# ./utils/install_server.sh 遇到提示就回车
- [root@host53 ~]# /etc/init.d/redis_6379 stop
- [root@host53 ~]# sed -n '70p;93p;815p;823p;829p' /etc/redis/6379.conf
- bind 192.168.88.53
- port 6379
- cluster-enabled yes
- cluster-config-file nodes-6379.conf
- cluster-node-timeout 5000
- [root@host53 ~]#
- [root@host53 ~]# /etc/init.d/redis_6379 start
- [root@host53 ~]# netstat -utnlp | grep redis-server
- tcp 0 0 192.168.88.53:16379 0.0.0.0:* LISTEN 4249/redis-server 1
- tcp 0 0 192.168.88.53:6379 0.0.0.0:* LISTEN 4249/redis-server 1
4)配置服务器host54
- [root@host54 ~]# yum -y install gcc
- [root@host54 ~]# tar -xf redis-4.0.8.tar.gz
- [root@host54 ~]# cd redis-4.0.8/
- [root@host54 ~]# make && make install
- [root@host54 ~]# ./utils/install_server.sh 遇到提示就回车
- [root@host54 ~]# /etc/init.d/redis_6379 stop
- [root@host54 ~]# sed -n '70p;93p;815p;823p;829p' /etc/redis/6379.conf
- bind 192.168.88.54
- port 6379
- cluster-enabled yes
- cluster-config-file nodes-6379.conf
- cluster-node-timeout 5000
- [root@host54 ~]#
- [root@host54 ~]# /etc/init.d/redis_6379 start
- [root@host54 ~]# netstat -utnlp | grep redis-server
- tcp 0 0 192.168.88.54:16379 0.0.0.0:* LISTEN 4249/redis-server 1
- tcp 0 0 192.168.88.54:6379 0.0.0.0:* LISTEN 4249/redis-server 1
5)配置服务器host55
- [root@host55 ~]# yum -y install gcc
- [root@host55 ~]# tar -xf redis-4.0.8.tar.gz
- [root@host55 ~]# cd redis-4.0.8/
- [root@host55 ~]# make && make install
- [root@host55 ~]# ./utils/install_server.sh 遇到提示就回车
- [root@host55 ~]# /etc/init.d/redis_6379 stop
- [root@host55 ~]# sed -n '70p;93p;815p;823p;829p' /etc/redis/6379.conf
- bind 192.168.88.55
- port 6379
- cluster-enabled yes
- cluster-config-file nodes-6379.conf
- cluster-node-timeout 5000
- [root@host55 ~]#
- [root@host55 ~]# /etc/init.d/redis_6379 start
- [root@host55 ~]# netstat -utnlp | grep redis-server
- tcp 0 0 192.168.88.55:16379 0.0.0.0:* LISTEN 4249/redis-server 1
- tcp 0 0 192.168.88.55:6379 0.0.0.0:* LISTEN 4249/redis-server 1
6)配置服务器host56
- [root@host56 ~]# yum -y install gcc
- [root@host56 ~]# tar -xf redis-4.0.8.tar.gz
- [root@host56 ~]# cd redis-4.0.8/
- [root@host56 ~]# make && make install
- [root@host56 ~]# ./utils/install_server.sh 遇到提示就回车
- [root@host56 ~]# /etc/init.d/redis_6379 stop
- [root@host56 ~]# sed -n '70p;93p;815p;823p;829p' /etc/redis/6379.conf
- bind 192.168.88.56
- port 6379
- cluster-enabled yes
- cluster-config-file nodes-6379.conf
- cluster-node-timeout 5000
- [root@host56 ~]#
- [root@host56 ~]# /etc/init.d/redis_6379 start
- [root@host56 ~]# netstat -utnlp | grep redis-server
- tcp 0 0 192.168.88.56:16379 0.0.0.0:* LISTEN 4249/redis-server 1
- tcp 0 0 192.168.88.56:6379 0.0.0.0:* LISTEN 4249/redis-server 1
步骤二:创建管理集群脚本
第一步:准备ruby脚本的运行环境
第二步:创建脚本
第三步:查看脚本帮助信息
- ]#yum -y install rubygems ruby
- ]#gem install redis-3.2.1.gem
- ]#mkdir /root/bin //创建命令检索目录
- ]#tar -xf redis-4.0.8.tar.gz
- ]#cp redis-4.0.8/src/redis-trib.rb /root/bin/
- ]#chmod +x /root/bin/redis-trib.rb //设置执行权限
- ]#redis-trib.rb help //看到帮助信息为成功
步骤三:创建集群
创建集群的命令格式
- [root@mgm57 ~]# redis-trib.rb create --replicas 数字 ip地址:端口 ip地址:端口 ip地址:端口 ....
说明,创建集群时,会把前3台服务器 配置为主服务器,剩下的其他主机全做从服务器 --replicas 指定每个主服务器有几台从服务器
- [root@mgm57 ~]# redis-trib.rb create --replicas 1 192.168.88.51:6379 192.168.88.52:6379 192.168.88.53:6379 192.168.88.54:6379 192.168.88.55:6379 192.168.88.56:6379
- >>> Creating cluster
- >>> Performing hash slots allocation on 6 nodes...
- Using 3 masters:
- 192.168.88.51:6379
- 192.168.88.52:6379
- 192.168.88.53:6379
- Adding replica 192.168.88.55:6379 to 192.168.88.51:6379
- Adding replica 192.168.88.56:6379 to 192.168.88.52:6379
- Adding replica 192.168.88.54:6379 to 192.168.88.53:6379
- M: 0eb3b7aa0493a19189cba35b0c658202cc20884b 192.168.88.51:6379
- slots:0-5460 (5461 slots) master
- M: a9cb8ccd31bf3eb70433c00906c9f1a99b5e8441 192.168.88.52:6379
- slots:5461-10922 (5462 slots) master
- M: f2c1bdb78d8d224c3666fa6440bdf80ba563c581 192.168.88.53:6379
- slots:10923-16383 (5461 slots) master
- S: bdba77868965371680fa825badff59bf8ef95a81 192.168.88.54:6379
- replicates f2c1bdb78d8d224c3666fa6440bdf80ba563c581
- S: 11510f42bfd9cf667bab5f31c01476d94984200a 192.168.88.55:6379
- replicates 0eb3b7aa0493a19189cba35b0c658202cc20884b
- S: fe572ce003ee634c52adc4b42d92d15f847937d7 192.168.88.56:6379
- replicates a9cb8ccd31bf3eb70433c00906c9f1a99b5e8441
- Can I set the above configuration? (type 'yes' to accept): yes 同意
- ....
- ....
- [OK] All nodes agree about slots configuration.
- >>> Check for open slots...
- >>> Check slots coverage...
- [OK] All 16384 slots covered. 创建成功的提示
- [root@mgm57 ~]#
说明:创建集群失败:
1) 如果所有的Redis服务都启用的集群功能 内存里也没有数据 也没设置连接密码 还是创建失败
2)可能是物理内存不足 导致创建失败 把没用的虚拟机删除
3) 在集群中所有主机执行清除集群信息的命令 > cluster reset
步骤四:查看集群信息
连接集群中的任意主机都可以查看集群信息
1)查看集群统计信息
- [root@mgm57 ~]# redis-trib.rb info 192.168.88.56:6379
- 192.168.88.53:6379 (f2c1bdb7...) -> 0 keys | 5461 slots | 1 slaves.
- 192.168.88.51:6379 (0eb3b7aa...) -> 0 keys | 5461 slots | 1 slaves.
- 192.168.88.52:6379 (a9cb8ccd...) -> 0 keys | 5462 slots | 1 slaves.
- [OK] 0 keys in 3 masters.
- 0.00 keys per slot on average.
- [root@mgm57 ~]#
2)查看集群详细信息
- [root@mgm57 ~]# redis-trib.rb check 192.168.88.51:6379
- >>> Performing Cluster Check (using node 192.168.88.51:6379)
- M: 0eb3b7aa0493a19189cba35b0c658202cc20884b 192.168.88.51:6379
- slots:0-5460 (5461 slots) master
- 1 additional replica(s)
- M: f2c1bdb78d8d224c3666fa6440bdf80ba563c581 192.168.88.53:6379
- slots:10923-16383 (5461 slots) master
- 1 additional replica(s)
- S: bdba77868965371680fa825badff59bf8ef95a81 192.168.88.54:6379
- slots: (0 slots) slave
- replicates f2c1bdb78d8d224c3666fa6440bdf80ba563c581
- M: a9cb8ccd31bf3eb70433c00906c9f1a99b5e8441 192.168.88.52:6379
- slots:5461-10922 (5462 slots) master
- 1 additional replica(s)
- S: 11510f42bfd9cf667bab5f31c01476d94984200a 192.168.88.55:6379
- slots: (0 slots) slave
- replicates 0eb3b7aa0493a19189cba35b0c658202cc20884b
- S: fe572ce003ee634c52adc4b42d92d15f847937d7 192.168.88.56:6379
- slots: (0 slots) slave
- replicates a9cb8ccd31bf3eb70433c00906c9f1a99b5e8441
- [OK] All nodes agree about slots configuration.
- >>> Check for open slots...
- >>> Check slots coverage...
- [OK] All 16384 slots covered.
- [root@mgm57 ~]#
步骤五:配置网站服务器
- [root@web33 ~]# tar -xf redis-cluster-4.3.0.tgz //解压
- [root@web33 ~]# cd redis-4.3.0/ //进入源码目录
- [root@web33 redis-4.3.0]# phpize //创建configure命令及配置信息文件/usr/bin/php-config
- Configuring for:
- PHP Api Version: 20100412
- Zend Module Api No: 20100525
- Zend Extension Api No: 220100525
- [root@web33 redis-4.3.0]#
- [root@web33 redis-4.3.0]# ./configure --with-php-config=/usr/bin/php-config 配置
- ……
- ……
- configure: creating ./config.status
- config.status: creating config.h
- config.status: config.h is unchanged
- config.status: executing libtool commands
- [root@web33 redis-4.3.0]#
- [root@web33 redis-4.3.0]# make //编译
- ……
- ……
- Build complete.
- Don't forget to run 'make test'.
- [root@web33 redis-4.3.0]#
- [root@web33 redis-4.3.0]# make install //安装
- Installing shared extensions: /usr/lib64/php/modules/ //提示模块安装目录
- [root@web33 redis-4.3.0]#
- [root@web33 redis-4.3.0]# ls /usr/lib64/php/modules/ //查看目录列表
- curl.so fileinfo.so json.so mysqli.so mysql.so pdo_mysql.so pdo.so pdo_sqlite.so phar.so redis.so sqlite3.so zip.so
- [root@web33 redis-4.3.0]#
2)修改配置文件,调用模块
- [root@web33 redis-4.3.0]# vim /etc/php.ini
- 728 extension_dir = "/usr/lib64/php/modules/" //模块目录
- 730 extension = "redis.so" //模块名
- :wq
- [root@web33 redis-4.3.0]# systemctl restart php-fpm //重启php-fpm服务
- [root@web33 redis-4.3.0]# php -m | grep -i redis //查看模块
- redis
- [root@web33 redis-4.3.0]#
步骤六:测试配置
1)创建连接集群PHP脚本
- //存储数据脚本
- Web33~ ]# vim /usr/local/nginx/html/set_data.php
- <?php
- $redis_list = ['192.168.88.51:6379','192.168.88.52:6379','192.168.88.53:6379','192.168.88.54:6379','192.168.88.55:6379','192.168.88.56:6379']; //定义redis服务器列表
- $client = new RedisCluster(NUll,$redis_list); //定义连接redis服务器命令
- $client->set("i","tarenaA "); //存储变量i
- $client->set("j","tarenaB "); //存储变量j
- $client->set("k","tarenaC "); //存储变量k
- echo "save data ok";
- ?>
- :wq
- //获取数据脚本
- Web33 ~]# vim /usr/local/nginx/html/get_data.php
- <?php
- $redis_list = ['192.168.88.51:6379','192.168.88.52:6379','192.168.88.53:6379','192.168.88.54:6379','192.168.88.55:6379','192.168.88.56:6379']; //定义redis服务器列表
- $client = new RedisCluster(NUll,$redis_list); //定义连接redis服务器命令
- echo $client->get("i"); //获取变量i 的数据
- echo $client->get("j"); //获取变量j 的数据
- echo $client->get("k"); //获取变量k 的数据
- ?>
- :wq
2)访问网站执行脚本(在任意主机访问网站服务器都可以)
- ]# curl http://192.168.4.33/set_data.php
- ]# curl http://192.168.4.33/get_data.php
3)命令行连接任意一台redis服务器查看数据(在任意主机连接redis服务器都可以)
- ]# redis-cli -c -h 192.168.88.51 -p 6379
- 192.168.88.51:6379> keys *
- 1) i
- 192.168.88.51:6379> exit
- ]# redis-cli -c -h 192.168.88.52 -p 6379
- 192.168.88.52:6379> keys *
- 1) j
- 192.168.88.52:6379> exit
- ]# redis-cli -c -h 192.168.88.53 -p 6379
- 192.168.88.52:6379> keys *
- 1) k
- 192.168.88.52:6379> exit
2 案例2:环境准备
2.1 问题
要求如下:
- 部署MySQL服务
- 配置从服务器
2.2 方案
创建1台新的虚拟机,配置ip地址为192.168.88.66,并配置为192.168.88.11的从数据库服务器。
2.3 步骤
实现此案例需要按照如下步骤进行。
步骤一:部署MySQL服务
1)安装软件
- [root@pxcnode66 ~]# tar -xf mysql-5.7.17.tar //解包
- [root@pxcnode66 ~]# ls *.rpm //查看软件列表
- mysql-community-client-5.7.17-1.el7.x86_64.rpm
- mysql-community-common-5.7.17-1.el7.x86_64.rpm
- mysql-community-devel-5.7.17-1.el7.x86_64.rpm
- mysql-community-embedded-5.7.17-1.el7.x86_64.rpm
- mysql-community-embedded-compat-5.7.17-1.el7.x86_64.rpm
- mysql-community-embedded-devel-5.7.17-1.el7.x86_64.rpm
- mysql-community-libs-5.7.17-1.el7.x86_64.rpm
- mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm
- mysql-community-minimal-debuginfo-5.7.17-1.el7.x86_64.rpm
- mysql-community-server-5.7.17-1.el7.x86_64.rpm
- mysql-community-test-5.7.17-1.el7.x86_64.rpm
- [root@pxcnode66 ~]#
- [root@pxcnode66 ~]# yum -y install mysql-community-*.rpm //安装软件
- 已加载插件:fastestmirror
- 正在检查 mysql-community-client-5.7.17-1.el7.x86_64.rpm: mysql-community-client-5.7.17-1.el7.x86_64
- mysql-community-client-5.7.17-1.el7.x86_64.rpm 将被安装
- ……
- ……
- 已安装:
- mysql-community-client.x86_64 0:5.7.17-1.el7 mysql-community-common.x86_64 0:5.7.17-1.el7
- mysql-community-devel.x86_64 0:5.7.17-1.el7 mysql-community-embedded.x86_64 0:5.7.17-1.el7
- mysql-community-embedded-compat.x86_64 0:5.7.17-1.el7 mysql-community-embedded-devel.x86_64 0:5.7.17-1.el7
- mysql-community-libs.x86_64 0:5.7.17-1.el7 mysql-community-libs-compat.x86_64 0:5.7.17-1.el7
- mysql-community-minimal-debuginfo.x86_64 0:5.7.17-1.el7 mysql-community-server.x86_64 0:5.7.17-1.el7
- mysql-community-test.x86_64 0:5.7.17-1.el7
- 作为依赖被安装:
- perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-JSON.noarch 0:2.59-2.el7
- 完毕!
- [root@pxcnode66 ~]#
2)启动服务
- [root@pxcnode66 ~]# systemctl start mysqld
- [root@pxcnode66 ~]# systemctl enable mysqld //设置服务开机运行
- [root@pxcnode66 ~]# netstat -utnlp | grep :3306 //查看端口
- tcp6 0 0 :::3306 :::* LISTEN 1531/mysqld
3)管理员登录
- [root@pxcnode66 ~]# grep password /var/log/mysqld.log //查看初始密码
- 2019-07-05T01:56:51.895852Z 1 [Note] A temporary password is generated for root@localhost: bB0*uCmu:.Kj
- [root@pxcnode66 ~]# mysql -uroot -p'bB0*uCmu:.Kj' //初始密码登录
- mysql>
- mysql> alter user root@"localhost" identified by "123qqq...A"; //修改登录密码
- Query OK, 0 rows affected (0.01 sec)
- mysql>
- mysql> exit //断开连接
- Bye
- [root@pxcnode66 ~]# mysql -uroot -p123qqq…A //新密码登录
- mysql> show databases; //查看数据库
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | performance_schema |
- | sys |
- +--------------------+
- 4 rows in set (0.00 sec)
- Mysql>
步骤二:配置从服务器
在192.168.88.66主机做如下配置
1)修改服务主配置文件
- [root@pxcnode66 ~]# vim /etc/my.cnf
- [mysqld]
- server_id=66 //指定server_id
- :wq
- [root@pxcnode66 ~]# systemctl restart mysqld //重启服务
在MySQL11 主机 做完全备份
- [root@mysql11 ~]# rpm -ivh libev-4.15-1.el6.rf.x86_64.rpm //安装依赖软件
- //安装在线热备软件
- [root@mysql11 ~]# yum -y install percona-xtrabackup-24-2.4.7-1.el7.x86_64.rpm
- //备份所有数据,并记录备份数据对应的binlog日志名
- [root@mysql11 ~]# innobackupex -uroot -pa123qqq…A /allbak –no-timestamp
- //把备份文件发送给pxcnode66主机
- [root@mysql11 ~]# scp -r /allbak root@192.168.88.66:/root/
在pxcnode66 主机 恢复数据
- //安装依赖软件
- [root@pxcnode66 ~]# rpm -ivh libev-4.15-1.el6.rf.x86_64.rpm
- //安装在线热备软件
- [root@pxcnode66 ~]# yum -y install percona-xtrabackup-24-2.4.7-1.el7.x86_64.rpm
- [root@pxcnode66 ~]# systemctl stop mysqld //停止服务
- [root@pxcnode66 ~]# rm -rf /var/lib/mysql/* //清空数据库目录
- [root@pxcnode66 ~]# innobackupex --apply-log /root/allbak/ //准备恢复数据
- [root@pxcnode66 ~]# innobackupex --copy-back /root/allbak/ //恢复数据
- [root@pxcnode66 ~]# chown -R mysql:mysql /var/lib/mysql //修改所有者
- [root@pxcnode66 ~]# systemctl start mysqld //启动服务
3)指定主服务器
- //查binlog日志
- [root@pxcnode66 ~]# grep master11 /root/allbak/xtrabackup_info
- binlog_pos = filename 'master11.000001', position '7700'
- //管理员登录指定主服务器信息
- [root@pxcnode66 ~]# mysql -uroot -p123qqq…A
- mysql> change master to
- master_host="192.168.88.11" //主服务器ip地址
- master_user="repluser", //主服务器授权用户
- master_password="123qqq...A", //授权密码
- master_log_file="master11.000001", //binlog日志名
- master_log_pos=7700; //日志偏移量
- Query OK, 0 rows affected, 2 warnings (0.31 sec)
- mysql> start slave ; //启动slave 程序
- Query OK, 0 rows affected (0.09 sec)
- mysql> exit //断开连接
- Bye
- //查看主服务器地址
- [root@pxcnode66 ~]# mysql -uroot -p123qqq…A -e ‘show slave status \G’ | grep -i 192.168.4.11
- mysql: [Warning] Using a password on the command line interface can be insecure.
- Master_Host: 192.168.4.11 //主服务器ip地址
- //查看状态信息
- [root@pxcnode66 ~]# mysql -uroot -p123qqq…A -e ‘show slave status \G’ | grep -i "yes"
- mysql: [Warning] Using a password on the command line interface can be insecure.
- Slave_IO_Running: Yes //IO线程正常
- Slave_SQL_Running: Yes //SQL线程正常
- [root@pxcnode66 ~]#
3 案例3:创建PXC集群
3.1 问题
要求如下:
- 1)配置第1台PXC服务器
- 2)配置第2台PXC服务器
- 3)配置第3台PXC服务器
- 4)公共配置
- 5)测试配置
步骤一:配置第1台PXC服务器(192.168.88.66)
1)卸载mysqld服务软件
- [root@pxcnode66 ~]# systemctl stop mysqld //停止服务
- //查看安装的MySQL服务软件
- [root@pxnode66 ~]# rpm -qa | grep -i mysql
- mysql-community-server-5.7.17-1.el7.x86_64
- mysql-community-embedded-compat-5.7.17-1.el7.x86_64
- mysql-community-common-5.7.17-1.el7.x86_64
- mysql-community-client-5.7.17-1.el7.x86_64
- mysql-community-devel-5.7.17-1.el7.x86_64
- mysql-community-test-5.7.17-1.el7.x86_64
- mysql-community-libs-compat-5.7.17-1.el7.x86_64
- mysql-community-minimal-debuginfo-5.7.17-1.el7.x86_64
- perl-DBD-MySQL-4.023-6.el7.x86_64
- mysql-community-libs-5.7.17-1.el7.x86_64
- mysql-community-embedded-5.7.17-1.el7.x86_64
- mysql-community-embedded-devel-5.7.17-1.el7.x86_64
- [root@pxcnode66 ~]#
- //卸载所有的MySQL服务软件
- [root@pxcnode66 ~]# rpm -e --nodeps mysql-community-server mysql-community-embedded-compat mysql-community-common mysql-community-client mysql-community-devel
- mysql-community-test mysql-community-libs-compat mysql-community-minimal-debuginfo mysql-community-libs mysql-community-embedded mysql-community-embedded-devel
- 警告:/etc/my.cnf 已另存为 /etc/my.cnf.rpmsave
- [root@pxcnode66 ~]#
2)安装PXC软件
- //进软件目录
- [root@pxcnode66 ~]# cd PXC
- //安装依赖
- [root@pxcnode66 PXC]# yum -y install libev-4.15-1.el6.rf.x86_64.rpm \
- percona-xtrabackup-24-2.4.13-1.el7.x86_64.rpm qpress-1.1-14.11.x86_64.rpm \
- qpress-1.1-14.11.x86_64.rpm
- //解压软件包
- [root@pxcnode66 PXC]# tar -xf Percona-XtraDB-Cluster-5.7.25-31.35-r463-el7-x86_64-bundle.tar
- Percona-XtraDB-Cluster-57-5.7.25-31.35.1.el7.x86_64.rpm
- Percona-XtraDB-Cluster-57-debuginfo-5.7.25-31.35.1.el7.x86_64.rpm
- Percona-XtraDB-Cluster-client-57-5.7.25-31.35.1.el7.x86_64.rpm
- Percona-XtraDB-Cluster-devel-57-5.7.25-31.35.1.el7.x86_64.rpm
- Percona-XtraDB-Cluster-full-57-5.7.25-31.35.1.el7.x86_64.rpm
- Percona-XtraDB-Cluster-garbd-57-5.7.25-31.35.1.el7.x86_64.rpm
- Percona-XtraDB-Cluster-server-57-5.7.25-31.35.1.el7.x86_64.rpm
- Percona-XtraDB-Cluster-shared-57-5.7.25-31.35.1.el7.x86_64.rpm
- Percona-XtraDB-Cluster-shared-compat-57-5.7.25-31.35.1.el7.x86_64.rpm
- Percona-XtraDB-Cluster-test-57-5.7.25-31.35.1.el7.x86_64.rpm
- [root@pxcnode66 PXC]#
- //安装软件
- [root@pxcnode66 PXC]# yum -y install Percona-XtraDB-Cluster-*.rpm
- 已安装:
- Percona-XtraDB-Cluster-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-57-debuginfo.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-client-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-devel-57.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-full-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-garbd-57.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-server-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-shared-57.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-shared-compat-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-test-57.x86_64 0:5.7.25-31.35.1.el7
- 作为依赖被安装:
- keyutils-libs-devel.x86_64 0:1.5.8-3.el7 krb5-devel.x86_64 0:1.15.1-18.el7 libcom_err-devel.x86_64 0:1.42.9-11.el7 libkadm5.x86_64 0:1.15.1-18.el7
- libselinux-devel.x86_64 0:2.5-12.el7 libsepol-devel.x86_64 0:2.5-8.1.el7 libverto-devel.x86_64 0:0.2.5-4.el7 openssl-devel.x86_64 1:1.0.2k-12.el7
- pcre-devel.x86_64 0:8.32-17.el7 perl-Env.noarch 0:1.04-2.el7 perl-Test-Harness.noarch 0:3.28-3.el7 perl-Test-Simple.noarch 0:0.98-243.el7
- zlib-devel.x86_64 0:1.2.7-17.el7
- 完毕!
- [root@pxcnode66 PXC]#
3)、修改配置文件
- //修改数据库服务配置文件
- [root@pxcnode66 PXC]# vim /etc/percona-xtradb-cluster.conf.d/mysqld.cnf
- [mysqld]
- server-id=66 #指定server_id
- :wq
- [root@pxcnode66 PXC]#
- //修改集群服务配置文件
- [root@pxcnode66 PXC]# vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf
- wsrep_cluster_address=gcomm:// #不需要写ip地址
- wsrep_node_address=192.168.88.66 #指定本机Ip地址
- wsrep_cluster_name=pxc-cluster #指定集群名称(另外2台的集群名称要于此相同)
- wsrep_node_name=pxcnode66 #指定本机主机名
- wsrep_sst_auth="sstuser:123qqq…A" #数据全量同步授权用户及密码
- :wq
- [root@pxcnode66 PXC]#
4)启动mysql服务
- [root@pxcnode66 PXC]# systemctl start mysql //启动服务
- [root@pxcnode66 PXC]# netstat -utnlp | grep :3306 //查看MySQL服务端口
- tcp6 0 0 :::3306 :::* LISTEN 24482/mysqld
- [root@pxcnode66 PXC]# netstat -utnlp | grep :4567 //查看集群通信端口
- tcp 0 0 0.0.0.0:4567 0.0.0.0:* LISTEN 24472/mysqld
- [root@pxcnode66 PXC]# systemctl enable mysql //设置服务开机运行
- [root@pxcnode66 PXC]#
5)数据库管理员登录、用户授权、查看状态信息
- [root@pxcnode66 PXC]# mysql -uroot -p123qqq…A //管理员登录
- //用户授权
- mysql> grant all on *.* to sstuser@"localhost" identified by "123qqq...A";
- Query OK, 0 rows affected, 1 warning (0.10 sec)
- //查看集群状态信息
- mysql> show status like "%wsrep%";
- | wsrep_incoming_addresses | 192.168.88.66:3306 |
- | wsrep_cluster_weight | 1 |
- | wsrep_desync_count | 0 |
- | wsrep_evs_delayed | |
- | wsrep_evs_evict_list | |
- | wsrep_evs_repl_latency | 0/0/0/0/0 |
- | wsrep_evs_state | OPERATIONAL |
- | wsrep_gcomm_uuid | 73809cc5-cf00-11e9-aac3-b223959fecdf |
- | wsrep_cluster_conf_id | 1 |
- | wsrep_cluster_size | 1 |
- | wsrep_cluster_state_uuid | 73848b1a-cf00-11e9-9058-36c1ac1e1359 |
- | wsrep_cluster_status | Primary |
- | wsrep_connected | ON |
- | wsrep_local_bf_aborts | 0 |
- | wsrep_local_index | 0 |
- | wsrep_provider_name | Galera |
- | wsrep_provider_vendor | Codership Oy <info@codership.com> |
- | wsrep_provider_version | 3.35(rddf9876) |
- | wsrep_ready | ON |
- +----------------------------------+--------------------------------------+
- 71 rows in set (0.00 sec)
- mysql> exit ;
- [root@pxcnode66 ~]#
- //查看状态信息依然是192.168.88.11的从服务器
- [root@pxcnode66 ~]# mysql -uroot -p123qqq…A -e ‘show slave status \G’ | grep -i "yes"
- mysql: [Warning] Using a password on the command line interface can be insecure.
- Slave_IO_Running: Yes //IO线程正常
- Slave_SQL_Running: Yes //SQL线程正常
- [root@pxcnode66 ~]#
步骤二:配置第2台PXC服务器(192.168.88.10)
1)安装PXC软件
- [root@pxcnode10 ~]# cd PXC //进软件目录
- //安装依赖
- [root@pxcnode10 PXC]# yum -y install libev-4.15-1.el6.rf.x86_64.rpm \
- percona-xtrabackup-24-2.4.13-1.el7.x86_64.rpm \
- qpress-1.1-14.11.x86_64.rpm
- //解压PXC软件包
- [root@pxcnode10 PXC]# tar -xf Percona-XtraDB-Cluster-5.7.25-31.35-r463-el7-x86_64-bundle.tar
- //安装软件
- [root@pxcnode10 PXC]# yum -y install Percona-XtraDB-Cluster-*.rpm
- 已安装:
- Percona-XtraDB-Cluster-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-57-debuginfo.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-client-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-devel-57.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-full-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-garbd-57.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-server-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-shared-57.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-shared-compat-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-test-57.x86_64 0:5.7.25-31.35.1.el7
- 作为依赖被安装:
- keyutils-libs-devel.x86_64 0:1.5.8-3.el7 krb5-devel.x86_64 0:1.15.1-18.el7 libcom_err-devel.x86_64 0:1.42.9-11.el7 libkadm5.x86_64 0:1.15.1-18.el7
- libselinux-devel.x86_64 0:2.5-12.el7 libsepol-devel.x86_64 0:2.5-8.1.el7 libverto-devel.x86_64 0:0.2.5-4.el7 openssl-devel.x86_64 1:1.0.2k-12.el7
- pcre-devel.x86_64 0:8.32-17.el7 perl-Env.noarch 0:1.04-2.el7 perl-Test-Harness.noarch 0:3.28-3.el7 perl-Test-Simple.noarch 0:0.98-243.el7
- zlib-devel.x86_64 0:1.2.7-17.el7
- 完毕!
- [root@pxcnode10 PXC]#
2)修改配置文件
- //修改数据库服务配置
- [root@pxcnode10 PXC]# vim /etc/percona-xtradb-cluster.conf.d/mysqld.cnf
- [mysqld]
- server-id=10 //指定server_id
- :wq
- //修改集群服务配置文件
- [root@pxcnode10 PXC]# vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf
- wsrep_cluster_address=gcomm://192.168.88.66 //集群成员列表
- wsrep_node_address=192.168.88.10 //指定本机Ip地址
- wsrep_cluster_name=pxc-cluster //指定集群名称(要与66主机相同)
- wsrep_node_name=pxcnode10 //指定本机主机名
- wsrep_sst_auth="sstuser:123qqq…A" //数据全量同步授权用户及密码
- :wq
- [root@pxcnode10 PXC]#
3)启动mysql服务
- [root@pxcnode10 PXC]# systemctl start mysql //启动服务
- [root@pxcnode10 PXC]# systemctl enable mysql //服务开机运行
- [root@pxcnode10 PXC]# netstat -utnlp | grep :3306 //查看MySQL服务端口
- tcp6 0 0 :::3306 :::* LISTEN 24482/mysqld
- [root@pxcnode10 PXC]# netstat -utnlp | grep :4567 //查看集群端口
- tcp6 0 0 :::4567 :::* LISTEN 24489/mysqld
- [root@pxcnode10 PXC]#
- mysql> show status like "%wsrep%"; //查看集群状态信息
- | wsrep_incoming_addresses | 192.168.88.66:3306,192.168.88.10:3306|
- | wsrep_cluster_weight | 1 |
- | wsrep_desync_count | 0 |
- | wsrep_evs_delayed | |
- | wsrep_evs_evict_list | |
- | wsrep_evs_repl_latency | 0/0/0/0/0 |
- | wsrep_evs_state | OPERATIONAL |
- | wsrep_gcomm_uuid | 73809cc5-cf00-11e9-aac3-b223959fecdf |
- | wsrep_cluster_conf_id | 1 |
- | wsrep_cluster_size | 1 |
- | wsrep_cluster_state_uuid | 73848b1a-cf00-11e9-9058-36c1ac1e1359 |
- | wsrep_cluster_status | Primary |
- | wsrep_connected | ON |
- | wsrep_local_bf_aborts | 0 |
- | wsrep_local_index | 0 |
- | wsrep_provider_name | Galera |
- | wsrep_provider_vendor | Codership Oy <info@codership.com> |
- | wsrep_provider_version | 3.35(rddf9876) |
- | wsrep_ready | ON |
- +----------------------------------+--------------------------------------+
- 71 rows in set (0.00 sec)
- mysql> exit ;
- [root@pxcnode10 ~]#
步骤三:配置第3台PXC服务器(192.168.88.88)
1)安装PXC软件
- [root@pxcnode88 ~]# cd PXC //进软件目录
- //安装依赖
- [root@pxcnode88 PXC]# yum -y install qpress-1.1-14.11.x86_64.rpm \
- percona-xtrabackup-24-2.4.13-1.el7.x86_64.rpm \
- qpress-1.1-14.11.x86_64.rpm
- //解压PXC软件包
- [root@pxcnode88 PXC]# tar -xf Percona-XtraDB-Cluster-5.7.25-31.35-r463-el7-x86_64-bundle.tar
- [root@pxcnode88 PXC]# yum -y install Percona-XtraDB-Cluster-*.rpm //安装软件
- 已安装:
- Percona-XtraDB-Cluster-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-57-debuginfo.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-client-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-devel-57.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-full-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-garbd-57.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-server-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-shared-57.x86_64 0:5.7.25-31.35.1.el7
- Percona-XtraDB-Cluster-shared-compat-57.x86_64 0:5.7.25-31.35.1.el7 Percona-XtraDB-Cluster-test-57.x86_64 0:5.7.25-31.35.1.el7
- 作为依赖被安装:
- keyutils-libs-devel.x86_64 0:1.5.8-3.el7 krb5-devel.x86_64 0:1.15.1-18.el7 libcom_err-devel.x86_64 0:1.42.9-11.el7 libkadm5.x86_64 0:1.15.1-18.el7
- libselinux-devel.x86_64 0:2.5-12.el7 libsepol-devel.x86_64 0:2.5-8.1.el7 libverto-devel.x86_64 0:0.2.5-4.el7 openssl-devel.x86_64 1:1.0.2k-12.el7
- pcre-devel.x86_64 0:8.32-17.el7 perl-Env.noarch 0:1.04-2.el7 perl-Test-Harness.noarch 0:3.28-3.el7 perl-Test-Simple.noarch 0:0.98-243.el7
- zlib-devel.x86_64 0:1.2.7-17.el7
- 完毕!
- [root@pxcnode88 PXC]#
2)修改配置文件
- [root@pxcnode88 PXC]# vim /etc/percona-xtradb-cluster.conf.d/mysqld.cnf //修改数据库服务配置
- [mysqld]
- server-id=88 //指定server_id
- :wq
- [root@pxcnode88 PXC]# vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf //修改集群服务配置文件
- wsrep_cluster_address=gcomm://192.168.88.66 //集群成员ip地址
- wsrep_node_address=192.168.88.88 //指定本机Ip地址
- wsrep_cluster_name=pxc-cluster //指定集群名称
- wsrep_node_name=pxcnode88 //指定本机主机名
- wsrep_sst_auth="sstuser:123qqq...A" //数据全量同步授权用户及密码
- :wq
- [root@pxcnode88 PXC]#
3)启动mysql服务
- [root@pxcnode88 PXC]# systemctl start mysql //启动服务
- [root@pxcnode88 PXC]# systemctl enable mysql //服务开机运行
- [root@pxcnode88 PXC]# netstat -utnlp | grep :3306 //查看MySQL服务端口
- tcp6 0 0 :::3306 :::* LISTEN 24472/mysqld
- [root@pxcnode88 PXC]# netstat -utnlp | grep :4567 //查看集群端口
- tcp6 0 0 :::4567 :::* LISTEN 24486/mysqld
- [root@pxcnode88 PXC]#
步骤四:公共配置
1)修改192.168.88.88主机的集群配置文件
- [root@pxcnode88 ~]# vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf
- wsrep_cluster_address=gcomm://192.168.88.66,192.168.88.10,192.168.88.88 //指定集群成员列表
- :wq
- [root@pxcnode88 ~]#
2)修改192.168.88.10主机的集群配置文件
- [root@pxcnode10 ~]# vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf
- wsrep_cluster_address=gcomm:// 192.168.88.66,192.168.88.10,192.168.88.88 //指定集群成员列表
- :wq
- [root@pxcnode10 ~]#
3)修改192.168.88.66主机的集群配置文件
- [root@pxcnode66 ~]# vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf
- wsrep_cluster_address=gcomm://192.168.88.66,192.168.88.10,192.168.88.88 //指定集群成员列表
- :wq
- [root@pxcnode66 ~]#
步骤五:测试配置
1)在主数据库服务器给表添加主键
- //访问pxc集群存储数据需要表中有主键字段
- [root@mysql11 ~]# mysql -uroot -p123qqq…A
- mysql> alter table gamedb.user add id int primary key auto_increment first;
- mysql> exit;
2)存储数据:在网站服务器连接PXC集群主机存储数据
- [root@web33 ~]# mysql -h192.168.88.66 -uyaya -p123qqq…A
- Mysql> insert into gamedb.user values ("pljA");
- Mysql> exit ;
- [root@web33 ~]# mysql -h192.168.88.10 -uyaya -p123qqq…A
- Mysql> insert into gamedb.user values ("pljB");
- Mysql> exit ;
- [root@web33 ~]# mysql -h192.168.88.88 -uyaya -p123qqq…A
- Mysql> insert into gamedb.user values ("pljC");
- Mysql> exit ;
4 案例4:部署LB集群
4.1 问题
配置步骤如下:
- 安装软件
- 修改配置文件
- 启动服务
- 测试配置
4.2 方案
创建1台新虚拟机,配置ip地址 eth0 192.168.88.99 主机名 haproxy99 ;运行haproxy服务 接受客户端访问数据库的连接请求,把请求平均分发给3台PXC集群主机。
4.3 步骤
实现此案例需要按照如下步骤进行。
步骤一:安装软件
- //在haproxy99主机上安装haproxy软件
- [root@haproxy99 ~]# yum -y install haproxy
- ……
- 已安装:
- haproxy.x86_64 0:1.5.18-7.el7
- 完毕!
- [root@haproxy99 ~]#
步骤二:修改配置文件
- //文件末尾添加如下行
- [root@haproxy99 ~]# vim /etc/haproxy/haproxy.cfg
- listen mysqlLB *:3306 //集群名称与端口号
- mode tcp //mysql服务使用 tcp 协议
- option tcpka //启用长连接
- balance roundrobin //调度算法
- server pxcnode66 192.168.88.66:3306 check //第1台数据库服务器
- server pxcnode10 192.168.88.10:3306 check //第2台数据库服务器
- server pxcnode88 192.168.88.88:3306 check //第3台数据库服务器
- :wq
- [root@haproxy99 haproxy]#
步骤三:启动服务
- [root@haproxy99 ~]# systemctl start haproxy //启动服务
- [root@haproxy99 ~]# systemctl enable haproxy //开机运行
- Created symlink from /etc/systemd/system/multi-user.target.wants/haproxy.service to /usr/lib/systemd/system/haproxy.service.
- [root@haproxy99 ~]# netstat -utnlp | grep 3306 //查看端口
- tcp6 0 0 :::3306 :::* LISTEN 29768/haproxy
- [root@haproxy99 ~]#
步骤四:测试配置
- //在网站服务器连接haproxy99主机访问数据服务
- [root@web33 ~]# mysql -h192.168.88.99 -uyaya -p123qqq…A -e 'select @@hostname'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- +------------+
- | @@hostname |
- +------------+
- | pxcnode66 | //第1次连接
- +------------+
- [root@web33 ~]#
- [root@web33 ~]# mysql -h192.168.88.99 -uyaya99 -p123qqq…A -e 'select @@hostname'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- +------------+
- | @@hostname |
- +------------+
- | pxcnode10 | //第2次连接
- +------------+
- [root@web33 ~]#
- [root@web33 ~]# mysql -h192.168.88.99 -uyaya99 -p123qqq…A -e 'select @@hostname' [Warning] Using a password on the command line interface can be insecure.
- +------------+
- | @@hostname |
- +------------+
- | pxcnode88 | //第3次连接
- +------------+
- [root@web33 ~]#
5 案例5:部署HA集群
5.1 问题
具体配置如下:
- 准备备用调度器主机
- 安装软件
- 修改配置文件
- 启动服务
- 测试配置
5.2 方案
创建1台新的虚拟机,配置ip地址为192.168.88.98做备用调度器。
5.3 步骤
实现此案例需要按照如下步骤进行。
步骤一:准备备用调度器主机
- [root@haproxy98 ~]# yum -y install haproxy
- ……
- 已安装:
- haproxy.x86_64 0:1.5.18-7.el7
- 完毕!
- [root@haproxy98 ~]#
2)修改haproxy98主机haproxy.conf文件)
- //直接拷贝haproxy99主机的配置文件
- [root@haproxy98 ~]# scp root@192.168.88.99:/etc/haproxy/haproxy.cfg /etc/haproxy/
- Warning: Permanently added '192.168.88.99' (ECDSA) to the list of known hosts.
- root@192.168.4.99's password: //输入haproxy99主机的密码
- haproxy.cfg 100% 3142 6.0MB/s 00:00
- [root@haproxy98 ~]#
3)启动haproxy服务
- [root@haproxy98 ~]# systemctl start haproxy //启动服务
- [root@haproxy98 ~]# systemctl enable haproxy //服务开机运行
- Created symlink from /etc/systemd/system/multi-user.target.wants/haproxy.service to /usr/lib/systemd/system/haproxy.service.
- [root@haproxy98 ~]# netstat -utnlp | grep :3306 //查看端口
- tcp6 0 0 :::3306 :::* LISTEN 29768/haproxy
步骤二:安装软件keepalived软件
1)在haproxy99主机安装keepalived软件
- [root@haproxy99 ~]# yum -y install keepalived.x86_64
- 已安装:
- keepalived.x86_64 0:1.3.5-6.el7
- 作为依赖被安装:
- lm_sensors-libs.x86_64 0:3.4.0-4.20160601gitf9185e5.el7 net-snmp-agent-libs.x86_64 1:5.7.2-32.el7
- net-snmp-libs.x86_64 1:5.7.2-32.el7
- [root@haproxy99 ~]#
2)在haproxy98主机安装keepalived软件
- [root@haproxy98 ~]# yum -y install keepalived.x86_64
- 已安装:
- keepalived.x86_64 0:1.3.5-6.el7
- 作为依赖被安装:
- lm_sensors-libs.x86_64 0:3.4.0-4.20160601gitf9185e5.el7 net-snmp-agent-libs.x86_64 1:5.7.2-32.el7
- net-snmp-libs.x86_64 1:5.7.2-32.el7
- [root@haproxy98 ~]#
- 完毕!
- [root@haproxy98 ~]#
步骤三:修改配置文件
1)修改haproxy99主机的配置文件
- //删除无关的配置行
- [root@haproxy99 ~]# sed -i '36,$d' /etc/keepalived/keepalived.conf
- [root@haproxy99 ~]#vim /etc/keepalived/keepalived.conf
- global_defs {
- ……
- ……
- vrrp_iptables //禁止iptables
- }
- vrrp_instance VI_1 {
- state MASTER //主服务器标识
- interface eth0
- virtual_router_id 51
- priority 150 //优先级要比 haproxy88主机高
- advert_int 1
- authentication {
- auth_type PASS //主备服务器连接验证方式
- auth_pass 1111 //连接密码
- }
- virtual_ipaddress {
- 192.168.88.100 //定义vip地址
- }
- }
- :wq
- //把文件拷贝给备用调度器haproxy98
- [root@haproxy99 ~]# scp /etc/keepalived/keepalived.conf root@192.168.88.98: /etc/keepalived/
- root@192.168.88.98's password: //输入haproxy98主机的密码
2)修改haproxy98主机的配置文件
- [root@haproxy98 ~]#vim /etc/keepalived/keepalived.conf
- global_defs {
- ……
- ……
- vrrp_iptables //禁止iptables
- }
- vrrp_instance VI_1 {
- state BACKUP //备用服务器标识
- interface eth0
- virtual_router_id 51
- priority 100 //优先级要比 haproxy99低
- advert_int 1
- authentication {
- auth_type PASS
- auth_pass 1111
- }
- virtual_ipaddress {
- 192.168.88.100 //定义vip地址
- }
- }
- [root@haproxy98 ~]#
步骤四:启动服务
1)在haproxy99主机启动keepalived服务
- [root@haproxy99 ~]# systemctl start keepalived.service //启动服务
- [root@haproxy99 ~]#
- [root@haproxy99 ~]# ip addr show | grep 192.168.88.100 //查看vip地址
- inet 192.168.88.100/32 scope global eth0
- [root@haproxy99 ~]#
2)在haproxy98主机启动keepalived服务
- [root@haproxy98 ~]# systemctl start keepalived.service //启动服务
- [root@haproxy98 ~]# ip addr show | grep 192.168.88.100 //查看不到vip
步骤五:测试配置
1)客户端连接vip地址,访问数据库服务
- [root@web33 ~]# mysql -h192.168.88.100 -uyaya99 -p123qqq…A -e 'select @@hostname'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- +------------+
- | @@hostname |
- +------------+
- | pxcnode66 |
- +------------+
- [root@web33 ~]#
- [root@web33 ~]# mysql -h192.168.88.100 –uyaya99 –p123qqq…A -e 'select @@hostname'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- +------------+
- | @@hostname |
- +------------+
- | pxcnode10 |
- +------------+
- [root@web33 ~]# mysql -h192.168.88.100 –uyaya99 –p123qqq…A -e 'select @@hostname'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- +------------+
- | @@hostname |
- +------------+
- | pxcnode88 |
- +------------+
- [root@web33 ~]#
2)测试高可用
- [root@haproxy99 ~]# systemctl stop keepalived.service //停止keepalived服务
- [root@haproxy99 ~]# ip addr show | grep 192.168.88.100 //查看不到vip地址
- [root@haproxy98 ~]# ip addr show | grep 192.168.88.100 //在备用的haproxy98主机查看地址
- inet 192.168.4.100/32 scope global eth0
- [root@haproxy98 ~]#
- //客户端连接vip地址访问数据库服务
- [root@web33 ~]# mysql -h192.168.88.100 –uyaya99 –p123qqq…A -e 'select @@hostname'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- +------------+
- | @@hostname |
- +------------+
- | pxcnode66 |
- +------------+
- [root@web33 ~]#
- [root@web33 ~]# mysql -h192.168.88.100 –uyaya99 –p123qqq…A -e 'select @@hostname'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- +------------+
- | @@hostname |
- +------------+
- | pxcnode10 |
- +------------+
- [root@web33 ~]# mysql -h192.168.88.100 –uyaya99 –p123qqq…A -e 'select @@hostname'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- +------------+
- | @@hostname |
- +------------+
- | pxcnode88 |
- +------------+
- [root@web33 ~]#