|
If I want to set-up a MariaDB Master/Master GTID based Replication from a fresh created empty instance this is not possible because BINLOG_GTID_POS() return empty set.
I have to add data to the database to get my first GTID!
This is especially evil on a DBaaS platform where you want to provide an empty M/M set-up...
reset master;
show master status;
-----------------
| File |
Position |
Binlog_Do_DB |
Binlog_Ignore_DB |
-----------------
-----------------
select BINLOG_GTID_POS("binlog-m1.000001", 328);
------------------------------------------
| BINLOG_GTID_POS("binlog-m1.000001", 328) |
------------------------------------------
------------------------------------------
show global variables like 'gtid%';
-----------------------
-----------------------
| gtid_binlog_pos |
|
| gtid_binlog_state |
|
| gtid_current_pos |
2-2-1 |
| gtid_domain_id |
1 |
| gtid_ignore_duplicates |
OFF |
| gtid_slave_pos |
2-2-1 |
| gtid_strict_mode |
ON |
-----------------------
insert into test.test values (null, 'some data', null);
show master status;
-----------------
| File |
Position |
Binlog_Do_DB |
Binlog_Ignore_DB |
-----------------
-----------------
select BINLOG_GTID_POS("binlog-m1.000001", 555);
------------------------------------------
| BINLOG_GTID_POS("binlog-m1.000001", 555) |
------------------------------------------
------------------------------------------
show global variables like 'gtid%';
-----------------------
-----------------------
| gtid_binlog_pos |
1-1-1 |
| gtid_binlog_state |
1-1-1 |
| gtid_current_pos |
1-1-1,2-2-1 |
| gtid_domain_id |
1 |
| gtid_ignore_duplicates |
OFF |
| gtid_slave_pos |
2-2-1 |
| gtid_strict_mode |
ON |
-----------------------
|