{"id":57299,"date":"2025-08-15T10:00:48","date_gmt":"2025-08-15T02:00:48","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/57299.html"},"modified":"2025-08-15T10:00:48","modified_gmt":"2025-08-15T02:00:48","slug":"%e6%9c%8d%e5%8a%a1%e5%99%a8%e7%9a%84mysql-%e9%9b%86%e7%be%a4%e6%8a%80%e6%9c%af","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/57299.html","title":{"rendered":"\u670d\u52a1\u5668\u7684Mysql \u96c6\u7fa4\u6280\u672f"},"content":{"rendered":"

Mysql \u96c6\u7fa4\u6280\u672f <\/span><\/h3>\n

Mysql \u5728\u670d\u52a1\u5668\u4e2d\u7684\u90e8\u7f72\u65b9\u6cd5<\/span><\/h4>\n

\u00a0\u00a0\u00a0\u00a0\u5728\u4f01\u4e1a\u4e2d90%\u7684\u670d\u52a1\u5668\u64cd\u4f5c\u7cfb\u7edf\u5747\u4e3a<\/span>Linux <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5728\u4f01\u4e1a\u4e2d\u5bf9\u4e8e<\/span>Mysql<\/span>\u7684\u5b89\u88c5\u901a\u5e38\u7528\u6e90\u7801\u7f16\u8bd1\u7684\u65b9\u5f0f\u6765\u8fdb\u884c<\/span><\/p>\n

Rhel<\/span>7<\/span>\u90e8\u7f72\u6570\u636e\u5e93<\/span>\u00a0<\/h4>\n

\u00a0\u00a0\u3010<\/span>\u6ce8\u610f：<\/span>\u7528rhel <\/span>7<\/span>\u00a0\u7248\u672c\u3011<\/span><\/p>\n

\u6240\u6709mysql ]<\/span># <\/span>yum install -y git bison openssl-devel ncurses-devel -y<\/span><\/p>\n

# unzip gcc-11.zip<\/span><\/p>\n

# cd gcc-11\/<\/span><\/p>\n

# yum install *.rpm -y<\/span><\/p>\n

# source \/opt\/rh\/devtoolset-11\/enable<\/span><\/p>\n

# gcc –version<\/span><\/p>\n

\"\"<\/p>\n

# cat \/opt\/rh\/devtoolset-11\/enable >> ~\/.bash_profile<\/span><\/p>\n

# gcc -v<\/span><\/p>\n

# vim \/etc\/yum.repos.d\/rhel7.repo<\/span><\/p>\n

\"\"<\/p>\n

# tar zxf cmake3.tar.gz<\/span><\/p>\n

# cd make3\/<\/span><\/p>\n

# rpm -ivh *.rpm –nodeps –force<\/span><\/p>\n

# cmake3 –version<\/span><\/p>\n

\"\"<\/p>\n

\u6e90\u7801\u7f16\u8bd1\u5b89\u88c5mysql<\/span><\/h4>\n

# cd <\/span>\/mnt\/<\/span><\/p>\n

# du -sh mysql-boost-8.0.40.tar.gz<\/span><\/p>\n

\"\"<\/p>\n

# tar zxf mysql-boost-8.0.40.tar.gz<\/span><\/p>\n

# cd mysql-8.0.40\/<\/span><\/p>\n

# mkdir -p build<\/span><\/p>\n

# cd build\/<\/span><\/p>\n

# \u00a0cmake3 \u00a0.. -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mysql -DMYSQL_DATADIR=\/data\/mysql -DMYSQL_UNIX_ADDR=\/data\/mysql\/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all -DWITH_SSL=system -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_ci -DWITH_DEBUG=OFF<\/span>\u00a0\u00a0-DWITH_BOOST=\/<\/span>mnt<\/span>\/mysql-8.0.40\/boost\/boost_1_77_0\/<\/span><\/p>\n

# make -j<\/span>4<\/span><\/p>\n

# make install<\/span><\/p>\n

# <\/span>du -sh \/usr\/local\/mysql<\/span><\/p>\n

\"\"<\/p>\n

\u90e8\u7f72mysql<\/span><\/h3>\n

mysqlA ]<\/span># cd \/usr\/local\/mysql\/support-files\/<\/span><\/p>\n

# cp -p mysql.server \/etc\/init.d\/mysqld<\/span><\/p>\n

# vim ~\/.bash_profile<\/span><\/p>\n

\"\"<\/p>\n

# source ~\/.bash_profile<\/span><\/p>\n

# mysql –version<\/span><\/p>\n

\"\"<\/p>\n

# systemctl disable –now firewalld.service<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010\u5173\u706b\u5899\u3011<\/span><\/p>\n

# useradd -M -s \/sbin\/nologin mysql<\/span><\/p>\n

# mkdir <\/span>-p <\/span>\/data\/mysql\/<\/span><\/p>\n

# chown mysql.mysql \/data\/mysql\/<\/span><\/p>\n

# vim \/etc\/my.cnf<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010<\/span>MySQL \u7684\u4e3b\u914d\u7f6e\u6587\u4ef6<\/span>\u3011<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0[mysqld]<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0server-id=10<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#<\/span>\u8bbe\u7f6e\u670d\u52a1\u5668\u552f\u4e00\u6807\u8bc6<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0datadir=\/data\/mysql \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#\u6307\u5b9a\u6570\u636e\u76ee\u5f55<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0socket=\/data\/mysql\/mysql.sock <\/span>\u00a0\u00a0\u00a0#\u6307\u5b9a\u5957\u63a5\u5b57<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0default_authentication_plugin=mysql_native_password<\/span>\u00a0\u00a0\u00a0\u00a0#<\/span>\u8bbe\u7f6e\u9ed8\u8ba4\u8ba4\u8bc1\u63d2\u4ef6<\/span><\/p>\n

\u6570\u636e\u5e93\u521d\u59cb\u5316\u5efa\u7acbmysql<\/span>\u57fa\u672c\u6570\u636e <\/span><\/h4>\n

# mysqld –initialize –user=mysql <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u3010<\/span>\u521d\u59cb\u5316 MySQL \u6570\u636e\u76ee\u5f55<\/span>\u3011<\/span><\/p>\n

\"\"<\/p>\n

# \/etc\/init.d\/mysqld start <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u3010<\/span>\u542f\u52a8 MySQL \u670d\u52a1<\/span>\u3011<\/span><\/p>\n

# chkconfig mysqld on<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010<\/span>\u00a0\u8bbe\u7f6e MySQL \u5f00\u673a\u81ea\u542f<\/span>\u3011<\/span><\/p>\n

# mysql_secure_installation<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u3010\u6570\u636e\u5e93\u5b89\u5168\u521d\u59cb\u5316\u3011<\/span><\/p>\n

\"\"<\/p>\n

# <\/span>mysql -uroot -plee<\/span><\/p>\n

mysql> SHOW DATABASES;<\/span><\/p>\n

\"\"<\/p>\n

mysql\u7f16\u8bd1\u590d\u5236<\/span><\/h4>\n

mysqlB ]<\/span># <\/span>scp -r root@172.25.254.10:\/usr\/local\/mysql<\/span>\/<\/span>\u00a0\/usr\/local\/<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010\u590d\u5236\u5185\u5bb9\u3011<\/span><\/p>\n

# useradd -M -s \/sbin\/nologin mysql<\/span><\/p>\n

# mkdir <\/span>-p <\/span>\/data\/mysql\/<\/span><\/p>\n

# chown mysql.mysql \/data\/mysql\/<\/span><\/p>\n

# \/usr\/local\/mysql\/bin\/mysqld –initialize –user=mysql<\/span><\/p>\n

# vim \/etc\/my.cnf<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010<\/span>MySQL \u7684\u4e3b\u914d\u7f6e\u6587\u4ef6<\/span>\u3011<\/span><\/p>\n

\"\"<\/p>\n

# cd \/usr\/local\/mysql\/support-files\/<\/span><\/p>\n

# cp -p mysql.server \/etc\/init.d\/mysqld<\/span><\/p>\n

# <\/span>\/etc\/init.d\/mysqld start<\/span><\/p>\n

# chkconfig mysqld on<\/span><\/p>\n

# mysql_secure_installation<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u3010\u6570\u636e\u5e93\u5b89\u5168\u521d\u59cb\u5316，\u76f8\u540c\u7684\u914d\u7f6e\u3011<\/span><\/p>\n

mysql\u7684\u7ec4\u4ece\u590d\u5236<\/span><\/h3>\n

mysqlA ]<\/span># vim \/etc\/my.cnf<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0log-bin<\/span>=mysql-bin<\/span>\u00a0\u00a0\u00a0\u00a0#\u6dfb\u52a0\u5185\u5bb9，<\/span>\u542f\u7528binlog<\/span>，\u751f\u6210\u65e5\u5fd7\u6587\u4ef6<\/span><\/p>\n

# \/etc\/init.d\/mysqld restart<\/span><\/p>\n

# mysql -plee<\/span><\/p>\n

mysql> CREATE USER lee@<\/span>'%' IDENTIFIED WITH caching_sha2_password BY 'lee'; <\/span><\/p>\n

mysql> GRANT REPLICATION SLAVE ON *.* TO '<\/span>lee<\/span>'@'%';<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#<\/span>\u5bf9\u8fd9\u4e2a\u7528\u6237\u8fdb\u884c\u6388\u6743 <\/span><\/p>\n

mysql> show grants for lee@'%';<\/span><\/p>\n

\"\"<\/p>\n

mysql> SHOW MASTER STATUS;<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#<\/span>\u67e5\u770b\u4fe1\u606f<\/span><\/p>\n

\"\"<\/p>\n

# cd \/data\/mysql\/<\/span><\/p>\n

# mysqlbinlog mysql-bin.000001 -vv \u00a0\u00a0<\/span>\u00a0\u00a0\u00a0\u3010\u67e5\u770b\u65e5\u5fd7\u6587\u4ef6\u3011<\/span><\/p>\n

\"\"<\/p>\n

\u914d\u7f6esalve1<\/span><\/h4>\n

mysqlB ]<\/span># vim \/etc\/my.cnf<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010<\/span>MySQL \u7684\u4e3b\u914d\u7f6e\u6587\u4ef6<\/span>\u3011<\/span><\/p>\n

\"\"<\/p>\n

# <\/span>\/etc\/init.d\/mysqld start<\/span><\/p>\n

# mysql -plee<\/span><\/p>\n

mysql><\/span>CHANGE MASTER TO MASTER_HOST='172.25.254.10', MASTER_USER='<\/span>lee<\/span>', MASTER_PASSWORD='lee', MASTER_LOG_FILE='<\/span>mysql-bin.000001<\/span>', MASTER_LOG_POS=<\/span>691<\/span>;<\/span><\/p>\n

mysql> SELECT @@server_uuid;<\/span><\/p>\n

\"\"<\/p>\n

mysql><\/span>start slave;<\/span><\/p>\n

\"\"<\/p>\n

#\u5982\u679c\u4e0a\u8ff0\u5185\u5bb9\u8f93\u5165\u9519\u8bef\u53ef\u4ee5reset<\/span>\u91cd\u65b0\u586b\u5165\u4fe1\u606f\u5373\u53ef <\/span><\/p>\n

mysql> RESET SLAVE ALL;<\/span><\/p>\n

mysqlA ]<\/span># mysql -plee<\/span><\/p>\n

mysql> CREATE DATABASE lee;<\/span><\/p>\n

> <\/span>CREATE TABLE lee.userlist (<\/span>\u00a0username varchar(20) not null, password varchar(50) not null );<\/span><\/p>\n

> <\/span>INSERT INTO lee.userlist VALUE ('lee','123');<\/span><\/p>\n

> <\/span>SELECT * FROM lee.userlist;<\/span><\/p>\n

mysqlB ]<\/span># mysql -plee<\/span><\/p>\n

