Questions tagged [gtid]

GTID - MySQL's Global Transaction Identifier

Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

display the transaction for a given GTID in MySQL

is there a way to show the statements of a transaction for a given GTID ? I know the binlog, if the correspond binlog file was not purged, can be used, but I'd like to know if I could see any ...
0
votes
2answers
28 views

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. ...
0
votes
0answers
34 views

MySQL 8 can not enable Mast-Master Replication after rollback from GTID Replication

can you help me with this issue please? I have rolled back from GTID replication to traditional (master-master replication with binlog), and at the same time I’m adding new node to the cluster as ...
0
votes
0answers
12 views

Not able to see the master gtid in gtid_executed_set slave status after switching master. But replication is working fine

I recently switched source of a slave(C) from a existing master. The old architecture was B<--A-->C, A being the primary source for B and C. After switching master, now it is working as A-->B-...
0
votes
1answer
43 views

Enabling mySQL replication using GTID after purging binlog

I am currently working to get GTID based replication established between mySQL 5.7.33 on 2 servers. Amidst this work, I ran into a disk space issue and purged the binary logs on the master. Now I have ...
2
votes
0answers
176 views

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 ...
0
votes
0answers
14 views

Understanding MySQL Innodb replication issue

I am trying to flip MySQL primary/ RW database from one host to other host. There are times where replication on the workers is broken post flip. Trying to understand the internal details and best ...
1
vote
0answers
53 views

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 = ...
1
vote
0answers
133 views

Error 1062 : Duplicate entry on the slave after a failover

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: ...
0
votes
0answers
11 views

I'm looking for steps to reset my master-master replication after an error

I'm using mysql 5.7.30 with GTID enabled on two nodes (rhel 7.8) configured for master-master replication. In the event of an error where one or both of my slaves stop running I would like some ...
0
votes
0answers
9 views

How are GTIDs used to determine what transaction should be executed?

I use MariaDB 10.14 on servers M1, S2, S3. M1 is active master, and servers S2 and S3 replicate from M1. S3 also replicates from S2. All servers have GTID domain ID=1 then M1.server_id=100, S2....
0
votes
2answers
657 views

Broken Slave MySQL : How To Fix MySQL Replication (BINLOG) error in the Slave?

Before we start I can give some info about the versions, Ubuntu - 14.04, MySQL - 5.5 I have successfully configured the Master-Slave replication with two EC2 Ubuntu instances. My master is in Ubuntu ...
1
vote
0answers
340 views

Restart a GTID Based MySQL Master-Master Replication

I can see many good articles around the web about setting up MySQL Master-Master Replication with GTID. However, strangely enough, I simply can't find the same about in how to stop and start it. My ...
1
vote
1answer
255 views

Restoring a mysqldump loses user privileges for routines?

When I try and restore a mysqldump, the user privileges against some routines are missing. From what I can tell that is happeneing the routines that are in schemas that are loaded after the mysql ...
2
votes
0answers
369 views

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 ...
2
votes
1answer
286 views

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
votes
1answer
85 views

Repair GTID from Restore with sql_log_bin=0 and then drop table

I have been experimenting with mysql innodb cluster. One of the errors i've come across I don't know how to remedy or why exactly it causes a permanent death to any slave that wishes to catch up to ...
1
vote
0answers
36 views

What does it take to replicate the mysql, 'mysql' database correctly?

I've searched for a while and I am having trouble finding anything that even addresses my situation. I have need to replicate the 'user' table specifically, from my master cluster to my async slave....
1
vote
0answers
112 views

MySQL fatal error 1236 when swapping in new master, “master has purged binary logs”

Our situation: we have three MySQL 5.7.23 replica servers attached to a MySQL 5.7.23 master server running in EC2 instances in AWS. All the servers are fine and GTID replication is working properly. ...
0
votes
1answer
2k views

MariaDB GTID current_pos vs slave_pos

In a standard master-slave setup using MariaDB (10.3 at this time) and GTID (Global Transaction ID), it is unclear wether to use current_pos or slave_pos. Reminder from the documentation: Using ...
1
vote
0answers
106 views

GTID ignore error on parallel replication

Im getting an error in replication where GTID and parallel replications are enabled. Now I want to skip one transaction. I didn't find a way to do that. Last_SQL_Error: Worker 48 failed executing ...
0
votes
0answers
339 views

mysql unable to start with semi sync parameter

Im using mysql 5.7 and it has 2 slaves with GTID. I tried to enable semi-sync and I have done with set global variable in mysql prompt. It was running fine. Then I did a restart, after that mysql ...
1
vote
0answers
349 views

MHA vs Orchestrator

Im going to setup an HA solution. Im planning to use Orchestrator. But seems MHA is also doing well. If anyone already used/using any one these solutions, please suggest me to choose a right one ...
0
votes
1answer
419 views

Enable GTID on one node in Percona/Galera

Im having 3 node percona cluster. (5.6) Server ID is enabled on each node but all are different IDs. Binlog and log slave updates are enabled. Now I want to enable GTID on the third node alone. I ...
1
vote
1answer
1k views

How do I turn off MariaDB GTID to revert back to binlog replication?

We have found concerns with GTID on MariaDB related to our multi-tenant MyISAM databases. It sounds like there are problems with temporary table replication so we'd like to revert away from GTID. How ...
6
votes
2answers
5k views

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)]&...
1
vote
2answers
5k views

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 ...
0
votes
1answer
39 views

Do MySQL GTIDs get created for all transactions or just those that occur after enabling GTIDs?

I have a MySQL database that I'm going to start replicating, and I plan on using GTIDs to do so. The slave will be a brand new virtualized server located overseas. My question is 2-fold: When I ...
1
vote
0answers
1k views

mysql 5.7 gtid based replication, Got fatal error 1236 from master when reading data from binary log

That post is not really a question, but I think stackexchange is a good place to keep record of a head scratching try, to get a GTID based replication slave working. Just in case someone hit's the ...
1
vote
2answers
1k views

MySQL Still purging binary logs and ignoring expire_logs_days

We are running mysql v5.6.17 and I cannot find if there is something else that is causing the binary logs to be purged other than the following: Adding expire_logs_days to the my.ini (and ...
1
vote
0answers
227 views

MySql slave thinks that the query didn't run on the master, no helpful error

We have a master-slave replication that was running perfectly until recently. Today i've found the error: Query caused different errors on master and slave. Error on master: message (format)='Size ...
2
votes
4answers
5k views

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 STATUS; 278bfda1-b93d-11e4-801b-14feb5d284bc:...
0
votes
1answer
213 views

changes on multimaster replication and activate GTID

I've been reading a lot about the changes I planned to do to our DB landscape but I need some confirmation or recommendation to be sure the work I'll do goes without causing a disaster. Here is what ...
0
votes
1answer
2k views

MySQL GTID error 1236

I am try to reduce machine come to live in production.. MySQL is making bottleneck. What i trying. I update code in one machine and also MySQL restore everything is working fine after this i am making ...
1
vote
1answer
5k views

Got fatal error 1236 Slave has more GTIDs than the master has, using the master's SERVER_UUID

We are testing replication using GTID's on two servers running MySQL 5.6. Replication was running fine, but now it is not functioning. When I run show slave status\G on the slave, I get the following ...
2
votes
2answers
5k views

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?
1
vote
1answer
5k views

mysql 5.6 gtid replication slave stuck (system lock)?

I have set up 5.6 gtid based replication (on 5.6.26) it seemed to work when I did it, it replicated my random test db over that I created beside normal data. However at some point something must have ...
5
votes
1answer
2k views

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 ...
2
votes
2answers
3k views

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 ...