MySQL的主从复制
点击前往查看MySQL的安装
1、主库操作
vim /etc/my.cnf
添加如下配置
log-bin=mysql-bin #[必须]启用二进制日志
server-id=128 #[必须]服务器唯一id
保存后重启MySQL
systemctl restart mysqld
mysql -uroot -pczx123
mysql> grant replication slave on *.* to 'czx'@'%' identified by 'root@czx123';
mysql> flush privileges;
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 | 740 | | | |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)
主节点别操作,从库slave进行配置
如果grant添加用户报错ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
,执行下面两个命令即可再添加即可
mysql > set global validate_password_policy=LOW; #设置密码复杂度为低
mysql > set global validate_password_length=4; #密码长度为4
2、从库操作
注意这是另一台子节点的虚拟机的操作
vim /etc/my.cnf
添加如下配置并保存。
server-id=129 #[必须]服务器唯一id
保存成功厚要重启MySQL
systemctl restart mysqld
mysql -uroot -pczx123
mysql> change master to master_host='192.168.64.128',master_user='czx',master_password='root@czx123',master_log_file='mysql-bin.000001',master_log_pos=740;
Query OK, 0 rows affected, 2 warnings (0.09 sec)
# 其中master_host为主库IP地址,master_log_file和master_log_pos为主库执行“show master status;”查找到的
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status;
+----------------+----------------+-------------+-------------+---------------+------------------+---------------------+----------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------+-----------------------------+------------------+-------------+----------------------------+-----------+---------------------+--------------------------------------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+-------------------+---------------+----------------------+--------------+--------------------+
| Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table