mysql> SELECT * FROM lee.userlist;<\/span><\/p>\n

\"\"<\/p>\n

\u5f53\u6709\u6570\u636e\u65f6\u6dfb\u52a0slave2<\/span><\/h4>\n

# <\/span>scp -r \/usr\/local\/mysql<\/span>\u00a0root@172.25.254.<\/span>3<\/span>0:\/usr\/local\/mysql <\/span><\/p>\n

# vim \/etc\/my.cnf<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010<\/span>MySQL \u7684\u4e3b\u914d\u7f6e\u6587\u4ef6<\/span>\u3011<\/span><\/p>\n

\"\"<\/p>\n

# \/etc\/init.d\/mysqld restart<\/span><\/p>\n

mysqlb ]<\/span># mysqldump -uroot -plee lee > \/mnt\/lee.sql \u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0\u00a0\u3010\u6570\u636e\u5907\u4efd\u3011<\/span><\/p>\n

\u751f\u4ea7\u73af\u5883\u4e2d\u5907\u4efd\u65f6\u9700\u8981\u9501\u8868，\u4fdd\u8bc1\u5907\u4efd\u524d\u540e\u7684\u6570\u636e\u4e00\u81f4 <\/span><\/p>\n

mysql> FLUSH TABLES WITH READ LOCK; <\/span><\/p>\n

\u5907\u4efd\u540e\u518d\u89e3\u9501 <\/span><\/p>\n

mysql> UNLOCK TABLES; <\/span><\/p>\n

mysqldump<\/span>\u547d\u4ee4\u5907\u4efd\u7684\u6570\u636e\u6587\u4ef6，\u5728\u8fd8\u539f\u65f6\u5148<\/span>DROP TABLE<\/span>，\u9700\u8981\u5408\u5e76\u6570\u636e\u65f6\u8981\u5220\u9664\u6b64\u8bed\u53e5<\/span><\/p>\n

mysqlc ]<\/span># <\/span>scp -r root@172.25.254.10:<\/span>\/mnt\/<\/span>lee.sql<\/span>\u00a0\/mnt\/<\/span><\/p>\n

# mysql -uroot -plee -e "create database lee;" <\/span><\/p>\n

# mysql -uroot -p lee <<\/span>\u00a0\/mnt\/<\/span>lee.sql <\/span><\/p>\n

# mysql -uroot -plee -e "select * from lee.userlist;"<\/span><\/p>\n

mysql> SELECT * FROM lee.userlist;<\/span><\/p>\n

\"\"<\/p>\n

\u914d\u7f6eslave2\u7684<\/span>slave<\/span>\u529f\u80fd<\/span><\/h4>\n

mysqla ]<\/span># <\/span>mysql -uroot -plee -e "SHOW MASTER STATUS;"<\/span><\/p>\n

\"\"<\/p>\n

mysqlc ]<\/span># mysql -uroot -plee<\/span><\/p>\n

mysql> CHANGE REPLICATION SOURCE TO SOURCE_HOST='172.25.254.10', SOURCE_USER='lee', SOURCE_PASSWORD='lee',SOURCE_LOG_FILE='mysql-bin.000002',SOURCE_LOG_POS=872, SOURCE_SSL=0,GET_SOURCE_PUBLIC_KEY=1;<\/span><\/p>\n

mysql> start slave; <\/span><\/p>\n

mysql> SELECT * FROM lee.userlist;<\/span><\/p>\n

\"\"<\/p>\n

mysql> SHOW SLAVE STATUS\\\\G;<\/span><\/p>\n

\"\"<\/p>\n

mysqla ]<\/span># mysql -uroot -plee -e "INSERT INTO lee.userlist<\/span>\u00a0VALUES('user3','123');"<\/span><\/p>\n

mysqlc ]<\/span># mysql -uroot -plee -e 'select * from lee.userlist;'<\/span><\/p>\n

\"\"<\/p>\n

\u6162\u67e5\u8be2\u65e5\u5fd7<\/span><\/h3>\n

\u00a0\u00a0\u00a0\u00a0\u6162\u67e5\u8be2，\u987e\u540d\u601d\u4e49，\u6267\u884c\u5f88\u6162\u7684\u67e5\u8be2 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5f53\u6267\u884c<\/span>SQL<\/span>\u8d85\u8fc7<\/span>long_query_time<\/span>\u53c2\u6570\u8bbe\u5b9a\u7684\u65f6\u95f4\u9608\u503c（\u9ed8\u8ba4<\/span>10s<\/span>）\u65f6，\u5c31\u88ab\u8ba4\u4e3a\u662f\u6162\u67e5\u8be2，\u8fd9\u4e2a<\/span>SQL<\/span>\u8bed\u53e5\u5c31\u662f\u9700\u8981\u4f18\u5316\u7684 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u6162\u67e5\u8be2\u88ab\u8bb0\u5f55\u5728\u6162\u67e5\u8be2\u65e5\u5fd7\u91cc <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u6162\u67e5\u8be2\u65e5\u5fd7\u9ed8\u8ba4\u662f\u4e0d\u5f00\u542f\u7684 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5982\u679c\u9700\u8981\u4f18\u5316<\/span>SQL<\/span>\u8bed\u53e5，\u5f00\u542f\u8fd9\u529f\u80fd，\u5b83\u53ef\u4ee5\u8ba9\u4f60\u5f88\u5bb9\u6613\u5730\u77e5\u9053\u54ea\u4e9b\u8bed\u53e5\u662f\u9700\u8981\u4f18\u5316\u7684\u3002<\/span><\/p>\n

> SHOW variables like "slow%";<\/span><\/p>\n

\"\"<\/p>\n

\u5f00\u542f\u6162\u67e5\u8be2\u65e5\u5fd7<\/span><\/h4>\n

> SET GLOBAL slow_query_log=ON;<\/span><\/p>\n

> SET long_query_time=4;<\/span><\/p>\n

> SHOW VARIABLES like "long%";<\/span><\/p>\n

\"\"<\/p>\n

> SHOW VARIABLES like "slow%";<\/span><\/p>\n

\"\"<\/p>\n

\u6d4b\u8bd5\u6162\u67e5\u8be2<\/span><\/h4>\n

> select sleep (<\/span>6<\/span>);<\/span><\/p>\n

# cat \/data\/mysql\/mysqla-slow.log<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u3010\u6162\u67e5\u8be2\u65e5\u5fd7\u3011<\/span><\/p>\n

\"\"<\/p>\n

mysql\u7684\u5e76\u884c\u590d\u5236<\/span><\/h3>\n

\u67e5\u770bslave\u4e2d\u7684\u7ebf\u7a0b\u4fe1\u606f<\/span><\/p>\n

mysqlb ~]<\/span>\u00a0\u00a0> show processlist;<\/span><\/p>\n

\"\"<\/p>\n

\u9ed8\u8ba4\u60c5\u51b5\u4e0bslave\u4e2d\u4f7f\u7528\u7684\u662f<\/span>sql<\/span>\u5355\u7ebf\u7a0b\u56de\u653e <\/span><\/p>\n

\u5728<\/span>master<\/span>\u4e2d\u65f6\u591a\u7528\u6237\u8bfb\u5199，\u5982\u679c\u4f7f\u7528<\/span>sql<\/span>\u5355\u7ebf\u7a0b\u56de\u653e\u90a3\u4e48\u4f1a\u9020\u6210\u7ec4\u4ece\u5ef6\u8fdf\u4e25\u91cd <\/span><\/p>\n

\u5f00\u542f<\/span>MySQL<\/span>\u7684\u591a\u7ebf\u7a0b\u56de\u653e\u53ef\u4ee5\u89e3\u51b3\u4e0a\u8ff0\u95ee\u9898<\/span><\/p>\n

# vim \/etc\/my.cnf<\/span><\/p>\n

slave-parallel-type=LOGICAL_CLOCK <\/span>\u00a0\u00a0\u00a0\u00a0#\u57fa\u4e8e\u7ec4\u63d0\u4ea4， <\/span><\/p>\n

slave-parallel-workers=6<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#<\/span>\u5f00\u542f\u7ebf\u7a0b\u6570\u91cf <\/span><\/p>\n

relay_log_recovery=ON <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#<\/span>\u65e5\u5fd7\u56de\u653e\u6062\u590d\u529f\u80fd\u5f00\u542f<\/span><\/p>\n

# \/etc\/init.d\/mysqld restart<\/span><\/p>\n

> show processlist;<\/span>\u00a0\u00a0\u00a0## \u67e5\u770b\u7ed3\u679c：<\/span><\/p>\n

\"\"<\/p>\n

\u4e09\u4e2a\u7ebf\u7a0b <\/span><\/h4>\n

\u00a0\u00a0\u00a0\u00a0\u5b9e\u9645\u4e0a\u4e3b\u4ece\u540c\u6b65\u7684\u539f\u7406\u5c31\u662f\u57fa\u4e8e binlog <\/span>\u8fdb\u884c\u6570\u636e\u540c\u6b65\u7684\u3002\u5728\u4e3b\u4ece\u590d\u5236\u8fc7\u7a0b\u4e2d，\u4f1a\u57fa\u4e8e<\/span>3 <\/span>\u4e2a\u7ebf\u7a0b\u6765\u64cd\u4f5c，\u4e00\u4e2a\u4e3b\u5e93\u7ebf\u7a0b，\u4e24\u4e2a\u4ece\u5e93\u7ebf\u7a0b\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8f6c\u50a8\u7ebf\u7a0b（<\/span>Binlog dump thread<\/span>）\u662f\u4e00\u4e2a\u4e3b\u5e93\u7ebf\u7a0b\u3002\u5f53\u4ece\u5e93\u7ebf\u7a0b\u8fde\u63a5\u7684\u65f6\u5019， \u4e3b\u5e93\u53ef\u4ee5\u5c06\u4e8c\u8fdb\u5236\u65e5\u5fd7\u53d1\u9001\u7ed9\u4ece\u5e93，\u5f53\u4e3b\u5e93\u8bfb\u53d6\u4e8b\u4ef6（<\/span>Event<\/span>）\u7684\u65f6\u5019，\u4f1a\u5728<\/span>\u00a0Binlog <\/span>\u4e0a\u52a0\u9501，\u8bfb\u53d6\u5b8c\u6210\u4e4b\u540e，\u518d\u5c06\u9501\u91ca\u653e\u6389\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4ece\u5e93<\/span>\u00a0I\/O <\/span>\u7ebf\u7a0b\u4f1a\u8fde\u63a5\u5230\u4e3b\u5e93，\u5411\u4e3b\u5e93\u53d1\u9001\u8bf7\u6c42\u66f4\u65b0<\/span>\u00a0Binlog<\/span>\u3002\u8fd9\u65f6\u4ece\u5e93\u7684<\/span>\u00a0I\/O <\/span>\u7ebf\u7a0b\u5c31\u53ef\u4ee5\u8bfb\u53d6\u5230\u4e3b\u5e93\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8f6c\u50a8\u7ebf\u7a0b\u53d1\u9001\u7684<\/span>\u00a0Binlog <\/span>\u66f4\u65b0\u90e8\u5206，\u5e76\u4e14\u62f7\u8d1d\u5230\u672c\u5730\u7684\u4e2d\u7ee7\u65e5\u5fd7 （<\/span>Relay log<\/span>）\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4ece\u5e93<\/span>\u00a0SQL <\/span>\u7ebf\u7a0b\u4f1a\u8bfb\u53d6\u4ece\u5e93\u4e2d\u7684\u4e2d\u7ee7\u65e5\u5fd7，\u5e76\u4e14\u6267\u884c\u65e5\u5fd7\u4e2d\u7684\u4e8b\u4ef6，\u5c06\u4ece\u5e93\u4e2d\u7684\u6570\u636e\u4e0e\u4e3b\u5e93\u4fdd\u6301\u540c\u6b65\u3002 <\/span><\/p>\n

