MySQL Forums
Forum List  »  Replication

how to setup master, primary slave master and slaves
Posted by: Victor Matladi
Date: September 10, 2010 03:36AM

hi
can you please help me on how to configure a primary master.

current scenario: 4 slaves connecting to the production master and it locks some of the tables when inserting large amount of data.

I was wondering if the following scenario would be possible.

server 1: master(production)
--replicating to--
server 2: primary slave master
--replicating to--
server 3:slave
server 4:slave
server 5: slave

I want to reduce load on the production master.
replication should occur from server 1 to server 5 through server 2

how to configure master to master and slaves

thanks,
victor



Edited 1 time(s). Last edit at 09/10/2010 08:21AM by Victor Matladi.

Options: ReplyQuote


Subject
Views
Written By
Posted
how to setup master, primary slave master and slaves
3195
September 10, 2010 03:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.