Administrace komentářů

Starám se o db server s mysql 8 z repa repo.mysql.com na Ubuntu 18 LTS. Z nějakého důvodu bylo na serveru zapnuto GTID a udělány k serveru 2 repliky. Bohužel nyní se nedaří GTID zbavit. Postupoval jsem podle návodu ze stránek mysql.com. Vypnu GTID online, udělám reset master a flush logs, a GTID je vypnuté. Po restaru mysql je v error logu jen "[Note] [MY-011980] [InnoDB] GTID recovery trx_no: 9375865" a GTID je zase nahozené. V konfigu mysql mám GTID zakázané. (GTID_MODE = OFF a ENFORCE_GTID_CONSISTENCY = OFF ) . Hledal jsem v dokeumentaci, ale nic jsem k tomu nenašel. Neuměl by mi někdo poradit jak se GTID zbavit?

mysql> SHOW VARIABLES LIKE '%gti%';
+----------------------------------+----------------------------------------+
| Variable_name                    | Value                                  |
+----------------------------------+----------------------------------------+
| binlog_gtid_simple_recovery      | OFF                                    |
| enforce_gtid_consistency         | ON                                     |
| gtid_executed                    | 3290d1e2-16d1-11ec-b8c6-005056ac7ad9:1 |
| gtid_executed_compression_period | 0                                      |
| gtid_mode                        | ON                                     |
| gtid_next                        | AUTOMATIC                              |
| gtid_owned                       |                                        |
| gtid_purged                      |                                        |
| session_track_gtids              | OFF                                    |
+----------------------------------+----------------------------------------+
9 rows in set (0.01 sec)

mysql> SET @@GLOBAL.GTID_MODE = ON_PERMISSIVE;
Query OK, 0 rows affected (0.05 sec)

mysql> SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE;
Query OK, 0 rows affected (0.03 sec)

mysql> SET @@GLOBAL.GTID_MODE = OFF;
Query OK, 0 rows affected (0.04 sec)

mysql> SET @@GLOBAL.enforce_gtid_consistency=OFF;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE '%gti%';
+----------------------------------+------------------------------------------+
| Variable_name                    | Value                                    |
+----------------------------------+------------------------------------------+
| binlog_gtid_simple_recovery      | OFF                                      |
| enforce_gtid_consistency         | OFF                                      |
| gtid_executed                    | 3290d1e2-16d1-11ec-b8c6-005056ac7ad9:1-2 |
| gtid_executed_compression_period | 0                                        |
| gtid_mode                        | OFF                                      |
| gtid_next                        | AUTOMATIC                                |
| gtid_owned                       |                                          |
| gtid_purged                      |                                          |
| session_track_gtids              | OFF                                      |
+----------------------------------+------------------------------------------+
9 rows in set (0.00 sec)

mysql> flush logs
    -> ;
Query OK, 0 rows affected (0.05 sec)

mysql> reset master;
Query OK, 0 rows affected (0.05 sec)

mysql> show binary logs;
+---------------+-----------+-----------+
| Log_name      | File_size | Encrypted |
+---------------+-----------+-----------+
| binlog.000001 |       156 | No        |
+---------------+-----------+-----------+
1 row in set (0.00 sec)

mysql> SHOW VARIABLES LIKE '%gti%';
+----------------------------------+-----------+
| Variable_name                    | Value     |
+----------------------------------+-----------+
| binlog_gtid_simple_recovery      | OFF       |
| enforce_gtid_consistency         | OFF       |
| gtid_executed                    |           |
| gtid_executed_compression_period | 0         |
| gtid_mode                        | OFF       |
| gtid_next                        | AUTOMATIC |
| gtid_owned                       |           |
| gtid_purged                      |           |
| session_track_gtids              | OFF       |
+----------------------------------+-----------+
9 rows in set (0.01 sec)

mysql> 

tail -n 200  /var/log/mysql/error.log |grep  -i "GTID\|shutdown"
2022-03-01T21:03:19.508010Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 9372244
2022-03-01T21:20:40.582510Z 478 [System] [MY-010035] [Server] Changed GTID_MODE from ON to ON_PERMISSIVE.
2022-03-01T21:20:46.374331Z 478 [System] [MY-010035] [Server] Changed GTID_MODE from ON_PERMISSIVE to OFF_PERMISSIVE.
2022-03-01T21:20:58.430702Z 478 [System] [MY-010035] [Server] Changed GTID_MODE from OFF_PERMISSIVE to OFF.
2022-03-01T21:21:17.122360Z 478 [Note] [MY-010034] [Server] Changed ENFORCE_GTID_CONSISTENCY from ON to OFF.
2022-03-01T21:43:23.081767Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user v_i_a user signal. Shutting down mysqld (Version: 8.0.26).
2022-03-01T21:43:23.364627Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2022-03-01T21:43:24.664927Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 32131780623
2022-03-01T21:43:24.678127Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26)  MySQL Community Server - GPL.
2022-03-01T21:57:53.705999Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 9375865