\u590d\u5236\u4e09\u6b65\u9aa4<\/span><\/h4>\n

\u6b65\u9aa41<\/span>：<\/span>Master<\/span>\u5c06\u5199\u64cd\u4f5c\u8bb0\u5f55\u5230\u4e8c\u8fdb\u5236\u65e5\u5fd7（<\/span>binlog<\/span>）\u3002<\/span><\/p>\n

\u6b65\u9aa4<\/span>2<\/span>：<\/span>Slave<\/span>\u5c06<\/span>Master<\/span>\u7684<\/span>binary log events<\/span>\u62f7\u8d1d\u5230\u5b83\u7684\u4e2d\u7ee7\u65e5\u5fd7（<\/span>relay log<\/span>）； <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u6b65\u9aa4<\/span>3<\/span>：<\/span>Slave<\/span>\u91cd\u505a\u4e2d\u7ee7\u65e5\u5fd7\u4e2d\u7684\u4e8b\u4ef6，\u5c06\u6539\u53d8\u5e94\u7528\u5230\u81ea\u5df1\u7684\u6570\u636e\u5e93\u4e2d\u3002<\/span>\u00a0MySQL<\/span>\u590d\u5236\u662f\u5f02\u6b65\u7684\u4e14\u4e32\u884c\u5316\u7684，\u800c\u4e14\u91cd\u542f\u540e\u4ece\u63a5\u5165\u70b9\u5f00\u59cb\u590d\u5236\u3002 <\/span><\/p>\n

\u5177\u4f53\u64cd\u4f5c <\/span><\/h4>\n

\u00a0\u00a0\u00a0\u00a01.slaves<\/span>\u7aef\u4e2d\u8bbe\u7f6e\u4e86<\/span>master<\/span>\u7aef\u7684<\/span>ip<\/span>，\u7528\u6237，\u65e5\u5fd7，\u548c\u65e5\u5fd7\u7684<\/span>Position<\/span>，\u901a\u8fc7\u8fd9\u4e9b\u4fe1\u606f\u53d6\u5f97<\/span>master<\/span>\u7684\u8ba4\u8bc1\u53ca\u4fe1\u606f <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a02.master<\/span>\u7aef\u5728\u8bbe\u5b9a\u597d<\/span>binlog<\/span>\u542f\u52a8\u540e\u4f1a\u5f00\u542f<\/span>binlog dump<\/span>\u7684\u7ebf\u7a0b <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a03.master<\/span>\u7aef\u7684<\/span>binlog dump<\/span>\u628a\u4e8c\u8fdb\u5236\u7684\u66f4\u65b0\u53d1\u9001\u5230<\/span>slave<\/span>\u7aef\u7684 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a04.slave<\/span>\u7aef\u5f00\u542f\u4e24\u4e2a\u7ebf\u7a0b，\u4e00\u4e2a\u662f<\/span>I\/O<\/span>\u7ebf\u7a0b，\u4e00\u4e2a\u662f<\/span>sql<\/span>\u7ebf\u7a0b， <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0i\/o<\/span>\u7ebf\u7a0b\u7528\u4e8e\u63a5\u6536<\/span>master<\/span>\u7aef\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7，\u6b64\u7ebf\u7a0b\u4f1a\u5728\u672c\u5730\u6253\u5f00<\/span>relaylog<\/span>\u4e2d\u7ee7\u65e5\u5fd7，\u5e76\u4e14\u4fdd\u5b58\u5230\u672c\u5730\u78c1\u76d8 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sql<\/span>\u7ebf\u7a0b\u8bfb\u53d6\u672c\u5730<\/span>relog<\/span>\u4e2d\u7ee7\u65e5\u5fd7\u8fdb\u884c\u56de\u653e <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a05.<\/span>\u4ec0\u4e48\u65f6\u5019\u6211\u4eec\u9700\u8981\u591a\u4e2a<\/span>slave<\/span>？ <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5f53\u8bfb\u53d6\u7684\u800c\u64cd\u4f5c\u8fdc\u8fdc\u9ad8\u4e0e\u5199\u64cd\u4f5c\u65f6\u3002\u6211\u4eec\u91c7\u7528\u4e00\u4e3b\u591a\u4ece\u67b6\u6784 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u6570\u636e\u5e93\u5916\u5c42\u63a5\u5165\u8d1f\u8f7d\u5747\u8861\u5c42\u5e76\u642d\u914d\u9ad8\u53ef\u7528\u673a\u5236<\/span><\/p>\n

\u67b6\u6784\u7f3a\u9677 <\/span><\/h3>\n

\u00a0\u00a0\u00a0\u00a0\u4e3b\u4ece\u67b6\u6784\u91c7\u7528\u7684\u662f\u5f02\u6b65\u673a\u5236 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0master\u66f4\u65b0\u5b8c\u6210\u540e\u76f4\u63a5\u53d1\u9001\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5230<\/span>slave<\/span>，\u4f46\u662f<\/span>slaves<\/span>\u662f\u5426\u771f\u6b63\u4fdd\u5b58\u4e86\u6570\u636e<\/span>master<\/span>\u7aef\u4e0d\u4f1a\u68c0\u6d4b<\/span>master<\/span>\u7aef\u76f4\u63a5\u4fdd\u5b58\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5230\u78c1\u76d8 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5f53<\/span>master<\/span>\u7aef\u5230<\/span>slave<\/span>\u7aef\u7684\u7f51\u7edc\u51fa\u73b0\u95ee\u9898\u65f6\u6216\u8005<\/span>master<\/span>\u7aef\u76f4\u63a5\u6302\u6389，\u4e8c\u8fdb\u5236\u65e5\u5fd7\u53ef\u80fd\u6839\u672c\u6ca1\u6709\u5230\u8fbe<\/span>slave<\/span>\u00a0master<\/span>\u51fa\u73b0\u95ee\u9898<\/span>slave<\/span>\u7aef\u63a5\u7ba1<\/span>master<\/span>，\u8fd9\u4e2a\u8fc7\u7a0b\u4e2d\u6570\u636e\u5c31\u4e22\u5931\u4e86 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u8fd9\u6837\u7684\u95ee\u9898\u51fa\u73b0\u5c31\u65e0\u6cd5\u8fbe\u5230\u6570\u636e\u7684\u5f3a\u4e00\u81f4\u6027，\u96f6\u6570\u636e\u4e22\u5931<\/span><\/p>\n

\u534a\u540c\u6b65\u6a21\u5f0f<\/span><\/h3>\n

\"\"<\/p>\n

1.\u7528\u6237\u7ebf\u7a0b\u5199\u5165\u5b8c\u6210\u540e<\/span>master<\/span>\u4e2d\u7684<\/span>dump<\/span>\u4f1a\u628a\u65e5\u5fd7\u63a8\u9001\u5230<\/span>slave<\/span>\u7aef <\/span><\/p>\n

2.slave<\/span>\u4e2d\u7684<\/span>io<\/span>\u7ebf\u7a0b\u63a5\u6536\u540e\u4fdd\u5b58\u5230<\/span>relaylog<\/span>\u4e2d\u7ee7\u65e5\u5fd7 <\/span><\/p>\n

3.<\/span>\u4fdd\u5b58\u5b8c\u6210\u540e<\/span>slave<\/span>\u5411<\/span>master<\/span>\u7aef\u8fd4\u56de<\/span>ack <\/span><\/p>\n

4.<\/span>\u5728\u672a\u63a5\u53d7\u5230<\/span>slave<\/span>\u7684<\/span>ack<\/span>\u65f6<\/span>master<\/span>\u7aef\u65f6\u4e0d\u505a\u63d0\u4ea4\u7684，\u4e00\u76f4\u5904\u4e8e\u7b49\u5f85\u5f53\u6536\u5230<\/span>ack<\/span>\u540e\u63d0\u4ea4\u5230\u5b58\u50a8\u5f15\u64ce <\/span><\/p>\n

5.<\/span>\u5728<\/span>5.6<\/span>\u7248\u672c\u4e2d\u7528\u5230\u7684<\/span>after_commit<\/span>\u6a21\u5f0f\u65f6\u5148\u63d0\u4ea4\u5728\u7b49\u5f85<\/span>ack<\/span>\u8fd4\u56de\u540e\u8f93\u51fa<\/span>ok<\/span><\/p>\n

gtid\u6a21\u5f0f <\/span><\/h3>\n

\u5f53\u4e3a\u542f\u7528gtid\u65f6\u6211\u4eec\u8981\u8003\u8651\u7684\u95ee\u9898 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5728master<\/span>\u7aef\u7684\u5199\u5165\u65f6\u591a\u7528\u6237\u8bfb\u5199，\u5728<\/span>slave<\/span>\u7aef\u7684\u590d\u5236\u65f6\u5355\u7ebf\u7a0b\u65e5\u5fd7\u56de\u653e，\u6240\u4ee5<\/span>slave<\/span>\u7aef\u4e00\u5b9a\u4f1a\u5ef6\u8fdf\u4e0e<\/span>master<\/span>\u7aef <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u8fd9\u79cd\u5ef6\u8fdf\u5728<\/span>slave<\/span>\u7aef\u7684\u5ef6\u8fdf\u53ef\u80fd\u4f1a\u4e0d\u4e00\u81f4，\u5f53<\/span>master<\/span>\u6302\u6389\u540e<\/span>slave<\/span>\u63a5\u7ba1，\u4e00\u822c\u4f1a\u6311\u9009\u4e00\u4e2a\u548c<\/span>master<\/span>\u5ef6\u8fdf\u65e5\u5fd7\u6700\u63a5\u8fd1\u7684\u5145\u5f53\u65b0\u7684<\/span>master <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u90a3\u4e48\u4e3a\u63a5\u7ba1<\/span>master<\/span>\u7684\u4e3b\u673a\u7ee7\u7eed\u5145\u5f53<\/span>slave<\/span>\u89d2\u8272\u5e76\u4f1a\u6307\u5411\u5230\u65b0\u7684<\/span>master<\/span>\u4e0a，\u4f5c\u4e3a\u5176<\/span>slave <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u8fd9\u65f6\u5019\u6309\u7167\u4e4b\u524d\u7684\u914d\u7f6e\u6211\u4eec\u9700\u8981\u77e5\u9053\u65b0\u7684<\/span>master<\/span>\u4e0a\u7684<\/span>pos<\/span>\u7684<\/span>id<\/span>，\u4f46\u662f\u6211\u4eec\u65e0\u6cd5\u786e\u5b9a\u65b0\u7684<\/span>master<\/span>\u548c<\/span>slave<\/span>\u4e4b\u95f4\u5dee\u591a\u5c11<\/span><\/p>\n

mysqla ]<\/span># vim \/etc\/my.cnf<\/span><\/p>\n

[mysqld] <\/span><\/p>\n

datadir=\/data\/mysql <\/span><\/p>\n

socket=\/data\/mysql\/mysql.sock <\/span><\/p>\n

server-id=1<\/span>0<\/span>\u00a0<\/p>\n

log-bin=mysql-bin <\/span><\/p>\n

gtid_mode=ON <\/span><\/p>\n

enforce-gtid-consistency=ON<\/span><\/p>\n

# mysql -uroot -plee<\/span><\/p>\n

> SHOW VARIABLES LIKE '%gtid%';<\/span><\/p>\n

\"\"<\/p>\n

> <\/span>CREATE DATABASE gtid_test;<\/span><\/p>\n

> <\/span>USE gtid_test;<\/span><\/p>\n

> <\/span>CREATE TABLE test_table(id INT);<\/span><\/p>\n

> <\/span>INSERT INTO test_table VALUES(1);<\/span><\/p>\n

> <\/span>SHOW MASTER STATUS;<\/span><\/p>\n

> <\/span>SELECT * FROM mysql.gtid_executed;<\/span><\/p>\n

\"\"<\/p>\n

