Linked Questions

5
votes
3answers
14k views

Master-master Replication with 3 Nodes

I need to configure mysql master/master replication with 3 nodes. Currently I have master/slave setup and I need to move it to master/master with 3 nodes. I have gone through some posts about ...
6
votes
1answer
3k views

Replicate MySQL 5.0 Master to 5.5 Slave?

We're planning out a series of server/software upgrades and were curious. We have a RHEL5 install running MySQL 5.0 that we'd like to replicate to a new (virtualized) server running CentOS 6 and ...
4
votes
1answer
18k views

MySQL my.cnf vs my-huge.cnf

I've recently installed MySQL server and client 5.5.28 through rpm packages on an openSUSE machine, and I was not able to locate my.cnf file. I look into all directories mysql --verbose --help | grep -...
1
vote
1answer
5k views

How do I configure multi master replication on WAMP?

I want to configure mysql multi master replication, but I've not seen any comprehensive article or tutorial on how to do that on WAMP. I will be grateful if some will point me to a tutorial, or ...
1
vote
2answers
1k views

I have been tasked with Mysql Master-Master replication?

I have done some study and i came to know that Mysql master-master replication violates the ACID properties and there has been problem with primary key collision.Please Let me Know,Apart from these ...
0
votes
1answer
755 views

Multi-master and multi slave

I have been having some issues creating a redundant multi master setup. Here's the proposed layout: The problem I'm having is when something is written to master1 it replicates to slave1 and master2 ...
2
votes
1answer
601 views

Create a mysql slave database from master database

I have a mysql master database running. I want to have a slave database. So, I stopped the master mysql database and copied it to the slave machine. I had bin log enabled on master so even those files ...
1
vote
1answer
329 views

MySQL Circular Replication

I have this scenario where I have 4 MySQL servers (A,B,C,D), as this: Server (A) is always online, and serves as the main website. Servers (B,C and D) are online on random periods of the day, and not ...
0
votes
0answers
63 views

Mysql Replication Grant Privilages and Different row records

I followed the steps answered in the following question Setting Circular Replication in mysql I applied this steps in only two nods not three nods I was trying to add commend answer @...
1
vote
1answer
29 views

CREATE TABLE not issued on other masters

Database is created on all multi masters. Why CREATE TABLE doesn't being replicated to other masters. some explanations?