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

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 ...
1
vote
1answer
26 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 ...
0
votes
1answer
43 views

RDS Mixed replication, master in EC2-Classic, replica in VPC (MySQL)

I have a heavy used RDS instance (MySQL) in EC2-Classic with three read replica instances. We're on plan to move some of our micro-services into VPC and some of them need to read on those replica ...
1
vote
1answer
9 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 ...
2
votes
0answers
26 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 ...
1
vote
0answers
48 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 ...
2
votes
1answer
172 views

Multi-state MySQL master/slave pacemaker resource fails to launch on cluster nodes

Setup I'm setting up an HA cluster for a web application using two physical servers in a Corosync/Pacemaker managed cluster. After finding out I was heading the wrong way, I decided to use ...
0
votes
1answer
33 views

mysql replicate-* data transfer from master

I have been playing with MySQL replication for a new project of mine. I am using row based replication. I have a particular confusion with replicate_do_db which is to be written in the my.cnf of the ...
0
votes
1answer
77 views

GTID have been turned off But I have error in replication

I just upgrade from mariadb5 to mariadb10. Then I have error on my slave replication Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't ...
0
votes
1answer
104 views

Binlog format - RDS default

By default in MySQL 5.6 default binary logging format is "STATEMENT". (https://dev.mysql.com/doc/refman/5.6/en/replication-formats.html) MySQL 5.6 running on RDS has by default format set to "MIXED" ...
0
votes
0answers
24 views

How to avoid MySQL replication corruption while executing flush-logs command

I have three servers running MySQL, let's say A, B and C. Server A is the master, and server B is the slave. I want to do mysql replication between server A and B, at the same time, I also want to use ...
0
votes
1answer
31 views

DB replication using BinLog

I am using mysql-binlog-connector to listen to any binlog event and then perform replication on the slave DB. My problem is that, the binlog registers event right after the execution and before ...
0
votes
0answers
74 views

trouble setting up pt-heartbeat (percona toolkit) for mysql/mariaDB replication

I'm facing some problems with pt-heartbeat (from percona toolkit) in order to observe MariaDB replication. I have one master instance with IP 172.17.0.3 and server-id = 1 I have one slave instance ...
0
votes
1answer
148 views

Mysql master-slave replication very slow

We're running a MySQL master-slave replication set-up and the slave is very slow at catching up. There seems to be no high network or cpu usage while the slave is going through the masters' logs. ...
0
votes
1answer
38 views

How to get the log position for a disconected mysql slave?

We have a system where our biz people have notebooks that they take on business trips. They are all mysql slaves and they plug them in every other day to sync them up but sometimes a person might not ...
1
vote
2answers
34 views

Moving mysql slave

I am trying to move MySQL slave from old pc to new. Original slave is MySQL version 5.6.12 same as new slave(MySQL is part of wamp 2.4). Replication works fine at old machine. But when I stop slave, ...
3
votes
0answers
24 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 ...
0
votes
0answers
28 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 ...
0
votes
2answers
97 views

How to open the MySQL port only to Amazon RDS for replication?

I have a MySQL database on a dedicated server, that I want to replicate to Amazon RDS to always have an up-to-date backup. For this, Amazon RDS needs to be able to connect to my master MySQL server. ...
-1
votes
1answer
81 views

MySQL: Why would I have to repeatedly FLUSH HOSTS after a few minutes? [closed]

I have a web system setup in AWS that we are building up to migrate an existing web app to. I have 2 VPCs: 1 for web and 1 for data. These VPCs are Peered and Security Groups are setup to isolate each ...
2
votes
1answer
92 views

Best practices to backup mysql databases

This question concerns best practices for mysql backup with replication and large number of databases. I'm looking for your point of view and suggestions :) I - Current situation I have two ...
1
vote
0answers
33 views

Advice on management of large MySQL database [duplicate]

I've inherited responsibility for a 400GB MySQL database that is hosted in Amazon RDS. The DB serves an application that relies intensively on DB operations, so version releases frequently involve ...
0
votes
0answers
101 views

Mysql Cluster Tables not available after 30 seconds.

I setup MySQL ndb today using this guide: http://www.catharinegeek.com/set-up-mysql-cluster-on-ubuntu-14041/ . I can get my mysql to start, but it says "Tables not available after 30 seconds." The ...
0
votes
3answers
69 views

Which MySQL Replication should I use? [closed]

I have two servers consider server 1 and server 2. There are many databases on server 1 and few active databases on server 2 as well. Can I setup MySQL replication of server 1 and server 2. If yes, ...
0
votes
1answer
55 views

Azure Load Balance Virtual Machines in a Subnetwork

If I have 2 subnetworks, 10.0.0.0 for my processes and 11.0.0.0 for databases, how can I load balance the databases internally within the subnetwork such that any of the processes in 10.0.0.0 network ...
0
votes
0answers
32 views

mysqlfailover automatic failover is not enabled

i use mysqlfailover mysqlfailover --master=root@132.232.142.73:3306 --discover-slaves-login=root --slaves=root@12.32.53.2:3306 --report-values=health --verbose --failover-mode=auto ...
1
vote
1answer
473 views

MariaDB replication lag

I'm trying to get replication working between 2 servers running MariaDB 10.1.7 64 bit. The database I'm trying to replicate is huge, 520G and the export/import on the slave with disabled autocommits ...
1
vote
0answers
64 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 ...
0
votes
1answer
65 views

mysql GTID replication

i try to use GTID and backdump mysql -u root -h xx.xxx.xxx.xx -p < 2015-10-30_all_database.sql Enter password: ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when ...
0
votes
3answers
54 views

Mysql master slave replication fail PID error

I have Master on 5.6 & Slave on 5.5, this will be the test ENV to check if 5.6 can replicate on 5.5 on PROD. I am getting this below error when starting mysql ERROR! MySQL server PID file ...
1
vote
0answers
17 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 ...
2
votes
1answer
62 views

How to secure the db dump taken from daily run script

In one of my mysql slave servers I have written a daily run script, which 1) stops slave, 2) takes a db dump, 3) starts slave again, 4) encrypts it, 5) copies it to my s3-bucket. I am using aws-cli ...
0
votes
1answer
124 views

MySQL proxy or Master-Master replication?

I currently have a MySQL database hosted on a remote server (Server A). This database have to stay there because this remote server is very secure. Our online website use this database to display ...
0
votes
1answer
208 views

How does read/write splitting work with MySQL replication?

I know how to setup a master->slave replication but I am a bit confused on how I would do read/write splitting between the two MySQL servers with a PHP application. When I have MySQL replication ...
1
vote
1answer
185 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
91 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
362 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
121 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
291 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
164 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
729 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
364 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
91 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
821 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 ...
4
votes
2answers
3k 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
411 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
86 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 ...
1
vote
1answer
546 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
183 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
34 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 ...