mysqlb ]<\/span># vim \/etc\/my.cnf<\/span><\/p>\n

[mysqld] <\/span><\/p>\n

datadir=\/data\/mysql <\/span><\/p>\n

socket=\/data\/mysql\/mysql.sock <\/span><\/p>\n

server-id=<\/span>20<\/span>\u00a0<\/p>\n

log-bin=mysql-bin <\/span><\/p>\n

gtid_mode=ON <\/span><\/p>\n

enforce-gtid-consistency=ON<\/span><\/p>\n

# mysql -uroot -plee<\/span><\/p>\n

> stop slave;<\/span><\/p>\n

><\/span>\u00a0RESET SLAVE ALL; <\/span><\/p>\n

> <\/span>CHANGE MASTER TO MASTER_HOST='172.25.254.10', MASTER_USER='<\/span>lee<\/span>', MASTER_PASSWORD='lee', MASTER_AUTO_POSITION=1;<\/span><\/p>\n

> START SLAVE;<\/span><\/p>\n

> SHOW SLAVE STATUS\\\\G<\/span><\/p>\n

\"\"<\/p>\n

\u542f\u7528\u534a\u540c\u6b65\u6a21\u5f0f <\/span><\/h3>\n

\u5728master<\/span>\u7aef\u914d\u7f6e\u542f\u7528\u534a\u540c\u6b65\u6a21\u5f0f<\/span><\/p>\n

mysqla ]<\/span># vim \/etc\/my.cnf<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0rpl_semi_sync_master_enabled=1<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0#\u5f00\u542f<\/span>\u4e3b\u5e93<\/span>\u534a\u540c\u6b65\u529f\u80fd<\/span><\/p>\n

# mysql -p lee<\/span><\/p>\n

> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';<\/span>\u00a0\u00a0\u00a0##\u914d\u7f6e\u534a\u540c\u6b65<\/span><\/p>\n

> show plugins;<\/span>\u00a0\u00a0\u00a0\u00a0##\u67e5\u770b\u534a\u540c\u6b65<\/span><\/p>\n

\"\"<\/p>\n

> SET GLOBAL rpl_semi_sync_master_enabled = 1; <\/span>\u00a0\u00a0##\u8bbe\u5b9a\u5168\u5c40\u914d\u7f6e<\/span><\/p>\n

> SHOW VARIABLES LIKE 'rpl_semi_sync%'; \u00a0<\/span>\u00a0##\u67e5\u770b\u534a\u540c\u6b65\u72b6\u6001<\/span><\/p>\n

\"\"<\/p>\n

> SHOW STATUS LIKE 'Rpl_semi_sync%'; <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0##\u67e5\u770b\u540c\u6b65<\/span><\/p>\n

\u5728slave\u7aef\u5f00\u542f\u534a\u540c\u6b65\u529f\u80fd<\/span><\/h4>\n

mysql (b\u548cc) ]<\/span># vim \/etc\/my.cnf<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0rpl_semi_sync_selave_enabled=1 \u00a0\u00a0\u00a0\u00a0\u00a0#\u5f00\u542f<\/span>\u4ece\u5e93<\/span>\u534a\u540c\u6b65\u529f\u80fd<\/span><\/p>\n

# mysql -plee<\/span><\/p>\n

> INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';<\/span><\/p>\n

> SET GLOBAL rpl_semi_sync_slave_enabled =1;<\/span><\/p>\n

> SHOW VARIABLES LIKE 'rpl_semi_sync%';<\/span><\/p>\n

\"\"<\/p>\n

> STOP SLAVE IO_THREAD; <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#\u91cd\u542fio<\/span>\u7ebf\u7a0b，\u534a\u540c\u6b65\u624d\u80fd\u751f\u6548<\/span><\/p>\n

> START SLAVE IO_THREAD;<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0##\u91cd\u542fio<\/span>\u7ebf\u7a0b，\u534a\u540c\u6b65\u624d\u80fd\u751f\u6548<\/span><\/p>\n

> SHOW STATUS LIKE 'Rpl_semi_sync%';<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0#<\/span>#\u67e5\u770b\u534a\u540c\u6b65\u662f\u5426\u5f00\u542f<\/span><\/p>\n

\"\"<\/p>\n

> SHOW SLAVE STATUS\\\\G<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#<\/span>#\u67e5\u770b\u540c\u6b65<\/span><\/p>\n

\"\"<\/p>\n

\u6d4b\u8bd5\u5728master\u7aef\u5199\u5165\u6570\u636e<\/span><\/h4>\n

mysqla ]<\/span># mysql -plee<\/span><\/p>\n

> insert into lee.userlist values ('user4','123');<\/span>\u00a0\u00a0\u00a0#<\/span>#\u8f93\u5165\u5185\u5bb9<\/span><\/p>\n

> SHOW STATUS LIKE 'Rpl_semi_sync%';<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#<\/span>#\u67e5\u770b\u72b6\u6001<\/span><\/p>\n

\"\"<\/p>\n

\u6a21\u62df\u6545\u969c<\/span><\/h4>\n

mysql (b\u548cc) ]<\/span># mysql -plee<\/span><\/p>\n

> STOP SLAVE IO_THREAD;<\/span><\/p>\n

> insert into lee.userlist values ('user5','555');<\/span><\/p>\n

\"\"<\/p>\n

> SHOW STATUS LIKE 'Rpl_semi%';<\/span><\/p>\n

\"\"<\/p>\n

mysql\u9ad8\u53ef\u7528\u4e4b\u7ec4\u590d\u5236<\/span>\u00a0(MGR) <\/span><\/h3>\n

\u00a0\u00a0\u00a0\u00a0MySQL Group Replication(\u7b80\u79f0<\/span>\u00a0MGR )<\/span>\u662f<\/span>\u00a0MySQL <\/span>\u5b98\u65b9\u4e8e<\/span>\u00a02016 <\/span>\u5e74<\/span>\u00a012 <\/span>\u6708\u63a8\u51fa\u7684\u4e00\u4e2a\u5168\u65b0\u7684\u9ad8\u53ef\u7528\u4e0e\u9ad8\u6269\u5c55\u7684\u89e3\u51b3\u65b9\u6848 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u7ec4\u590d\u5236\u662f<\/span>\u00a0MySQL 5.7.17 <\/span>\u7248\u672c\u51fa\u73b0\u7684\u65b0\u7279\u6027，\u5b83\u63d0\u4f9b\u4e86\u9ad8\u53ef\u7528\u3001\u9ad8\u6269\u5c55\u3001\u9ad8\u53ef\u9760\u7684<\/span>\u00a0MySQL <\/span>\u96c6\u7fa4\u670d\u52a1<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MySQL <\/span>\u7ec4\u590d\u5236\u5206\u5355\u4e3b\u6a21\u5f0f\u548c\u591a\u4e3b\u6a21\u5f0f，\u4f20\u7edf<\/span>mysql<\/span>\u590d\u5236\u6280\u672f\u4ec5\u89e3\u51b3\u4e86\u6570\u636e\u540c\u6b65\u7684\u95ee\u9898 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MGR <\/span>\u5bf9\u5c5e\u4e8e\u540c\u4e00\u7ec4\u7684\u670d\u52a1\u5668\u81ea\u52a8\u8fdb\u884c\u534f\u8c03\u3002\u5bf9\u4e8e\u8981\u63d0\u4ea4\u7684\u4e8b\u52a1，\u7ec4\u6210\u5458\u5fc5\u987b\u5c31\u5168\u5c40\u4e8b\u52a1\u5e8f\u5217\u4e2d\u7ed9\u5b9a\u4e8b\u52a1\u7684\u987a\u5e8f\u8fbe\u6210\u4e00\u81f4 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u63d0\u4ea4\u6216\u56de\u6eda\u4e8b\u52a1\u7531\u6bcf\u4e2a\u670d\u52a1\u5668\u5355\u72ec\u5b8c\u6210，\u4f46\u6240\u6709\u670d\u52a1\u5668\u90fd\u5fc5\u987b\u505a\u51fa\u76f8\u540c\u7684\u51b3\u5b9a <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5982\u679c\u5b58\u5728\u7f51\u7edc\u5206\u533a，\u5bfc\u81f4\u6210\u5458\u65e0\u6cd5\u8fbe\u6210\u4e8b\u5148\u5b9a\u4e49\u7684\u5206\u5272\u7b56\u7565，\u5219\u5728\u89e3\u51b3\u6b64\u95ee\u9898\u4e4b\u524d\u7cfb\u7edf\u4e0d\u4f1a\u7ee7\u7eed\u8fdb\u884c，\u8fd9\u662f\u4e00\u79cd\u5185\u7f6e\u7684\u81ea\u52a8\u88c2\u8111\u4fdd\u62a4\u673a\u5236 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MGR<\/span>\u7531\u7ec4\u901a\u4fe1\u7cfb\u7edf<\/span>( <\/span>Group Communication System ，<\/span>GCS ) <\/span>\u534f\u8bae\u652f\u6301 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u8be5\u7cfb\u7edf\u63d0\u4f9b\u6545\u969c\u68c0\u6d4b\u673a\u5236\u3001\u7ec4\u6210\u5458\u670d\u52a1\u4ee5\u53ca\u5b89\u5168\u4e14\u6709\u5e8f\u7684\u6d88\u606f\u4f20\u9012<\/span><\/p>\n

\u7ec4\u590d\u5236\u6d41\u7a0b<\/span><\/h4>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u9996\u5148\u6211\u4eec\u5c06\u591a\u4e2a\u8282\u70b9\u5171\u540c\u7ec4\u6210\u4e00\u4e2a\u590d\u5236\u7ec4，\u5728\u6267\u884c\u8bfb\u5199（RW<\/span>）\u4e8b\u52a1\u7684\u65f6\u5019，\u9700\u8981\u901a\u8fc7\u4e00\u81f4\u6027\u534f\u8bae\u5c42（<\/span>Consensus <\/span>\u5c42）\u7684\u540c\u610f，\u4e5f\u5c31\u662f\u8bfb\u5199\u4e8b\u52a1\u60f3\u8981\u8fdb\u884c\u63d0\u4ea4，\u5fc5\u987b\u8981\u7ecf\u8fc7\u7ec4\u91cc<\/span>\u201c<\/span>\u5927\u591a\u6570\u4eba<\/span>\u201d<\/span>（\u5bf9\u5e94<\/span>\u00a0Node <\/span>\u8282\u70b9）\u7684\u540c\u610f，\u5927\u591a\u6570\u6307\u7684\u662f\u540c\u610f\u7684\u8282\u70b9\u6570\u91cf\u9700\u8981\u5927\u4e8e （<\/span>N\/2+1<\/span>），\u8fd9\u6837\u624d\u53ef\u4ee5\u8fdb\u884c\u63d0\u4ea4，\u800c\u4e0d\u662f\u539f\u53d1\u8d77\u65b9\u4e00\u4e2a\u8bf4\u4e86\u7b97\u3002\u800c\u9488\u5bf9\u53ea\u8bfb（<\/span>RO<\/span>）\u4e8b\u52a1\u5219\u4e0d\u9700\u8981\u7ecf\u8fc7\u7ec4\u5185\u540c\u610f，\u76f4\u63a5 \u63d0\u4ea4 \u5373\u53ef<\/span><\/p>\n

\u7ec4\u590d\u5236\u5355\u4e3b\u548c\u591a\u4e3b\u6a21\u5f0f<\/span><\/h3>\n

single-primary mode(\u5355\u5199\u6216\u5355\u4e3b\u6a21\u5f0f) <\/span><\/h4>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5355\u5199\u6a21\u5f0f group <\/span>\u5185\u53ea\u6709\u4e00\u53f0\u8282\u70b9\u53ef\u5199\u53ef\u8bfb，\u5176\u4ed6\u8282\u70b9\u53ea\u53ef\u4ee5\u8bfb\u3002\u5f53\u4e3b\u670d\u52a1\u5668\u5931\u8d25\u65f6，\u4f1a\u81ea\u52a8\u9009\u62e9\u65b0\u7684\u4e3b\u670d\u52a1\u5668<\/span><\/p>\n

