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

1
vote
1answer
59 views

MySQL Replication Logs Filling Partition

We have MySQL replication setup from site-to-site. The slave is just a backup used for reporting etc(No write). Everything is going well as far as I can tell. However, the server is quickly running ...
0
votes
1answer
64 views

Slave Failover to other Master in MySQL Master-Master-Slave Scenario

I have a Master-Master MySQL Setup (5.6) with an additional Slave attached to Master 1: Master 1 (alive) <---> Master 2 (alive) | Slave 1 Now when Master 1 dies, i want the Slave to ...
0
votes
1answer
91 views

MySQL backups/Replication using xtrabackup and Native Mysql Replication

This aspect of using Percona Xtrabackup over Native Replication has been in my head for sometime now and I just cant seem to find an answer to this, I am posting this as a last resort seeking advice ...
0
votes
1answer
191 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
0answers
152 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 ...
-2
votes
1answer
44 views

MySQL Replicator requirements

I have a simple MySQL Master-Slave replication setup, but always get an unaccaptable huge slave lag. That means that the slave lag will get higher than the expire_logs_days of 14 and the replication ...
0
votes
1answer
81 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
0answers
72 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
276 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
2answers
74 views

MySQLD is using 175% of the cpu

On one of the servers, I have mysqld running as slave DB. The CPU usage is 175% at the moment used by mysqld. Here are the results of SHOW PROCESSLIST; ...
0
votes
2answers
6k views

Slave SQL Thread not running

My replication suddenly went offline. SHOW SLAVE STATUS shows me that I/O Thread is running, while SQL thread is not. I have error message: Fatal error: Found table map event mapping table id 0 ...
8
votes
3answers
19k views

What causes the MySQL error 1062 - duplicate entry when starting slave?

MySQL Master version: 5.5.16-1 MySQL Slave version: 5.5.18-1 The master's snapshot is created by: mysql> FLUSH TABLES WITH READ LOCK; shell> mysqldump --all-databases --master-data > ...
2
votes
1answer
143 views

MySQL replication slowing master

We are currently running MySQL 5.1 Quick Overview We use 5 web servers ( Apache ) all connected to 1 DB server ( MySQL ) hosted on the cloud. The DB server running on the cloud ( Master ) ...
58
votes
9answers
69k views

How can I export the privileges from MySQL and then import to a new server?

I know how to export/import the databases using mysqldump & that's fine but how do I get the privileges into the new server. For extra points, there are a couple of existing databases on the new ...
0
votes
0answers
123 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
1answer
312 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: ...
1
vote
1answer
94 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%, ...
2
votes
1answer
402 views

High Mysql Connections

Having a challenge discovering why results are as they are. Perhaps missing something obvious. Sorry this isn't very specific. But if anyone has an pointers on areas to focus on that would be very ...
0
votes
1answer
55 views

Mysql database restore

My mysql backup is running everyday at 4 am & accidently my database got corrupted at 7am. Now how to restore data updated between time period of 4am & 7am
1
vote
1answer
546 views

AWS RDS. Upgrade MySQL from 5.5 to 5.6, external replica and Access denied

I want to create external read replica for my RDS instance using this doc: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html My old instance is running ...
0
votes
1answer
75 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 ...
1
vote
2answers
2k views

MySQL Replication Over SSH - Last_IO_Errno: 2003 - error connecting to master

