mysql5.6-"5.7

This experiment will use MySQL 5.6.x as a multi-"master".

0 test Environment:
OS: CentOS 6.5
master_1: 192.168.1.185 (MySQL 5.6.30)
master_2: 192.168.1.186 (MySQL 5.6.30)
slave: 192.168.1.1.187 (MySQL 5.7.15)

0 Configuration:
Master_1 Related configurations:

1. [Mysqld]
2. server_id = 185
3. Log-bin = master_1
4. Log-bin-index = Master_1.index

Master_2 Related configurations:

1. [Mysqld]
2. server_id = 186
3. Log-bin = master_2
4. Log-bin-index = Master_2.index

Slave related configurations:

1. [Mysqld]
2. server_id = 187
3. Relay-log = Slave
4. Relay-log-index = Slave.index
6. # slave in a multi-source replication structure, the official requirements for Master-info and relay-log-info repositories must be table.
7. # If it is file, it will fail when multiple master is added: Er_slave_new_channel_wrong_repository.
8. Master-info-repository = TABLE
9. Relay-log-info-repository = TABLE

0 Create a replication user on master_1 & master_2:

1. GRANT REPLICATION SLAVE On * * to [e-mail protected] ' 192.168.1.187 ' identified by ' repl ';
2. FLUSH privileges;

0 Test Data Preparation:
master_1 test Data:

1. Master_1> FLUSH LOGS;
2. Query OK, 0 rows Affected (0.00 sec)
4. master_1> SHOW BINARY LOGS; --Remember the name and position of the current Binlog
5. +-----------------+-----------+
6. | Log_name | File_size |
7. +-----------------+-----------+
8. | master_1.000001 | 166 |
9. | master_1.000002 | 455 |
10. | master_1.000003 | 120 |
11. +-----------------+-----------+
12. 3 Rows in Set (0.00 sec)
14. master_1> CREATE DATABASE master_1;
15. Query OK, 1 row affected (0.03 sec)

Master_2 test Data:

1. Master_2> FLUSH LOGS;
2. Query OK, 0 rows Affected (0.00 sec)
4. master_2> SHOW BINARY LOGS; --Remember the name and position of the current Binlog
5. +-----------------+-----------+
6. | Log_name | File_size |
7. +-----------------+-----------+
8. | master_2.000001 | 166 |
9. | master_2.000002 | 455 |
10. | master_2.000003 | 120 |
11. +-----------------+-----------+
12. 3 Rows in Set (0.00 sec)
14. master_2> CREATE DATABASE master_2;
15. Query OK, 1 row affected (0.02 sec)

0 performed on Slave:

2. Salve> Change MASTER to
4. Master_host= ' 192.168.1.185 ',
6. Master_user= ' Repl ',
8. master_port=3306,
10. Master_password= ' Repl ',
12. Master_log_file= ' master_1.000003 ',
14. master_log_pos=120
16. For CHANNEL ' master_1 ';
18. Query OK, 0 rows affected, 2 warnings (0.02 sec)-The warnings generated here are some security recommendations and warnings that this experiment ignores.
22. Salve> Change MASTER to
24. Master_host= ' 192.168.1.186 ',
26. Master_user= ' Repl ',
28. master_port=3306,
30. Master_password= ' Repl ',
32. Master_log_file= ' master_2.000003 ',
34. master_log_pos=120
36. For CHANNEL ' master_2 ';
38. Query OK, 0 rows affected, 2 warnings (0.02 sec)
42. slave> START Slave;
44. Query OK, 0 rows affected (0.01 sec)
48. Salve> SHOW DATABASES; -The Binlog events on master_1 and master_2 have been properly apply.
50. +--------------------+
52. | Database |
54. +--------------------+
56. | Information_schema |
58. | master_1 |
60. | master_2 |
62. | MySQL |
64. | Performance_schema |
66. | SYS |
68. +--------------------+
70. 6 rows in Set (0.00 sec)

Finally, the replication status can be found through the start slave status

2. slave> SHOW Slave Status\g
4. 1. Row ***************************
6. Slave_io_state:waiting for Master to send event
8. master_host:192.168.1.185
10. Master_user:repl
12. master_port:3306
14. ............................................................
16. Slave_io_running:yes
18. Slave_sql_running:yes
20. ............................................................
22. master_server_id:185
24. Master_uuid:ee1f8704-58c4-11e6-95b5-000c297f23b7
26. Master_Info_File:mysql.slave_master_info
28. sql_delay:0
30. Sql_remaining_delay:null
32. Slave_sql_running_state:slave have read all relay log; Waiting for more updates
34. ............................................................
36. Channel_name:master_1
38. Master_tls_version:
40. 2. Row ***************************
42. Slave_io_state:waiting for Master to send event
44. master_host:192.168.1.186
46. Master_user:repl
48. master_port:3306
50. Connect_retry:60
52. ............................................................
54. Slave_io_running:yes
56. Slave_sql_running:yes
58. ............................................................
60. master_server_id:186
62. master_uuid:53774f2d-7e14-11e6-8900-000c298e914c
64. Master_Info_File:mysql.slave_master_info
66. sql_delay:0
68. Sql_remaining_delay:null
70. Slave_sql_running_state:slave have read all relay log; Waiting for more updates
72. ............................................................
74. Channel_name:master_2
76. Master_tls_version:
78. 2 rows in Set (0.00 sec)

0 Test:
Operation on master_1:

1. Master_1> CREATE TABLE master_1.test_table (id int);
2. Query OK, 0 rows affected (0.05 sec)
4. Master_1> INSERT into master_1.test_table SELECT 666666;
5. Query OK, 1 row affected (0.01 sec)
6. Records:1 duplicates:0 warnings:0

Operation on master_2:

1. Master_2> CREATE TABLE master_2.test_table (massage varchar (16));
2. Query OK, 0 rows affected (0.02 sec)
4. Master_2> INSERT into master_2.test_table SELECT ' hehe hey ';
5. Query OK, 1 row Affected (0.00 sec)
6. Records:1 duplicates:0 warnings:0
8. Master_2> INSERT into master_2.test_table SELECT ' samyang inflammation ';
9. Query OK, 1 row Affected (0.00 sec)
10. Records:1 duplicates:0 warnings:0

Operation on Slave:

1. salve> SELECT ID from master_1.test_table;
2. +--------+
3. | ID |
4. +--------+
5. | 666666 |
6. +--------+
7. 1 row in Set (0.00 sec)
10. salve> SELECT massage from master_2.test_table;
11. +--------------+
12. | Massage |
13. +--------------+
14. | Hey heh |
15. | Samyang of the disease |
16. +--------------+
17. 2 rows in Set (0.00 sec)

0 Other related syntax:

1. Start/stop/reset all/reset SLAVE for CHANNEL ' XXX ';
3. SHOW SLAVE STATUS for CHANNEL ' XXX ';

Ps.
Similar to the traditional position method described above, the Gtid mode is similarly configured, after opening the Gtid, you need to pay attention to using the for CHANNEL ' xxx ' keyword, such as:

1. Change MASTER to
2. Master_host= ',
3. Master_user= ' Repl ',
4. master_port=3306,
5. Master_password= ' Repl ',
6. Master_auto_position = 1
7. For CHANNEL ' master_1 ';

Multiple hosts of the schema name can not be the same, (for example, master_1 for db_00 ... db_09 total 10 libraries, master_2 for db_10 ... db_19,master_3 ... db_20 ... ）

mysql5.6-"5.7