[root@vmc11 mysql]# cat /etc/my.cnf |grep -i server-id
|
server-id=800
|
[root@vmc11 mysql]# cat /etc/my.cnf |grep -i wsrep_on
|
wsrep_on=1
|
[root@vmc11 mysql]# galera_new_cluster
|
[root@vmc11 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)]> show global status like '%wsrep_cluster_s%';
|
+--------------------------+--------------------------------------+
|
| Variable_name | Value |
|
+--------------------------+--------------------------------------+
|
| wsrep_cluster_size | 1 |
|
| wsrep_cluster_state_uuid | ed1d4249-ee72-11eb-862d-eb9f56d82d4a |
|
| 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 | 800 | 1 | 1 |
|
+------------------+-------------+------------------------+-------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> show global variables like '%gtid%';
|
+-------------------------+---------+
|
| Variable_name | Value |
|
+-------------------------+---------+
|
| gtid_binlog_pos | 1-600-1 |
|
| gtid_binlog_state | 1-600-1 |
|
| gtid_cleanup_batch_size | 64 |
|
| gtid_current_pos | |
|
| 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.000005 | 342 | | |
|
+------------------+----------+--------------+------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> drop database sbtest;
|
Query OK, 0 rows affected (0.002 sec)
|
|
MariaDB [(none)]> create database sbtest;
|
Query OK, 1 row affected (0.001 sec)
|
|
MariaDB [(none)]> show global variables like '%gtid%';
|
+-------------------------+---------+
|
| Variable_name | Value |
|
+-------------------------+---------+
|
| gtid_binlog_pos | 1-600-3 |
|
| gtid_binlog_state | 1-600-3 |
|
| gtid_cleanup_batch_size | 64 |
|
| gtid_current_pos | |
|
| 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 binlog events in 'mysql-bin.000005' from 342;
|
+------------------+-----+------------+-----------+-------------+------------------------+
|
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
|
+------------------+-----+------------+-----------+-------------+------------------------+
|
| mysql-bin.000005 | 342 | Gtid | 600 | 384 | GTID 1-600-2 |
|
| mysql-bin.000005 | 384 | Query | 600 | 478 | drop database sbtest |
|
| mysql-bin.000005 | 478 | Gtid | 600 | 520 | GTID 1-600-3 |
|
| mysql-bin.000005 | 520 | Query | 600 | 616 | create database sbtest |
|
+------------------+-----+------------+-----------+-------------+------------------------+
|
|
Reproducible_test_case_with_extracted_Binary_log.txt
my.cnf