Stack Overflow
Stack Overflow

Questions tagged [gtid]

A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (master). This identifier is unique not only to the server on which it originated, but is unique across all servers in a given replication setup. There is a 1-to-1 mapping between all transactions and all GTIDs.

More information: GTID Concepts

41 questions
1
vote
1 answer

How to skip GTID transaction for a particular channel in MyQL?

We can skip a error in GTID based replication by following steps: STOP SLAVE; set GTID_NEXT='SERVER_UUID:LAST_TRANSACTION_NUMBER+1' ; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE; But if a replication is running with channel information,…
Aman Aggarwal
  • 17,619
  • 9
  • 53
  • 81
1
vote
1 answer

MySQL multiple GTID Executed GTID set

I believe I have an issue of sorts with MySQL Replication on the slaves. Instead of there being one clean GTID under 'Executed GTID Set' there are multiple GTIDs. Retrieved_Gtid_Set:…
user2841861
  • 423
  • 2
  • 8
  • 22
1
vote
1 answer

eclipselink and mysql's GTID replication

I'm in the process of migrating an existing JPA/eclipselink application from mysql 5.5 to mysql 5.6 and I'd like to use GTID replication going forward. However, MySQL's documentation for Global Transaction Identifiers (GTID) calls out specific…
invinity
  • 21
  • 5
0
votes
1 answer

How can I solve this GTID error when restoring through binlogs?

I have a sequence of sql files created with the command mysqlbinlog binlog.000093 > log93.sql, from 93 to 109. These logs go back to the creation of the database, so I suppose I can fully restore the database. I need to restore the database to the…
Damiano Scevola
  • 86
  • 7
0
votes
1 answer

Is there a way to actively get the newest MariaDB GTID without constantly querying the server?

I establish the master-slave replication based on GTID. And i want to get the newest GTID of master or slave, I know the way of getting GTID by show variables like '%gtid%', but this way requires constant timed query. Is there any way about mariadb…
programZhuang
  • 1
0
votes
0 answers

Promote Slave with MySQL GTIDs failing with slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs

Working on promoting a slave to master with MySQL GTIDs. Normally without GTID we would pause traffic flip replication streams then start traffic again. With GTIDs do we still need to pause traffic? Tried failing traffic to the slave then changing…
Obsete
  • 1
  • 1
0
votes
0 answers

MySQL replication with 3 nodes (GTID and channels)

I would like to ask a question regarding replication of 3 nodes within MySQL before I do proceed with my idea by purchasing more hardware. That being the case, currently I do have 2 nodes with master-master GTID based replication (lets name those…
xc3s50an
  • 21
  • 3
0
votes
1 answer

MariaDB server isn't rejoining as slave after being down

I was testing a few failover cases & initially this was my setup maxctrl list servers ┌─────────┬────────────────┬──────┬─────────────┬─────────────────┬────────────┐ │ Server │ Address │ Port │ Connections │ State │ GTID …
Nandni
  • 1
0
votes
1 answer

MySQL enable GTID on Replica MySQL instance

We are currently using binary replication from our master to slave. Is it possible to enable the GTID on the slave only? (this is required from some other application reading from the replicas, but we don't want to make changes to master) Are there…
M4rk
  • 2,172
  • 5
  • 36
  • 70
0
votes
0 answers

Why GTID on Master is different from GTID on Slave while both are synced (MariaDB 10.5)?

I have noticed that the Gtid_IO_Pos value is 0-1-557278 and gtid_current_pos on Master is 0-1-557279. On Slave: MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State:…
Mohammad Ali Sarbanha
  • 37
  • 7
0
votes
0 answers

Error 1062 : Duplicate entry on the slave after a failover

TOPIC MOVED IN DBA SO I need a little bit of help for this problem : I got this error : Could not execute Write_rows event on table ....; Duplicate entry '16XXXXX-\xE790\XXXXXXX-16XXXXXX' for key 'PRIMARY', Error_code: 1062; handler error…
AnonymeJohnDoe
  • 1
  • 3
0
votes
0 answers

MySQL 8 group replication: How to skip some GTID transactions

We have a MySQL 8 replication group. How can we skip some GTID transactions which cause errors on slave.
giang
  • 33
  • 5
0
votes
1 answer

Does MySQL stalls the whole cluster during DDL statements?

Recently, I read that Galera based MySQL cluster uses a concept called total order isolation (https://galeracluster.com/library/documentation/schema-upgrades.html#toi) for DDL's by default which stalls the writes on the whole cluster until it is…
Shubham Jairath
  • 382
  • 1
  • 4
  • 14
0
votes
0 answers

MySQL GTID, is my setup a Master <=(Slave,Master)=> Slave type?

My boss has given me the task to migrate a quite old ecommerce legacy web based application to a new server. Its database has around 150m rows in total and it runs on MySQL 5.6 and PHP 5.5.9. On this application, there is what seems to be a MySQL…
user2094178
  • 9,204
  • 10
  • 41
  • 70
0
votes
2 answers

Can ProxySQL be asked to use a specific GTID on a read?

We have an application that issues a write to ProxySQL, followed by an immediate read that might be affected by the write. Behind ProxySQL are four MySQL servers - one writer and three readers that replicate from the writer. Now, ProxySQL is able…
Thickycat
  • 894
  • 6
  • 12
1
2
3