Re: streaming replication

On Wed, Nov 2, 2011 at 4:48 PM, Karuna Karpe
<karuna(dot)karpe(at)os3infotech(dot)com> wrote:
> 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????

What about using rsync to take a base backup from new master and load it
onto old master? rsync can reduce the backup time by sending only differences
between those two servers.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center