下面一起来了解下Mysql5.7主从复制如何配置文档，相信大家看完肯定会受益匪浅，文字在精不在多，希望Mysql5.7主从复制如何配置文档这篇短内容是你想要的。安装的数据是mysql5.7社区版本yum安装,官网有下载地址wget https://repo.mysql.com//mysql57-community-release-el7-10.noarch.rpm注意事项: 防火墙,命令引号.主云服务器[root@localhost opt]# egrep -v “^$|#” /etc/my.cnf 红色部分为添加[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socksymbolic-links=0log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidserver-id=1 log-bin=mysql-bin登陆数据库systemctl start mysqld.servicegrep ‘temporary p开发云主机域名assword’ /var/log/mysqld.log #查看临时密码mysql -uroot -p修改root密码set global validate_password_policy=0; #取消复杂密码设置alter user ‘root’@’localhost’ identified by ‘123’;开始创建用户GRANT REPLICATION SLAVE ON *.* TO ‘repl’@’192.168.1.%’ IDENTIFIED BY ‘admin123456′; 查看master日志mysql>quitmysql>SHOW MASTER STATUS;+——————+———-+————–+——————+——————-+| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |+——————+———-+————–+——————+——————-+| mysql-bin.000001 | 154 | | | |+——————+———-+————–+——————+——————-+1 row in set (0.00 sec)从配置[root@localhost ~]# egrep -v “^$|#” /etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socksymbolic-links=0log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidserver-id=2登陆数据库5.7版本CHANGE MASTER TO MASTER_HOST=’192.168.1.200’,
MASTER_PORT=3306,MASTER_USER=’repl’, MASTER_PASSWORD=’admin123456′, MASTER_LOG_FILE=’mysql-bin.000001′, 主配置日志MASTER_LOG_POS=154; 主配置日志启动start slave;stopslave;查看是否连接成功. 红色部分一定要为yes.mysql> show slave status G*************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.1.200 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000001 Read_Master_Log_Pos: 316 Relay_Log_File: localhost-relay-bin.000002 Relay_Log_Pos: 482 Relay_Master_Log_File: mysql-bin.000001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table:Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 316 Relay_Log_Space: 693 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error:Replicate_Ignore_Server_Ids: Master_Server_Id: 200 Master_UUID: 706337e4-1ebb-11e7-a606-000c2987fd49 Master_Info_File: /var/lib/mysql/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version:1 row in set (0.00 sec)看完Mysql5.7主从复制如何配置文档这篇文章后，很多读者朋友肯定会想要了解更多的相关内容，如需获取更多的行业信息，可以关注我们的行业资讯栏目。
相关推荐: 实现sqlserver的row_number函数方法
本文主要给大家介绍实现sqlserver的row_number函数方法，其所涉及的东西，从理论知识来获悉，有很多书籍、文献可供大家参考，从现实意义角度出发，开发云累计多年的实践经验可分享给大家。1. 使用临时表CREATE DEFINER=`root`@`%`…
免责声明：本站发布的图片视频文字，以转载和分享为主，文章观点不代表本站立场，本站不承担相关法律责任；如果涉及侵权请联系邮箱：360163164@qq.com举报，并提供相关证据，经查实将立刻删除涉嫌侵权内容。
微信扫一扫 
