MySQL Forums :: Replication :: how to setup master, primary slave master and slaves


Advanced Search

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 3158 Victor Matladi 09/10/2010 03:36AM
Re: how to setup master, primary slave master and slaves 1152 Rick James 09/12/2010 12:45PM
Re: how to setup master, primary slave master and slaves 792 Victor Matladi 09/13/2010 01:22AM
Re: how to setup master, primary slave master and slaves 1051 Rick James 09/13/2010 10:44AM
Re: how to setup master, primary slave master and slaves 991 Victor Matladi 09/14/2010 02:15AM
Re: how to setup master, primary slave master and slaves 802 Rick James 09/14/2010 07:51AM
Re: how to setup master, primary slave master and slaves 986 Victor Matladi 09/14/2010 08:47AM
Re: how to setup master, primary slave master and slaves 835 Rick James 09/14/2010 08:16PM
Re: how to setup master, primary slave master and slaves 777 Victor Matladi 09/15/2010 12:53AM
Re: how to setup master, primary slave master and slaves 849 Rick James 09/15/2010 06:03AM
Re: how to setup master, primary slave master and slaves 718 Victor Matladi 09/15/2010 07:48AM
Re: how to setup master, primary slave master and slaves 804 Rick James 09/15/2010 08:40AM
Re: how to setup master, primary slave master and slaves 888 Victor Matladi 09/15/2010 08:56AM
Re: how to setup master, primary slave master and slaves 718 Rick James 09/15/2010 09:25PM
Re: how to setup master, primary slave master and slaves 704 Victor Matladi 09/16/2010 02:15AM
Re: how to setup master, primary slave master and slaves 754 Lance Badger 09/16/2010 02:45PM
Re: how to setup master, primary slave master and slaves 840 Rick James 09/16/2010 09:07PM
Re: how to setup master, primary slave master and slaves 720 Victor Matladi 09/18/2010 08:27PM
Re: how to setup master, primary slave master and slaves 826 Rick James 09/18/2010 09:53PM
Re: how to setup master, primary slave master and slaves 804 Victor Matladi 09/22/2010 06:15AM
Re: how to setup master, primary slave master and slaves 686 Rick James 09/22/2010 07:38PM
Re: how to setup master, primary slave master and slaves 695 Victor Matladi 09/27/2010 07:38AM


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.