• MHA-Atlas-MySQL高可用集群

     

     

    主机名映射

     
    1. [root@localhost ~]# cat /etc/hosts
    2. 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
    3. ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
    4. 192.168.200.20 mysql-db01
    5. 192.168.200.28 mysql-db02
    6. 192.168.200.29 mysql-db03
     

    关闭selinux和iptables

     
    1. [root@mysql-db01 ~]# setenforce 0
    2. [root@mysql-db01 ~]# service iptables stop
    3. iptables: Setting chains to policy ACCEPT: filter [ OK ]
    4. iptables: Flushing firewall rules: [ OK ]
    5. iptables: Unloading modules: [ OK ]

    安装（3台都装）

     
    1. [root@mysql-db01 ~]# yum -y install ncurses-devel
    2. [root@mysql-db01 ~]# yum -y install libaio
    3. [root@mysql-db01 ~]# tar xf mysql-5.6.17-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
    4. [root@mysql-db01 ~]# ln -s /usr/local/mysql-5.6.17-linux-glibc2.5-x86_64 /usr/local/mysql
    5. [root@mysql-db01 ~]# useradd mysql -s /sbin/nologin -M
    6. [root@mysql-db01 ~]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/
    7. [root@mysql-db01 ~]# /bin/cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
    8. [root@mysql-db01 ~]# /bin/cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
    9. [root@mysql-db01 ~]# ln -s /usr/local/mysql/bin/* /usr/local/bin/
    10. [root@mysql-db01 ~]# which mysqladmin
    11. /usr/local/bin/mysqladmin
     

    加入开机自启动并启动mysql

     
    1. [root@mysql-db01 ~]# chkconfig mysqld on
    2. [root@mysql-db01 ~]# chkconfig mysqld --list
    3. mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
    4. [root@mysql-db01 ~]# /etc/init.d/mysqld start
    5. Starting MySQL. SUCCESS!
    6. [root@mysql-db01 ~]# netstat -antup | grep mysql
    7. tcp 0 0 :::3306 :::* LISTEN 1258/mysqld
     

    配置密码

     
    1. [root@mysql-db01 ~]# mysqladmin -uroot password '666666'

    主库操作（mysql-db01）

     

    修改配置文件

     
    1. #修改主库配置文件/etc/my.cnf
    2. [root@mysql-db01 mysql]# cat /etc/my.cnf
    3. [client]
    4. socket = /usr/local/mysql/data/mysql.sock
    5. [mysqld]
    6. lower_case_table_names = 1
    7. default-storage-engine = InnoDB
    8. port = 3306
    9. datadir = /usr/local/mysql/data
    10. character-set-server = utf8
    11. socket = /usr/local/mysql/data/mysql.sock
    12. log_bin = mysql-bin #开启binlog日志
    13. server_id = 1 #设置server_id
    14. innodb_buffer_pool_size = 200M
    15. slave-parallel-workers = 8
    16. thread_cache_size = 600
    17. back_log = 600
    18. slave_net_timeout = 60
    19. max_binlog_size = 512M
    20. key_buffer_size = 8M
    21. query_cache_size = 64M
    22. join_buffer_size = 2M
    23. sort_buffer_size = 2M
    24. query_cache_type = 1
    25. thread_stack = 192K
    26. #重启动MySQL服务
    27. [root@mysql-db01 mysql]# /etc/init.d/mysqld restart
    28. Shutting down MySQL.. SUCCESS!
    29. Starting MySQL. SUCCESS!

    创建主从复制用户

     
    1. mysql> grant replication slave on *.* to rep@'192.168.200.%' identified by '666666';
    2. Query OK, 0 rows affected (0.01 sec)
    3. mysql> select user,host from mysql.user;
    4. +------+---------------+
    5. | user | host |
    6. +------+---------------+
    7. | root | 127.0.0.1 |
    8. | rep | 192.168.200.% |
    9. | root | ::1 |
    10. | | localhost |
    11. | root | localhost |
    12. | | mysql-db01 |
    13. | root | mysql-db01 |
    14. +------+---------------+
    15. 7 rows in set (0.00 sec)
    16. mysql> show grants for rep@'192.168.200.%';
    17. +----------------------------------------------------------------------------------------------------------------------------+
    18. | Grants for rep@192.168.200.% |
    19. +----------------------------------------------------------------------------------------------------------------------------+
    20. | GRANT REPLICATION SLAVE ON *.* TO 'rep'@'192.168.200.%' IDENTIFIED BY PASSWORD '*B2B366CA5C4697F31D4C55D61F0B17E70E5664EC' |
    21. +----------------------------------------------------------------------------------------------------------------------------+
    22. 1 row in set (0.00 sec)

    从库操作(mysql-db02和mysql-db03)

     

    修改配置文件

     
    1. #修改mysql-db02配置文件(和mysql-db01配置文件一致)
    2. #只需要修改server-id = 5选项
    3. [root@mysql-db02 ~]# cat /etc/my.cnf
    4. [client]
    5. socket = /usr/local/mysql/data/mysql.sock
    6. [mysqld]
    7. lower_case_table_names = 1
    8. default-storage-engine = InnoDB
    9. port = 3306
    10. datadir = /usr/local/mysql/data
    11. character-set-server = utf8
    12. socket = /usr/local/mysql/data/mysql.sock
    13. log_bin = mysql-bin #从binlog也要打开
    14. server_id = 5 #仅需修改此项
    15. innodb_buffer_pool_size = 200M
    16. slave-parallel-workers = 8
    17. thread_cache_size = 600
    18. back_log = 600
    19. slave_net_timeout = 60
    20. max_binlog_size = 512M
    21. key_buffer_size = 8M
    22. query_cache_size = 64M
    23. join_buffer_size = 2M
    24. sort_buffer_size = 2M
    25. query_cache_type = 1
    26. thread_stack = 192K
    27. [root@mysql-db02 ~]# /etc/init.d/mysqld restart #重启mysql
    28. Shutting down MySQL.. SUCCESS!
    29. Starting MySQL. SUCCESS!
      1. #修改mysql-db03配置文件(和mysql-db01配置文件一致)
      2. #只需要修改server-id = 10选项
      3. [root@mysql-db03 ~]# cat /etc/my.cnf
      4. [client]
      5. socket = /usr/local/mysql/data/mysql.sock
      6. [mysqld]
      7. lower_case_table_names = 1
      8. default-storage-engine = InnoDB
      9. port = 3306
      10. datadir = /usr/local/mysql/data
      11. character-set-server = utf8
      12. socket = /usr/local/mysql/data/mysql.sock
      13. log_bin = mysql-bin #从binlog也要打开
      14. server_id = 10 #只需修改此项
      15. innodb_buffer_pool_size = 200M
      16. slave-parallel-workers = 8
      17. thread_cache_size = 600
      18. back_log = 600
      19. slave_net_timeout = 60
      20. max_binlog_size = 512M
      21. key_buffer_size = 8M
      22. query_cache_size = 64M
      23. join_buffer_size = 2M
      24. sort_buffer_size = 2M
      25. query_cache_type = 1
      26. thread_stack = 192K
      27. [root@mysql-db03 ~]# /etc/init.d/mysqld restart #重启mysql
      28. Shutting down MySQL.. SUCCESS!
      29. Starting MySQL. SUCCESS!

    开启GTID

     
    1. mysql> show global variables like '%gtid%'; #查看GTID是否开启
    2. +--------------------------+-------+
    3. | Variable_name | Value |
    4. +--------------------------+-------+
    5. | enforce_gtid_consistency | OFF |
    6. | gtid_executed | |
    7. | gtid_mode | OFF |
    8. | gtid_owned | |
    9. | gtid_purged | |
    10. +--------------------------+-------+
    11. 5 rows in set (0.07 sec) #没开启

    编辑mysql配置文件（主库从库都需要修改） 
    image_1ct0ajvnj13flq6cf94eidav8m.png-59.4kB

    再次查看GTID状态

     
    1. [root@mysql-db01 ~]# mysql -uroot -p666666
    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 1
    5. Server version: 5.6.17-log MySQL Community Server (GPL)
    6. Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
    7. Oracle is a registered trademark of Oracle Corporation and/or its
    8. affiliates. Other names may be trademarks of their respective
    9. owners.
    10. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
    11. mysql> show global variables like '%gtid%';
    12. +--------------------------+-------+
    13. | Variable_name | Value |
    14. +--------------------------+-------+
    15. | enforce_gtid_consistency | ON | # 执行GTID一致
    16. | gtid_executed | |
    17. | gtid_mode | ON | # 开启GTID模块
    18. | gtid_owned | |
    19. | gtid_purged | |
    20. +--------------------------+-------+
    21. 5 rows in set (0.00 sec)

    开启从库的主从复制功能（mysql-db02,mysql-db03）

     
    1. mysql> start slave; #开启主从同步功能
    2. Query OK, 0 rows affected, 1 warning (0.01 sec)
    3. mysql> show slave statusG
    4. *************************** 1. row ***************************
    5. Slave_IO_State: Waiting for master to send event
    6. Master_Host: 192.168.0.51
    7. Master_User: rep
    8. Master_Port: 3306
    9. Connect_Retry: 60
    10. Master_Log_File: mysql-bin.000003
    11. Read_Master_Log_Pos: 151
    12. Relay_Log_File: mysql-db02-relay-bin.000002
    13. Relay_Log_Pos: 361
    14. Relay_Master_Log_File: mysql-bin.000003
    15. Slave_IO_Running: Yes #此项yes代表成功
    16. Slave_SQL_Running: Yes #此项yes代表成功
    17. Replicate_Do_DB:
    18. Replicate_Ignore_DB:
    19. Replicate_Do_Table:
    20. Replicate_Ignore_Table:
    21. #....以下省略若干行....

    因为MHA需要relaylog日志，但是mysql会自动删除relaylog日志，所以需要关闭自动删除

     
    1. #登陆从库
    2. [root@mysql-db02 ~]# mysql -uroot -p123123
    4. #临时禁用自动删除relay log功能
    5. mysql> set global relay_log_purge = 0;
    6. Query OK, 0 rows affected (0.00 sec)
    8. #设置只读
    9. mysql> set global read_only=1;
    10. Query OK, 0 rows affected (0.00 sec)

    编辑配置文件/etc/my.cof 
    image_1ct0crfc11ifvith01j431uac13.png-74.7kB

    修改配置文件必须重启服务 
    /etc/init.d/mysqld restart

    部署MHA

     

    环境准备（所有节点mysql-01，mysql-02，mysql-03）

     
    1. #光盘安装依赖包
    2. [root@mysql-db01 ~]# yum -y install perl-DBD-MySQL
    3. #安装mha4mysql-node-0.56-0.el6.noarch.rpm
    4. [root@mysql-db01 rpm]# rpm -ivh mha4mysql-node-0.56-0.el6.noarch.rpm
    5. Preparing... ########################################### [100%]
    6. 1:mha4mysql-node ########################################### [100%]
    7. [root@mysql-db01 rpm]# mysql -uroot -p666666
    8. Warning: Using a password on the command line interface can be insecure.
    9. Welcome to the MySQL monitor. Commands end with ; or g.
    10. Your MySQL connection id is 3
    11. Server version: 5.6.17-log MySQL Community Server (GPL)
    12. Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
    13. Oracle is a registered trademark of Oracle Corporation and/or its
    14. affiliates. Other names may be trademarks of their respective
    15. owners.
    16. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
    17. mysql> grant all privileges on *.* to mha@'192.168.200.%' identified by '666666';
    18. Query OK, 0 rows affected (0.12 sec)
    19. mysql> select user,host from mysql.user where user='mha';
    20. +------+---------------+
    21. | user | host |
    22. +------+---------------+
    23. | mha | 192.168.200.% | #主库上创建从库自动复制
    24. +------+---------------+
    25. 1 row in set (0.10 sec)
    26. # 3台MsQL都需要安装mha4mysql-node-0.56-0.el6.noarch.rpm

    部署管理节点（mha-manager）

     

    在mysql-db03上部署管理节点

     
    1. #使用阿里云源+epel源
    2. wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo
    3. wget -O /etc/yum.repos.d/epel-6.repo http://mirrors.aliyun.com/repo/epel-6.repo
    4. #安装manager依赖包（需要公网源）
    5. [root@mysql-db03 ~]# yum -y install perl-Config-Tiny epel-release perl-Log-Dispatch perl-Parallel-ForkManager perl-Time-HiRes
    6. #安装manager包
    7. [root@mysql-db03 rpm]# rpm -ivh mha4mysql-manager-0.56-0.el6.noarch.rpm
    8. Preparing... ########################################### [100%]
    9. 1:mha4mysql-manager ########################################### [100%]

    编辑配置文件

     
    1. #创建配置文件目录
    2. [root@mysql-db03 ~]# mkdir -p /etc/mha
    3. #创建日志目录
    4. [root@mysql-db03 ~]# mkdir -p /var/log/mha/mha1
    5. #创建配置文件（默认没有）
    6. [root@mysql-db03 ~]# cd /etc/mha/
    7. [root@mysql-db03 mha]# ls
    8. [root@mysql-db03 mha]# vim /etc/mha/mha1.cnf
    9. [root@mysql-db03 mha]# cat /etc/mha/mha1.cnf
    10. [server default]
    11. manager_log=/var/log/mha/mha1/manager #manager管理日志存放路径
    12. manager_workdir=/var/log/mha/mha1 #manager管理日志的目录路径
    13. master_binlog_dir=/usr/local/mysql/data #binlog日志的存放路径
    14. user=mha #管理账户
    15. password=123123 #管理账户密码
    16. ping_interval=2 #存活检查的间隔时间
    17. repl_user=rep #主从复制的授权账户
    18. repl_password=123123 #主从复制的授权账户密码
    19. ssh_user=root #用于ssh连接的账户
    20. [server1]
    21. hostname=192.168.0.51
    22. port=3306
    23. [server2]
    24. #candidate_master=1 #此条暂时注释掉（后面解释）
    25. #check_repl_delay=0 #此条暂时注释掉（后面解释）
    26. hostname=192.168.0.52
    27. port=3306
    28. [server3]
    29. hostname=192.168.0.53
    30. port=3306

     

    配置ssh信任（所有节点mysql-db01,mysql-db02,mysql-db03）

     
    1. #创建秘钥对，三个都创建，因为要互相免密码登录
    2. [root@mysql-db03 ~]# ssh-keygen -t dsa -P "" -f ~/.ssh/id_dsa
    3. #发送mysql-db03公钥，包括自己
    4. [root@mysql-db03 ~]# ssh-copy-id -i /root/.ssh/id_dsa.pub root@192.168.200.20
    5. [root@mysql-db03 ~]# ssh-copy-id -i /root/.ssh/id_dsa.pub root@192.168.200.28
    6. [root@mysql-db03 ~]# ssh-copy-id -i /root/.ssh/id_dsa.pub root@192.168.200.29
    7. #发送mysql-db02公钥，包括自己
    8. [root@mysql-db02 ~]# ssh-copy-id -i /root/.ssh/id_dsa.pub root@192.168.200.20
    9. [root@mysql-db02 ~]# ssh-copy-id -i /root/.ssh/id_dsa.pub root@192.168.200.28
    10. [root@mysql-db02 ~]# ssh-copy-id -i /root/.ssh/id_dsa.pub root@192.168.200.29
    11. #发送mysql-db01公钥，包括自己
    12. [root@mysql-db01 ~]# ssh-copy-id -i /root/.ssh/id_dsa.pub root@192.168.200.20
    13. [root@mysql-db01 ~]# ssh-copy-id -i /root/.ssh/id_dsa.pub root@192.168.200.28
    14. [root@mysql-db01 ~]# ssh-copy-id -i /root/.ssh/id_dsa.pub root@192.168.200.29

    启动测试

     

    ssh检查检测

     
    1. [root@mysql-db03 mha]# masterha_check_ssh --conf=/etc/mha/mha1.cnf #ssh检查命令
    2. Sat Nov 24 06:21:45 2018 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
    3. Sat Nov 24 06:21:45 2018 - [info] Reading application default configuration from /etc/mha/mha1.cnf..
    4. Sat Nov 24 06:21:45 2018 - [info] Reading server configuration from /etc/mha/mha1.cnf..
    5. Sat Nov 24 06:21:45 2018 - [info] Starting SSH connection tests..
    6. Sat Nov 24 06:21:46 2018 - [debug]
    7. Sat Nov 24 06:21:45 2018 - [debug] Connecting via SSH from root@192.168.200.20(192.168.200.20:22) to root@192.168.200.28(192.168.200.28:22)..
    8. Sat Nov 24 06:21:45 2018 - [debug] ok.
    9. Sat Nov 24 06:21:45 2018 - [debug] Connecting via SSH from root@192.168.200.20(192.168.200.20:22) to root@192.168.200.29(192.168.200.29:22)..
    10. Sat Nov 24 06:21:45 2018 - [debug] ok.
    11. Sat Nov 24 06:21:47 2018 - [debug]
    12. Sat Nov 24 06:21:46 2018 - [debug] Connecting via SSH from root@192.168.200.29(192.168.200.29:22) to root@192.168.200.20(192.168.200.20:22)..
    13. Sat Nov 24 06:21:46 2018 - [debug] ok.
    14. Sat Nov 24 06:21:46 2018 - [debug] Connecting via SSH from root@192.168.200.29(192.168.200.29:22) to root@192.168.200.28(192.168.200.28:22)..
    15. Sat Nov 24 06:21:47 2018 - [debug] ok.
    16. Sat Nov 24 06:21:47 2018 - [debug]
    17. Sat Nov 24 06:21:45 2018 - [debug] Connecting via SSH from root@192.168.200.28(192.168.200.28:22) to root@192.168.200.20(192.168.200.20:22)..
    18. Sat Nov 24 06:21:46 2018 - [debug] ok.
    19. Sat Nov 24 06:21:46 2018 - [debug] Connecting via SSH from root@192.168.200.28(192.168.200.28:22) to root@192.168.200.29(192.168.200.29:22)..
    20. Sat Nov 24 06:21:46 2018 - [debug] ok.
    21. Sat Nov 24 06:21:47 2018 - [info] All SSH connection tests passed successfully. #出现这个就表示成功

    主从复制检查

    （1）错误的主从复制检测 
    [root@mysql-db03 ~]# masterha_check_repl --conf=/etc/mha/mha1.cnf 
    如果出现下面的情况 
    image_1ct20dkp01j56s4rgqkis11ifk9.png-228kB

    因此在mysql-db02和mysql-db03上添加主从复制的用户即可。 
    grant replication slave on *.* to rep@'192.168.200.%' identified by '666666'; 
    再次检查

    image_1ct20ikvhuiercl1tdb1dgc2pcp.png-27.6kB

    启动MHA

     
    1. #启动
    2. [root@mysql-db03 ~]# nohup masterha_manager --conf=/etc/mha/mha1.cnf --remove_dead_master_conf --ignore_last_failover < /dev/null > /var/log/mha/mha1/manager.log 2>&1 & #启动后按几次回车，不退出就是没问题。
    3. [root@mysql-db03 ~]# ps -ef | grep perl | grep -v grep
    4. root 5585 2925 0 09:23 pts/1 00:00:00 perl /usr/bin/masterha_manager --conf=/etc/mha/mha1.cnf --remove_dead_master_conf --ignore_last_failover

    （1）登陆mysql-db02(192.168.200.28)查看信息状态

     
    1. #登陆数据库mysql-db02(192.168.200.28)
    2. [root@mysql-db03 ~]# mysql -uroot -p666666
    3. mysql> show slave statusG
    4. *************************** 1. row ***************************
    5. Slave_IO_State: Waiting for master to send event
    6. Master_Host: 192.168.200.20 #这是主库IP地址
    7. Master_User: rep
    8. Master_Port: 3306
    9. Connect_Retry: 60
    10. Master_Log_File: mysql-bin.000003
    11. Read_Master_Log_Pos: 1656
    12. Relay_Log_File: mysql-db02-relay-bin.000004
    13. Relay_Log_Pos: 1796
    14. Relay_Master_Log_File: mysql-bin.000003
    15. Slave_IO_Running: Yes
    16. Slave_SQL_Running: Yes
    17. ..以下省略若干内容..

    （2）停掉mysql-db01(192.168.200.20)上的MySQL服务

     
    1. [root@localhost rpm]# /etc/init.d/mysqld stop
    2. Shutting down MySQL...... SUCCESS!

    （3）查看mysql-db03上的MySQL从库同步状态

     
    1. [root@localhost mha]# mysql -uroot -p666666 -e 'show slave statusG'
    2. Warning: Using a password on the command line interface can be insecure.
    3. *************************** 1. row ***************************
    4. Slave_IO_State: Waiting for master to send event
    5. Master_Host: 192.168.200.28 #现在的主库IP
    6. Master_User: rep
    7. Master_Port: 3306
    8. Connect_Retry: 60
    9. Master_Log_File: mysql-bin.000003 #binlog日志
    10. Read_Master_Log_Pos: 662 #binlog日志位置
    11. Relay_Log_File: localhost-relay-bin.000002
    12. Relay_Log_Pos: 665
    13. Relay_Master_Log_File: mysql-bin.000003
    14. Slave_IO_Running: Yes
    15. Slave_SQL_Running: Yes
    16. ..以下省略若干内容..

    （4）查看mysql-db02上的MySQL，主库同步状态。 
    image_1ct28v6do6o10s51ob010erck91j.png-19.6kB

    5）查看mysql-db03上的mha进程状态

     
    1. [root@mysql-db03 ~]# ps -ef | grep perl | grep -v grep #查询发现mha进程已经没了
    2. [root@mysql-db03 ~]#

    （6）查看mha配置文件信息 
    image_1ct294dqo1093lg119321j1i1n9220.png-40.3kB

    进行mha的故障还原测试

    （1）将故障宕机的mysql-db01的MySQL服务启动并授权进行从同步

     
    1. [root@mysql-db01 ~]# /etc/init.d/mysqld start
    2. Starting MySQL. SUCCESS!
    3. [root@mysql-db01 ~]# mysql -uroot -p666666
    4. mysql> CHANGE MASTER TO MASTER_HOST='192.168.200.28', MASTER_PORT=3306, MASTER_AUTO_POSITION=1, MASTER_USER='rep', MASTER_PASSWORD='666666';

    （2）将mha配置文件里缺失的部分补全

     
    1. [root@localhost mha]# cat /etc/mha/mha1.cnf
    2. [server default]
    3. manager_log=/var/log/mha/mha1/manager
    4. manager_workdir=/var/log/mha/mha1
    5. master_binlog_dir=/usr/local/mysql/data
    6. password=666666
    7. ping_interval=2
    8. repl_password=666666
    9. repl_user=rep
    10. ssh_user=root
    11. user=mha
    12. [server1]
    13. hostname=192.168.200.20
    14. port=3306
    15. [server2]
    16. hostname=192.168.200.28
    17. port=3306
    18. [server3]
    19. hostname=192.168.200.29
    20. port=3306

    （3）启动mha进程

     
    1. [root@mysql-db03 ~]# nohup masterha_manager --conf=/etc/mha/mha1.cnf --remove_dead_master_conf --ignore_last_failover < /dev/null > /var/log/mha/mha1/manager.log 2>&1 &
    2. [root@localhost mha]# ps -ef |grep perl
    3. root 4541 934 0 23:39 pts/0 00:00:00 perl /usr/bin/masterha_manager --conf=/etc/mha/mha1.cnf --remove_dead_master_conf --ignore_last_failover

    （4）停掉mysql-db02上的MySQL服务

     
    1. [root@localhost ~]# /etc/init.d/mysqld stop
    2. Shutting down MySQL...... SUCCESS!

    （5）查看mysql-db03上的主从同步状态： 
    image_1ct2bdebd11n6guq1q683o81pbq2q.png-40.6kB 
    （6）启动mysql-db02上的MySQL服务

     
      2. [root@mysql-db02 ~]# /etc/init.d/mysqld start
      3. Starting MySQL. SUCCESS!
      4. [root@mysql-db02 ~]# mysql -uroot -p666666
      5. mysql> CHANGE MASTER TO MASTER_HOST='192.168.200.20', MASTER_PORT=3306, MASTER_AUTO_POSITION=1, MASTER_USER='rep', MASTER_PASSWORD='666666';
      6. mysql> start slave;
      7. mysql> show slave statusG #查看从同步状态

    （7）再次补全mha配置文件后，启动mha进程

     
    1. [root@localhost mha]# cat /etc/mha/mha1.cnf
    2. [server default]
    3. manager_log=/var/log/mha/mha1/manager
    4. manager_workdir=/var/log/mha/mha1
    5. master_binlog_dir=/usr/local/mysql/data
    6. password=666666
    7. ping_interval=2
    8. repl_password=666666
    9. repl_user=rep
    10. ssh_user=root
    11. user=mha
    12. [server1]
    13. hostname=192.168.200.20
    14. port=3306
    15. [server2]
    16. hostname=192.168.200.28
    17. port=3306
    18. [server3]
    19. hostname=192.168.200.29
    20. port=3306
    21. [root@mysql-db03 ~]# nohup masterha_manager --conf=/etc/mha/mha1.cnf --remove_dead_master_conf --ignore_last_failover < /dev/null > /var/log/mha/mha1/manager.log 2>&1 &
    22. [root@localhost mha]# ps -ef | grep perl | grep -v grep
    23. root 5027 934 0 Nov24 pts/0 00:00:00 perl /usr/bin/masterha_manager --conf=/etc/mha/mha1.cnf --remove_dead_master_conf --ignore_last_failover

     
  • 相关阅读:
    linux eclipse cdt make error 127
    centos 安装网络错误
    c++ string 结束符‘00’
    北京市工资交税情况
    gprof参数说明及常见错误
    【转】Eclipse Plugin 在 Console上打印出message
    C++做client Java做客户端传送数据
    word统计章节字数
    【转】Profiling application LLC cache misses under Linux using Perf Events
    【转】eclipse插件开发，调试运行，导出与安装
  • 原文地址：https://www.cnblogs.com/fengdou/p/10014887.html
Copyright © 2020-2023  润新知