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
1answer
72 views

How to properly migrate mysql server?

Currently I am dealing with server migration. I have mysqldump --all-databases dump, which contains also mysql and might be information schema databases. All I need is somehow safely and fast ...
0
votes
0answers
130 views

MySQL replication & logrotate

I'm using MySQL Master-Slave replication for backup purposes (for a few days). Today after changing to expire_logs_days = 3 on master and slave I got this message (from slave): ...
3
votes
1answer
338 views

Using Amazon RDS (or similar) as a slave

Officially, RDS instances can't be directly set up to slave non-RDS databases. My production master is MySQL running on Hetzner and I want an RDS instance to closely follow it for backup purposes, ...
1
vote
0answers
27 views

Mysql Multi slave replication

Hi I have a master Mysql server from where i am replicating other 2 slaves. The issue is one of the slave stops with an error frequently. The error message is below. Error 'Duplicate entry ...
0
votes
1answer
81 views

Is there a log to see when a user is trying to access file/directory that he doesn't have permission?

My database is failing to replicate and the only clue in the error log is Operation Not Permitted, which I am guessing is file access permission failure either on donar or joiner. Is there any file ...
1
vote
1answer
167 views

mySQL: Slave not able to connect to Master for replication

On my master, I did: GRANT REPLICATION SLAVE ON *.* TO 'repluser'@'%' IDENTIFIED BY 'mypassword'; On my slave, I see: mysql> show slave status \G; *************************** 1. row ...
-1
votes
1answer
68 views

MySQL won't start if I set the log_bin

[mysqld] datadir=/db_vol/datadir socket=/var/lib/mysql/mysql.sock port=3306 server_id=1 log-bin=/db_vol/log/mysql-bin.log binlog-do-db=mydb When I try to start MySQL, I get an error that says MySQL ...
0
votes
1answer
25 views

Single slave - multiple master MySQL replication

I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?
0
votes
1answer
529 views

How to stream and record MySQL binlog remotely

For data redundancy goals, I want to record the binlog of a few hundred mysql servers in a central location. To run a full replicator for each stream would require lots of resources (multiple servers) ...
0
votes
0answers
33 views

How to do replication of data on mysql?

i am trying to do mysql replication for my site database. i searched on internet but did not get proper solution for replication. i am looking to do replication on same server.
1
vote
1answer
95 views

syncing specific tables between two already-replicating MySQL clusters

I have a circularly replicating MySQL cluster, and a newer cluster of Percona XtraDB instances that we're in the process of moving to. During the move, we're running some projects on the old cluster ...
0
votes
0answers
215 views

Mysql Replication Not Working

I setup Mysql Master Slave Replication but on my slave server I am continously getting below error, I tried all possibles but no luck. FYI I am using Percona Mysql 5.0.92-50-log 130405 5:36:54 ...
0
votes
1answer
73 views

MySQL Slave Not Replicating

I had a deleted some data on the master mysql. Looking at the slave status, it shows this: mysql> show slave status \G; *************************** 1. row *************************** ...
1
vote
1answer
2k views

Which binlog format to use for MySQL Replication?

Just about to start using MySQL replication and I'm wondering what kind of binlog format is the best to use? There's Row, Statement and Mixed. I'm going to be using 5.1.49. Row is winning at the ...
1
vote
5answers
768 views

Moving MySQL Data from 1 RDS server to another

How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another? An interruption of up to 20 mins is acceptable, although not preferred. My current plan ...
0
votes
1answer
98 views

Make heartbeat check MySQL replication lag before resource takeover

I am using heartbeat with MySQL master-master configuration, and using mon to check up on MySQL health. All works well for detecting downed host or broken MySQL. But the problems start after takeover, ...
0
votes
1answer
137 views

How can I estimate binlog size and whether binlogs should be on a separate disk?

