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
9 views

How to enabel 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 ...
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 ...
-3
votes
2answers
61 views

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

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
107 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
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 | ...
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 ...
1
vote
2answers
10k views

MySQL replication Slave_IO_Running: No

I have two servers that I am trying to get replication of one database between. I found a setup guide on sourceforge that I followed and I have tried various other settings since then, but no matter ...
1
vote
1answer
46 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
28 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
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 ...
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
1answer
60 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
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
236 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, ...
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 ...
3
votes
3answers
16k views

How to sync two MySQL tables (on demand or via cron)

I have seen Cron sync mysql tables . But I cannot use replication. I used to use percona-toolkit and it worked perfectly. I could run the sync command on demand or just run it via cron. It would ...
0
votes
3answers
1k views

MySQl, Postgresql replication comparison

One main issue with MySQL replication is that the slave is single threaded. This can cause replication lag. How does Postgresql handle replication? Does it (or add-on such as slony-I) allow ...
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 ...
2
votes
3answers
274 views

Rebuild mysql slave from scratch

I'm having a master/slave mysql setup. This night I had some problems with the master. I needed to recreate all databases again because they were corrupt. Now I stopped my mysql slave but want to ...
0
votes
3answers
135 views

How to proceed setting up a secondary mysql linux slave?

I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the ...
0
votes
4answers
719 views

Rebuilding corrupt slave by copying mysql folder

Rebuilding an existing slave from a master using cold-copying of /var/lib/mysql, would this be the proper process/order? Anything missing? master mysql> SHOW MASTER STATUS\G (take notes) slave ...
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 ...
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 ...
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. ...
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
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
3answers
2k views

MariaDB Galera Cluster

I ma trying setup MariaDB in cluster but looks like I stuck on this error: #mysqld -u mysql 130407 21:36:24 InnoDB: The InnoDB memory heap is disabled 130407 21:36:24 InnoDB: Mutexes and rw_locks use ...
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 ...
4
votes
2answers
4k views

MySQL slave replication reset with no Master Downtime (using MyISAM)

Root of the issue: In all instructions for creating a slave on a running master requires flush tables with read lock. We use MyISAM, so we can't just use --single transaction to get consistent table ...
7
votes
1answer
734 views

Recovery strategy for Master-Master replication

I have implemented a HA solution for mysql based on master-master replication. There is a mechanism on the front end part which guarantees that only one db will be read/written to at a given time ...
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
112 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
1answer
237 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 ...
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
110 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 ...
1
vote
1answer
233 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 ...
2
votes
2answers
51 views

MySQL slave attaches production database name to new views

I have a slave database that bears a different name than it's production counterpart. (We are using the replicate-rewrite-db option.) When I run a mysqldump from the slave (which I do for making dev ...
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 ...
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 ...
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]: ...
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 ...
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. ...
-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 ...