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).

Filter by
Sorted by
Tagged with
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 ...
Illidan's user avatar
  • 139
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 ...
Kuldeep Yadav's user avatar
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 ...
nak3c's user avatar
  • 111
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 ...
Liam Smith's user avatar
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 ...
user3637899's user avatar
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 ...
adminz's user avatar
  • 397
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 ...
neubert's user avatar
  • 337
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 ...
Jim Rubenstein's user avatar
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 ...
aditya Mehta's user avatar
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 ...
tawfekov's user avatar
  • 195
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 ...
Dmitri DB's user avatar
  • 113
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 ...
Bas van den Dikkenberg's user avatar
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 ...
Frank Martin's user avatar
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 ...
Frank Martin's user avatar
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 ...
Frank Martin's user avatar
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 '/...
Dessa Simpson's user avatar
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 ...
mohit singh's user avatar
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 ...
a coder's user avatar
  • 799
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....
brenguy's user avatar
  • 11
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 ...
avizzzy's user avatar
  • 123
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: ...
Jacco's user avatar
  • 377
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 ...
Manu's user avatar
  • 101
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 ...
technoob's user avatar
  • 142
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 ...
user362986's user avatar
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 ...
Ethan Shrago's user avatar
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 ...
Steve Rukuts's user avatar
-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 ...
czioutas's user avatar
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 ...
lurkerbelow's user avatar
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 ...
Mark Gerolimatos's user avatar
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 ...
Mark Gerolimatos's user avatar
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 ...
alison_feik's user avatar
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 ...
Hydra IO's user avatar
  • 139
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 ...
blep's user avatar
  • 13
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 ...
user182030's user avatar
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 ...
LawrenceLi's user avatar
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 ...
user182030's user avatar
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 ...
Chris Favaloro's user avatar
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 ...
Jose Peinado's user avatar
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 `...
Stephen Johnston's user avatar
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 ...
John's user avatar
  • 9,170
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 ...
Henrik's user avatar
  • 31
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'...
Habovh's user avatar
  • 271
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 ...
user1066991's user avatar
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 ...
Fadzhli Azmandin's user avatar
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" ...
Piotr's user avatar
  • 195
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 ...
technoob's user avatar
  • 142
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,...
Tamaghna Guha Thakurta's user avatar
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. ...
Qlii256's user avatar
  • 151
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 ...
johnsout's user avatar
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, ...
martin's user avatar
  • 83

1 2
3
4 5
11