Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).

learn more… | top users | synonyms

3
votes
1answer
348 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
1answer
308 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
1answer
340 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 ...
1
vote
1answer
33 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 ...
1
vote
1answer
87 views

MySQL 5.6 replicate live master WITHOUT down time

Following the steps to replicate an existing server, it seems most methods rely on the ability to either completely stop the master server or at least prevent it from writing using flush tables with ...
1
vote
1answer
85 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%, ...
1
vote
1answer
163 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 ...
1
vote
1answer
163 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 ...
1
vote
1answer
501 views

2 servers, high availability and faster response

I recently bought a second webserver because I worry about hardware failure of my old server. Now that I have that second server I wish to do a little more then just have one server standby and ...
1
vote
1answer
130 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 ...
1
vote
1answer
51 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 ...
1
vote
1answer
72 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 ...
1
vote
1answer
329 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 ...
1
vote
1answer
647 views

Migrating master-slave MySQL database servers to 2 new servers, any tips or suggestions?

I'm setting up 2 new database servers that will be replacing a current master-slave setup. All boxes are running / will be running MySQL on RHEL. Our current naming conventions: db1 - master ...
0
votes
1answer
44 views

MySQL replication ignoring BINLOG statements for certain table

I'm trying to make MySQL Replication work, but my slave is constantly stopping because of constraint fails. This errors occurs because the replication of one particular table is not working. If I ...
0
votes
1answer
47 views

RDS replication from a remote master outside of my VPC

I'm attempting to replicate from an external MySQL master to an RDS instance. I don't really want to be sending data in the clear over the Internet, so I have an EC2 instance that I have set up an ssh ...
0
votes
1answer
30 views

Force a connect to mysql

My Mysql server instance has crashed (I assume its been 10 hours and its not running) - I have tried show full processlist but the new connection can't connect. I've tried using mysqladmin and that ...
0
votes
1answer
130 views

Can I do zero downtime MySQL replication if I have archive tables present?

I've read the question and answers at How to setup MySQL replication with minimal downtime. It looks like I can get a slave DB into sync without down time if I am using only Innodb tables. My ...
0
votes
1answer
59 views

MySQL replication slave got 2147483647 (INT32_MAX) in a column for time stamp

I have set up two replication slaves, one on CentOS(x86_64 5.1.37), the other on Ubuntu LTS(x86_64 mysql 5.5.38). Both of them seem to replicate most of the Master db (CentOS i686, mysql 5.5.37) ...
0
votes
1answer
247 views

MySQL Master-Master Replication Issue

I have two databases that sync data through Master-Master replication. The setup was created using the following guide: ...
0
votes
1answer
61 views

MySQL Cluster with no access to Data Nodes

I'd like to set up a MySQL Cluster for HA, but the client of the data cannot yet use ClusterJ. I would like create 2 SQL Nodes and access only them from the client. i.e. No access to the NDB Data ...
0
votes
1answer
106 views

What is wrong with this iptable for Mysql Replication

I'm not quite used to IPTables and I'm trying to run an iptables script to allow only ssh connection from all and connection to mysql server only from specified IPs. I made a bash script for this, ...
0
votes
1answer
27 views

Single slave - multiple master MySQL replication

I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?
0
votes
1answer
343 views

MySQL Slave Not Replicating

I had a deleted some data on the master mysql. Looking at the slave status, it shows this: mysql> show slave status \G; *************************** 1. row *************************** ...
0
votes
1answer
133 views

Replicate from slaves to master and viceversa

I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this: MySQL DB (master) table1 table2 ...
0
votes
1answer
204 views

mysqlbinlog does not continue to last log

I am using the following command to start reading mysqlbinlog. mysqlbinlog -t -v -v --base64-output=DECODE-ROWS -h my_host -ppasswd -R mysql-bin.000960 -j 1052323996 I would expect the output to ...
0
votes
1answer
303 views

