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

MySQL Replication not working on binlog-do-db

I set up MySQL master-master replication on my 2 Ubuntu VM. Configuration and connection done correctly according to this guide. Here is my problem. I print the master status on master 1 and it ...
1
vote
1answer
186 views

Automatic promotion of slave in MySQL master-slave replication

In a master-slave replication environment, what is required to automatically promote the slave as the master if the master goes down. What are common practice used to change the database reference ...
0
votes
1answer
114 views

Client to use the slave when the master is down in MySQL replication

Is it possible for the client to use the slave when the master is down in mysql replication? I have already set up a simple MySQL replication having a master and a slave. The client connects to the ...
2
votes
3answers
421 views

MySQL Master-Master Replication Lag

I have configured two MySQL servers (MySQL-1, MySQL-2) in master-master replication in the same datacenter using a local backend connection with the following options: ...
3
votes
2answers
14k 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
1answer
112 views

Setup MySQL replication - multiple machines?

i read a lot of mysql server repliaction tutorials, but there's no hint, if the slave server is on a second machine or on the same server but just another mysqld process? any advice? thanks in ...
0
votes
1answer
317 views

MySQL is failing to connect

I am building two mysql machines in master-slave config. Master has: mysql> create user 'repl'@'%.%.%.abc.mydomain.com' identified by 'mypassword'; mysql> grant replication slave on *.* to ...
4
votes
1answer
1k views

Recover a crashed MySQL master server from the slave

we are building a simple master/slave MySQL configuration using asynchronous replication, with MySQL enterprise 5.5.17 on both servers and innoDB based tables. In case of a crash of the master server ...
1
vote
1answer
2k views

Where can I find documentation on my.cnf directives?

I'm skimming through how to set up a basic master/slave replication in mysql. http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ However ...
1
vote
3answers
284 views

MySQL incremental backups and database replication

We have some servers that runs a tomcat app with a MySQL database. These servers are in different cities and the web app is used locally by our customers. On these servers a crontab job runs twice a ...
3
votes
1answer
1k views

MySQL on VMware for High Availability

Given a choice between the current database-level HA options for MySQL, like Master-Master, Cluster, or Galera, and vSphere HA for the machine running the MySQL master, which would you use or combine ...
0
votes
1answer
163 views

Is there a difference between the mysql native master/slave replication setup versus one that uses percona xtrabackup?

The reason I ask is because these instructions seem to indicate that setting up a slave is different when using xtrabackup.
1
vote
1answer
86 views

SQL Server 2005 to Mysql Replciation DATA duplication

I set up Replication between SQL Server 2005 and Mysql 5 using following articles : http://ratecontrol.blogspot.com/2010/12/one-way-transactional-replication-from.html and error setting up ...
2
votes
1answer
49 views

Finding binary log position to start replication

I'm setting up master/slave replication on a non-trivally-sized schema (around 3Gb of data) and I'm trying to work out the best way to go about it. I have a backup script working on the master that ...
1
vote
1answer
48 views

How to check if data are the same between to Mysql servers setup as master-master replication

I have two servers using Mysql Master-Master replication. Actually, only one server receives write orders. One of the databases is out of sync. Several tables don't have the same numbers of records, ...
0
votes
1answer
67 views

MySQL two master databases for two seperate apps

We have two different websites one is hosted in asia datacenter called it asiadata.com and other site is hosted in europe datacenter called it europedata.com. Currently we have only one master ...
6
votes
3answers
17k 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 > ...
0
votes
1answer
78 views

Aggregating data from multiple MySQL servers

I have 10 MySQL servers and each one holds a database that needs to be replicated to a single, centralised MySQL server. The complexity is that each server must replicate its database to the same ...
1
vote
2answers
161 views

Measuring MySQL Replication Delay

How to measure MySQL replication delay between 2 MySQL servers ( 1 Master 1 Slave ) ? Given that two Xeon E5620 grade 1U servers are separate machine in same network segment, using MySQL Community ...
1
vote
1answer
272 views

making slave server as master for another server

I have three servers, Server X, Y, and Z. I have the main mysql DB on X (innodb DB). now I have created Master-Slave from X to Y. everything is working fine here. and now i set Y as a master for Z. ...
1
vote
2answers
1k views

Mysql Cluster not working on Ubuntu

I am unable to setup MySQL Cluster on ubuntu servers. As a starting point I started from the link but I am not successful and the tar ball version I download is 6.3.45. As I wanted to test the mysql ...
-2
votes
1answer
96 views

log error in mysql replication [closed]

