Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [gtid]

GTID - MySQL's Global Transaction Identifier

GTID is a 31 character UUID that associates with one or more transactions with the MySQL Server the transaction originated from. When mysqld is running with gtid_mode=ON, each transaction recorded in a binary log is preceded by a token UUID:NNN where NNN is the transaction number.

44 questions
6
votes
2 answers

SQL_SLAVE_SKIP_COUNTER = 1 fails, setting @@gtid_slave_pos used to skip a given GTID position

I recently broke replication and when I tried to get past the one incorrect transaction. I got the following. MariaDB [(none)]> STOP SLAVE; Query OK, 0 rows affected (0.05 sec) MariaDB [(none)]> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; ERROR 1966…
nelaaro
  • 767
  • 3
  • 10
  • 22
5
votes
1 answer

mysqlpump --set-gtid-purged=OFF still adds @SESSION.SQL_LOG_BIN=0;

Whenever I add --set-gtid-purged=OFF, it still adds @@SESSION.SQL_LOG_BIN=0; to the output. According to the documentation, shouldn't it get removed? --set-gtid-purged=OFF: SET @@SESSION.SQL_LOG_BIN=0; is not added to the output. Dump created by…
Watson
  • 155
  • 1
  • 5
5
votes
1 answer

Replication stops with GTID_NEXT error after creation/drop of memory table in mysql5.6

We have recently upgraded to mysql5.6.25 from mysql5.5.x/mysql5.1.x on our mysql-cluster. Below is a brief snapshot of our architecture. Since we have upgraded and enabled gtid-mode we have been intermittently getting slave errors similar to…
raman2887
  • 51
  • 1
  • 3
3
votes
0 answers

Got fatal error 1236 from master when reading data from binary log

I am trying to do a MySQL failover, in some situations I endup with broken replication. Any idea what could be the cause of it ? Background Needed to perform a host updates on master host. Hence promoting one of the slave as new master and restore…
RobinHood
  • 49
  • 2
3
votes
4 answers

MySQL: Remove bad GTID from GTID Set

MySQL 5.6.35-log (community) How can I remove a incorrectly manually injected GTID from a GTID set without doing a RESET MASTER? STOP SLAVE; SHOW MASTER…
Van
  • 328
  • 3
  • 10
2
votes
2 answers

Vague replication error code 2005

2015-04-07 13:49:53 23758 [ERROR] Slave I/O: error connecting to master 'replication'@master-host:3306' - retry-time: 60 retries: 1, Error_code: 2005 This was after attempting to do a change master to from previously running replication. The only…
atxdba
  • 5,293
  • 5
  • 41
  • 62
2
votes
1 answer

GTID replication from a MySQL 5.7.38 Master to MariDB 10.6.10?

Is it possible to use GTID in a replication scenario where MySQL 5.7.38 is the master and MariaDB 10.6.10 is the slave?
aeaeae
  • 23
  • 3
2
votes
0 answers

Faster way to restore MySQL innoDB dump

I have a below MySQL configuration. # The MySQL server [mysqld] .... key_buffer = 384M max_allowed_packet = 5M table_open_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M ... # enable GTID mode gtid_mode =…
RobinHood
  • 49
  • 2
2
votes
0 answers

CREATE TABLE AS SELECT with GTID

I am trying to migrate to MySQL/Percona server 8.0 and GTID based replication and have stumbled upon the issue where CREATE TABLE AS SELECT is not allowed using GTID. The tables that are created are for materializing complex selects which span…
Paso
  • 121
  • 3
2
votes
2 answers

Should I turn off GTID to fix this error?

Recently, a query has started failing. It is a query in the Magento software core (not a module) that Reindexes Catalog Search. I have receive the following error. Catalog Search Index index process unknown error: exception 'PDOException' with…
Goose
  • 319
  • 2
  • 4
  • 12
2
votes
2 answers

mysql gtid_executed and gtid_purged variables

I would like to know where the gtid_executed and gtid_purged variables are stored in the database engine. If these are just runtime variables how exactly are they initialized?
Jeff
  • 123
  • 1
  • 3
1
vote
1 answer

Restoring a primary mysqldump on a R/O replica

EDITED: I've encountered the following error message on my R/O replica which supports GTIDs and had not been running for a few weeks: Last_IO_Error: Got fatal error 1236 from source when reading data from binary log: 'Cannot replicate because the…
jean-christophe manciot
  • 121
  • 4
1
vote
1 answer

How to resolve GTID difference between Master and Slave servers in MariaDB replication using MaxScale?

I wrote accidently directly on the Slave DB, and therefore the data is not in sync anymore. When I check MaxScale status, all servers are running, but the Slaves are not detected as "Slave" and there is a difference in GTID. Does anyone know how to…
Lucian Tarbă
  • 21
  • 5
1
vote
0 answers

How to see content of specific GTID transaction in MySQL

To maintain my GTID-Replication, I want to see the content of the GTID transaction. I use this command to do that: #I want to see the content of binlog when GTID=1 mysqlbinlog -u USER -p'PASS' mysql-bin.000001 --database=DB …
N_Z
  • 248
  • 2
  • 13
1
vote
2 answers

Does GTID have only benefits in MySQL over "standard" Replication?

I'm used to setup MySQL replication in the old-fashioned way and notice now there is a method using GTID. From what I read, GTID is presented has an improvement over "standard" replication. But I'm sceptical because if GTID is so good I'm surprised…
Baptiste Mille-Mathias
  • 130
  • 1
  • 10
1
2 3