Questions tagged [gtid]

GTID - MySQL's Global Transaction Identifier

Filter by
Sorted by
Tagged with
0
votes
0answers
7 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
6 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
0answers
19 views

How to turn on GTID on MariaDB if already using binary/position replication?

MariaDB 10.3 current master config [mysqld] log-bin server_id=1 binlog-format=mixed expire_logs_days=10 current slave config [mysqld] log-bin server_id=2 binlog-format=mixed expire_logs_days=10 I ...
0
votes
2answers
239 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 ...
0
votes
0answers
86 views

Master-Master Mysql Replication temporarily stuck

I've set up a Master Master replication using GTID (Mysql 5.7.29 @ Debian). Its setup for multi-source, but only two servers are in use now. Once in a while, the execution of the transactions on one ...
1
vote
0answers
239 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
146 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
284 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 ...
1
vote
0answers
212 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
59 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
35 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
106 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
1k 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
96 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
289 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
327 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
349 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
980 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
38 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
190 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 ...
1
vote
4answers
4k 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
206 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 ...
1
vote
1answer
1k 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
4k 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 ...
4
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 ...
0
votes
0answers
790 views

How to troubleshoot, find and fix query Percona 5.6 with error “SQLSTATE[HY000]: General error: 1785 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1”

i'm running Magento CMS, and underneath there are 2 physical servers both with Percona Server version: 5.6.23-72.1-log Percona Server (GPL), Release 72.1, Revision 0503478 in Master/Slave with ...
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 ...