I use mysql replication. At slave, i read in aa.err Statement may not be safe to log in statement format. Statement: update idv_product set visit = visit+1 where id = '173' limit 1 I don`t understad, ...
2
votes
1answer
154 views

my.cnf file makeup, does the [] headers matter?

I've got a pretty basic question, I am making a configuration script for mySQL replication between 2 new blank servers, now to make it a bit more failsafe I added the lines: sed '/log-bin/d' ...
2
votes
3answers
175 views

How do I quickly create new instances of complex MySQL database?

I'm managing an enterprise web application that uses Amazon's RDS as our database server. Our architecture is such that when a user signs up for a new account we create a brand new database for them ...
2
votes
1answer
331 views

Replication stops

I have 2 CentOS 5.5 servers runnig Mysql 5.5, configured as master-master replication. When on one server i have network problems, on another i see messages in log: 111105 2:38:30 [Note] Stop ...
1
vote
0answers
158 views

MySQL master-master replication: “Lock wait timeout exceeded”

I am setting up master-master replication with MySQL. Writes are done only to Master1. Master2 is slave of Master1 and is replicating perfectly. When I set Master1 as slave of Master2, I get lots of ...
1
vote
1answer
304 views

MAMP MySql Master Slave Replication on local machine [closed]

Has anyone got a good tutorial or info how to make a master slave replication on a local machine with MAMP 2.0? Should I install multiple MySQL instances or can I do it with one installation? Thanks ...
0
votes
2answers
99 views

MySQL Master Slave Replication Not Working

I setup MySQL master slave replication, but none of the databases, tables, and data is being copied over to the slave from the master. Here is the relevant configuration on the master: server-id=1 ...
1
vote
2answers
217 views

mysql master master master

I have n servers and I am planning to setup n master servers using master-master configuration. What architecture will be the best one ? Also I need to take care of auto-increment table things... ...
0
votes
1answer
47 views

msyql replication time

I am planning to setup mysql master-master or master-slave configuration. Yet to be decided. But my question is, is there any way to specify in the slave or master saying that it needs to check for ...
1
vote
2answers
847 views

Broken Slave (MySQL replication)

Last night one of the developer ran a wrong mySQL statement (Query inserting a row with duplicate primary key) on master machine. Suddenly the replication to its slave stopped. Slave started writing ...
1
vote
3answers
342 views

Is it possible with MySQL to have a database-specific Master Binary Log setup?

Is it possible for me to have a unique binary log per MySQL database on my MySQL server? I've done some googling and can't seem to find any solutions. Surely there's a way!!
0
votes
1answer
89 views

mysql performance optimization after enabling replication

Over the weekend I upgrade my Ubuntu server from 9.10 to 10.04 which also updated my MySQL server. I also enabled MySQL replication over to another server as slave. I have not yet moved any ...
1
vote
1answer
128 views

Failed to Attach DB on replicated SAN

We currently have a clustered SQL Server 2005 which has replicated SAN disks for our DR solution, to test DR we break the SAN synch and then attach the various DB's on the DR server. Our web servers ...
2
votes
1answer
749 views

Redundancy for WordPress sites

For static websites I'm using HAProxy (one master, several nodes with static HTML files on them). What services in addition would you recommend to allow WordPress sites to be hosted in the same way in ...
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 ...
0
votes
2answers
110 views

Replicate mysql database to DBserverBackup without stopping the service on DBserver

I have an Ubuntu Server with mysql database on it and I would like to copy its full content (data, users, anything) to another mysql server I have on the network. How can I obtain this result ...
2
votes
3answers
299 views

mysql replication master master

is it recommended to do mysql master-slave cluster or master-master cluster? do I need a 3rd party tool in order to do a master-master mysql cluster for the virtual IP? (I thought to use heartbeat ...
3
votes
3answers
2k views

Database scalability with write-heavy application

I have a write-heavy application. The application is best compared to surveys - the customer creates custom questionares and this is saved to the database. Most of the requests are from their users ...
0
votes
1answer
126 views

MySQL table keeps corrupting, need a simple fail over solution?

One of my clients servers recently crashed at the planet, we got an automatic email from them that they had to do a hard reboot. Since then mysqld stops running occasionally and then shopping cart ...
2
votes
1answer
501 views

error setting up replication from mssql to mysql

I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error: OLE DB or ...
0
votes
1answer
65 views

how mysql replication

I'm doing mysql replication (master - slave). There are a few questions Can I assign replication for some databases and not all databases that are on master (for example, ON master server there are ...
0
votes
2answers
862 views

MySQL Binary Logs more than 15 GB

Binary log in one of my server has grown more than 15 GB even after setting the max size to 1 GB. The MySQL server is as well not starting. Can anyone highlight what might have caused it ? Thanks.
15
votes
2answers
2k views

Is it ok to replicate the `mysql` database?

When I originally set up my master-to-master replication, I used: binlog-ignore-db=mysql and have been syncing the user accounts and grants manually. This is simply how it was done in the how-to I ...
1
vote
1answer
202 views

Setting up MysqlMM replication with EC2 instances with elastic IPs for both

I just spun up two EC2 instances and got an elastic IP for each. I can't seem to get it to connect. Here is the bulk of my config: auto_increment_offset=2 log-bin=master2-bin binlog-ignore-db=mysql ...
1
vote
1answer
480 views

Running MySql replication between datacenters

I run my website from EC2. Due to AWS outages, I am contemplating replicating my setup on Rackspace and switch over from DNS in case of an outage. I am looking to learn ways to replicate my MySql ...
0
votes
1answer
549 views

MySql backup using mysqldump in replication environment

I was checking the mysql backup script that being designed by senior mysql admin (left long time ago), just in order to implement the same setup for different client. all the steps were clear and ...
2
votes
1answer
288 views

Full, Differential and Log backups of databases, MSSQL an MYSQL

Best I give a back story so you get the full picture. I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One ...
0
votes
1answer
546 views

Best MySQL failover and load-balancing for shared hosting environment [closed]

I am creating a shared hosting environment, load balanced and HA. HTTP/HTTPS is okay as well as the distribution of files (code and file uploads) between the servers. The last thing remaining is to ...
2
votes
2answers
49 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 ...