MySQL教程之mysql5.6搭建主从复制
发布时间：2022-08-10 10:10:57 所属栏目：MySql教程 来源：互联网
导读：使用MySQL 5.6，搭建主从复制。关于5.6的安装，可以参考《MySQL 5.6 rpm安装方法和碰见的问题》。 主库创建slave用户，设置复制权限， mysql create user slave@1.1.1.2 identified by root; Query OK, 0 rows affected (0.00 sec) mysql grant replication
|
使用MySQL 5.6，搭建主从复制。关于5.6的安装，可以参考《MySQL 5.6 rpm安装方法和碰见的问题》。 主库创建slave用户，设置复制权限， mysql> create user 'slave'@'1.1.1.2' identified by 'root'; Query OK, 0 rows affected (0.00 sec) mysql> grant replication slave on *.* to 'slave'@'1.1.1.2' identified by 'root'; Query OK, 0 rows affected (0.00 sec) 编辑my.cnf配置文件，设置主库server-id=1，定义需要复制的库为test，忽略mysql数据库 [root@vm-kvm10000-app mysql]# vi /etc/my.cnf [mysqld] server-id=1 log-bin=mysql-bin binlog_do_db=test binlog_ignore_db=mysql 重启主库MySQL服务， [root@vm-kvm10000-app mysql]# service mysql restart Shutting down MySQL.. SUCCESS! Starting MySQL. SUCCESS! 看一下主库状态， mysql> show master status; +------------------+----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+----------+--------------+------------------+-------------------+ | mysql-bin.000002 | 120 | test | mysql | | +------------------+----------+--------------+------------------+-------------------+ 1 row in set (0.00 sec) 或者 mysql> show master status G *************************** 1. row *************************** File: mysql-bin.000002 Position: 120 Binlog_Do_DB: test Binlog_Ignore_DB: mysql Executed_Gtid_Set: 1 row in set (0.00 sec) 从库，编辑my.cnf配置，设置server-id=2，区别于主库， [root@vm-kvm10001-app mysql]# vi /etc/my.cnf [mysqld] server-id=2 重启MySQL服务， [root@vm-kvm10001-app mysql]# service mysql restart Shutting down MySQL.. SUCCESS! Starting MySQL. SUCCESS! 设置主库信息， mysql> change master to master_host='1.1.1.1',master_user='slave',master_password='root',master_log_file='mysql-bin.000001',master_log_pos=120,master_connect_retry=10; Query OK, 0 rows affected, 2 warnings (0.03 sec) 检索从库状态， mysql> show slave status G; *************************** 1. row *************************** Slave_IO_State: Master_Host: 10.221.3.129 Master_User: slave Master_Port: 3306 Connect_Retry: 10 Master_Log_File: mysql-bin.000001 Read_Master_Log_Pos: 120 Relay_Log_File: vm-kvm11853-app-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: mysql-bin.000001 Slave_IO_Running: No Slave_SQL_Running: No 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: 120 Relay_Log_Space: 120 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: （编辑：黄山站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
