Re: streaming replication

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(dot)dhoom(at)gmail(dot)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.
>
> Vinay
>
>
> On Tue, Nov 1, 2011 at 5:10 PM, Karuna Karpe <karuna(dot)karpe(at)os3infotech(dot)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.
>>
>
>