Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [gtid]

GTID - MySQL's Global Transaction Identifier

0
votes
0answers
17 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 ...
0
votes
0answers
12 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
28 views

Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active

I am trying to setup mysql 5.7 GTID replication but when I try to reset CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=1; I get the following error: ERROR 1776 (HY000): ...
0
votes
0answers
32 views

Mysql GTID replication - Master has purged binary logs containing GTIDs

Im setting up replication with GTID. The total database size is 4GB. DUMP: mysqldump -h MASTER_IP --databases db-u bhuvi -p \ --master-data=1 \ --routines \ --triggers \ --events \ --flush-...
0
votes
0answers
14 views

MySQL 5.6 and Replication

I'm stuck with one specificity of Replication on MySQL servers. I'm currently working with this configuration : A <--> B ⊦---> C ---> D I explain. I've got a replication Master <-->...
0
votes
0answers
14 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 ...
0
votes
0answers
53 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
53 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 ...
0
votes
0answers
24 views

Does MySQL 5.7 support multi-source replication with GTID enabled?

The plan was to retrieve data to one MySQL db and keep replicating from different sources. The problem is all the upstream DBs are base on GTID, since GTID is globally identical, is this even possible ...
0
votes
0answers
235 views

Should we use slave_pos or current_pos with MariaDB 2 node GTID master-master replication?

We are currently migrating our DB cluster from "traditional" binlog based replication to GTID based one. We use MariaDB 10.1.31 and the topology is pretty straight forward - 2 nodes each is master and ...
1
vote
1answer
340 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
1k 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
1answer
1k 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
33 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
541 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
502 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
119 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
1k 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:...
1
vote
1answer
147 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
998 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
3k 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 ...
1
vote
2answers
2k 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
4k 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 ...
3
votes
0answers
1k 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
682 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
2k 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 ...