MySQL主从复制
[root@localhost ~]
[mysqld]
log_bin=mysql-bin
server_id=11
[root@root2 ~]
[mysqld]
log_bin=mysql-bin
server_id=12
[root@root2 ~]
[root@localhost ~]
[root@root2 ~]
mysql> grant replication slave on *.* to 'yy'@'192.168.40.%' identified by '密码';
mysql> mysql> show master status;
+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+
| mysql-bin.000004 | 446 | | | |
+
mysql> change master to
-> master_host='192.168.40.128',
-> master_user='yy',
-> master_password='Fmx1220.',
-> master_log_file='mysql-bin.000004',
-> master_log_pos=446;
mysql> start slave;
mysql> show slave status\G;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
mysql> create database yy;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+
| Database |
+
| information_schema |
| emp |
| mysql |
| performance_schema |
| sys |
| yy |
+
6 rows in set (0.00 sec)