We are about to setup MySQL Master-Slave replication on our production database. We intend to run backups from the slave (at the moment our master lags out for 15 mins every day whilst backups are ...
1
vote
2answers
642 views

PHP mysqlnd on Debian 6

I've installed php5-mysqlnd via: apt-get install php5-mysqlnd This is a brand new virgin Debian install with just apache2 and php5 via: apt-get install apache2 echo "deb ...
6
votes
8answers
1k views

Monitor MySQL Replication

What is the best practice for monitoring a slave to make sure that it is a) Still running b) Not too far being the master I would like to alert by email if it is behind, happy to write a script or ...
3
votes
3answers
4k views

Can I run mysqld on top of glusterfs?

I have been playing with glusterfs recently. What I want to try is to run mysqld on top of the glusterfs in a similar way as it is possible to run MySQL on top of DRBD. I am familiar with MySQL ...
0
votes
1answer
80 views

Replicate from slaves to master and viceversa

I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this: MySQL DB (master) table1 table2 ...
0
votes
1answer
142 views

mysqlbinlog does not continue to last log

I am using the following command to start reading mysqlbinlog. mysqlbinlog -t -v -v --base64-output=DECODE-ROWS -h my_host -ppasswd -R mysql-bin.000960 -j 1052323996 I would expect the output to ...
0
votes
2answers
236 views

Synchronisation between MySQL databases on different hosts

I want to solve a data replication/data sync problem between two MySQL server instances. Both of them have the same database structure (databases, tables, columns, everyting ...) but each of them has ...
2
votes
3answers
97 views

MySQL Replication A->B->C

I was setting the MySQL Replication for master -> slave/master -> slave and Replication for master -> slave its works fine but when i have enable this option in my.cnf log-slave-updates=1 for ...
1
vote
4answers
218 views

greping multiple lines from MySql binlog

I have binlog from MySQL and I need to output certain time frame into a seperate file, how would I do that? here is sample of what binlog file contains: # at 460 #130120 0:09:17 server id 1 ...
1
vote
1answer
201 views

MySQL Data Center Replication [closed]

I have a (possibly not so quick question) about the best way to set up a 'global' MySQL Database. I basically need to set up multiple MySQL servers in separate geographical locations that will all ...
0
votes
1answer
449 views

MySQL replication lag increasing

I have simple master-slave replication setup. Everything worked with no problems for more than a year. Few days ago replication lag started to rise and it's still rising with no obvious reason. ...
5
votes
2answers
13k views

What causes the MySQL error 1062 - duplicate entry when starting slave?

MySQL Master version: 5.5.16-1 MySQL Slave version: 5.5.18-1 The master's snapshot is created by: mysql> FLUSH TABLES WITH READ LOCK; shell> mysqldump --all-databases --master-data > ...
3
votes
1answer
288 views

Add MySQL as a resource to pacemaker

I am trying to enable fail over strategy using pacemaker on a mysql Master-Master replication on two virtual machine running openSUSE 12 created by VritualBox. I managed to complete the mysql ...
1
vote
1answer
494 views

MySQL error 2003 over ssh tunnel when replicating, not when using client

I am trying to set up replication on a MySQL server over an SSH tunnel. I've set up a port forward on the slave from port 7777 at localhost to port 3306 on the master, and I can connect to my ...
1
vote
3answers
313 views

How to check if MySQL replication is using SSL

I have a MySQL (actually mariaDB) install that I just started replicating to another server. I want to ensure that I've setup SSL correctly. The SSL portion of SHOW SLAVE STATUS looks like: ...
1
vote
0answers
39 views

MySQL Replication Monitoring for OS X Server

I have a CentOS 5 MySQL 5.0 server running that I need to replicate. I will setup MYSQL on OS X (Mac mini), but what tool should I use to monitor the replication that runs on OS X?
2
votes
2answers
399 views

How do I handle mysql replication in EC2 using private IPs?

I am trying to set up a mysql master/slave configuration in two EC2 instances. However, every time I reboot an instance, the IP address (and hostname) changes. I could assign an Elastic IP address, ...
1
vote
2answers
73 views

What is the best time to set the IP address for a server headed to a server colocation facility?

What is the best time to set the IP address for a server? I have a server that I am going to install the OS on and then I am going to send it to a server colocation facility. The server is going to ...
0
votes
2answers
429 views

