Questions tagged [mysql-replication]
Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).
527
questions
0
votes
2
answers
473
views
MySQL Group Replication - does read only operations supported for disconnected node?
Please consider the following topology of some organization, consisting of 4 branches (A,B,C,D). All branches are located in different geo locations and interconnected with VPN:
This organization ...
1
vote
0
answers
461
views
Mysql replication, master_log_pos sync but tables not update
First, my replication config on Master:
server-id = 1
replicate-same-server-id = 0
auto-increment-increment = 1
auto-increment-offset = 1
log-bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 5
...
0
votes
2
answers
486
views
how to mirror a database and implement failover solution
There are many questions that address the issue of failover and Im a bit overwhelmed which is why I am asking about my specific situation here.
my setup is as follows:
I have three servers running ...
0
votes
1
answer
939
views
What am I missing when setting up reverse DNS?
I'm setting up rDNS for use with a SolusVM server. I used PowerDNS on two servers for a slave and a master, and set up the MySQL replication successfully. When viewing the MySQL records table, I see ...
0
votes
2
answers
2k
views
Percona-Server-shared my.cnf file conflicts with file from package mysql-community-server-5.5
I'm trying to install Percona Toolkit on the server where there is already mysql-community-server5.5.52 is running.
I require pt-table-checksum and pt-table-snc utility, so I ran:
yum install ...
2
votes
1
answer
1k
views
How to add new slave server to existing Mysql master slave replication
I have a Mysql Master server and Slave replication on Amazon Ec2 instance.
Currently need to add new slave server to this loop. I can take AMI of existing slave server and spin new slave server.
How ...
0
votes
1
answer
596
views
overwrite values with mysql master-slave replication
I have a production database with master-slave replication being done on it. Production DB backups are done off of the slave server.
I'd like to make it so that an arbitrary number of development ...
7
votes
1
answer
5k
views
MySQL Slave stuck on a single bin log + bin log position for 17+ hours
tl;dr: Replication is stalled on a specific binlog and position, and I'm not sure why
I have a MySQL Replication setup with MySQL 5.5.
This replication setup has no history of ever falling behind ...
1
vote
2
answers
103
views
How to create a multiple mysql replication
My question is about to create a mysql replication server.
Here i have multiple slaves and i want replicate all respective database into multiple master server .
Que is that how could i set multiple ...
0
votes
1
answer
424
views
secure mysql replication on a docker container with outside mysql server
I've a docker host & mariadb container in it and I want to apply a replication between this container and another server on another provider
using the following example below I was able to ...
0
votes
1
answer
509
views
Is it safe to mysqldump a section of missing data for re-importation with my flags?
Let's say on a test database about a year's data got erased. I got the two id's for the data in one year at the earliest and the data in the other at the latest and therefore a range of what's missing ...
0
votes
0
answers
902
views
mysql slave stops after restart mysql in master master setup
We upgraded from mysql 5.5 tot mysql 5.7 master-master cluster .
Now ervery time i restart mysql on one of the two host the mysql slave stops.
What is changed in mysql 5.7, how can fix this so i ...
0
votes
1
answer
201
views
Master-Slave semi circle replication not working in MySQL
I didn't know how to describe it so I am calling it semi circle. Here's what I am doing.
Server A
Server B = This is slave of Server A
Server C = This is slave of Server B
When I update something ...
2
votes
1
answer
4k
views
Multi source replication not working in MySQL
I am trying to setup multi source replication. In my slave I have defined following two properties in its configuration file.
master-info-repository=table
relay-log-info-repository=table
These ...
0
votes
1
answer
149
views
Making master server slave of another master
I have 4 MySQL servers Master1, Master2, Master3 and Master4.
Both Master1 and Master2 are masters of each other while Master3 and Master4 are masters of each other.
I want to make Master3 slave of ...
0
votes
1
answer
69
views
Charset error on replication
I'm trying to set up replication between two MariaDB databases, but I get the following error in phpMyAdmin:
Error 'Character set '#610' is not a compiled character set and is not specified in the '/...
0
votes
1
answer
202
views
How to connecct mysql with two difffrent diffrent port through haproxy
I have 2 mysql server and one ha-proxy server mysql server pointed to haproxy server with diffirent diffrent port ( 3306 and 3307 ) . when i try to connect mysql server tohrough haproxy with port 3306 ...
1
vote
2
answers
5k
views
MySQL won't start, ran out of disk space on /var/log
Long story short, I discovered expire_log_days = 3 a little too late. My /var/log directory is completely filled with old mysql-bin files, and per google/SE search, it is strongly recommended not to ...
0
votes
0
answers
87
views
pt-pmp fails to run on percona 5.5 ubuntu 12.04
Command:
[mysql] root:/mnt# pt-pmp --pid 16898
Wed Dec 7 18:41:51 UTC 2016
warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fffd4126000
18 libaio::??(libaio....
2
votes
1
answer
3k
views
Best way to migrate a large database from EC2 to RDS MySQL
I currently have my database on a MySQL server hosted in a dedicated EC2 instance and planning to migrate the DB to a RDS backed MySQL server.
Now the issue I have is with migrating the data from ...
3
votes
1
answer
1k
views
AWS RDS MySQL Replication with user with REQUIRE SSL
I'm trying to set up a MySQL read replica on AWS RDS.
The user for the slave (rdsrepladmin) has the REQUIRE SSL flag set.
This causes the read replica server to enter a perpetual 'read replication: ...
0
votes
1
answer
538
views
I/O usage high on drdb drives
The I/O usage is high on drives of drdb, but the usage is very low on the underlying drive. Is it right to ignore usage of I/O on DRDB drive as the underlying disk usage is fine.
We have 4 Redhat ...
2
votes
1
answer
786
views
Mysql GTID replication stopped working
I've setup mysql gtid replication between master and slave. the interesting thing is that I found the replication stopped working after several minutes, and I have to use stop slave and start slave to ...
0
votes
1
answer
203
views
mysql replication fail (no error)
I'm doing a replication on a mysql 5.6 server (master) to a slave in mixed mode.
The thing is, i connect to mysql trought workbench, i execute querys and are replicated.
But if another user connected ...
0
votes
1
answer
70
views
maxscale doesn't see host for binlogrouter
not sure what I'm missing I'm following the documentation but it doesn't seem to know what the host is:
2016-10-11 21:21:02 error : Failure loading users data from backend [_none_:3306] for ...
1
vote
1
answer
737
views
Can I now replicate an encrypted RDS instance to another region?
RDS offers encryption at rest, but this is incompatible with cross-region replication. The documentation states:
Because KMS encryption keys are specific to the region that they are created in, you ...
-6
votes
1
answer
596
views
How to test HA MySQL Database
Recently we have been testing an HA Database solution from a 3rd party provider.
I have done some stress tests to see some metrics for Master & Slave status etc, however I would like to test the ...
0
votes
1
answer
263
views
MySQL 5.7 Multi Master Multi Source Replication issues after mysqld restart
I've a multi master & multi source replication setup working perfectly fine.
M1 -> M2 ||
M1 -> M3
M2 -> M1 ||
M2 -> M3
M3 -> M1 ||
M3 -> M2
As soon as I restart mysqld on M2 I'm missing a ...
0
votes
1
answer
509
views
MySQL replication: any risks to master if replica is locked down?
Any danger to a MySQL master if the slave replica is locked down for an extended period of time? I am using 5.6.xx.
This question states that it's "safe", but does not speak to degradation in ...
1
vote
1
answer
4k
views
How do I make an AWS RDS MySQL Read "replica" have a different schema?
Rather than using the AWS CLI/UI to create a read replica, I would like to create a DB instance with a "close enough" schema and SET it to be the replica.
I need to make a schema change (a collation ...
2
votes
0
answers
103
views
MySQL replication broken as binlog not in chronological order
Looking at an excerpt from the binary log, it can be seen that these 2 statements are written to the log out of order chronologically:
#160628 17:32:46 server id 2220 end_log_pos 64812204 Query ...
0
votes
2
answers
109
views
Update mysql.user from non-root yet privileged account?
This question might sound silly, but I wanted to make absolutely certain before I carried this out on a production MySQL instance.
Currently, I have a MySQL master->slave setup on a production ...
1
vote
1
answer
2k
views
Can't connect MySQL EC2 master to RDS slave
I am having issues setting up replication between a MySQL RDS instance and an external master on EC2. As far as I can tell, everything is set up correctly but the slave never reaches the master and ...
0
votes
1
answer
438
views
MySQL slave becoming a replication master for additional slaves
I have MySQL servers A, B, C, and D. Server A is the MySQL master who receives the write traffic, and my applications look at B + C for reads (current slaves). I have replication forwarding ALL ...
0
votes
1
answer
698
views
my ssh is OK,but mha ssh check is fail
CentOS 6.6 + MySQL MHA(0.56)\
ssh-keygen -t rsa
ssh-copy-id -i /root/.ssh/id_rsa.pub root@slave2
and my SSH check is ok
[root@master ~]# ssh -v root@slave2
OpenSSH_5.3p1, OpenSSL 1.0.1e-fips 11 Feb ...
1
vote
1
answer
3k
views
MySQL Replication Errno1146 Table doesn't exist
Here's the setup: I have a MySQL DB cluster in Rackspace that I'm already using for replication to multple slaves in multiple datacenters. I am trying to use AWS' Aurora with a MySQL front-end, which ...
1
vote
1
answer
338
views
Amazon RDS Replication
I'm having an issue with working with Amazon RDS in itself, is there a way through RDS to create a seperate RDS instance and have RDS Server 1 replciate to RDS Server 2?
I cannot seem to figure out ...
1
vote
1
answer
911
views
RDS Mixed replication, master in EC2-Classic, replica in VPC (MySQL)
I have a heavy used RDS instance (MySQL) in EC2-Classic with three read replica instances.
We're on plan to move some of our micro-services into VPC and some of them need to read on those replica ...
1
vote
1
answer
368
views
Magento > Slave breaks when a product is added from master
Title really says it all. Here is the LAST_ERROR:
Last_Error: Error 'Cannot add or update a child row: a foreign key constraint fails
(`cd1n401`.`cdi_catalog_product_entity_int`, CONSTRAINT `...
2
votes
0
answers
180
views
MySQL slave index file corruption
I have a MySQL master-slave replication pair, and to take backups, I run a script that stops the slave, dumps the database, and then re-starts the slave. However, after restarting, the slave's MySQL ...
3
votes
1
answer
608
views
MySQL Multi-source replication from 5.6 masters to 5.7 slave
In MySQL 5.7 multi-source replication is finally available.
Is it possible to use several MySQL servers running version 5.6 as multiple masters for a single MySQL slave running 5.7? Or do you have to ...
3
votes
1
answer
5k
views
Multi-state MySQL master/slave pacemaker resource fails to launch on cluster nodes
Setup
I'm setting up an HA cluster for a web application using two physical servers in a Corosync/Pacemaker managed cluster.
After finding out I was heading the wrong way, I decided to use heartbeat'...
0
votes
1
answer
153
views
mysql replicate-* data transfer from master
I have been playing with MySQL replication for a new project of mine.
I am using row based replication.
I have a particular confusion with replicate_do_db which is to be written in the my.cnf of the ...
2
votes
2
answers
10k
views
GTID have been turned off But I have error in replication
I just upgrade from mariadb5 to mariadb10. Then I have error on my slave replication
Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't ...
0
votes
2
answers
4k
views
Binlog format - RDS default
By default in MySQL 5.6 default binary logging format is "STATEMENT".
(https://dev.mysql.com/doc/refman/5.6/en/replication-formats.html)
MySQL 5.6 running on RDS has by default format set to "MIXED" ...
0
votes
1
answer
394
views
How to avoid MySQL replication corruption while executing flush-logs command
I have three servers running MySQL, let's say A, B and C. Server A is the master, and server B is the slave. I want to do mysql replication between server A and B, at the same time, I also want to use ...
0
votes
1
answer
299
views
DB replication using BinLog
I am using mysql-binlog-connector to listen to any binlog event and then perform replication on the slave DB. My problem is that, the binlog registers event right after the execution and before commit,...
0
votes
1
answer
4k
views
Mysql master-slave replication very slow
We're running a MySQL master-slave replication set-up and the slave is very slow at catching up. There seems to be no high network or cpu usage while the slave is going through the masters' logs. ...
1
vote
1
answer
591
views
How to get the log position for a disconected mysql slave?
We have a system where our biz people have notebooks that they take on business trips. They are all mysql slaves and they plug them in every other day to sync them up but sometimes a person might not ...
1
vote
2
answers
104
views
Moving mysql slave
I am trying to move MySQL slave from old pc to new. Original slave is MySQL version 5.6.12 same as new slave(MySQL is part of wamp 2.4). Replication works fine at old machine. But when I stop slave, ...