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).
127
questions with no upvoted or accepted answers
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 ...
- 31
3
votes
0
answers
202
views
Get floating ip from mmm to work on Tinc vpn on Ubuntu
I've got 3 ubuntu servers connected with a Tinc VPN right now. 2 servers are running mysql 5.6 db's, and the 3rd is used only as a monitor. We're using mmm to do the monitoring and assign a floating ...
- 265
3
votes
2
answers
158
views
MySQL Replication 'Catchup' UPDATES keep newer record
I've got two MySQL clusters that have Master-Master replication setup between them.
Most tables are log based, with only inserts and selects, so they don't have any problems with the replication.
...
- 83
3
votes
1
answer
411
views
Failover strategy for a 4 servers scenario
I am trying to figure out how to set up replication & failover in a scenario with 4 servers (2 per location) where any server may assume the Master role. My initial scenario is the following one:
...
2
votes
1
answer
1k
views
Amazon Aurora read-only slaves slowly increase to 100% CPU and die
We have a master database instance hosted on AWS Aurora (mysql) and have many read-only slaves being replicated from it. The master and the 4-12 autoscaling slaves are currently of db.r4.4xlarge size ...
- 102
2
votes
0
answers
1k
views
Converting Mariadb Galera Cluster into Simple Master Slave Replication Cluster
Now we have this project to convert our Mariadb Galera Cluster (3 nodes) to Simple Master Slave cluster (One master and two slaves). So our goal to get rid of Galera and make our setup just async / ...
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 ...
- 783
2
votes
0
answers
104
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 ...
- 21
2
votes
0
answers
181
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 ...
- 9,180
2
votes
0
answers
842
views
MySQL persistent tmpdir on slave: use tmpdir or slave_load_tmpdir only?
While setting up a replicated MySQL database I looked at the manual about tmpdir and was somewhat confused about the two variables tmpdir and slave_load_tmpdir. I know the slave needs some data to be ...
- 379
2
votes
0
answers
915
views
Create RDS Read-Replicate in a separate region using VPC
We have a MySQL RDS instance in a VPC, and want to setup a read-replicata in another region.
Unfortunately since our RDS instance is in a VPC, we don't appear to have the option to replicate across ...
- 273
2
votes
1
answer
389
views
MySQL Master-Slave Replication
I am trying to set up highly-available master-slave MySQL replication. I plan to have two servers on different networks with one running as master and the other running as slave like so:
A ...
- 235
2
votes
1
answer
850
views
MySQL replication and UPDATE prioritisation
I have a master server, where I want modify operations such as UPDATEs to be LOW_PRIORITY so that they don't block SELECTs etc. This is better for end-user visible behaviour.
I have a slave server, ...
2
votes
1
answer
785
views
Replication stops
I have 2 CentOS 5.5 servers runnig Mysql 5.5, configured as master-master replication.
When on one server i have network problems, on another i see messages in log:
111105 2:38:30 [Note] Stop ...
- 375
2
votes
2
answers
240
views
Mysql cluster Vs basic Mysql db setup(not cluster)
Why mysql cluster requires more ram as compared to basic mysql db setup (no cluster)?
What is the ideal ram requirement for a mysql cluster with 2 mysql servers on 2 different hosts ?
- 51
1
vote
0
answers
40
views
Using Clone for addInstance on MySQL Innodb Cluster uses 100% Memory
When trying to add a new node to a MySQL Innodb cluster using Cluster.addInstance() and selecting the Clone option, within 2 or 3 minutes the donor nodes memory usages hits 100% on a server with 36Gb ...
- 11
1
vote
0
answers
324
views
Using MySQL/MariaDB replication, how to know when the Replica is in a consistent state?
This is a question about MariaDB (mostly) and a replication that I am considering.
For this replication, the Primary database is updated every minute by a process which can take about 15 seconds to ...
- 83
1
vote
0
answers
211
views
MySQL hangs on SELECT from table with blob fields
I managed to create a mysql InnoDB cluster with three nodes and a router everything works great but when i try to run a select query from the table below from a another server it freezes, but it works ...
- 77
1
vote
0
answers
3k
views
MySql Slave Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.00116, end_log_pos 8631
I have Active-Passive-Master-Master replication setup in Mysql with version 5.7.
I found the below error in MySql2 (passive Master server) but the status show it's in sync with Master server (mysql1).
...
- 11
1
vote
0
answers
321
views
How to configure keepalived, so that choosing master is not static?
I have already managed to configure a setup where I have a master and a backup machine, so when the master fails the backup goes back up. And when the master starts again, it takes the master position ...
- 21
1
vote
0
answers
133
views
Setup Local Persistent Volume on physical machines with Kubernetes
Let me make a statement first: I'm new to Kubernetes, please take it easy if I'm asking wrong questions.
Ok, here is what I'm gonna do. I'm planning to build a Kubernetes for my project using some ...
- 131
1
vote
1
answer
779
views
MySQL 5.6 Deadlock Issue
I have a sporadic deadlocking issue with MySQL 5.6. This server is configured as a read only slave, which is why it is extremely odd there is a deadlock issue.
I have innodb_lock_wait_timeout set to ...
- 135
1
vote
0
answers
299
views
MySQL group replication configuration issue
I am trying to create an instance in one AWS region that would be a group replica of an instance in a different region(both are database servers). I followed the below link to do this.
https://www....
1
vote
0
answers
641
views
The ndb_mgmd daemon does not start
The ndb_mgmd daemon does not start
I want to configure a NDB Mysql cluster, I followed the documentation of its official page. Install version 7.5 of mysql-cluster-community and I have the following ...
1
vote
1
answer
691
views
Suppressing warning “Statement may not be safe to log in statement format” in mysqld.log
I've noticed the mysqld.log is being filled up with these log messages about the statement not be safe to log in a statement format for the MySQL replication.
I know the query is fine, and from what ...
- 268
1
vote
0
answers
462
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
...
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 ...
- 31
1
vote
1
answer
347
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
371
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 `...
1
vote
0
answers
430
views
Do I need binlogs with a Percona xtradb cluster?
If I am running an XtraDB cluster, with no replication, do I need binlogs?
They're enabled and chewing up disk space. I'm aware I can restrict their number using max_binlog_files, but I'm not sure if ...
1
vote
0
answers
95
views
Replication Setup what will be the value of MySQL auto_increment and offset in my.ini
I have setup master master mysql replication to sync changes in both server. But now I want to setup 6 server it is possible? I'm making 6 because when an area lost it connection over WAN it will ...
- 11
1
vote
0
answers
2k
views
how to do automatic failover of mysql / galera cluster
I have two mysql/galera clusters of three nodes each (two + garb node).
The clusters are in separate DC's (dc1 and dc2)
The cross cluster replication happens between
node1-dc1 and node1-dc2
I want ...
- 89
1
vote
1
answer
177
views
MariaDB Replication server disk usage drop
I have a MariaDB master-slave setup on 2 CentOS 7.0 servers. Today, I extended a LVM volume on the master server (because it was getting full). After extending the partition, I rebooted the server and ...
- 2,025
1
vote
0
answers
769
views
Mysql table doesnt exist error after trying run from lvm snapshot
I'm trying to set up mysql replication by making lvm snapshot of master datadir and copying it to slave.
The procedure is quite simple, on master server I execute "FLUSH TABLES WITH READ LOCK" and on ...
- 5,258
1
vote
0
answers
689
views
How to fix MySQL replication on one table
I have a rather large MySQL database with a handful of replicating slaves. Recently I ran the percona toolkit checksum and found a couple of tables out of sync. What is the best way to get them back ...
- 1,968
1
vote
1
answer
139
views
Unable to start MySQL server while configuring MySQL Cluster using its auto installer GUI?
We are trying to configure MySQL Cluster using its Auto Installer GUI. When we click on 'Deploy and Start MySQL Cluster' button, it showing a small popup with progress. Once it is reached at 57%, ...
- 11
1
vote
0
answers
37
views
Mysql Master to Master Configuration Steps
In our project currently we are using Mysql Master to Master replication, both mysql server version is mysql 5.1. we are going to upgrade the replication then our requirement is one mysql server ...
- 11
1
vote
0
answers
272
views
How to prevent bad queries from breaking replication?
For my personal experience, mysql replication is fragile.
I know that there area many things not to do beacuse they could break replication, but we are humans and an error could always occur.
So I ...
- 507
1
vote
0
answers
819
views
mysql cluster node lost connection shutdown
I'm testing a mysql cluster with VirtualBox using several virtual machines:
Each virtual machine (2 in total) has a mysqld and ndbd node. Plus there's a vm for the ndb_mgmd to manage the cluster.
I ...
1
vote
1
answer
539
views
syncing specific tables between two already-replicating MySQL clusters
I have a circularly replicating MySQL cluster, and a newer cluster of Percona XtraDB instances that we're in the process of moving to. During the move, we're running some projects on the old cluster ...
- 33.2k
1
vote
0
answers
102
views
MySQL Replication Monitoring for OS X Server
I have a CentOS 5 MySQL 5.0 server running that I need to replicate. I will setup MYSQL on OS X (Mac mini), but what tool should I use to monitor the replication that runs on OS X?
- 109
1
vote
0
answers
59
views
Mysql Master-ColdMaster
I explain my case:
I'm at Amazon AWS and I want to be fault tolerant on a entire region failure. My basic problem is to have the db in sync with 2 regions.
My options:
Master-Master (high lag)
Hand ...
- 1,086
1
vote
0
answers
1k
views
MySQL Replication not working on binlog-do-db
I set up MySQL master-master replication on my 2 Ubuntu VM. Configuration and connection done correctly according to this guide. Here is my problem.
I print the master status on master 1 and it ...
- 23
1
vote
0
answers
277
views
MySQL master-master replication: "Lock wait timeout exceeded"
I am setting up master-master replication with MySQL.
Writes are done only to Master1. Master2 is slave of Master1 and is replicating perfectly. When I set Master1 as slave of Master2, I get lots of ...
- 133
1
vote
1
answer
201
views
Failed to Attach DB on replicated SAN
We currently have a clustered SQL Server 2005 which has replicated SAN disks for our DR solution, to test DR we break the SAN synch and then attach the various DB's on the DR server.
Our web servers ...
- 11
1
vote
0
answers
3k
views
MySQL Replication: Slave I/O thread constantly dying and starting back up
I have MySQL running on Debian 5 (Lenny) between two MySQL databases. The data is being transferring between the two machines, but one of them is logging the fact that it's slave I/O thread is ...
- 11
1
vote
1
answer
56
views
maybe stupid question: If a single java app on a separate server is causing 23Gigs of Binlogs to be sent to the db replica
does this mean there is 23gb of traffic (or more ) moving between the Java app (server) and the master Mysql server?
this has been bugging me.
The reason why I ask is because we have one server that ...
- 29
1
vote
1
answer
84
views
MySQL database solution
I have 2 offices that are located around 500km apart and both offices need to access the MySQL database frequently. So to make it faster I am planning to set up two MySQL servers where each office has ...
- 41
1
vote
1
answer
575
views
Changing MySQL master host on slave and preserving MASTER_LOG_POS, MASTER_LOG_FILE
Folks, my master MySQL server got an additional NIC used for local networking and now I want all slave servers to use the new local IP of the master server.
I know I can achieve this using "CHANGE ...
- 495
1
vote
2
answers
548
views
A few tables are still out of sync after running mk-table-sync
I have 1 master and 2 slaves. I am using MySQL 5.1.42 on all servers. I am attempting to use mk-table-checksum to verify that their data is in sync, but I am getting unexpected results on one of ...
- 653