Details steps followed for testing.. [root@vmc11 ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 13 Server version: 10.5.11-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show global status like '%wsrep_cluster_s%'; +--------------------------+--------------------------------------+ | Variable_name | Value | +--------------------------+--------------------------------------+ | wsrep_cluster_size | 3 | | wsrep_cluster_state_uuid | 6a1302cd-ee94-11eb-8007-4aaf33b56dc1 | | wsrep_cluster_status | Primary | +--------------------------+--------------------------------------+ 3 rows in set (0.001 sec) MariaDB [(none)]> select @@gtid_domain_id, @@server_id, @@wsrep_gtid_domain_id,@@wsrep_gtid_mode; +------------------+-------------+------------------------+-------------------+ | @@gtid_domain_id | @@server_id | @@wsrep_gtid_domain_id | @@wsrep_gtid_mode | +------------------+-------------+------------------------+-------------------+ | 11 | 1 | 1 | 1 | +------------------+-------------+------------------------+-------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> show global variables like '%gtid%'; +-------------------------+--------+ | Variable_name | Value | +-------------------------+--------+ | gtid_binlog_pos | 1-1-17 | | gtid_binlog_state | 1-1-17 | | gtid_cleanup_batch_size | 64 | | gtid_current_pos | 1-1-17 | | gtid_domain_id | 11 | | gtid_ignore_duplicates | ON | | gtid_pos_auto_engines | | | gtid_slave_pos | | | gtid_strict_mode | OFF | | wsrep_gtid_domain_id | 1 | | wsrep_gtid_mode | ON | +-------------------------+--------+ 11 rows in set (0.001 sec) MariaDB [(none)]> show master status; +------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000003 | 385 | | | +------------------+----------+--------------+------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> show binlog events in 'mysql-bin.000003'; +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | mysql-bin.000003 | 4 | Format_desc | 1 | 256 | Server ver: 10.5.11-MariaDB-log, Binlog ver: 4 | | mysql-bin.000003 | 256 | Gtid_list | 1 | 299 | [1-1-17] | | mysql-bin.000003 | 299 | Binlog_checkpoint | 1 | 342 | mysql-bin.000002 | | mysql-bin.000003 | 342 | Binlog_checkpoint | 1 | 385 | mysql-bin.000003 | +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ 4 rows in set (0.000 sec) MariaDB [(none)]> create database sbtest1; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> show binlog events in 'mysql-bin.000003'; +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | mysql-bin.000003 | 4 | Format_desc | 1 | 256 | Server ver: 10.5.11-MariaDB-log, Binlog ver: 4 | | mysql-bin.000003 | 256 | Gtid_list | 1 | 299 | [1-1-17] | | mysql-bin.000003 | 299 | Binlog_checkpoint | 1 | 342 | mysql-bin.000002 | | mysql-bin.000003 | 342 | Binlog_checkpoint | 1 | 385 | mysql-bin.000003 | | mysql-bin.000003 | 385 | Gtid | 1 | 427 | GTID 1-1-18 | | mysql-bin.000003 | 427 | Query | 1 | 525 | create database sbtest1 | +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ 6 rows in set (0.000 sec) Backup and restored on another node of DC2 [root@vmc21 mysql]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.5.11-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@gtid_domain_id, @@server_id, @@wsrep_gtid_domain_id,@@wsrep_gtid_mode; +------------------+-------------+------------------------+-------------------+ | @@gtid_domain_id | @@server_id | @@wsrep_gtid_domain_id | @@wsrep_gtid_mode | +------------------+-------------+------------------------+-------------------+ | 21 | 2 | 2 | 1 | +------------------+-------------+------------------------+-------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> show global status like '%wsrep_cluster_s%'; +--------------------------+--------------------------------------+ | Variable_name | Value | +--------------------------+--------------------------------------+ | wsrep_cluster_size | 1 | | wsrep_cluster_state_uuid | fbd3a238-ee95-11eb-b7f2-32dd0d05b8ad | | wsrep_cluster_status | Primary | +--------------------------+--------------------------------------+ 3 rows in set (0.001 sec) MariaDB [(none)]> show global variables like '%gtid%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | gtid_binlog_pos | | | gtid_binlog_state | | | gtid_cleanup_batch_size | 64 | | gtid_current_pos | | | gtid_domain_id | 21 | | gtid_ignore_duplicates | ON | | gtid_pos_auto_engines | | | gtid_slave_pos | | | gtid_strict_mode | OFF | | wsrep_gtid_domain_id | 2 | | wsrep_gtid_mode | ON | +-------------------------+-------+ 11 rows in set (0.001 sec) MariaDB [(none)]> show master status; +------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000002 | 328 | | | +------------------+----------+--------------+------------------+ 1 row in set (0.000 sec) MariaDB [(none)]> create database test123; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> show global variables like '%gtid%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | gtid_binlog_pos | 1-1-1 | | gtid_binlog_state | 1-1-1 | | gtid_cleanup_batch_size | 64 | | gtid_current_pos | | | gtid_domain_id | 21 | | gtid_ignore_duplicates | ON | | gtid_pos_auto_engines | | | gtid_slave_pos | | | gtid_strict_mode | OFF | | wsrep_gtid_domain_id | 2 | | wsrep_gtid_mode | ON | +-------------------------+-------+ 11 rows in set (0.001 sec) MariaDB [(none)]> show binlog events in 'mysql-bin.000002'; +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | mysql-bin.000002 | 4 | Format_desc | 2 | 256 | Server ver: 10.5.11-MariaDB-log, Binlog ver: 4 | | mysql-bin.000002 | 256 | Gtid_list | 2 | 285 | [] | | mysql-bin.000002 | 285 | Binlog_checkpoint | 2 | 328 | mysql-bin.000002 | | mysql-bin.000002 | 328 | Gtid | 1 | 370 | GTID 1-1-1 | | mysql-bin.000002 | 370 | Query | 1 | 468 | create database test123 | +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ 5 rows in set (0.000 sec) MariaDB [(none)]> exit Bye [root@vmc21 mariabackup_slavebuild]# cat xtrabackup_binlog_info mysql-bin.000003 525 1-1-18 [root@vmc21 mariabackup_slavebuild]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.5.11-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> set global gtid_slave_pos='1-1-18'; Query OK, 0 rows affected (0.004 sec) MariaDB [(none)]> show global variables like '%gtid%'; +-------------------------+--------+ | Variable_name | Value | +-------------------------+--------+ | gtid_binlog_pos | 1-1-1 | | gtid_binlog_state | 1-1-1 | | gtid_cleanup_batch_size | 64 | | gtid_current_pos | 1-1-18 | | gtid_domain_id | 21 | | gtid_ignore_duplicates | ON | | gtid_pos_auto_engines | | | gtid_slave_pos | 1-1-18 | | gtid_strict_mode | OFF | | wsrep_gtid_domain_id | 2 | | wsrep_gtid_mode | ON | +-------------------------+--------+ 11 rows in set (0.001 sec) MariaDB [(none)]> change master to master_host='192.168.8.11', master_port=3306, master_user='repl_user', master_password='repl_user',MASTER_USE_GTID=slave_pos; Query OK, 0 rows affected (0.012 sec) MariaDB [(none)]> start slave; Query OK, 0 rows affected (0.012 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.8.11 Master_User: repl_user Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 525 Relay_Log_File: vmc21-relay-bin.000002 Relay_Log_Pos: 727 Relay_Master_Log_File: mysql-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 525 Relay_Log_Space: 1036 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 1-1-18 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 0 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> drop database test123; Query OK, 0 rows affected (0.003 sec) MariaDB [(none)]> show global variables like '%gtid%'; +-------------------------+--------+ | Variable_name | Value | +-------------------------+--------+ | gtid_binlog_pos | 1-1-2 | | gtid_binlog_state | 1-1-2 | | gtid_cleanup_batch_size | 64 | | gtid_current_pos | 1-1-18 | | gtid_domain_id | 21 | | gtid_ignore_duplicates | ON | | gtid_pos_auto_engines | | | gtid_slave_pos | 1-1-18 | | gtid_strict_mode | OFF | | wsrep_gtid_domain_id | 2 | | wsrep_gtid_mode | ON | +-------------------------+--------+ 11 rows in set (0.001 sec) MariaDB [(none)]> show binlog events in 'mysql-bin.000002'; +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | mysql-bin.000002 | 4 | Format_desc | 2 | 256 | Server ver: 10.5.11-MariaDB-log, Binlog ver: 4 | | mysql-bin.000002 | 256 | Gtid_list | 2 | 285 | [] | | mysql-bin.000002 | 285 | Binlog_checkpoint | 2 | 328 | mysql-bin.000002 | | mysql-bin.000002 | 328 | Gtid | 1 | 370 | GTID 1-1-1 | | mysql-bin.000002 | 370 | Query | 1 | 468 | create database test123 | | mysql-bin.000002 | 468 | Gtid | 1 | 510 | GTID 1-1-2 | | mysql-bin.000002 | 510 | Query | 1 | 606 | drop database test123 | +------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ 7 rows in set (0.000 sec) MariaDB [(none)]> select @@hostname; +------------+ | @@hostname | +------------+ | vmc21 | +------------+ 1 row in set (0.000 sec) MariaDB [(none)]> create database sbtest100; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> drop database sbtest100; Query OK, 0 rows affected (0.002 sec) MariaDB [(none)]> show binlog events in 'mysql-bin.000002' from 892; +------------------+------+------------+-----------+-------------+---------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +------------------+------+------------+-----------+-------------+---------------------------+ | mysql-bin.000002 | 892 | Gtid | 1 | 934 | GTID 1-1-3 | | mysql-bin.000002 | 934 | Query | 1 | 1036 | create database sbtest100 | | mysql-bin.000002 | 1036 | Gtid | 1 | 1078 | GTID 1-1-4 | | mysql-bin.000002 | 1078 | Query | 1 | 1178 | drop database sbtest100 | +------------------+------+------------+-----------+-------------+---------------------------+ 4 rows in set (0.000 sec)