1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
SET @old_gtid_domain_id= @@global.gtid_domain_id;
SELECT @@global.gtid_domain_id;
@@global.gtid_domain_id
0
SET GLOBAL gtid_domain_id= 10;
SET SESSION gtid_domain_id= 20;
SELECT @@global.gtid_domain_id;
@@global.gtid_domain_id
10
SELECT @@session.gtid_domain_id;
@@session.gtid_domain_id
20
SET GLOBAL gtid_domain_id= DEFAULT;
SELECT @@global.gtid_domain_id;
@@global.gtid_domain_id
0
SET GLOBAL gtid_domain_id= -10;
Warnings:
Warning 1292 Truncated incorrect gtid_domain_id value: '-10'
SELECT @@global.gtid_domain_id;
@@global.gtid_domain_id
0
SET SESSION gtid_domain_id= -1;
Warnings:
Warning 1292 Truncated incorrect gtid_domain_id value: '-1'
SELECT @@session.gtid_domain_id;
@@session.gtid_domain_id
0
SET GLOBAL gtid_domain_id= @old_gtid_domain_id;
|