← Back to team overview

maria-discuss team mailing list archive

Reg replication and commit


Hi All,

I have the below topology:

Master -> Slave (using GTID replication)

Master -> Maxscale (Binlog Router)

Maxscale -> DR Site (via binlog router)

my.cnf is same across all sites:


#replication variables

I have created a table and I could see on slave DB as well as at DR Site
When I INSERT records, this is not shown up in Slave DB as well DR Site DB.
I have checked replication status and both are sync with master server
binlog pos.

But the rows reflected in slave and DR site DB only when we COMMIT on both
Slave as well DR site DB.

Below when I try at Slave DB:

MariaDB [dr_repl]> select * from test_dr_repl;
Empty set (0.00 sec)

MariaDB [dr_repl]> commit;
Query OK, 0 rows affected (0.00 sec)

MariaDB [dr_repl]> select * from test_dr_repl;
| id | val  |
|  1 |    1 |
|  2 |    2 |
|  3 |    3 |
3 rows in set (0.00 sec)

I am wondering whether I did any weird mistake. Could anyone please help me
to understand and a solution for this.


Follow ups