MariaDB [db1]> show global variables where variable_name in ('wsrep_on', 'wsrep_gtid_domain_id');
|
+----------------------+-------+
|
| Variable_name | Value |
|
+----------------------+-------+
|
| wsrep_gtid_domain_id | 3 |
|
| wsrep_on | ON |
|
+----------------------+-------+
|
2 rows in set (0.00 sec)
|
|
MariaDB [db1]> show master status;
|
+--------------------+----------+--------------+------------------+
|
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
|
+--------------------+----------+--------------+------------------+
|
| mariadb-bin.000016 | 591 | | |
|
+--------------------+----------+--------------+------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [db1]> show create table tab1;
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------+
|
| tab1 | CREATE TABLE `tab1` (
|
`id` int(11) NOT NULL,
|
`str` varchar(10) DEFAULT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [db1]> insert into tab1 values (2, 'str2');
|
Query OK, 1 row affected (0.01 sec)
|
|
MariaDB [db1]> show binlog events in 'mariadb-bin.000016' from 591;
|
+--------------------+-----+---------------+-----------+-------------+--------------------------------+
|
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
|
+--------------------+-----+---------------+-----------+-------------+--------------------------------+
|
| mariadb-bin.000016 | 591 | Gtid | 1 | 629 | BEGIN GTID 0-1-3 |
|
| mariadb-bin.000016 | 629 | Table_map | 1 | 674 | table_id: 19 (db1.tab1) |
|
| mariadb-bin.000016 | 674 | Write_rows_v1 | 1 | 713 | table_id: 19 flags: STMT_END_F |
|
| mariadb-bin.000016 | 713 | Xid | 1 | 740 | COMMIT /* xid=5 */ |
|
+--------------------+-----+---------------+-----------+-------------+--------------------------------+
|
4 rows in set (0.00 sec)
|