But I want huge amount of data in database. so it is take so much to take dump from slave db and load in master db.
for example :-
I have one master db server with 20GB of data and two slave db server are replicated from master server. when my master db server is fail, then one of slave server become new master server. In new master server 50MB of data add into database. After some time my failed(old) master back up, then I want to become my old master server as master and my new master server become slave(as previous setting). So please let me know that how replication only that 50MB data into old master database server????
Please give me solution for that...
Regards,
Karuna karpe.
On Tue, Nov 1, 2011 at 5:14 PM, Vinay
<vinay.dhoom@gmail.com> wrote:
Dear Karuna,
Its one way replication streaming ie Master to Slave. Once failed master DB is up, you need to reconfigure the replication streaming. Before that you need to take the updated dump of slave db and load in master db.
Hope this information is useful.
VinayOn Tue, Nov 1, 2011 at 5:10 PM, Karuna Karpe
<karuna.karpe@os3infotech.com> wrote:
Hello,
I am replicating master server to slave server using streaming replication. I want to know that, when my master server is failed and my slave server become master server with adding some additional data into database and after some time failed master server is up then how will i replicate that additional changes into my failed master server?????
can any one tell me that how to do this?
Regards,
karuna karpe.