Skip to main content
21 votes
Accepted

Slave_SQL_Running: No: MySQL replication stopped working

TL;DR STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE; Now the slightly longer version: if you have manually created the user on your slave first and on your master second, the ...
the-wabbit's user avatar
  • 41.1k
10 votes

Slave replication stops with Last_SQL_Errno: 1032

You can locate the sql clause code like /usr/bin/mysqlbinlog -v --start-position=142743807 --stop-position=147399325 /data/mysql/data/master-bin.000010 > temp.log Then compare slave and master ...
LF-DevJourney's user avatar
8 votes
Accepted

MySQL Slave stuck on a single bin log + bin log position for 17+ hours

I was on the right track here with the large query transactions from yesterday. After I migrated the data, I executed a DELETE statement on the original table, to get rid of the rows that I had ...
Jim Rubenstein's user avatar
7 votes
Accepted

How do I make an AWS RDS MySQL Read "replica" have a different schema?

The problem is that the AWS RDS MySQL read-replica mechanism requires that the two schemas be exact. Replication, in general, requires this. But, if your definition of "close enough" is indeed close ...
Michael - sqlbot's user avatar
7 votes

Can I put the MySQL binlogs on a slow disk?

Binary logging is done immediately after a statement or transaction completes but before any locks are released or any commit is done, so I imagine that placing your logs on a slower disk can have an ...
HBruijn's user avatar
  • 80.8k
5 votes

Can I run mysqld on top of glusterfs?

Attempted this on a K8 cluster. MySQL running inside of a container, GlusterFS installed directly on the node (non-containerized). MySQL container had an affinity set to always run on the same node as ...
Aman B.'s user avatar
  • 51
5 votes

Can I run mysqld on top of glusterfs?

In theory you can. In practice and especially regarding the performance, Gluster manual suggests that it is not intended to be used for replicating DB files or other fine-grain I/O systems. See the ...
Mike Mountrakis's user avatar
5 votes

Can I put the MySQL binlogs on a slow disk?

