Questions tagged [gtid]

GTID - MySQL's Global Transaction Identifier

Filter by
Sorted by
Tagged with
2 votes
1 answer
25 views

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?
  • 23
0 votes
1 answer
49 views

Error 1236 in MySQL GTID Slave due to mistaken 'reset master' on MySQL 5.7 GTID master

Sequence of events: Disabled binary logs in MySQL 8 slave with the following relevant parameters in mysqld.cnf: log-replica-updates = OFF gtid-mode = ON enforce-gtid-consistency = ON master-info-...
0 votes
1 answer
31 views

fixing GTID based multi source replication error on selected source

I can't find or think of a solution when ever i encounter db replication errors on affected source and repositioning the GTID in the replica. What i do is retrieve from (four) masters gtid postion (...
  • 1
0 votes
0 answers
48 views

AWS RDS for MySQL and On-Prem MySQL multi-master replication error 1236 from master when reading data from binary log

I am trying to set up a GTID multi-master replication between On-Prem MySQL and AWS RDS MySQL, so RDS MySQL should act as replica for On-Prem MySQL and vice versa. Due to the fact that we have a ...
  • 1
0 votes
0 answers
21 views

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) Are ...
  • 111
0 votes
0 answers
255 views

ERROR 1682 (HY000): Native table 'performance_schema'.'global_variables' has the wrong structure

I’m getting stuck into a strange problem. When I check for global_variable -it says my performance schema has wrong structure: mysql> SHOW GLOBAL VARIABLES WHERE Variable_name = 'gtid_mode'; ...
  • 328
0 votes
0 answers
32 views

How to start a replica from a gtid postion two days before

I am using Blackhole tables in slave in gtid replication. There are few binary logs of slave. I want to reread old data of master binary logs from a specific gtid. I cannot execute RESET MASTER due to ...
  • 99
1 vote
2 answers
448 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
1 answer
213 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 ...
3 votes
0 answers
957 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 ...
1 vote
0 answers
157 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
2 answers
2k 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
0 answers
491 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
1 answer
528 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
0 answers
552 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 ...
  • 121
3 votes
1 answer
1k 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=...
  • 133
0 votes
1 answer
111 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 ...
  • 133
1 vote
0 answers
39 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
0 answers
127 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
2 answers
4k 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
0 answers
144 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 ...
  • 1,738
0 votes
0 answers
406 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,738
1 vote
0 answers
416 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 ...
  • 1,738
0 votes
1 answer
530 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,738
1 vote
1 answer
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
2 answers
7k 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)]&...
  • 667
2 votes
2 answers
7k 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 ...
  • 299
0 votes
1 answer
49 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 ...
  • 105
1 vote
0 answers
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 ...
  • 73
1 vote
2 answers
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
0 answers
270 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
4 answers
6k 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:...
  • 308
0 votes
1 answer
260 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
1 answer
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 ...
  • 109
1 vote
1 answer
6k 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 ...
  • 437
2 votes
2 answers
6k 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?
  • 123
1 vote
1 answer
6k 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
1 answer
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
2 answers
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 ...
  • 5,173