Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous - slaves need not be connected permanently to receive updates from the master. This means that updates can occur over long-distance ...
1
vote
2answers
45 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, ...
0
votes
1answer
16 views
mysql relay log corrupted, How to recover?
I am running with one master and two slaves in a chain. ie
Master-->Primary Slave-->Secondary Slave.
The relay log of primary slave got corrupted.
How can I recreate the relay log of ...
2
votes
4answers
58 views
Replicate main MySql db to a development server to play with real data
I have a main architecture with a MySql db, replication and backup, it's working fine. Now I also have a development server where I play with the code and I would like to use the data from the main db ...
2
votes
3answers
55 views
MySQL to PostgreSQL replication
Is there way to replicate in near-realtime MySQL changes to equal PostgreSQL database?
1
vote
0answers
33 views
Mysql Master-ColdMaster
I explain my case:
I'm at Amazon AWS and I want to be fault tolerant on a entire region failure. My basic problem is to have the db in sync with 2 regions.
My options:
Master-Master (high lag)
...
1
vote
1answer
52 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 ...
1
vote
2answers
89 views
MySQL replication not working on leap day
Though out of my "core" knowledge I maintain a two-way replicated MySQL database (primary and backup). It's been working fine mostly. All changes are almost instantly replicated between the two ...
0
votes
0answers
40 views
Replicate mysql server with networking disabled
I like having network disabled on mysql, but now I need to replicate one table across two servers. That is, the table will be updated on one server and then I need a copy of that table to be ...
1
vote
2answers
57 views
[MySQL]multiple-masters single-slave
Is is possible to have a setup where multiple mysql servers (containing different databases) are replicated in a single mysql slave server ?
If yes, how to do it ?
1
vote
1answer
33 views
Backups from MySQL slave server — Good idea or bad?
I'm have one MySQL master and two MySQL slaves set up to replicate. I'm running my database backup process, consisting of an Xtrabakup (via the perl wrapper Innobackupex) backup and an atomic ...
0
votes
0answers
38 views
MySQL 4.1 to 5.1 Replication: “ON DUPLICATE KEY UPDATE” and “ON UPDATE CURRENT_TIMESTAMP” not working
I have a problem with a MySQL 4.1 master with a MySQL 5.1 slave. The binlog format is STATEMENT (the only one supported by 4.1).
The problem is that the triggers ("ON DUPLICATE KEY UPDATE" and "ON ...
2
votes
2answers
157 views
What do you think about this Debian Backup strategy?
I am not really a sys admin, I am mainly a developer with some unix knowledge, and because we don;t have any competent sysadmin , I have been delegated the task to implement the backup strategy.
We ...
0
votes
1answer
38 views
Mysql Replicated database UPDATE not working
I have been trying to start replication in a MySQL database. I followed all the steps from the MySQL manual to setup and configure the replication.
...
0
votes
0answers
54 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 ...
0
votes
0answers
40 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
40 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
117 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:
...
2
votes
2answers
599 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
98 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
51 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 ...
3
votes
1answer
93 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 ...
0
votes
1answer
67 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
132 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
175 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
51 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.
0
votes
1answer
26 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 ...
0
votes
0answers
66 views
Find out the position of binlog having error (mysqlbinlog)
While applying the mysql binlog manually (mysqlbinlog) it throws an error You have an error in your SQL syntax...... , How can we find out the position of the binlog having issue ?
2
votes
1answer
24 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
33 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
33 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 ...
0
votes
0answers
65 views
Changing MySQL replication method in chained setup
I am trying to achieve a chained replication setup where the second master in the chain switches from row-based replication to statement-based replication. The reason for this is I want to ensure data ...
4
votes
1answer
1k 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
40 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
65 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
60 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
333 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
38 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, ...
1
vote
1answer
43 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
100 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
103 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 ...
0
votes
0answers
76 views
MySQL Replication delays INSERT queries
I am setting up MySQL master-master replication using Ubuntu and MySQL 5.0.51.
I have two servers, which I will call Master 1 and Master 2.
Master 1 is the master where clients connect to. About 50 ...
1
vote
0answers
77 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 ...
0
votes
0answers
39 views
How to acomplish Multi Database Replication on disconnected/slow enviorements
This is the scenario I need to make it work:
50 different servers geographically dispersed running the same application all connected to one "Home" server running the same application. Same database ...
1
vote
1answer
60 views
MAMP MySql Master Slave Replication on local machine
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
48 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
148 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
38 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
161 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
78 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
57 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 ...
Community Bulletin
Related Tags
mysql× 179replication× 28
database× 17
mysql-cluster× 11
linux× 9
master-slave× 9
mysqldump× 8
backup× 8
mysql5× 7
database-administration× 7
database-replication× 6
maatkit× 6
sql-server× 5
mysql-mmm× 5
clustering× 5
database-backup× 5
postgresql× 4
ubuntu× 4
master-master× 4
high-availability× 4
load-balancing× 3
scalability× 3 monitoring× 3
haproxy× 3
amazon-ec2× 3
