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

MySQL - Error Reading Packet From Server - Adding new slave to replication environment

I have a working application, currently using MySQL, 1 master, and 1 slave. Everything appears to work fine with replication. I am using WAMP Server 2.5 (Windows) MySQL v 5.6.17 I have followed a ...
1
vote
1answer
87 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
24 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
18 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
28 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
17 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
23 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
34 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
62 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
32 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
31 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
15 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
21 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
61 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
65 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
57 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
53 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
66 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
40 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
20 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
213 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
39 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
30 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
43 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
59 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
91 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
165 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
112 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
82 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
232 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
83 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
164 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
125 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
472 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
281 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
67 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
451 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 ...
3
votes
2answers
2k 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
291 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
78 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
374 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
111 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 ...
0
votes
0answers
327 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
48 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 ...
5
votes
3answers
482 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
183 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
96 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 ...