[#MDEV-21090] the innodb transaction use the gtid_domin_id in galera cluster not wsrep_gtid_domin

(root@localhost) [sbdb] 11:38:22> show create table jian;

+-------+----------------------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                                         |

+-------+----------------------------------------------------------------------------------------------------------------------+

| jian  | CREATE TABLE `jian` (

  `id` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |

+-------+----------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

(root@localhost) [sbdb] 11:42:39> show create table jianm;

+-------+-----------------------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                                          |

+-------+-----------------------------------------------------------------------------------------------------------------------+

| jianm | CREATE TABLE `jianm` (

  `id` int(11) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |

+-------+-----------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

(root@localhost) [sbdb] 11:42:45> show variables like '%gtid%';

+-------------------------+---------------+

| Variable_name           | Value         |

+-------------------------+---------------+

| gtid_binlog_pos         | 1-1-7,101-1-9 |

| gtid_binlog_state       | 1-1-7,101-1-9 |

| gtid_cleanup_batch_size | 64            |

| gtid_current_pos        | 1-1-7,101-1-9 |

| gtid_domain_id          | 101           |

| gtid_ignore_duplicates  | ON            |

| gtid_pos_auto_engines   |               |

| gtid_seq_no             | 0             |

| gtid_slave_pos          |               |

| gtid_strict_mode        | ON            |

| last_gtid               | 101-1-9       |

| wsrep_gtid_domain_id    | 1             |

| wsrep_gtid_mode         | ON            |

+-------------------------+---------------+

13 rows in set (0.00 sec)

(root@localhost) [sbdb] 11:43:31> insert into jianm values(1);

Query OK, 1 row affected (0.00 sec)

(root@localhost) [sbdb] 11:43:43> show variables like '%gtid%';

+-------------------------+----------------+

| Variable_name           | Value          |

+-------------------------+----------------+

| gtid_binlog_pos         | 1-1-7,101-1-10 |

| gtid_binlog_state       | 1-1-7,101-1-10 |

| gtid_cleanup_batch_size | 64             |

| gtid_current_pos        | 1-1-7,101-1-10 |

| gtid_domain_id          | 101            |

| gtid_ignore_duplicates  | ON             |

| gtid_pos_auto_engines   |                |

| gtid_seq_no             | 0              |

| gtid_slave_pos          |                |

| gtid_strict_mode        | ON             |

| last_gtid               | 101-1-10       |

| wsrep_gtid_domain_id    | 1              |

| wsrep_gtid_mode         | ON             |

+-------------------------+----------------+

13 rows in set (0.00 sec)

(root@localhost) [sbdb] 11:43:44> insert into jian values(1);

Query OK, 1 row affected (0.00 sec)

(root@localhost) [sbdb] 11:43:50> show variables like '%gtid%';

+-------------------------+----------------+

| Variable_name           | Value          |

+-------------------------+----------------+

| gtid_binlog_pos         | 1-1-7,101-1-11 |

| gtid_binlog_state       | 1-1-7,101-1-11 |

| gtid_cleanup_batch_size | 64             |

| gtid_current_pos        | 1-1-7,101-1-11 |

| gtid_domain_id          | 101            |

| gtid_ignore_duplicates  | ON             |

| gtid_pos_auto_engines   |                |

| gtid_seq_no             | 0              |

| gtid_slave_pos          |                |

| gtid_strict_mode        | ON             |

| last_gtid               | 101-1-11       |

| wsrep_gtid_domain_id    | 1              |

| wsrep_gtid_mode         | ON             |

+-------------------------+----------------+

13 rows in set (0.00 sec)

This is a galera env
my question is i think it it right the gtid_domain_id transaction sequence increase when i insert into the myisam table ,but why when i insert into the innodb table the gtid_domain_id transaction sequence increase also ,i think when insert into the innodb table the wsrep_gtid_domain_id transaction sequence shoud be increase

[MDEV-21090] the innodb transaction use the gtid_domin_id in galera cluster not wsrep_gtid_domin_id Created: 2019-11-20 Updated: 2019-12-12 Resolved: 2019-12-12
Status:	Closed
Project:	MariaDB Server
Component/s:	Galera, wsrep
Affects Version/s:	10.4.7
Fix Version/s:	N/A

[MDEV-21090] the innodb transaction use the gtid_domin_id in galera cluster not wsrep_gtid_domin_id Created: 2019-11-20 Updated: 2019-12-12 Resolved: 2019-12-12