1# 2# wsrep_sst_receive_address 3# 4# save the initial value 5SET @wsrep_sst_receive_address_global_saved = @@global.wsrep_sst_receive_address; 6# default 7SELECT @@global.wsrep_sst_receive_address; 8@@global.wsrep_sst_receive_address 9AUTO 10 11# scope 12SELECT @@session.wsrep_sst_receive_address; 13ERROR HY000: Variable 'wsrep_sst_receive_address' is a GLOBAL variable 14SELECT @@global.wsrep_sst_receive_address; 15@@global.wsrep_sst_receive_address 16AUTO 17 18# valid values 19SET @@global.wsrep_sst_receive_address=AUTO; 20SELECT @@global.wsrep_sst_receive_address; 21@@global.wsrep_sst_receive_address 22AUTO 23SET @@global.wsrep_sst_receive_address=default; 24SELECT @@global.wsrep_sst_receive_address; 25@@global.wsrep_sst_receive_address 26AUTO 27SET @@global.wsrep_sst_receive_address='192.168.2.254'; 28SELECT @@global.wsrep_sst_receive_address; 29@@global.wsrep_sst_receive_address 30192.168.2.254 31 32# invalid values 33SELECT @@global.wsrep_sst_receive_address; 34@@global.wsrep_sst_receive_address 35192.168.2.254 36SET @@global.wsrep_sst_receive_address=NULL; 37ERROR 42000: Variable 'wsrep_sst_receive_address' can't be set to the value of 'NULL' 38SELECT @@global.wsrep_sst_receive_address; 39@@global.wsrep_sst_receive_address 40192.168.2.254 41SET @@global.wsrep_sst_receive_address='OFF'; 42SELECT @@global.wsrep_sst_receive_address; 43@@global.wsrep_sst_receive_address 44OFF 45SET @@global.wsrep_sst_receive_address=ON; 46SELECT @@global.wsrep_sst_receive_address; 47@@global.wsrep_sst_receive_address 48ON 49SET @@global.wsrep_sst_receive_address=''; 50SELECT @@global.wsrep_sst_receive_address; 51@@global.wsrep_sst_receive_address 52 53SET @@global.wsrep_sst_receive_address='junk'; 54SELECT @@global.wsrep_sst_receive_address; 55@@global.wsrep_sst_receive_address 56junk 57 58# restore the initial value 59SET @@global.wsrep_sst_receive_address = @wsrep_sst_receive_address_global_saved; 60# End of test 61