云原生第四次作业

[root@openEuler-1 ~]# vim /etc/my.cnf

      
mysql> change master to
    -> master_host='192.168.1.12',
    -> master_user='rep',
    -> master_password='123456',
    -> master_log_file='binlog.000001',
    -> master_log_pos=678;
Query OK, 0 rows affected, 8 warnings (0.01 sec)

mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.04 sec)

mysql> show slave status \G
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
 

[root@openEuler-1 ~]# systemctl enable --now mysqld

mysql> change master to
    -> master_host='192.168.1.12',
    -> master_user='rep',
    -> master_password='123456',
    -> master_log_file='binlog.000001',
    -> master_log_pos=678;
Query OK, 0 rows affected, 8 warnings (0.02 sec)

mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.12 sec)

mysql> show slave status \G

            Slave_IO_Running: Yes
            Slave_SQL_Running: Yes

主创建

mysql> create database xiao;
Query OK, 1 row affected (0.01 sec)

mysql> use xiao
Database changed
mysql> create table td1(id int(10),name varchar(20));
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> insert into td1 values(1,'不是');
Query OK, 1 row affected (0.03 sec)
辅查看

第二

三个都要

从1

mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CHANGE MASTER TO
    -> MASTER_HOST = '192.168.1.12',
    -> MASTER_USER = 'rep', MASTER_PASSWORD = '123456',MASTER_AUTO_POSITION = 678;
Query OK, 0 rows affected, 7 warnings (0.01 sec)

mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.02 sec)

mysql> show slave status \G
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes

从2

mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> change replication source to
    -> source_host='192.168.1.12';
Query OK, 0 rows affected (0.01 sec)

mysql> change replication source to
    -> source_host='192.168.1.12',
    -> source_user='rep',
    -> source_password='123456',
    -> source_auto_position=678;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

mysql> start replica
    -> ;
Query OK, 0 rows affected (0.05 sec)

mysql> show slave status \G
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes

测试

主
mysql> create database xiao;
Query OK, 1 row affected (0.01 sec)

mysql> use xiao;
Database changed
mysql> create table xiao(id int(10),name varchar(20));
Query OK, 0 rows affected, 1 warning (0.02 sec)
mysql> insert into xiao values(1,'马尼');
从
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| xiao               |
+--------------------+
5 rows in set (0.00 sec)
mysql> select * from xiao.xiao;
+------+--------+
| id   | name   |
+------+--------+
|    1 | 马尼   |
+------+--------+
1 row in set (0.00 sec)