[MDEV-9201] Dynamic replication variables cannot be changed in combination with multi-source replication Created: 2015-11-27  Updated: 2016-02-03  Resolved: 2016-02-03

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Replication
Affects Version/s: 10.0, 10.1
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Michael Neubert Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None
Environment:

Debian Jessie 64 Bit


 Description   

Hello,

we are running a multi-source replication setup. We are not able to change the dynamic replication variables on the slave without a restart of the mariadb server.

Example e.g.:

SHOW ALL SLAVES STATUS;

Result:

- Connection_name: gandalf
 
- Replicate_Do_Table: database1.table1,database1.table2
 

STOP SLAVE 'gandalf';
 
SET GLOBAL replicate_do_table='database1.table1,database1.table2,database1.table3';
 
START SLAVE 'gandalf';
 
 
 
SHOW ALL SLAVES STATUS;

Result:

- Connection_name: gandalf
 
- Replicate_Do_Table: database1.table1,database1.table2

Expected result:

- Connection_name: gandalf
 
- Replicate_Do_Table: database1.table1,database1.table2,database1.table3

Best regards
Michael

 Comments   
Comment by Elena Stepanova [ 2015-12-25 ]

When you set replicate_do_table variable, you address to the default slave connection. If you want to change the value for your gandalf connection, you should run it like this:

STOP SLAVE 'gandalf';
 
SET GLOBAL gandalf.replicate_do_table='database1.table1,database1.table2,database1.table3';
 
START SLAVE 'gandalf';

Alternatively, you can make the gandalf connection default, and then work with it in the usual fashion:

SET default_master_connection = 'gandalf';
 
STOP SLAVE; 
SET GLOBAL replicate_do_table='database1.table1,database1.table2,database1.table3';
 
START SLAVE;

I could not find it in the KB, so I am assigning the issue to greenman to either document it, or if it's already there, make it more visible ("findable") somehow.

Comment by Ian Gilfillan [ 2016-02-03 ]

Updated the page https://mariadb.com/kb/en/mariadb/dynamic-replication-variables/ with the example of this specific situation.

Generated at Thu Feb 08 07:32:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.