Mysql Replication— restricting drop database statements

we have a master-slave mysql replication setup. The master has multiple databases and they get created and dropped, fairly often. I would like to restrict the slave to not drop the databases. I ...
0
votes
1answer
580 views

MySQL Master-Master replication using MMM on Linode

Linode allows you have multiple IP's assigned to your node but I'm trying to setup MySQL Master-Master Replication with MMM following the guide on http://mysql-mmm.org/mmm2:guide. One part I don't ...
1
vote
0answers
121 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 ...
1
vote
0answers
27 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 ...
1
vote
0answers
101 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 ...
1
vote
0answers
269 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
0answers
32 views

Mysql Multi slave replication

Hi I have a master Mysql server from where i am replicating other 2 slaves. The issue is one of the slave stops with an error frequently. The error message is below. Error 'Duplicate entry ...
1
vote
0answers
44 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?
1
vote
0answers
46 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) ...
1
vote
0answers
312 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 ...
1
vote
0answers
160 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 ...
1
vote
0answers
808 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 ...
1
vote
0answers
269 views

MySQL Master silently drops slave thread, replication will not restart

We have a very active (high rate of change) MySQL master / slave. After the slave was offline for a few hours (over a million binlog entries missed) the slave will not start replication again. When ...
0
votes
0answers
14 views

RDS MySQL A B replicate across continents?

I have a web app that I run for Australian customers hosted on AWS using RDS. Can I bi-directional replicate in realtime the database to the USA and Europe AND expect to be able to have a single ...
0
votes
0answers
69 views

Trying to replicate a MySQL 5.6 master, the replication server crashes

We run a MySQL 5.6 server that acts as a replication master. Recently, due to some other bug in upgrading from 5.5 the replication seems out of sync so we're trying to create a new replication on a ...
0
votes
0answers
24 views

Amazon RDS MySQL Replication for Backup

I was thinking of setting up Amazon RDS for MySQL as a slave MySQL server for backing up MySQL databases from my dedicated server. The server will be programatically brought online for replication and ...
0
votes
0answers
109 views

Why does freshly created MySQL slave keep throwing foreign key errors?

We are running Ubuntu-14.04 LTS with its stock mysql-5.5.40 and mysql-utilities-1.3.5 and we are setting up some master/slaves couples. Some of them get up without any issues just like usual, but some ...
0
votes
0answers
66 views

How to link my local MySQL DB to remote MySQL on the internet

Please I need some suggestions or advice on how to how to link my local MySQL DB to remote MySQL on the internet. I developed a Conference Management System for my client and they want us to setup 2 ...
0
votes
0answers
206 views

How to restore a corrupted MySQL master database from a slave database?

I recently discovered that the master db in a setup I'm running became corrupted. The slave was getting all of the data correctly so I have a solid backup. What I'd like to do is use replication to ...
0
votes
0answers
93 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 ...
0
votes
0answers
39 views

MySQL Cluster replication: NDB$MAX_DELETE_WIN() changes always applied in primary

I am building TWO mysql clusters (A & B) with master-master replication: A --> B --> A I followed the official MySQL doc to setup conflict resolution. Eventually we may have more than 2 ...
0
votes
0answers
72 views

MySQL replication, slave don't connect

I try in mi LAN with 2 VM a master-to-master replication, configure: #bind-address = 127.0.0.1 server-id = 2 auto_increment_increment = 2 auto_increment_offset = 2 log_bin = ...
0
votes
0answers
222 views

MySQL replication & logrotate

I'm using MySQL Master-Slave replication for backup purposes (for a few days). Today after changing to expire_logs_days = 3 on master and slave I got this message (from slave): ...
0
votes
0answers
331 views

Mysql Replication Not Working

I setup Mysql Master Slave Replication but on my slave server I am continously getting below error, I tried all possibles but no luck. FYI I am using Percona Mysql 5.0.92-50-log 130405 5:36:54 ...