I have MySQL MASTER/SLAVE replication working on two test boxes (Centos 6.4 / MySQL 5.5.32) over LAN. Securing the connection over ssh causes connection problems from the SLAVE machine: (Sample of ...
0
votes
2answers
282 views

MySQL - Does the change in MySQL master db password affect on slave db?

I want to change the MySQL DB password on the master db. My question is: do we have to care for the slave DB when changing the master database password?
0
votes
0answers
81 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 = ...
3
votes
1answer
253 views

Restore database by files from broken Ubuntu server

I'm pretty lost right now. The RAID controller auf my server broke and all attached hard drives were corrupted. Luckily I copied the plain files off the server right before the crash (phew). I set ...
0
votes
1answer
353 views

update and insert MySQL DB on AWS RDS with local MySQL DB

I have created an RDS database and have used mysqldump to send all my local data to that remote database using the following commands: $ mysqldump -u root fishDB > localDB.sql $ mysql -h ...
0
votes
1answer
60 views

MySQL Replication across two mounts on AWS Amazon Linux

Recently we took advantage of the SSD instance stores available on AWS. While these are great, they obviously get deleted when the instance dies. Obviously the performance of non Provision IOPS is ...
1
vote
1answer
488 views

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our ...
2
votes
1answer
350 views

MySQL Master-Master Replication Slave Thread Issue

I'm currently trying to set up Master-Master MySQL replication between 2 servers, but I'm encountering an unusual issue. I'm getting this error on my MySQL log: Slave: Table 'phpmyadmin.pma_recent' ...
0
votes
2answers
349 views

Mysql Replicated database UPDATE not working

I have been trying to start replication in a MySQL database. I followed all the steps from the MySQL manual to setup and configure the replication. ...
1
vote
2answers
124 views

MySQL Replication threeway

We have MySQL Multi-Master replication setup between two servers ( A & B ). It has been working for a few years now and life is good. The management tool in our office connects directly to ...
1
vote
0answers
29 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 ...
0
votes
1answer
116 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, ...
1
vote
1answer
31 views

mySQL 'Stop Slave' on Server Reboot

Is there a way in mySQL to issue a 'stop slave' command when the server is rebooted to prevent the replication from getting out of sync? I haven't been able to find anything definitive on this.
1
vote
1answer
365 views

MySQL replication hung after slave goes offline and comes back online again

I have a master server and several slave servers replicating a single database. I am using in MySQL 5.0 in SLES 11. During fault tolerance testing I found that when the slave's network connection ...
1
vote
1answer
31 views

re-enabling a table for mysql replication

We were able to setup mysql master-slave replication with the following version on both master/slave: mysqld Ver 5.5.28-29.1-log for Linux on x86_64 (Percona Server (GPL), Release 29.1) One day, ...
0
votes
1answer
121 views

MySQL keeps starting logger and constantly restarts?

Alright, I have updated version 5.1 to version 5.6 without uninstalling the old one by using update-alternatives. This works just fine on our production/master server, but our replication slave seems ...
0
votes
1answer
247 views

MySQL Replication Stale

I had some interesting problems with Maria DB. 1st I have max_connections in config under section [mysqld] but the value is always 214 (default) after restart. So the problem is I can't defined the ...
0
votes
2answers
5k views

How to reset mysql's replication settings completely, without reinstalling it?

I set up mysql replication by adding references to binlogs, relay logs etc in my.cnf restarted mysql, it worked. I wanted to change it so I deleted all binlog related files including log-bin.index, ...
4
votes
5answers
4k views

Diagnosing Mysql Replication Issues

We have a mysql replication client running on our backup server. Since a power failure last week it's stopped replicating. Before this it was running uninterrupted for several months. I've tried ...
1
vote
1answer
323 views

Fail safe SSH tunnel Ubuntu (always up)

I need your advise for a very important technical issue on our project. We need to have a SSH tunnel always up between our two servers. We have a MySQL database replication process going between those ...
0
votes
3answers
281 views

mysql master-master setup as a way to simply master-slave promotion

I'm trying to see if the following plan is viable. Goal here is to be able to do HA (uptime) and not necessarily for load -- writes are fine on one MySQL 5.5 server (with innodb) but not really ...
-1
votes
1answer
111 views

Mysql MariaDB replication broken

I have a primary DB and two replicates. replicate1 became corrupted when the linux server was rebooted without stopping mysqld. I want to load replicate1 with a dump I've taken from replicate2 with ...
3
votes
1answer
157 views

Is it safe to lock tables on a mysql replica slave?

I have a master mysql database where the application writes and read production data, and then I setup a slave database just in case something goes wrong with the master database server (and I can do ...
1
vote
1answer
328 views

What are the options for any SQL Multi Master Master replication?

I am looking for a proper way to do Multi Master Master replication. I am currently using MySQL but open to switching to Postgres or Oracle if needed. So far the only solution I find is ...
1
vote
1answer
39 views

MySQL replication and replicating MySQL users

I have a MySQL Main Server and a slave server which replicates the main server. My question is, the new MySQL users added to the Main Server do not get replicated to the slave server. How can I make ...
1
vote
1answer
173 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
0answers
118 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 ...
3
votes
1answer
4k views

MySQL slave server not removing old relay binlogs

I have a MySQL server with slave replication on another host. Today I stumbled across the high disk usage of the slave host and invastigated what takes up all the space. As it turns out this space is ...
8
votes
4answers
3k views

How to setup MySQL replication with minimal downtime

Basically we have a large MySQL database and we're looking to do replication to a slave (master slave setup). Do you guys have any step-by-step guide on how to do this with MINIMAL downtime on the ...