How to use read replica instance for websites? Amazon RDS MySQL

Amazon RDS FAQs stated that it is up my application to distribute traffic to the read replica. My websites have mostly visitors - non-logged in users. So, I suppose most database activities are ...
6
votes
6answers
592 views

How can I centralise MySQL data between 3 or more geographically separate servers?

To explain the background to the question: We have a home-grown PHP application (for running online language-learning courses) running on a Linux server and using MySQL on localhost for saving user ...
2
votes
1answer
1k views

MySQL slave replication Seconds behind master increasing?

I started a MySQL slave using innobackupexand the Read_Master_Log_Pos: and the Relay_Log_Pos: are updating however the seconds behind master keeps on increasing (it's at Seconds_Behind_Master:496637 ...
3
votes
2answers
5k views

MySQL binlog format dilemma?

MySQL version: 5.5.13 If I set binlog format to STATEMENT, I got the following warnings on the Master: [Warning] Unsafe statement written to the binary log using statement format since ...
1
vote
1answer
193 views

mysqld - master to slave replication using rsync innodb, sequence number issues

I've read several of the related topics posted here, but I have not been able to avoid this innodb error. The steps I've taken to replicate data from a Slackware server - 5.5.27-log (S) to a FreeBSD ...
2
votes
0answers
60 views

HA across datacenters for wordpress [closed]

I have been tasked with setting up a High Available wordpress install accross 2 datacenters. We are going to use Anycast BGP so the same public IP will be live in each datacenter at the same time. I ...
2
votes
1answer
174 views

MySQL replication and UPDATE prioritisation

I have a master server, where I want modify operations such as UPDATEs to be LOW_PRIORITY so that they don't block SELECTs etc. This is better for end-user visible behaviour. I have a slave server, ...
3
votes
1answer
403 views

MySQL master-slave lag replication

Our company is using TokuDB on production and we are having a lot of problems trying to mitigate lag on our slave. Is very strange, because we're talking about very few rows... but with a few data it ...
1
vote
1answer
101 views

MySQL master-master replication between database running on 3 different server

I am trying to implement a master-master replication between 3 MySQL Databases running on 3 different servers. I implemented master-master replication for 2 servers, but can't figure out how can I ...
3
votes
2answers
1k views

mk-table-sync in a master-slave scenario: Changes not replicated to the slave

I have being employing mk-table-sync to synchronise tables from a master to slave on mysql 5.1. Unfortunately, while differences are correctly detected, modifications done on the master ...
3
votes
3answers
921 views

mysql master-slave setup with synchronous replication

I have a very trivial mysql master->slave setup going on between two servers. The problem is, replication is asynchronous, and this can cause issues (even on a low latency link), if the master server ...
0
votes
2answers
173 views

Setting up MySQL database replication [without restarting mysql]

I'm trying to setup MySQL db replication, it seems pretty straight forward. I was using this tutorial: http://www.howtoforge.com/mysql_database_replication Now I run a rather large MySQL database ...
1
vote
1answer
989 views

MySQL replication - rapidly growing relay bin logs

Morning all, I've got a really strange situation here this morning much like a reportedly fixed MySQL bug. http://bugs.mysql.com/bug.php?id=28421 My relay bin logs are rapidly filling with an ...
0
votes
0answers
77 views

MySql doesn't start after changing bind-address in Windows Server 2008

Actually I am working on Master to Master Replication MySQL on Windows Server 2008. My Master 1 is not able to connect with Master 2 whereas Master 2 is able to connect and it does telnet too. After ...
2
votes
3answers
206 views

MySQL replication automation?

I was wondering if there are any MySQL replication automators or managers that can take over the tasks of deploying MySQL slaves from a master. I come from an old school server management background, ...
1
vote
2answers
349 views

mysql master slave “table already exists” but table not exists

I have 1 master mysql process, and 2 slave. Today on both slaves i see : Error 'Table 'bgbilling.contract_status_balance_dump' already exists' on query. Default database: 'bgbilling'. Query: ...