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
0answers
22 views

MySQL Replication: Don't propagate failed queries to slaves

I have a simple MySQL replication setup with one master and two slaves. Occasionally there are queries that get executed on the Master which fail due to duplicate unique keys or other reasons. What ...
0
votes
1answer
19 views

check_mysql_slavestatus RPE: Unable to read output

i am using Nrpe plugin on Ubuntu from nagios exchange check_mysql_slavestatus. Manually its working from : root@Bastion-01:/usr/local/nagios/libexec# ./check_mysql_slavestatus -H Slave-ip -P 3306 ...
0
votes
1answer
16 views

different servers different databases replication mysql

I am not sure if this is possible or not but I have 3 servers. Server A, B and C Server A has database A_dataBase, B_database Server B has database A_dataBase, B_database and C_database Server C has ...
0
votes
0answers
19 views

MySQL Master migration

I've run into an unforeseen issue regarding a MySQL Master node: The cloud instance on which it's installed is soon to be retired. I've not needed to perform a migration like this before, so I'm ...
0
votes
0answers
26 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 ...
0
votes
0answers
25 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 ...
4
votes
3answers
151 views

Replicating a linux web server

I'm planning on replicating a web server for high availability purposes. The server is running as a Ubuntu 15.04 virtual machine in Hyper-V and has MariaDB 10.0, Apache 2.4 and PHP-FPM 5.6 installed. ...
5
votes
2answers
114 views

MySQL package upgrades (Debian apt-get) always break master-master replication due to changes in mysql schema

I have master-master replication set up on 2 Debian servers, and they replicate everything, including the mysql database itself (so that new users and such also replicate). This generally works very ...
0
votes
1answer
56 views

Current setup maxing CPU. Need help designing AWS architecture and MySQL Clustering via AWS RDS instances

My company runs a mid-sized eCommerce (30,000-50,000 unique views monthly) shopping cart using X-Cart as a back-end. We are in the processing of redesigning and upgrading our back-end software. We are ...
1
vote
1answer
39 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 ...
0
votes
1answer
64 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 ...
1
vote
1answer
124 views

MySQL - Unable to enable binary logging

I'm trying to enable binary logging so that I can set up master-slave replication between two servers. I'm working with an existing server with lots of data and I'm trying to dump the data with the ...
0
votes
1answer
138 views

Seconds_behind_master value keeps on increasing in MySQL replication slave

We have a MySQL 5.0.77 Master-Slave replication. The replication was not properly running for the past few weeks and it was giving Duplicate entry error 1062. The Set Global Skip-counter option didn't ...
1
vote
1answer
74 views

Is it possible to safely edit mysql-bin.index file while mysql server is running

I changed location of mysql bin-log files. I copied them so mysql started fine, because they where in both locations, but then removed them from old location. I forget about correcting the path in ...
0
votes
1answer
72 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
0answers
95 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 ...
1
vote
1answer
105 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 ...
0
votes
2answers
253 views

Replication server crash - > 18:39:32 UTC - mysqld got signal 11

Below you can see the part of the log showing the crash. The replication server is 5.6 and the master 5.5 but this setup has worked with warnings for the last week or so. Now, after trying to change ...
0
votes
1answer
175 views

MySQL replication or MySQL cluster?

Currently i'm running Rails 3 web application with MySQL on one first server and Rails API application on second server that connects to the MySQL database from first server. I'm not happy that API ...
1
vote
1answer
170 views

why is my mysql-proxy always doing selects on master?

My selects are always going to master and if i stop master I got some 'Cannot connect, all backends are down.' [read_query] 89.216.31.228:64166 current backend = 0 client default db = nivo client ...
0
votes
1answer
31 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 ...
1
vote
0answers
125 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
votes
1answer
40 views

MySQL - data inside vm on shared storage? [closed]

I'm planning on moving all my VMs to shared storage, and I have a question about how to deal with a MySQL VM: Currently the size of the VM image is 100GB, where most of the space is taken up by the ...
0
votes
0answers
33 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
2answers
1k views

ERROR 1130 (HY000): Host 'host' is not allowed to connect to this MySQL server, only on slave

So I have a master and a slave in a mysql cluster, the syntonization works as it should however I am not able to connect to the slave from any host except from the server it self. I have no problems ...
1
vote
1answer
53 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
58 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
78 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
161 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
2answers
62 views

mysql replication setup but not working

I'm experiencing some trouble setting up mysql replication between a master & a slave.. I did the setup successfully, but data doesn't update. Master : show master status; [File]: ...
0
votes
0answers
129 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
71 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
71 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
246 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
70 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; ...
2
votes
1answer
124 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 ) ...
0
votes
0answers
102 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
281 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
0answers
44 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 ...
1
vote
1answer
88 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
362 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
51 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
522 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
2answers
241 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
75 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 = ...
1
vote
2answers
1k views

PowerDNS Master Slave Transfer method

I would like to know which is the better option to transfer the domains & their updates between a master & slave PowerDNS server. I have seen many old posts from 2006 saying using the MySQL ...
0
votes
1answer
306 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 ...
2
votes
1answer
4k views

MySQL replication error: Error_code: 1032

I setup MySQL read replica that is read only. Both master and slave are running MySQL 5.6. The slave never gets written to directly, but I can't seem to keep it synced for more than an hour or two. ...