multi-primary mode(\u591a\u5199\u6216\u591a\u4e3b\u6a21\u5f0f) <\/span><\/h4>\n

\"\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u7ec4\u5185\u7684\u6240\u6709\u673a\u5668\u90fd\u662f primary <\/span>\u8282\u70b9，\u540c\u65f6\u53ef\u4ee5\u8fdb\u884c\u8bfb\u5199\u64cd\u4f5c，\u5e76\u4e14\u6570\u636e\u662f\u6700\u7ec8\u4e00\u81f4\u7684\u3002<\/span><\/p>\n

\u5b9e\u73b0mysql\u7ec4<\/span>\u590d\u5236<\/span><\/h3>\n

\u00a0\u00a0\u00a0\u00a0\u4e3a\u4e86\u907f\u514d\u51fa\u9519，\u5728\u6240\u6709\u8282\u70b9\u4e2d\u4ece\u65b0\u751f\u6210\u6570\u636e\u5e93\u6570\u636e<\/span><\/p>\n

\u7f16\u8f91\u4e3b\u914d\u7f6e\u6587\u4ef6<\/span><\/h4>\n

\u6240\u6709mysql ]<\/span># vim \/etc\/hosts<\/span><\/p>\n

\"\"<\/p>\n

mysqla ]<\/span># rm -fr \/data\/mysql\/<\/span><\/p>\n

# vim \/etc\/my.cnf<\/span><\/p>\n

[mysqld]<\/p>\n

server-id=10<\/p>\n

datadir=\/data\/mysql<\/p>\n

socket=\/data\/mysql\/mysql.sock<\/p>\n

default_authentication_plugin=mysql_native_password<\/p>\n

log-bin=mysql-bin<\/p>\n

gtid_mode=ON<\/p>\n

enforce-gtid-consistency=ON<\/p>\n

disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" #\u7981\u7528\u6307\u5b9a\u5b58\u50a8\u5f15\u64ce<\/p>\n

binlog_checksum=NONE \u00a0\u00a0\u00a0#\u7981\u6b62\u5bf9\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6821\u9a8c<\/p>\n

log_slave_updates=ON \u00a0\u00a0\u00a0#\u6253\u5f00\u6570\u636e\u5e93\u4e2d\u7ee7，<\/p>\n

binlog_format=ROW \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#\u4f7f\u7528\u884c\u65e5\u5fd7\u683c\u5f0f<\/p>\n

transaction_write_set_extraction=XXHASH64\u00a0\u00a0\u00a0\u00a0\u00a0#\u628a\u6bcf\u4e2a\u4e8b\u4ef6\u7f16\u7801\u4e3a\u52a0\u5bc6\u6563\u5217<\/p>\n

\n

# mysqld –user=mysql –initialize <\/span><\/p>\n

# <\/span>vim \/etc\/my.cnf<\/span><\/p>\n

##\u6dfb\u52a0\u5185\u5bb9<\/span><\/p>\n

plugin_load_add='group_replication.so' #\u52a0\u8f7d\u7ec4\u590d\u5236\u63d2\u4ef6<\/p>\n

group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" #\u901a\u77e5\u63d2\u4ef6\u6b63\u5f0f\u52a0\u5165<\/p>\n

group_replication_start_on_boot=off \u00a0\u00a0\u00a0#\u5728server\u542f\u52a8\u65f6\u4e0d\u81ea\u52a8\u542f\u52a8\u7ec4\u590d\u5236<\/p>\n

group_replication_local_address="172.25.254.10:33061" #\u6307\u5b9a\u63d2\u4ef6\u63a5\u53d7\u5176\u4ed6\u6210\u5458\u4fe1\u606f\u7aef\u53e3<\/p>\n

group_replication_group_seeds="172.25.254.10:33061,172.25.254.20:33061,172.25.254.30:33061" \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#\u672c\u5730\u5730\u5740\u5141\u8bb8\u8bbf\u95ee\u6210\u5458\u5217\u8868<\/p>\n

group_replication_ip_whitelist="172.25.254.0\/24,127.0.0.1\/8" \u00a0\u00a0\u00a0#\u4e3b\u673a\u767d\u540d\u5355<\/p>\n

group_replication_bootstrap_group=off \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#\u4e0d\u968f\u7cfb\u7edf\u81ea\u542f\u800c\u542f\u52a8<\/p>\n

group_replication_single_primary_mode=OFF \u00a0\u00a0\u00a0#\u4f7f\u7528\u591a\u4e3b\u6a21\u5f0f<\/p>\n

group_replication_enforce_update_everywhere_checks=ON \u00a0\u00a0#\u7ec4\u540c\u6b65\u4e2d\u6709\u4efb\u4f55\u6539\u53d8\u68c0\u6d4b\u66f4\u65b0<\/p>\n

\n

# \/etc\/init.d\/mysqld start<\/span><\/p>\n

# mysql -uroot -p<\/span>'<\/span>\u521d\u59cb\u5316\u7684\u5bc6\u7801<\/span>'<\/span><\/p>\n

><\/span>\u00a0ALTER USER 'root'@'localhost' IDENTIFIED BY 'lee';<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0##\u66f4\u6539\u5bc6\u7801<\/span><\/p>\n

> FLUSH PRIVILEGES;<\/span><\/p>\n

> SET SQL_LOG_BIN=0;<\/span><\/p>\n

> CREATE USER rpl_user@'%' IDENTIFIED BY 'lee';<\/span><\/p>\n

> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%';<\/span><\/p>\n

> GRANT CONNECTION_ADMIN ON *.* TO rpl_user@'%';<\/span><\/p>\n

> GRANT BACKUP_ADMIN ON *.* TO rpl_user@'%';<\/span><\/p>\n

> GRANT GROUP_REPLICATION_STREAM ON *.* TO rpl_user@'%';<\/span><\/p>\n

> FLUSH PRIVILEGES;<\/span><\/p>\n

> SET SQL_LOG_BIN=1;<\/span><\/p>\n

> reset master;<\/span><\/p>\n

> CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='lee' FOR CHANNEL 'group_replication_recovery'; \u00a0\u00a0\u00a0<\/span><\/p>\n

> SET GLOBAL group_replication_bootstrap_group=ON;<\/span><\/p>\n

> START GROUP_REPLICATION USER='rpl_user', PASSWORD='lee';<\/span><\/p>\n

> SET GLOBAL group_replication_bootstrap_group=OFF;<\/span><\/p>\n

> SELECT * FROM performance_schema.replication_group_members;<\/span><\/p>\n

\"\"<\/p>\n

mysql （b\u548cc） ]<\/span># rm -fr \/data\/mysql\/<\/span><\/p>\n

# v<\/span>im \/etc\/my.cnf<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0##\u548cmysqla\u76f8\u540c\u914d\u7f6e，\u8fd9\u4e2a\u4e5f\u4e00\u6837 <\/span>server-id=10<\/p>\n

# mysqld –user=mysql –initialize <\/span><\/p>\n

# <\/span>vim \/etc\/my.cnf<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0group_replication_local_address="172.25.254.2<\/span>0:33061"\u00a0\u00a0\u00a0\u00a0#\u8fd9\u4e2a\u4e0d\u540c\u5176\u4f59\u76f8\u540c，<\/p>\n

# \/etc\/init.d\/mysqld start<\/span><\/p>\n

# mysql -uroot -p<\/span>'<\/span>\u521d\u59cb\u5316\u7684\u5bc6\u7801<\/span>'<\/span><\/p>\n

><\/span>\u00a0ALTER USER 'root'@'localhost' IDENTIFIED BY 'lee';<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0##\u66f4\u6539\u5bc6\u7801<\/span><\/p>\n

> FLUSH PRIVILEGES;<\/span><\/p>\n

> SET SQL_LOG_BIN=0;<\/span><\/p>\n

> CREATE USER rpl_user@'%' IDENTIFIED BY 'lee';<\/span><\/p>\n

> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%';<\/span><\/p>\n

> GRANT CONNECTION_ADMIN ON *.* TO rpl_user@'%';<\/span><\/p>\n

> GRANT BACKUP_ADMIN ON *.* TO rpl_user@'%';<\/span><\/p>\n

> GRANT GROUP_REPLICATION_STREAM ON *.* TO rpl_user@'%';<\/span><\/p>\n

> FLUSH PRIVILEGES;<\/span><\/p>\n

> SET SQL_LOG_BIN=1;<\/span><\/p>\n

> reset master;<\/span><\/p>\n

> CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='lee' FOR CHANNEL 'group_replication_recovery';<\/span><\/p>\n

> START GROUP_REPLICATION USER='rpl_user', PASSWORD='lee';<\/span><\/p>\n

> SELECT * FROM performance_schema.replication_group_members;<\/span><\/p>\n

mysqla ]<\/span># mysql -plee<\/span><\/p>\n

> CREATE DATABASE lee;<\/span><\/p>\n

> CREATE TABLE lee.userlist( username VARCHAR(10) PRIMARY KEY NOT NULL, password VARCHAR(50) NOT NULL );<\/span><\/p>\n

> INSERT INTO lee.userlist VALUES ('user1','111');<\/span><\/p>\n

> SELECT * FROM lee.userlist;<\/span><\/p>\n

\"\"<\/p>\n

mysqla ]<\/span># mysql -plee<\/span><\/p>\n

> INSERT INTO lee.userlist values ('user2','222');<\/span><\/p>\n

> select * from lee.userlist;<\/span><\/p>\n

\"\"<\/p>\n

mysql\u9ad8\u53ef\u7528\u4e4bMHA<\/span><\/h3>\n

\"\"<\/p>\n

\u4ec0\u4e48\u662f MHA<\/span><\/h4>\n

\u00a0\u00a0\u00a0\u00a0MHA（Master High Availability<\/span>）\u662f\u4e00\u5957\u4f18\u79c0\u7684<\/span>MySQL<\/span>\u9ad8\u53ef\u7528\u73af\u5883\u4e0b\u6545\u969c\u5207\u6362\u548c\u4e3b\u4ece\u590d\u5236\u7684\u8f6f\u4ef6\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MHA <\/span>\u7684\u51fa\u73b0\u5c31\u662f\u89e3\u51b3<\/span>MySQL <\/span>\u5355\u70b9\u7684\u95ee\u9898\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MySQL<\/span>\u6545\u969c\u5207\u6362\u8fc7\u7a0b\u4e2d，<\/span>MHA<\/span>\u80fd\u505a\u5230<\/span>0-30<\/span>\u79d2\u5185\u81ea\u52a8\u5b8c\u6210\u6545\u969c\u5207\u6362\u64cd\u4f5c\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MHA<\/span>\u80fd\u5728\u6545\u969c\u5207\u6362\u7684\u8fc7\u7a0b\u4e2d\u6700\u5927\u7a0b\u5ea6\u4e0a\u4fdd\u8bc1\u6570\u636e\u7684\u4e00\u81f4\u6027，\u4ee5\u8fbe\u5230\u771f\u6b63\u610f\u4e49\u4e0a\u7684\u9ad8\u53ef\u7528\u3002<\/span><\/p>\n

MHA \u7684\u7ec4\u6210 <\/span><\/h4>\n

