1INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so'; 2select @@global.rpl_semi_sync_master_enabled; 3@@global.rpl_semi_sync_master_enabled 40 5SET @start_global_value = @@global.rpl_semi_sync_master_enabled; 6select @@global.rpl_semi_sync_master_enabled in (0,1); 7@@global.rpl_semi_sync_master_enabled in (0,1) 81 9select @@session.rpl_semi_sync_master_enabled; 10ERROR HY000: Variable 'rpl_semi_sync_master_enabled' is a GLOBAL variable 11show global variables like 'rpl_semi_sync_master_enabled'; 12Variable_name Value 13rpl_semi_sync_master_enabled OFF 14show session variables like 'rpl_semi_sync_master_enabled'; 15Variable_name Value 16rpl_semi_sync_master_enabled OFF 17select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_enabled'; 18VARIABLE_NAME VARIABLE_VALUE 19RPL_SEMI_SYNC_MASTER_ENABLED OFF 20select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_enabled'; 21VARIABLE_NAME VARIABLE_VALUE 22RPL_SEMI_SYNC_MASTER_ENABLED OFF 23set global rpl_semi_sync_master_enabled=0; 24set session rpl_semi_sync_master_enabled=0; 25ERROR HY000: Variable 'rpl_semi_sync_master_enabled' is a GLOBAL variable and should be set with SET GLOBAL 26select @@global.rpl_semi_sync_master_enabled; 27@@global.rpl_semi_sync_master_enabled 280 29select @@session.rpl_semi_sync_master_enabled; 30ERROR HY000: Variable 'rpl_semi_sync_master_enabled' is a GLOBAL variable 31show global variables like 'rpl_semi_sync_master_enabled'; 32Variable_name Value 33rpl_semi_sync_master_enabled OFF 34show session variables like 'rpl_semi_sync_master_enabled'; 35Variable_name Value 36rpl_semi_sync_master_enabled OFF 37select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_enabled'; 38VARIABLE_NAME VARIABLE_VALUE 39RPL_SEMI_SYNC_MASTER_ENABLED OFF 40select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_enabled'; 41VARIABLE_NAME VARIABLE_VALUE 42RPL_SEMI_SYNC_MASTER_ENABLED OFF 43set global rpl_semi_sync_master_enabled=1; 44set session rpl_semi_sync_master_enabled=1; 45ERROR HY000: Variable 'rpl_semi_sync_master_enabled' is a GLOBAL variable and should be set with SET GLOBAL 46select @@global.rpl_semi_sync_master_enabled; 47@@global.rpl_semi_sync_master_enabled 481 49select @@session.rpl_semi_sync_master_enabled; 50ERROR HY000: Variable 'rpl_semi_sync_master_enabled' is a GLOBAL variable 51show global variables like 'rpl_semi_sync_master_enabled'; 52Variable_name Value 53rpl_semi_sync_master_enabled ON 54show session variables like 'rpl_semi_sync_master_enabled'; 55Variable_name Value 56rpl_semi_sync_master_enabled ON 57select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_enabled'; 58VARIABLE_NAME VARIABLE_VALUE 59RPL_SEMI_SYNC_MASTER_ENABLED ON 60select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_enabled'; 61VARIABLE_NAME VARIABLE_VALUE 62RPL_SEMI_SYNC_MASTER_ENABLED ON 63set global rpl_semi_sync_master_enabled=1.1; 64ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_enabled' 65set global rpl_semi_sync_master_enabled=1e1; 66ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_enabled' 67set global rpl_semi_sync_master_enabled="some text"; 68ERROR 42000: Variable 'rpl_semi_sync_master_enabled' can't be set to the value of 'some text' 69SET @@global.rpl_semi_sync_master_enabled = @start_global_value; 70select @@global.rpl_semi_sync_master_enabled; 71@@global.rpl_semi_sync_master_enabled 720 73UNINSTALL PLUGIN rpl_semi_sync_master; 74