On Wed, Nov 2, 2011 at 4:48 PM, Karuna Karpe
<karuna.karpe@os3infotech.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