上课跟随老师一直做的实验,做个笔记。
有些的不对不好的地方,请各位指点!
version : mysql 8.0.21
IP : 主节点:192.168.1.13 从节点: 192.168.1.12
复制账户: repluser A123456.com
主节点配置 192.168.1.13
#cat /etc/my.cnf [mysqld] server-id=1 #指定serverID,一个集群中每个节点ID必须唯一 log-bin=/data/mysql/binlog/mysql-bin #指定log-bin路径 #mkdir -pv /data/mysql/binlog #chown mysql.mysql -R /data/mysql/binlog #systemctl enable --now mysqld;mysql mysql> select @@log_bin; #确定log_bin开启 +-----------+ | @@log_bin | +-----------+ | 1 | +-----------+ 1 row in set (0.00 sec) ··· mysql> show master logs; #查看logbin的位置。 +------------------+-----------+-----------+ | Log_name | File_size | Encrypted | +------------------+-----------+-----------+ | mysql-bin.000001 | 179 | No | | mysql-bin.000002 | 156 | No | +------------------+-----------+-----------+ 2 rows in set (0.00 sec) ··· mysql>create user repluser@'192.168.1.%' indentified by 'A123456.com'; mysql>grant replication slave on *.* to repluser@'192.168.1.%';
从节点配置: 192.168.1.12
#cat /etc/my.cnf [mysqld] server-id=12 read-only #设置从节点读写状态为只读 #systemctl enable --now mysqld;mysql mysql>CHANGE MASTER TO #添加master节点信息 MASTER_HOST='192.168.1.13', MASTER_USER='repluser', MASTER_PASSWORD='A123456.com', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=156; mysql>start slave; #开启slave模式 mysql> show slave status\G #查看slave状态。IO线程和SQl已经在运行 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.1.13 Master_User: repluser Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000002 Read_Master_Log_Pos: 869 Relay_Log_File: jake8-11-relay-bin.000002 Relay_Log_Pos: 1037 Relay_Master_Log_File: mysql-bin.000002 Slave_IO_Running: Yes Slave_SQL_Running: Yes #ss -tn 可以看到主节点与从节点已建立连接。 State Recv-Q Send-Q Local Address:Port Peer Address:Port ESTAB 0 52 192.168.1.12:22 192.168.1.185:55890 ESTAB 0 0 192.168.1.12:22 192.168.1.185:50958 ESTAB 0 0 192.168.1.12:34560 192.168.1.13:3306