当前位置：Gxlcms > 数据库问题 > 部署集群基础环境，MySQL-MMM架构部署，MySQL-MMM架构使用

部署集群基础环境，MySQL-MMM架构部署，MySQL-MMM架构使用

时间：2021-07-01 10:21:17 帮助过：10人阅读

  • 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
  • ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
  • 192.168.4.10 master1 master1.tarena.com
  • 192.168.4.11 master2 master2.tarena.com
  • 192.168.4.12 slave1 slave1.tarena.com
  • 192.168.4.13 slave2 slave2.tarena.com
  • 192.168.4.100 master1 master1.tarena.com
  • [root@master1 ~]# ping -c 2 master1
  • PING master1 (192.168.4.10) 56(84) bytes of data.
  • 64 bytes from master1 (192.168.4.10): icmp_seq=1 ttl=64 time=0.378 ms
  • 64 bytes from master1 (192.168.4.10): icmp_seq=2 ttl=64 time=0.396 ms
  • --- master1 ping statistics ---
  • 2 packets transmitted, 2 received, 0% packet loss, time 1001ms
  • rtt min/avg/max/mdev = 0.378/0.387/0.396/0.009 ms
  • [root@master1 ~]#

    • 步骤二：部署数据库主机

    1）安装启动数据库（4台数据库主机master1，master2，slave1，slave2执行以下操作）

    1. [root@master1 ~]# tar xvf MySQL-5.6.15-1.el6.x86_64.rpm-bundle.tar    //解压软件包
    2. .. ..
    3. [root@master1 ~]# rpm -Uvh MySQL-*.rpm                                //安装MySQL
    4. .. ..
    5. [root@master1 ~]# service mysql start
    6. Starting MySQL. [确定]

    2）初始化配置数据库（4台数据库主机master1，master2，slave1，slave2执行以下操作）

    1. [root@master1 ~]# cat /root/.mysql_secret         //查看随机生成密码
    2. # The random password set for the root user at Thu May 7 22:15:47 2015 (local time): wW1BNAjD
    4. [root@master1 ~]# mysql -uroot -pwW1BNAjD        //使用随机生成密码登陆
    5. Warning: Using a password on the command line interface can be insecure.
    6. Welcome to the MySQL monitor. Commands end with ; or \g.
    7. Your MySQL connection id is 1
    8. Server version: 5.6.15
    10. Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
    12. Oracle is a registered trademark of Oracle Corporation and/or its
    13. affiliates. Other names may be trademarks of their respective
    14. owners.
    16. Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.
    18. mysql> set password=password("pwd123");     //修改数据库root密码
    19. Query OK, 0 rows affected (0.49 sec)
    21. mysql> exit
    22. Bye
    23. [root@master1 ~]#

    步骤三：部署双主多从结构

    1）数据库授权（4台数据库主机master1，master2，slave1，slave2执行以下操作）

    部署主从同步只需要授权一个主从同步用户即可，但是我们要部署MySQL-MMM架构，所以在这里我们将MySQL-MMM所需用户一并进行授权设置。再授权一个测试用户，在架构搭建完成时测试使用。

    1. [root@master1 ~]# mysql -uroot -ppwd123
    2. Warning: Using a password on the command line interface can be insecure.
    3. Welcome to the MySQL monitor. Commands end with ; or \g.
    4. Your MySQL connection id is 2
    5. Server version: 5.6.15 MySQL Community Server (GPL)
    7. Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
    9. Oracle is a registered trademark of Oracle Corporation and/or its
    10. affiliates. Other names may be trademarks of their respective
    11. owners.
    13. Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

    数据库授权部分为了方便试验我们直接允许所有地址访问了，真实环境需谨慎

    1. mysql> grant replication slave on *.* to slaveuser@"%" identified by "pwd123";                                //主从同步授权
    2. Query OK, 0 rows affected (0.00 sec)
    4. mysql> grant replication client on *.* to monitor@"%" identified by "monitor";                                         //MMM所需架构用户授权
    5. Query OK, 0 rows affected (0.06 sec)        
    7. mysql> grant replication client,process,super on *.* to agent@"%" identified by "agent";                                 //MMM所需架构用户授权
    8. Query OK, 0 rows affected (0.00 sec)
    10. mysql> grant all on *.* to root@"%" identified by "pwd123"; //测试用户授权
    11. Query OK, 0 rows affected (0.00 sec)
    13. mysql>

    2）开启主数据库binlog日志、设置server_id（master1，master2）

    master1设置：

    1. [root@master1 ~]# cat /etc/my.cnf
    2. [mysqld]
    3. datadir=/var/lib/mysql
    4. socket=/var/lib/mysql/mysql.sock
    5. user=mysql
    6. server_id=10                        //设置server_id,该值集群中不可以重复
    7. log-bin                            //开启bin-log日志
    8. # Disabling symbolic-links is recommended to prevent assorted security risks
    9. symbolic-links=0
    11. [mysqld_safe]
    12. log-error=/var/log/mysqld.log
    13. pid-file=/var/run/mysqld/mysqld.pid
    15. [root@master1 ~]# service mysql restart                //重启MySQL服务
    16. Shutting down MySQL.. [确定]
    17. Starting MySQL.. [确定]
    18. [root@master1 ~]# ls /var/lib/mysql/master1-bin*        //查看binlog日志是否生成
    19. /var/lib/mysql/master1-bin.000001 /var/lib/mysql/master1-bin.index
    20. [root@master1 ~]#

    master2设置：

    1. [root@master2 ~]# cat /etc/my.cnf
    2. [mysqld]
    3. datadir=/var/lib/mysql
    4. socket=/var/lib/mysql/mysql.sock
    5. user=mysql
    6. server_id=11
    7. log-bin
    8. # Disabling symbolic-links is recommended to prevent assorted security risks
    9. symbolic-links=0
    11. [mysqld_safe]
    12. log-error=/var/log/mysqld.log
    13. pid-file=/var/run/mysqld/mysqld.pid
    14. [root@master2 ~]# service mysql restart
    15. Shutting down MySQL.. [确定]
    16. Starting MySQL. [确定]
    17. [root@master2 ~]# ls /var/lib/mysql/master2-bin.*
    18. /var/lib/mysql/master2-bin.000001 /var/lib/mysql/master2-bin.index

    3）从库设置server_id

    slave1设置：

    1. [root@slave1 ~]# cat /etc/my.cnf
    2. [mysqld]
    3. datadir=/var/lib/mysql
    4. socket=/var/lib/mysql/mysql.sock
    5. user=mysql
    6. server_id=12
    7. # Disabling symbolic-links is recommended to prevent assorted security risks
    8. symbolic-links=0
    10. [mysqld_safe]
    11. log-error=/var/log/mysqld.log
    12. pid-file=/var/run/mysqld/mysqld.pid
    13. [root@slave1 ~]# service mysql restart
    14. Shutting down MySQL.. [确定]
    15. Starting MySQL.. [确定]
    16. [root@slave1 ~]#

    slave2设置：

    1. [root@slave2 ~]# cat /etc/my.cnf
    2. [mysqld]
    3. datadir=/var/lib/mysql
    4. socket=/var/lib/mysql/mysql.sock
    5. user=mysql
    6. server_id=13
    7. # Disabling symbolic-links is recommended to prevent assorted security risks
    8. symbolic-links=0
    10. [mysqld_safe]
    11. log-error=/var/log/mysqld.log
    12. pid-file=/var/run/mysqld/mysqld.pid
    13. [root@slave2 ~]# service mysql restart
    14. Shutting down MySQL.. [确定]
    15. Starting MySQL. [确定]
    16. [root@slave2 ~]#

    4）配置主从从从关系

    配置master2、slave1、slave2成为master1的从服务器

    查看master1服务器binlong日志使用节点信息：

    1. [root@master1 ~]# mysql -uroot -ppwd123
    2. .. ..
    3. mysql> show master status\G
    4. *************************** 1. row ***************************
    5. File: master1-bin.000001
    6. Position: 120
    7. Binlog_Do_DB:
    8. Binlog_Ignore_DB:
    9. Executed_Gtid_Set:
    10. 1 row in set (0.00 sec)
    12. mysql>

    设置master2为master1从：

    1. [root@master2 ~]# mysql -uroot -ppwd123
    2. .. ..
    3. mysql> change master to                         //设置主服务器信息
    4. -> master_host="192.168.4.10",                //设置主服务器IP地址
    5. -> master_user="slaveuser",                //设置主从同步用户
    6. -> master_password="pwd123",                //设置主从同步密码
    7. -> master_log_file="master1-bin.000001",    //设置主库binlog日志名称
    8. -> master_log_pos=120;                        //设置主从binlog日志使用节点
    9. Query OK, 0 rows affected, 2 warnings (0.06 sec)
    11. mysql> start slave;                            //启动同步进程
    12. Query OK, 0 rows affected (0.00 sec)
    14. mysql> show slave status\G                        //查看主从是否成功
    15. .. ..

    启动同步进程后查看IO节点和SQL节点是否为Yes如果均为Yes表示主从正常。

    1. Slave_IO_Running: Yes                //IO节点正常
    2. Slave_SQL_Running: Yes                //SQL节点正常
    3. .. ..
    4. mysql>

    设置slave1为master1从：

    1. [root@slave1 ~]# mysql -uroot -ppwd123
    2. .. ..
    3. mysql> change master to
    4. -> master_host="192.168.4.10",
    5. -> master_user="slaveuser",
    6. -> master_password="pwd123",
    7. -> master_log_file="master1-bin.000001",
    8. -> master_log_pos=120;
    9. Query OK, 0 rows affected, 2 warnings (0.12 sec)
    11. mysql> start slave;
    12. Query OK, 0 rows affected (0.16 sec)
    14. mysql> show slave status\G
    15. .. ..
    16. Slave_IO_Running: Yes                //IO节点正常
    17. Slave_SQL_Running: Yes                //SQL节点正常
    18. .. ..
    19. mysql>

    设置slave2为master1从：

    1. [root@slave2 ~]# mysql -uroot -ppwd123
    2. .. ..
    3. mysql> change master to
    4. -> master_host="192.168.4.10",
    5. -> master_user="slaveuser",
    6. -> master_password="pwd123",
    7. -> master_log_file="master1-bin.000001",
    8. -> master_log_pos=120;
    9. Query OK, 0 rows affected, 2 warnings (0.13 sec)
    11. mysql> start slave;
    12. Query OK, 0 rows affected (0.27 sec)
    14. mysql> show slave status\G
    15. .. ..
    16. Slave_IO_Running: Yes                //IO节点正常
    17. Slave_SQL_Running: Yes                //SQL节点正常
    18. .. ..
    19. mysql>

    5）配置主主从从关系，将master1配置为master2的从

    查看master2的binlog使用信息：

    1. [root@master2 ~]# mysql -uroot -ppwd123
    2. .. ..
    3. mysql> show master status\G
    4. *************************** 1. row ***************************
    5. File: master2-bin.000001
    6. Position: 120
    7. Binlog_Do_DB:
    8. Binlog_Ignore_DB:
    9. Executed_Gtid_Set:
    10. 1 row in set (0.00 sec)
    12. mysql>

    设置master1成为master2的从：

    1. [root@master1 ~]# mysql -uroot -ppwd123
    2. .. ..
    3. mysql> change master to
    4. -> master_host="192.168.4.11",
    5. -> master_user="slaveuser",
    6. -> master_password="pwd123",
    7. -> master_log_file="master2-bin.000001",
    8. -> master_log_pos=120;
    9. Query OK, 0 rows affected, 2 warnings (0.31 sec)
    11. mysql> start slave;
    12. Query OK, 0 rows affected (0.27 sec)
    14. mysql> show slave status\G
    15. .. ..
    16. Slave_IO_Running: Yes                //IO节点正常
    17. Slave_SQL_Running: Yes                //SQL节点正常
    18. .. ..
    19. mysql>

    6）测试主从架构是否成功

    master1更新数据，查看其它主机是否同步：

    1. [root@master1 ~]# mysql -uroot -ppwd123
    2. .. ..
    3. mysql> show databases;
    4. +--------------------+
    5. | Database |
    6. +--------------------+
    7. | information_schema |
    8. | mysql |
    9. | performance_schema |
    10. | test |
    11. +--------------------+
    12. 4 rows in set (0.00 sec)
    14. mysql> create database tarena;
    15. Query OK, 1 row affected (0.06 sec)
    17. mysql> show databases;
    18. +--------------------+
    19. | Database |
    20. +--------------------+
    21. | information_schema |
    22. | mysql |
    23. | performance_schema |
    24. | tarena |
    25. | test |
    26. +--------------------+
    27. 5 rows in set (0.00 sec)
    29. mysql>

    master2主机查看：

    1. [root@master2 ~]# mysql -uroot -ppwd123 -e "show databases"
    2. Warning: Using a password on the command line interface can be insecure.
    3. +--------------------+
    4. | Database |
    5. +--------------------+
    6. | information_schema |
    7. | mysql |
    8. | performance_schema |
    9. | tarena |
    10. | test |
    11. +--------------------+
    12. [root@master2 ~]#

    slave1主机查看：

    1. [root@slave1 ~]# mysql -uroot -ppwd123 -e "show databases"
    2. Warning: Using a password on the command line interface can be insecure.
    3. +--------------------+
    4. | Database |
    5. +--------------------+
    6. | information_schema |
    7. | mysql |
    8. | performance_schema |
    9. | tarena |
    10. | test |
    11. +--------------------+
    12. [root@slave1 ~]#

    slave2主机查看：

    1. [root@slave2 ~]# mysql -uroot -ppwd123 -e "show databases"
    2. Warning: Using a password on the command line interface can be insecure.
    3. +--------------------+
    4. | Database |
    5. +--------------------+
    6. | information_schema |
    7. | mysql |
    8. | performance_schema |
    9. | tarena |
    10. | test |
    11. +--------------------+
    12. [root@slave2 ~]#

    2 MySQL-MMM架构部署

    2.1 问题

    本案例要求熟悉实现MySQL-MMM的架构部署，主要包括以下任务：

    1. 安装依赖包
    2. 安装软件包
    3. 配置MySQL-MMM

    2.2 方案

    使用5台RHEL 6虚拟机，如图-2所示。其中192.168.4.10、192.168.4.11作为MySQL双主服务器，192.168.4.12、 192.168.4.13作为主服务器的从服务器，192.168.4.100作为MySQL-MMM架构中管理监控服务器，实现监控MySQL主从服务 器的工作状态及决定故障节点的移除或恢复工作，架构搭建完成后使用客户机192.168.4.120进行访问，客户机需要安装MySQL-client软 件包。

    技术分享图片

    图-2

    2.3 步骤

    实现此案例需要按照如下步骤进行。

    步骤一：安装MySQL-MMM

    1）安装依赖关系（MySQL集群内5台服务器master1，master2，slave1，slave2，monitor）均需安装

    1. [root@master1 ~]# yum -y install gcc* perl-Date-Manip perl-Date-Manip perl-Date-Manip perl-XML-DOM-XPath perl-XML-Parser perl-XML-RegExp rrdtool perl-Class-Singleton perl perl-DBD-MySQL perl-Params-Validate perl-MailTools perl-Time-HiRes
    2. .. ..

    2）安装MySQL-MMM软件依赖包（MySQL集群内5台服务器master1，master2，slave1，slave2，monitor）均需安装，软件包讲师提供

    安装安装Log-Log4perl 类

    1. [root@mysql-master1 ~]# rpm -ivh perl-Log-Log4perl-1.26-1.el6.rf.noarch.rpm
    2. warning: perl-Log-Log4perl-1.26-1.el6.rf.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
    3. Preparing... ######################### [100%]
    4. 1:perl-Log-Log4perl ######################## [100%]

    安装Algorithm-Diff类

    1. [root@mysql-master1 ~]# tar -zxvf Algorithm-Diff-1.1902.tar.gz //解压安装包
    2. .. ..
    3. [root@mysql-master1 ~]# cd Algorithm-Diff-1.1902                //切换到安装目录
    4. [root@mysql-master1 Algorithm-Diff-1.1902]# perl Makefile.PL    //生成makefile文件
    5. Checking if your kit is complete...
    6. Looks good
    7. Writing Makefile for Algorithm::Diff
    9. [root@mysql-master1 Algorithm-Diff-1.1902]# make && make install        //编译，编译安装
    10. .. ..
    11. [root@mysql-master1 Algorithm-Diff-1.1902]# cd                //切换到软件包目录
    12. [root@mysql-master1 ~]#

    安装Proc-Daemon类

    1. [root@mysql-master1 ~]# tar -zxvf Proc-Daemon-0.03.tar.gz    //解压安装包
    2. .. ..
    3. [root@mysql-master1 ~]# cd Proc-Daemon-0.03                    //切换到安装目录
    4. [root@mysql-master1 Proc-Daemon-0.03]# perl Makefile.PL    //生成makefile文件
    5. Checking if your kit is complete...
    6. Looks good
    7. Writing Makefile for Proc::Daemon
    8. [root@mysql-master1 Proc-Daemon-0.03]# make && make install    //编译，编译安装
    9. .. ..
    10. [root@mysql-master1 Proc-Daemon-0.03]# cd                    //切换到软件包目录
    11. [root@mysql-master1 ~]#

    安装Net-ARP虚拟IP分配工具：

    1. [root@mysql-master1 ~]# gunzip Net-ARP-1.0.8.tgz    //使用gunzip解压tgz格式的安装包
    2. [root@mysql-master1 ~]# tar xvf Net-ARP-1.0.8.tar            //解压tar安装包
    3. .. ..
    4. [root@mysql-master1 ~]# cd Net-ARP-1.0.8                    //切换到安装目录
    5. [root@mysql-master1 Net-ARP-1.0.8]# perl Makefile.PL        //生成makefile文件
    6. Module Net::Pcap is required for make test!
    7. Checking if your kit is complete...
    8. Looks good
    9. Writing Makefile for Net::ARP
    10. [root@mysql-master1 Net-ARP-1.0.8]# make && make install    //编译，编译安装
    11. .. ..
    12. [root@mysql-master1 Net-ARP-1.0.8]# cd                        //切换到软件包目录
    13. [root@mysql-master1 ~]#

    安装Mysql-MMM软件包：

    1. [root@mysql-master1 ~]# tar xvf mysql-mmm-2.2.1.tar.gz        //解压安装包
    2. .. ..
    3. [root@mysql-master1 ~]# cd mysql-mmm-2.2.1                    //切换到安装目录
    4. [root@mysql-master1 mysql-mmm-2.2.1]# make && make install    //编译，编译安装
    5. .. ..
    6. [root@mysql-master1 mysql-mmm-2.2.1]#

    步骤二：修改配置文件

    1）修改公共配置文件

    本案例中MySQL集群的5台服务器（master1、master2、slave1、slave2、monitor）都需要配置，可以先配好一台后使用scp复制。

    1. [root@master1 ~]# vim /etc/mysql-mmm/mmm_common.conf
    2. active_master_role    writer
    4. <host default>
    5.     cluster_interface        eth0                //设置主从同步的用户
    7.     pid_path                /var/run/mmm_agentd.pid
    8.     bin_path                /usr/lib/mysql-mmm/
    10. replication_user slaveuser            //设置主从同步的用户
    11. replication_password pwd123            //设置主从同步用户密码
    13.     agent_user            agent                //mmm-agent控制数据库用户
    14.     agent_password        agent                //mmm-agent控制数据库用户密码
    15. </host>
    17. <host master1>                            //设置第一个主服务器
    18.     ip                    192.168.4.10            //master1 IP 地址
    19.     mode                    master
    20.     peer                    master2                //指定另外一台主服务器
    21. </host>
    23. <host master2>                            //指定另外一台主服务器
    24.     ip                    192.168.4.11
    25.     mode                    master
    26.     peer                    master1
    27. </host>
    29. <host slave1> &

    人气教程排行

    本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！