| slave > change master to master_host="127.0.0.1", master_port=12047, master_user="msandbox",master_password="msandbox" for channel="master1"; slave > change master to master_host="127.0.0.1", master_port=12048, master_user="msandbox",master_password="msandbox" for channel="master2"; |
按照所设定的通信名字启动从服务器。
| slave > start slave for channel="master1"; slave > start slave for channel="master2"; |
现在我们检查一下从服务器状态：
| slave > show slave statusG Empty set (0.00 sec) |
啊。是空的。我们需要写上通信名字。重新检查下从服务器状态：
| slave > SHOW SLAVE STATUS FOR CHANNEL="master1"G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 127.0.0.1 Master_User: msandbox Master_Port: 12047 Connect_Retry: 60 Master_Log_File: mysql-bin.000002 Read_Master_Log_Pos: 232 Relay_Log_File: squeeze-relay-bin-master1.000003 Relay_Log_Pos: 395 Relay_Master_Log_File: mysql-bin.000002 Slave_IO_Running: Yes Slave_SQL_Running: Yes [...] |
我们也可以检查正在运行的 IO_THREAD 和 SQL_THREADS :
| slave > SHOW PROCESSLIST; +----+-------------+-----------------------------------------------------------------------------+ | Id | User | State | +----+-------------+-----------------------------------------------------------------------------+ | 2 | system user | Waiting for master to send event | | 3 | system user | Slave has read all relay log; waiting for the slave I/O thread to update it | | 4 | system user | Waiting for master to send event | | 5 | system user | Slave has read all relay log; waiting for the slave I/O thread to update it | +----+-------------+-----------------------------------------------------------------------------+ |
测试看一下:
| master1 > create database master1; master2 > create database master2; slave > show databases like 'master%'; +--------------------+ | Database (master%) | +--------------------+ | master1 | | master2 | +--------------------+ |
正常工作了。看起来很简单!
结论
这个新的multi-source功能使在过去需要一些复杂操作创建的复制环境变得简单了。当然，你应用程序可以考虑这个新的特性设计和开发，使用 multi-master, multi-source都需要特别注意，不要把你的数据都弄乱了。
在每一个新的版本中，mysql的复制功能给我们更多的配置，性能和设计的可能性。所有这些新功能都可以结合起来。在你新（老）的功能中增加复制功能，你的复制环境会更加出色。举个例子：你可以配置 GTID 可以用 multi-threaded slave per schema或intra-database.
