Multisource replication
All the procedures explained previously also apply to multisource replication. The difference is that, with multisource replication, each slave associates each master-slave connection to a unique ID. This allows the replication commands and the configuration variables to refer to a particular master.
For example, we generally do not want to start or stop all the I/O threads, but only one of them.
Thus, all replication-related SQL statements support a parameter that specifies which connection they refer to. For example:
CHANGE MASTER 'connection_name' TO …START SLAVE 'connection_name1' 'connection_name2'STOP SLAVE 'connection_name1' 'connection_name2'RESET SLAVE 'connection_name'
Also, it is possible to start or stop all the ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
