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

0
votes
1answer
17 views

How to enable slow query log in MySQL Galera?

I want to enable slow query logging in MySQL Galera. In order to do so, I have enabled it through my.cnf: log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 1 ...
-3
votes
2answers
63 views

What's the best method to achieve full redundancy in a dedicated server? [closed]

I've been reading about full redundancy to achieve almost if not 100% uptime for your mission critical applications (handling financial data) running in a dedicated server, but I still can't wrap my ...
0
votes
1answer
42 views

Hard reboot causes MySQL replication to break

I have encountered an issue with my replication setup. Under normal circumstances it performs as intended, but it breaks if it encounters a hard reboot (I pull the power cable). Setup The setup ...
0
votes
0answers
20 views

MySQL Galera cluster nodes going out of sync

Please see http://pastebin.com/89u4jfzc However, on both nodes: mysql> SHOW STATUS LIKE 'wsrep_local_state_comment'; +---------------------------+--------+ | Variable_name | Value | ...
1
vote
1answer
47 views

RDS to EC2 mysql replication

I would like to create a RDS mysql and to replicate it to an EC2 server so the DB will be local and thus the query time will be faster (the EC2 is a web server). According to the second paragraph here ...
0
votes
1answer
29 views

MariaDB auto-increment-increment having no effect

I am trying to set up a master-master MySQL replication (both active servers). As I'm doing this on Centos 7, I have to use MariaDB instead of MySQL, although it seems fairly similar. So, before I ...
0
votes
1answer
108 views

Galera new cluster WSREP Unknown error 141

I am trying to create a new Galera cluster in the cloud using Ansible (DevOps tool). I can get the cluster started by issuing commands from an SSH shell, but not from Ansible. I have simplified the ...
0
votes
0answers
57 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 ...
0
votes
1answer
24 views

XtraBackup restore gives duplicates on slaving?

We've recently upgraded a MySQL 5.0 master-master setup to Percona 5.6. Slaving went b0rken due to some failures on our side, but we thought we could simply fix it by using xtrabackup to create a ...
0
votes
1answer
62 views

MySQL table only replication (Master->Slave)

I've set up two servers (one master and one slave db). I want to synchronize one single table of a whole database live (or with a delay of up to 5 minutes) in only one direction. I wanted to try the ...
2
votes
1answer
242 views

MariaDB Galera Cluster falls out of sync easily

We're trying to debug an issue with a MariaDB cluster. We're running Maria 10.0.19 on c4.large instances in Amazon EC2; the OS is Ubuntu 14.04 (Trusty). There are three machines clustered together, ...
2
votes
2answers
144 views

What would be a stable, failproof, scalable galera cluster implementation

Context: We are using a MariaDB Gallera cluster with (only) 2 master nodes for a web application. Last night we had a power failure and now we can't seem to recover the data and found out the database ...
2
votes
1answer
40 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
76 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
27 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
27 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
65 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
32 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
209 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
136 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
68 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
48 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
80 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
237 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
239 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
111 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
113 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
114 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
2answers
131 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
273 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
222 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
200 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
138 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
41 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
40 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
2k 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
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
2answers
74 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
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
275 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; ...
2
votes
1answer
142 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
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 ...