Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.2.10
-
None
Description
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 |
------------------------------------------------------+
| binlog-m1.000001 | 328 |
------------------------------------------------------+
select BINLOG_GTID_POS("binlog-m1.000001", 328);
------------------------------------------
| BINLOG_GTID_POS("binlog-m1.000001", 328) |
------------------------------------------
------------------------------------------
show global variables like 'gtid%';
-----------------------------+
| Variable_name | Value |
-----------------------------+
| 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 |
------------------------------------------------------+
| binlog-m1.000001 | 555 |
------------------------------------------------------+
select BINLOG_GTID_POS("binlog-m1.000001", 555);
------------------------------------------
| BINLOG_GTID_POS("binlog-m1.000001", 555) |
------------------------------------------
| 1-1-1 |
------------------------------------------
show global variables like 'gtid%';
-----------------------------------+
| Variable_name | Value |
-----------------------------------+
| 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 |
-----------------------------------+