From MySQL manual: By default, the binary log is synchronized to disk at each write (sync_binlog=1). If sync_binlog was not enabled, and the operating system or machine (not only the MySQL ...
shodanshok's user avatar
  • 51.1k
5 votes

error 1236 A slave with the same server_uuid/server_id as this slave has connected to the master

APPLIES TO: MySQL Server - Version 5.6 and later Information in this document applies to any platform. When attempting to start replication, the following error occurs: mysql> SHOW SLAVE STATUS\G ***...
jefry jacob's user avatar
5 votes
Accepted

Should I use public IP or private IP for connecting servers within the same VPC?

You should use internal IP addresses for your instances to talk to each other. If you use their public or elastic IP addresses, you are charged for in-region network data transfer. There is no charge ...
Michael Hampton's user avatar
4 votes

Show Slave Status not working from console, nor client

GRANT RELOAD, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'user'@'%' REPLICATION CLIENT
T D S's user avatar
  • 65
4 votes

Prevent non-replication writes to MySQL slave?

As of MySQL 5.7.8, there is now a super_read_only option, which prevents even SUPER users from performing client updates. It does not disrupt the replication process. As with other settings, it can be ...
billyw's user avatar
  • 1,622
4 votes
Accepted

mariaDB master to master replication

MySQL and MariaDB have compatible API, which means the clients and programs should work with either MySQL or MariaDB without any changes. However on the server side they are more and more diverging ...
MLu's user avatar
  • 25.6k
4 votes

How to "safely" shutdown/restart a Galera cluster?

I know it is late reply to this question. But just in case any one looking for the exact answer about how to safely shutdown and restart the mariadb galera cluster. For example we have three mariadb ...
Milad Hamid Elhaei Sahar's user avatar
4 votes

MySQL Master-Master with offsets getting ERROR 1872

On MySQL > 6 you should use also mysql> STOP SLAVE; mysql> RESET SLAVE ALL; Should be the same, but using documented command is better than tweaking into system tables. See also https://dev....
Alessandro Carini's user avatar
4 votes
Accepted

MySQL 5.7 on Ubuntu 18.04.4 LTS does not recognize any configuration-variable

All of those should be after this tag: [mysqld] The tag [mysql] refers to the commandline tool, not the server.
Rick James's user avatar
  • 2,618
4 votes
Accepted

mysql bind-address change from 127.0.0.1 to server's IP Address breaks websites

When binding an IPv4 socket, the BSD socket API (used by most *nix and other OSes) leaves two choices: bind to a single address, or bind to all addresses using the reserved address 0.0.0.0 aka ...
A.B's user avatar
  • 13k
3 votes
Accepted

Master-Slave semi circle replication not working in MySQL

FYI—this is typically called a replication relay chain. In order to turn this on, you will have to make sure the following settings are set on server B: log_bin log_slave_updates This will tell ...
2ps's user avatar
  • 1,126
3 votes

How to create a multiple mysql replication

So you're talking about several databases, that are already replicated between clients servers. And you need to add one more replication layer, and replicate them to your server, correct? What's the ...
Strepsils's user avatar
  • 5,125
3 votes

How to create a multiple mysql replication

Define your problem properly. There are several options and constraints on how you design a MySQL cluster. What is it that you are trying to achieve? (availability, performance, offline backups, ...
symcbean's user avatar
  • 22.7k
3 votes
Accepted

Best way to migrate a large database from EC2 to RDS MySQL

AWS offers the Database Migration Service (DMS) for exactly this. DMS can migrate from on-premises, EC2 or RDS instances. It offers progress, statistics and more. AWS blog: AWS Database Migration ...
jscott's user avatar
  • 24.8k
3 votes

how to mirror a database and implement failover solution

Agree with the previous answer, mysql replication can be a possible solution. Also, you can create shared storage between some of your servers, and place the VM with the database on it, thus it will ...
Strepsils's user avatar
  • 5,125
3 votes

MySQL Group Replication - does read only operations supported for disconnected node?

I've checked MySQL official documentation and haven't found answer on your question, then I googled for more information and found this article. So according this article it not possible to read from ...
Alexander Tolkachev's user avatar
3 votes

Slave replication stops with Last_SQL_Errno: 1032

For people who have this as a one off error, you can try skipping the item: SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE;
Steve's user avatar
  • 31
3 votes

MariaDb Master-master replication

Hey Mohan it is unclear if you want master to master or master to slave? To set up master to slave it is pretty simple. Especially if you have done it once or twice. In this scenario Machine A is ...
Joe M's user avatar
  • 321
2 votes

How to use read replica instance for websites? Amazon RDS MySQL

You can use route 53 to distribute traffic to your read replicas. Basically you create a domain name in your vpc, and configure route 53 to forward requests to that domain to the N replicas you place ...
mancini0's user avatar
  • 121
2 votes

GTID have been turned off But I have error in replication

sometimes a mysql_upgrade will not fix this, which will fail with below error mysql.gtid_slave_pos Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine status : Operation failed In that case, ...
alimajaf's user avatar
2 votes

Mysql GTID replication stopped working

SET GLOBAL SLAVE_NET_TIMEOUT = 60; STOP SLAVE; START SLAVE; You are right to be skeptical that this will resolve the issue, since no timeout seems to be occurring... nor so you want one to occur, but ...
Michael - sqlbot's user avatar
2 votes

MySQL won't start, ran out of disk space on /var/log

Assuming it is your binary logs that are occupying most of your disk space. All you need to do is move at least one binary log to a separate partition that has extra disk space. Only move do not ...
jerichorivera's user avatar
2 votes
Accepted

MySQL replication: any risks to master if replica is locked down?

There is absolutely no impact to the master's operations whether there is active replication or not, except of course for the load created by the replication process itself. To be 100% clear, the ...
Julie Pelletier's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible