19
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 ...
- 40.5k
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 ...
- 343
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 ...
- 1,187
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 ...
- 74k
6
votes
Accepted
Seconds_behind_master value keeps on increasing in MySQL replication slave
I won't worry about it if the IO and SQL are running, as well as the Relay_Master_Log_File is catching up with the Master_Log_File. I believe the delay is in the fact that your total relay log file is ...
- 9,176
6
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 ...
- 22.4k
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 ...
- 51
5
votes
What's the best method to achieve full redundancy in a dedicated server?
This depends entirely on the architecture and availability options of the specific applications in use.
Does your database support a clustered deployment? A mirrored/replicated deployment? Both? ...
- 101k
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 ...
- 45.5k
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 ...
- 241k
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 ...
- 1,572
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 ...
- 24.3k
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 ...
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....
3
votes
Accepted
Galera new cluster WSREP Unknown error 141
We had this problem too, and it took me a while to figure out what was going on because I managed to get Galera working at one point, then it failed again when I tried to repeat it all from scratch.
...
- 46
3
votes
Replicating a linux web server
You don't mention, but I assume that you are after a multi-master setup. This rules out master-slave database setups.
I believe which technology to use for security will be the least of your worries.
...
- 1,518
3
votes
Replicating a linux web server
rsync is a great tool for keeping files in sync. I would use it in combination with SSH (and public keys), like this:
rsync -az -e ssh --delete /var/www otherserver:/var/www
For multiple servers ...
3
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 ...
3
votes
Accepted
Binlog format - RDS default
There's no discrepancy. RDS, being a managed service, does not enable every possible configurable value for every configuration parameter.
The architects of RDS chose not to make STATEMENT ...
- 22.4k
3
votes
GTID have been turned off But I have error in replication
I already fix the replication by run the mysql_upgrade that I forgot to run after updating MariaDB from 5 to 10.
Thanks
3
votes
Accepted
Multi-state MySQL master/slave pacemaker resource fails to launch on cluster nodes
Solution
Thanks to the folks that investigated with me, I was able to find the solution to my problem and I do now have a working setup. If you feel brave enough, you can read the comments on the ...
- 271
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 ...
- 24.3k
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 ...
- 1,086
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, ...
- 20k
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 ...
- 4,897
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 ...
- 4,897
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 ...
- 4,558
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 ...
- 301
3
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
***...
- 51
Only top scored, non community-wiki answers of a minimum length are eligible