\u00a0\u00a0\u00a0\u00a0MHA\u7531\u4e24\u90e8\u5206\u7ec4\u6210:MHAManager (<\/span>\u7ba1\u7406\u8282\u70b9<\/span>) MHA Node (<\/span>\u6570\u636e\u5e93\u8282\u70b9<\/span>), <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MHA Manager <\/span>\u53ef\u4ee5\u5355\u72ec\u90e8\u7f72\u5728\u4e00\u53f0\u72ec\u7acb\u7684\u673a\u5668\u4e0a\u7ba1\u7406\u591a\u4e2a<\/span>master-slave<\/span>\u96c6\u7fa4，\u4e5f\u53ef\u4ee5\u90e8\u7f72\u5728\u4e00\u53f0<\/span>slave <\/span>\u8282\u70b9\u4e0a\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MHA Manager <\/span>\u4f1a\u5b9a\u65f6\u63a2\u6d4b\u96c6\u7fa4\u4e2d\u7684<\/span>\u00a0master <\/span>\u8282\u70b9\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5f53<\/span>\u00a0master <\/span>\u51fa\u73b0\u6545\u969c\u65f6，\u5b83\u53ef\u4ee5\u81ea\u52a8\u5c06\u6700\u65b0\u6570\u636e\u7684<\/span>\u00a0slave <\/span>\u63d0\u5347\u4e3a\u65b0\u7684<\/span>\u00a0master<\/span>， \u7136\u540e\u5c06\u6240\u6709\u5176\u4ed6\u7684<\/span>slave <\/span>\u91cd\u65b0\u6307\u5411\u65b0\u7684<\/span>\u00a0master<\/span>\u3002 <\/span><\/p>\n

MHA \u7684\u7279\u70b9 <\/span><\/h4>\n

\u00a0\u00a0\u00a0\u00a0\u81ea\u52a8\u6545\u969c\u5207\u6362\u8fc7\u7a0b\u4e2d<\/span>，<\/span>MHA<\/span>\u4ece\u4e3b\u673a\u4e3b\u670d\u52a1\u5668\u4fdd\u5b58\u4e8c\u8fdb\u5236\u65e5\u5fd7<\/span>，<\/span>\u6700\u5927\u7a0b\u5ea6\u4fdd\u8bc1\u6570\u636e\u4e0d\u4e22\u5931 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u4f7f\u7528\u534a\u540c\u6b65\u590d\u5236，\u53ef\u4ee5\u5927\u5927\u964d\u4f4e\u6570\u636e\u4e22\u5931\u7684\u98ce\u9669，\u5982\u679c\u53ea\u6709\u4e00\u4e2a<\/span>slave<\/span>\u5df2\u7ecf\u6536\u5230\u4e86\u6700\u65b0\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7，<\/span>MHA<\/span>\u53ef\u4ee5\u5c06\u6700\u65b0\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5e94\u7528\u4e8e\u5176\u4ed6\u6240\u6709\u7684<\/span>slave<\/span>\u670d\u52a1\u5668\u4e0a，\u56e0\u6b64\u53ef\u4ee5\u4fdd\u8bc1\u6240\u6709\u8282\u70b9\u7684\u6570\u636e\u4e00\u81f4\u6027 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u76ee\u524d<\/span>MHA<\/span>\u652f\u6301\u4e00\u4e3b\u591a\u4ece\u67b6\u6784，\u6700\u5c11\u4e09\u53f0\u670d\u52a1，\u5373\u4e00\u4e3b\u4e24\u4ece<\/span><\/p>\n

\u6545\u969c\u5207\u6362\u5907\u9009\u4e3b\u5e93\u7684\u7b97\u6cd5 <\/span><\/h4>\n

1．\u4e00\u822c\u5224\u65ad\u4ece\u5e93\u7684\u662f\u4ece（position\/GTID<\/span>）\u5224\u65ad\u4f18\u52a3，\u6570\u636e\u6709\u5dee\u5f02，\u6700\u63a5\u8fd1\u4e8e<\/span>master<\/span>\u7684<\/span>slave<\/span>，\u6210\u4e3a\u5907\u9009\u4e3b\u3002 <\/span><\/p>\n

2<\/span>．\u6570\u636e\u4e00\u81f4\u7684\u60c5\u51b5\u4e0b，\u6309\u7167\u914d\u7f6e\u6587\u4ef6\u987a\u5e8f，\u9009\u62e9\u5907\u9009\u4e3b\u5e93\u3002 <\/span><\/p>\n

3<\/span>．\u8bbe\u5b9a\u6709\u6743\u91cd（<\/span>candidate_master=1<\/span>），\u6309\u7167\u6743\u91cd\u5f3a\u5236\u6307\u5b9a\u5907\u9009\u4e3b\u3002 <\/span><\/p>\n

\u00a0（<\/span>1<\/span>）\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5982\u679c\u4e00\u4e2a<\/span>slave<\/span>\u843d\u540e<\/span>master 100M<\/span>\u7684<\/span>relay logs<\/span>\u7684\u8bdd，\u5373\u4f7f\u6709\u6743\u91cd\u4e5f\u4f1a\u5931\u6548\u3002 <\/span><\/p>\n

\u00a0（<\/span>2<\/span>）\u5982\u679c<\/span>check_repl_delay=0<\/span>\u7684\u8bdd，\u5373\u4f7f\u843d\u540e\u5f88\u591a\u65e5\u5fd7，\u4e5f\u5f3a\u5236\u9009\u62e9\u5176\u4e3a\u5907\u9009\u4e3b\u3002<\/span>MHA<\/span><\/p>\n

\u5de5\u4f5c\u539f\u7406 <\/span><\/h4>\n

\u00a0\u00a0\u00a0\u00a0\u76ee\u524d<\/span>MHA<\/span>\u4e3b\u8981\u652f\u6301\u4e00\u4e3b\u591a\u4ece\u7684\u67b6\u6784，\u8981\u642d\u5efa<\/span>MHA,<\/span>\u8981\u6c42\u4e00\u4e2a\u590d\u5236\u96c6\u7fa4\u5fc5\u987b\u6700\u5c11\u6709<\/span>3<\/span>\u53f0\u6570\u636e\u5e93\u670d\u52a1\u5668， <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u4e00\u4e3b\u4e8c\u4ece，\u5373\u4e00\u53f0\u5145\u5f53<\/span>Master<\/span>，\u53f0\u5145\u5f53\u5907\u7528<\/span>Master<\/span>，\u53e6\u4e00\u53f0\u5145\u5f53\u4ece\u5e93\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MHA Node <\/span>\u8fd0\u884c\u5728\u6bcf\u53f0<\/span>\u00a0MySQL <\/span>\u670d\u52a1\u5668\u4e0a <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0MHAManager <\/span>\u4f1a\u5b9a\u65f6\u63a2\u6d4b\u96c6\u7fa4\u4e2d\u7684<\/span>master <\/span>\u8282\u70b9 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5f53<\/span>master <\/span>\u51fa\u73b0\u6545\u969c\u65f6，\u5b83\u53ef\u4ee5\u81ea\u52a8\u5c06\u6700\u65b0\u6570\u636e\u7684<\/span>slave <\/span>\u63d0\u5347\u4e3a\u65b0\u7684<\/span>master <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u7136\u540e\u5c06\u6240\u6709\u5176\u4ed6\u7684<\/span>slave <\/span>\u91cd\u65b0\u6307\u5411\u65b0\u7684<\/span>master<\/span>，<\/span>VIP<\/span>\u81ea\u52a8\u6f02\u79fb\u5230\u65b0\u7684<\/span>master<\/span>\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u6574\u4e2a\u6545\u969c\u8f6c\u79fb\u8fc7\u7a0b\u5bf9\u5e94\u7528\u7a0b\u5e8f\u5b8c\u5168\u900f\u660e\u3002 <\/span><\/p>\n

MHA\u90e8\u7f72\u5b9e\u65bd <\/span><\/h3>\n

\u642d\u5efa\u4e3b\u4e24\u4ece\u67b6\u6784<\/span><\/h4>\n

\u6240\u6709\u6570\u636e\u5e93 <\/span>~]<\/span># \/etc\/init.d\/mysqld status<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010\u67e5\u770b\u6570\u636e\u5e93\u5f00\u542f\u3011<\/span><\/p>\n

> SHOW SLAVE STATUS\\\\G<\/span>;<\/span><\/p>\n

\"\"<\/p>\n

mha ~]<\/span># unzip MHA-7.zip<\/span><\/p>\n

MHA-7]<\/span># ls<\/span><\/p>\n

\"\"<\/p>\n

# yum install *.rpm -y<\/span><\/p>\n

# scp mha4mysql-node-0.58-0.el7.centos.noarch.rpm <\/span>root@172.25.254.10:\/mnt<\/span><\/p>\n

# scp mha4mysql-node-0.58-0.el7.centos.noarch.rpm <\/span>root@172.25.254.<\/span>2<\/span>0:\/mnt<\/span><\/p>\n

# scp mha4mysql-node-0.58-0.el7.centos.noarch.rpm <\/span>root@172.25.254.<\/span>3<\/span>0:\/mnt<\/span><\/p>\n

\u5728\u8f6f\u4ef6\u4e2d\u5305\u542b\u7684\u5de5\u5177\u5305\u4ecb\u7ecd <\/span><\/h4>\n

Manager\u5de5\u5177\u5305\u4e3b\u8981\u5305\u62ec\u4ee5\u4e0b\u51e0\u4e2a\u5de5\u5177： <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0masterha_check_ssh <\/span> #<\/span>\u68c0\u67e5<\/span>MHA<\/span>\u7684<\/span>SSH<\/span>\u914d\u7f6e\u72b6\u51b5 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0masterha_check_repl <\/span> #<\/span>\u68c0\u67e5<\/span>MySQL<\/span>\u590d\u5236\u72b6\u51b5 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0masterha_manger<\/span> #<\/span>\u542f\u52a8<\/span>MHA <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0masterha_check_status<\/span> #<\/span>\u68c0\u6d4b\u5f53\u524d<\/span>MHA<\/span>\u8fd0\u884c\u72b6\u6001 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0masterha_master_monitor <\/span> #<\/span>\u68c0\u6d4b<\/span>master<\/span>\u662f\u5426\u5b95\u673a <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0masterha_master_switch <\/span> #<\/span>\u63a7\u5236\u6545\u969c\u8f6c\u79fb（\u81ea\u52a8\u6216\u8005\u624b\u52a8） <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0masterha_conf_host <\/span> #<\/span>\u6dfb\u52a0\u6216\u5220\u9664\u914d\u7f6e\u7684<\/span>server<\/span>\u4fe1\u606f<\/span><\/p>\n

Node\u5de5\u5177\u5305 <\/span>（\u901a\u5e38\u7531<\/span>masterHA<\/span>\u4e3b\u673a\u76f4\u63a5\u8c03\u7528，\u65e0\u9700\u4eba\u4e3a\u6267\u884c） <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0save_binary_logs <\/span>\u00a0\u00a0\u00a0\u00a0#<\/span>\u4fdd\u5b58\u548c\u590d\u5236<\/span>master<\/span>\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0apply_diff_relay_logs <\/span>\u00a0#<\/span>\u8bc6\u522b\u5dee\u5f02\u7684\u4e2d\u7ee7\u65e5\u5fd7\u4e8b\u4ef6\u5e76\u5c06\u5176\u5dee\u5f02\u7684\u4e8b\u4ef6\u5e94\u7528\u4e8e\u5176\u4ed6\u7684<\/span>slave<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0filter_mysqlbinlog <\/span>\u00a0\u00a0\u00a0\u00a0#\u53bb\u9664\u4e0d\u5fc5\u8981\u7684ROLLBACK<\/span>\u4e8b\u4ef6（<\/span>MHA<\/span>\u5df2\u4e0d\u518d\u4f7f\u7528\u8fd9\u4e2a\u5de5\u5177） <\/span><\/p>\n

purge_relay_logs <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0#<\/span>\u6e05\u9664\u4e2d\u7ee7\u65e5\u5fd7（\u4e0d\u4f1a\u963b\u585e<\/span>SQL<\/span>\u7ebf\u7a0b）<\/span><\/p>\n

\u73af\u5883\u914d\u7f6e<\/span><\/h4>\n

mha ~]<\/span># ssh-keygen\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010\u521b\u5efa\u5bc6\u94a5\u3011<\/p>\n

# ssh-copy-id root@172.25.254.（ 10 ~ 30 ）\u00a0\u00a0\u00a0\u00a0\u3010\u514d\u5bc6\u8ba4\u8bc1\u3011<\/p>\n

# scp \/root\/.ssh\/id_rsa root@172.25.254.（ 10 ~ 30 ）:\/root\/.ssh\/<\/p>\n

# masterha_manager –help\u00a0\u00a0\u00a0\u00a0\u3010\u67e5\u770b\u914d\u7f6e\u76ee\u5f55\u548c\u914d\u7f6e\u6587\u4ef6\u3011<\/p>\n

\"\"<\/p>\n

# mkdir \/etc\/masterha<\/p>\n

# tar zxf mha4mysql-manager-0.58.tar.gz<\/p>\n

# cd mha4mysql-manager-0.58\/samples\/conf\/<\/p>\n<\/p>\n

# cat masterha_default.cnf app1.cnf > \/etc\/masterha\/app1.conf<\/p>\n

# vim \/etc\/masterha\/app1.conf<\/p>\n<\/p>\n

[server default]<\/p>\n

user=root #mysql\u7ba1\u7406\u5458\u7528\u6237，\u56e0\u4e3a\u9700\u8981\u505a\u81ea\u52a8\u5316\u914d\u7f6e<\/p>\n

password=lee #mysql\u5bc6\u7801<\/p>\n

ssh_user=root \u00a0#ssh\u8fdc\u7a0b\u767b\u9646\u7528\u6237<\/p>\n

repl_user=repl #mysql\u4e3b\u4ece\u590d\u5236\u4e2d\u8d1f\u8d23\u8ba4\u8bc1\u7684\u7528\u6237<\/p>\n

repl_password=lee \u00a0#mysql\u4e3b\u4ece\u590d\u5236\u4e2d\u8d1f\u8d23\u8ba4\u8bc1\u7684\u7528\u6237\u5bc6\u7801<\/p>\n

\n

master_binlog_dir=\/data\/mysql # mysqla \u4e8c\u8fdb\u5236\u65e5\u5fd7\u76ee\u5f55<\/p>\n

remote_workdir=\/data\/masterha\/app1 # mha\u7684\u8fdc\u7a0b\u76ee\u5f55<\/p>\n

manager_workdir=\/etc\/masterha\/app1 # mha\u7684\u5de5\u4f5c\u76ee\u5f55<\/p>\n

manager_log=\/var\/log\/masterha\/manager.log\u00a0\u00a0\u00a0# mha\u65e5\u5fd7<\/p>\n

ping_interval=3 #\u6bcf\u96943\u79d2\u68c0\u6d4b\u4e00\u6b21<\/p>\n

secondary_check_script=masterha_secondary_check -s 172.25.254.10 -s 172.25.254.11<\/p>\n

[server1]<\/p>\n

hostname=172.25.254.10<\/p>\n

candidate_master=1\u00a0\u00a0\u00a0\u00a0\u00a0 # \u4e3b\u5e93\u914d\u7f6e<\/p>\n

check_repl_delay=0 ##\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5982\u679c\u4e00\u4e2aslave\u843d\u540emaster 100M\u7684relay logs\u7684\u8bddMHA\u5c06\u4e0d\u4f1a\u9009\u62e9\u8be5slave\u4f5c\u4e3a\u4e00\u4e2a\u65b0\u7684master，\u56e0\u4e3a\u5bf9\u8fd9\u4e2aslave\u7684\u6062\u590d\u9700\u8981\u82b1\u8d39\u5f88\u957f\u65f6\u95f4<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#\u901a\u8fc7\u8bbe\u7f6echeck_repl_delay=0，MHA\u89e6\u53d1\u5207\u6362\u5728\u9009\u62e9\u4e00\u4e2a\u65b0\u7684master\u7684\u65f6\u5019\u5c06\u4f1a\u5ffd\u7565\u590d\u5236\u5ef6\u65f6<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0#\u8fd9\u4e2a\u53c2\u6570\u5bf9\u4e8e\u8bbe\u7f6e\u4e86candidate_master=1\u7684\u4e3b\u673a\u975e\u5e38\u6709\u7528，\u56e0\u4e3a\u8fd9\u4e2a\u5019\u9009\u4e3b\u5728\u5207\u6362\u7684\u8fc7\u7a0b\u4e2d\u4e00\u5b9a\u662f\u65b0\u7684master<\/p>\n

[server2]<\/p>\n

hostname=172.25.254.20<\/p>\n

candidate_master=1 # \u53ef\u80fd\u4f5c\u4e3a\u4e3b\u5e93master\u7684\u4e3b\u673a<\/p>\n

check_repl_delay=0<\/p>\n

\n

[server3]<\/p>\n

hostname=172.25.254.30<\/p>\n

no_master=1 #\u4e0d\u4f5c\u4e3amaster\u7684\u4e3b\u673a<\/p>\n

\u6240\u6709\u6570\u636e\u5e93 <\/span>~]<\/span># yum install \/mnt\/mha4mysql-node-0.58-<\/span>0.el7.centos.noarch.rpm -y<\/span><\/p>\n

> SELECT User, Host FROM mysql.user WHERE User='lee';<\/span><\/p>\n

\"\"<\/p>\n

> SHOW GRANTS FOR 'lee'@'%';<\/span><\/p>\n

\"\"<\/p>\n

mha ~]<\/span># masterha_check_ssh –conf=\/etc\/masterha\/app1.conf<\/span><\/p>\n

\"\"<\/p>\n

# <\/span>masterha_check_repl –conf=\/etc\/masterha\/app1.conf<\/span><\/p>\n

\"\"<\/p>\n

\u6240\u6709\u6570\u636e\u5e93 <\/span>~]<\/span>> GRANT ALL ON *.* TO root@'%' identified by 'lee'; <\/span>\u00a0\u00a0\u00a0\u00a0##\u5141\u8bb8root\u8fdc\u7a0b\u767b\u9646<\/p>\n

mha ~]<\/span># mysql -uroot -plee -h172.25.254.10 -e "SHOW DATABASES"<\/span><\/p>\n

\"\"<\/p>\n

MHA\u7684\u6545\u969c\u5207\u6362 <\/span><\/h3>\n

MHA\u7684\u6545\u969c\u5207\u6362\u8fc7\u7a0b\u5171\u5305\u62ec\u4ee5\u4e0b\u7684\u6b65\u9aa4： <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a01.<\/span>\u914d\u7f6e\u6587\u4ef6\u68c0\u67e5\u9636\u6bb5，\u8fd9\u4e2a\u9636\u6bb5\u4f1a\u68c0\u67e5\u6574\u4e2a\u96c6\u7fa4\u914d\u7f6e\u6587\u4ef6\u914d\u7f6e <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a02.<\/span>\u5b95\u673a\u7684<\/span>master<\/span>\u5904\u7406，\u8fd9\u4e2a\u9636\u6bb5\u5305\u62ec\u865a\u62df<\/span>ip<\/span>\u6458\u9664\u64cd\u4f5c，\u4e3b\u673a\u5173\u673a\u64cd\u4f5c <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a03.<\/span>\u590d\u5236<\/span>dead master<\/span>\u548c\u6700\u65b0<\/span>slave<\/span>\u76f8\u5dee\u7684<\/span>relay log<\/span>，\u5e76\u4fdd\u5b58\u5230<\/span>MHA Manger<\/span>\u5177\u4f53\u7684\u76ee\u5f55\u4e0b <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a04.<\/span>\u8bc6\u522b\u542b\u6709\u6700\u65b0\u66f4\u65b0\u7684<\/span>slave <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a05.<\/span>\u5e94\u7528\u4ece<\/span>master<\/span>\u4fdd\u5b58\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e8b\u4ef6（<\/span>binlog events<\/span>） <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a06.<\/span>\u63d0\u5347\u4e00\u4e2a<\/span>slave<\/span>\u4e3a\u65b0\u7684<\/span>master<\/span>\u8fdb\u884c\u590d\u5236 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a07.<\/span>\u4f7f\u5176\u4ed6\u7684<\/span>slave<\/span>\u8fde\u63a5\u65b0\u7684<\/span>master<\/span>\u8fdb\u884c\u590d\u5236<\/span><\/p>\n

master\u672a\u51fa\u73b0\u6545\u969c\u624b\u52a8\u5207\u6362<\/span><\/h4>\n

# <\/span>masterha_check_repl –conf=\/etc\/masterha\/app1.conf<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010\u8fd9\u4e2a\u548c\u4e0b\u9762\u7684\u90fd\u4e0d\u80fd\u62a5\u9519\u3011<\/span><\/p>\n

# masterha_check_ssh –conf=\/etc\/masterha\/app1.conf<\/span>\u00a0<\/p>\n

mha ~]<\/span># masterha_master_switch –conf=\/etc\/masterha\/app1.conf –master_state=alive<\/span>\u00a0–new_master_host=172.25.254.10 –new_master_port=3306 –orig_master_is_new_slave<\/span>\u00a0–running_updates_limit=10000<\/span><\/p>\n

\"\"<\/p>\n

mysqla<\/span>\u00a0~]<\/span>> SHOW SLAVE STATUS\\\\G;<\/span><\/p>\n

\"\"<\/p>\n

master\u6545\u969c\u624b\u52a8\u5207\u6362<\/span><\/h4>\n

mysqla<\/span>\u00a0~]<\/span># \/etc\/init.d\/mysqld <\/span>stop<\/span><\/p>\n

# masterha_master_switch –master_state=dead –conf=\/etc\/masterha\/app1.c<\/span>o<\/span>nf <\/span>–dead_master_host=<\/span>172.25.254.10<\/span>\u00a0–dead_master_port=3306 <\/span>–new_master_host=<\/span>172.25.254.20<\/span>\u00a0–new_master_port=3306 –ignore_last_failover<\/span><\/p>\n

\"\"<\/p>\n

\u6062\u590d\u6545\u969cmysql\u8282\u70b9<\/span><\/h4>\n

# \/etc\/init.d\/mysqld start<\/span><\/p>\n

# mysql -p<\/span>lee<\/span><\/p>\n

><\/span>\u00a0CHANGE MASTER TO MASTER_HOST='172.25.254.<\/span>2<\/span>0', MASTER_USER='lee', MASTER_PASSWORD='lee', MASTER_AUTO_POSITION=1;<\/span><\/p>\n

> start slave;<\/span><\/p>\n

> SHOW SLAVE STATUS\\\\G;<\/span><\/p>\n

\"\"<\/p>\n

\u81ea\u52a8\u5207\u6362<\/span><\/h4>\n

# cd \/etc\/masterha\/<\/span><\/p>\n

# rm -fr app1.failover.complete<\/span> \u3010<\/span>\u5220\u6389\u5207\u6362\u9501\u6587\u4ef6<\/span>\u3011 \u00a0<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u76d1\u63a7\u7a0b\u5e8f\u901a\u8fc7\u6307\u5b9a\u914d\u7f6e\u6587\u4ef6\u76d1\u63a7master\u72b6\u6001，\u5f53master\u51fa\u95ee\u9898\u540e\u81ea\u52a8\u5207\u6362\u5e76\u9000\u51fa\u907f\u514d\u91cd\u590d\u505a\u6545\u969c\u5207\u6362<\/span><\/p>\n

# masterha_manager –conf=\/etc\/masterha\/app1.c<\/span>o<\/span>nf <\/span><\/p>\n

\"\"<\/p>\n

mysqlb<\/span>\u00a0~]<\/span># \/etc\/init.d\/mysqld <\/span>stop<\/span><\/p>\n

\"\"<\/p>\n

mysqlc<\/span>\u00a0~]<\/span>> SHOW SLAVE STATUS\\\\G;<\/span><\/p>\n

\"\"<\/p>\n

\u6062\u590d\u6545\u969c\u8282\u70b9<\/span><\/h4>\n

# \/etc\/init.d\/mysqld start<\/span><\/p>\n

> CHANGE MASTER TO MASTER_HOST='172.25.254.10', MASTER_USER='lee', MASTER_PASSWORD='lee', MASTER_AUTO_POSITION=1;<\/span><\/p>\n

> start slave;<\/span><\/p>\n

> SHOW SLAVE STATUS\\\\G;<\/span><\/p>\n

\"\"<\/p>\n

\u6e05\u9664\u9501\u6587\u4ef6<\/span><\/h4>\n

# <\/span>rm -rf app1.failover.complete manager.log<\/span><\/p>\n

\n

\u4e3aMHA\u6dfb\u52a0VIP\u529f\u80fd<\/span><\/h3>\n

mha ~]<\/span># ls ma*<\/span><\/p>\n

# cp master_ip_failover master_ip_online_change \/usr\/local\/bin\/<\/span><\/p>\n

# <\/span>chmod +x \/usr\/local\/bin\/master_ip_*<\/span><\/p>\n

# vim \/etc\/masterha\/app1.conf<\/p>\n

\"\"<\/p>\n

# masterha_manager –conf=\/etc\/masterha\/app1.c<\/span>o<\/span>nf<\/span><\/p>\n

mysqla<\/span>\u00a0~]<\/span># <\/span>ip a a 172.25.254.<\/span>2<\/span>00\/24 dev eth0<\/span><\/p>\n

\u6a21\u62df\u6545\u969c<\/span><\/h4>\n

mysqla<\/span>\u00a0~]<\/span># \/etc\/init.d\/mysqld stop<\/span><\/p>\n

# cat manager.log<\/span><\/p>\n

\u6062\u590d\u6545\u969c\u4e3b\u673a<\/span><\/h4>\n

mysqla<\/span>\u00a0~]<\/span># \/etc\/init.d\/mysqld start<\/span><\/p>\n

> CHANGE MASTER TO MASTER_HOST='172.25.254.10', MASTER_USER='<\/span>lee<\/span>',<\/span>\u00a0MASTER_PASSWORD='lee', MASTER_AUTO_POSITION=1<\/span><\/p>\n

> start slave;<\/span><\/p>\n

> SHOW SLAVE STATUS\\\\G;<\/span><\/p>\n

\"\"<\/p>\n

mha ~]<\/span># rm -rf app1.failover.complete manager.log<\/span><\/p>\n

\u624b\u52a8\u5207\u6362\u540e\u67e5\u770bvip\u53d8\u5316<\/span><\/h4>\n

\u3010\u624b\u52a8\u5207\u6362\u8981\u5148\u5220\u9664\u9501\u6587\u4ef6 <\/span># rm -rf app1.failover.complete manager.log<\/span>\u00a0\u3011<\/span><\/p>\n

mha ~]<\/span># masterha_master_switch –conf=\/etc\/masterha\/app<\/span>1.conf<\/span>\u00a0–master_state=alive<\/span>\u00a0–new_master_host=172.25.254.10 –new_master_port=3306 –orig_master_is_new_slave<\/span>\u00a0–running_updates_limit=10000<\/span><\/p>\n

\"\"<\/p>\n

mysqla<\/span>\u00a0~]<\/span># mysql -plee<\/span><\/p>\n

> SHOW SLAVE STATUS\\\\G;<\/span><\/p>\n

# ip a<\/span><\/p>\n

\"\"<\/p>\n

mha ~]<\/span># ping 172.25.254.200<\/span><\/p>\n

\"\"<\/p>\n

mysql-router（mysql\u8def\u7531）<\/span><\/h3>\n

\"\"<\/p>\n

MySQL Router <\/span><\/h4>\n

\u00a0\u00a0\u00a0\u00a0\u662f\u4e00\u4e2a\u5bf9\u5e94\u7528\u7a0b\u5e8f\u900f\u660e\u7684InnoDB Cluster<\/span>\u8fde\u63a5\u8def\u7531\u670d\u52a1，\u63d0\u4f9b\u8d1f\u8f7d\u5747\u8861\u3001\u5e94\u7528\u8fde\u63a5\u6545\u969c\u8f6c\u79fb\u548c\u5ba2\u6237\u7aef\u8def\u7531\u3002 <\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u5229\u7528\u8def\u7531\u5668\u7684\u8fde\u63a5\u8def\u7531\u7279\u6027，\u7528\u6237\u53ef\u4ee5\u7f16\u5199\u5e94\u7528\u7a0b\u5e8f\u6765\u8fde\u63a5\u5230\u8def\u7531\u5668，\u5e76\u4ee4\u8def\u7531\u5668\u4f7f\u7528\u76f8\u5e94\u7684\u8def\u7531\u7b56\u7565\u6765\u5904\u7406\u8fde\u63a5，\u4f7f\u5176\u8fde\u63a5\u5230\u6b63\u786e\u7684<\/span>MySQL<\/span>\u6570\u636e\u5e93\u670d\u52a1\u5668 <\/span><\/p>\n

Mysql route\u7684\u90e8\u7f72\u65b9\u5f0f <\/span><\/h4>\n

\u00a0\u00a0\u00a0\u00a0\u6211\u4eec\u9700\u8981\u5728\u6240\u6709\u7684\u6570\u636e\u5e93\u4e3b\u673a\u4e4b\u5916\u518d\u5f00\u4e00\u53f0\u4e3b\u673a<\/span>mysql-router<\/span>（\u53ef\u4ee5\u662fMHA）<\/span><\/p>\n

mha ~]<\/span># yum install mysql-router-community-8.4.0-1.el7.x86_64.rpm -y<\/span><\/p>\n

# vim \/etc\/mysqlrouter\/mysqlrouter.conf<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3010\u66f4\u6539\u4e3b\u914d\u7f6e\u6587\u4ef6\u3011<\/span><\/p>\n

\"\"<\/p>\n

# systemctl start mysqlrouter.service<\/span><\/p>\n

# netstat -antlupe | grep mysql \u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u3010\u67e5\u770b\u7aef\u53e3\u3011<\/span><\/p>\n

\"\"<\/p>\n

# mysql -ulee -plee -h 172.25.254.100 -P 7001<\/span>\u00a0\u00a0\u00a0\u00a0\u3010\u8bbf\u95ee\u8d1f\u8f7d\u8c03\u5ea6\u7684\u3011<\/span><\/p>\n

> select @@server_id;<\/span>\u00a0\u00a0\u00a0\u00a0\u3010\u68c0\u6d4b\u67e5\u770b\u3011<\/span><\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

# mysql -ulee -plee -h 172.25.254.100 -P 7002<\/span>\u00a0\u00a0\u00a0\u00a0\u3010\u8bbf\u95ee\u8bbf\u95ee\u6307\u5b9a\u7684\u3011<\/span><\/p>\n

> select @@server_id;<\/span><\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb728\u6b21\uff0c\u70b9\u8d5e7\u6b21\uff0c\u6536\u85cf21\u6b21\u3002Mysql \u96c6\u7fa4\u6280\u672fMysql \u5728\u670d\u52a1\u5668\u4e2d\u7684\u90e8\u7f72\u65b9\u6cd5\u5728\u4f01\u4e1a\u4e2d90%\u7684\u670d\u52a1\u5668\u64cd\u4f5c\u7cfb\u7edf\u5747\u4e3aLinux\u5728\u4f01\u4e1a\u4e2d\u5bf9\u4e8eMysql\u7684\u5b89\u88c5\u901a\u5e38\u7528\u6e90\u7801\u7f16\u8bd1\u7684\u65b9\u5f0f\u6765\u8fdb\u884cRhel7\u90e8\u7f72\u6570\u636e\u5e93\u3002_mysql \u96c6\u7fa4\u63d2\u5165\u8868\u793a\u5177\u4f53\u670d\u52a1\u5668\u6570\u636e<\/p>\n","protected":false},"author":2,"featured_media":57279,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[58,114,97,100,43,305,44],"topic":[],"class_list":["post-57299","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-linux","tag-mysql","tag-97","tag-100","tag-43","tag-305","tag-44"],"yoast_head":"\n\u670d\u52a1\u5668\u7684Mysql \u96c6\u7fa4\u6280\u672f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/57299.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u670d\u52a1\u5668\u7684Mysql \u96c6\u7fa4\u6280\u672f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb728\u6b21\uff0c\u70b9\u8d5e7\u6b21\uff0c\u6536\u85cf21\u6b21\u3002Mysql \u96c6\u7fa4\u6280\u672fMysql \u5728\u670d\u52a1\u5668\u4e2d\u7684\u90e8\u7f72\u65b9\u6cd5\u5728\u4f01\u4e1a\u4e2d90%\u7684\u670d\u52a1\u5668\u64cd\u4f5c\u7cfb\u7edf\u5747\u4e3aLinux\u5728\u4f01\u4e1a\u4e2d\u5bf9\u4e8eMysql\u7684\u5b89\u88c5\u901a\u5e38\u7528\u6e90\u7801\u7f16\u8bd1\u7684\u65b9\u5f0f\u6765\u8fdb\u884cRhel7\u90e8\u7f72\u6570\u636e\u5e93\u3002_mysql \u96c6\u7fa4\u63d2\u5165\u8868\u793a\u5177\u4f53\u670d\u52a1\u5668\u6570\u636e\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/57299.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-15T02:00:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/08\/20250815020046-689e94ce309c8.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/57299.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/57299.html\",\"name\":\"\u670d\u52a1\u5668\u7684Mysql \u96c6\u7fa4\u6280\u672f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-08-15T02:00:48+00:00\",\"dateModified\":\"2025-08-15T02:00:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/57299.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/57299.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/57299.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u670d\u52a1\u5668\u7684Mysql \u96c6\u7fa4\u6280\u672f\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u670d\u52a1\u5668\u7684Mysql \u96c6\u7fa4\u6280\u672f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/57299.html","og_locale":"zh_CN","og_type":"article","og_title":"\u670d\u52a1\u5668\u7684Mysql \u96c6\u7fa4\u6280\u672f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb728\u6b21\uff0c\u70b9\u8d5e7\u6b21\uff0c\u6536\u85cf21\u6b21\u3002Mysql \u96c6\u7fa4\u6280\u672fMysql \u5728\u670d\u52a1\u5668\u4e2d\u7684\u90e8\u7f72\u65b9\u6cd5\u5728\u4f01\u4e1a\u4e2d90%\u7684\u670d\u52a1\u5668\u64cd\u4f5c\u7cfb\u7edf\u5747\u4e3aLinux\u5728\u4f01\u4e1a\u4e2d\u5bf9\u4e8eMysql\u7684\u5b89\u88c5\u901a\u5e38\u7528\u6e90\u7801\u7f16\u8bd1\u7684\u65b9\u5f0f\u6765\u8fdb\u884cRhel7\u90e8\u7f72\u6570\u636e\u5e93\u3002_mysql \u96c6\u7fa4\u63d2\u5165\u8868\u793a\u5177\u4f53\u670d\u52a1\u5668\u6570\u636e","og_url":"https:\/\/www.wsisp.com\/helps\/57299.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-08-15T02:00:48+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/08\/20250815020046-689e94ce309c8.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"13 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/57299.html","url":"https:\/\/www.wsisp.com\/helps\/57299.html","name":"\u670d\u52a1\u5668\u7684Mysql \u96c6\u7fa4\u6280\u672f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-08-15T02:00:48+00:00","dateModified":"2025-08-15T02:00:48+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/57299.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/57299.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/57299.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u670d\u52a1\u5668\u7684Mysql \u96c6\u7fa4\u6280\u672f"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/57299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=57299"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/57299\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/57279"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=57299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=57299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=57299"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=57299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}