From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | Karuna Karpe <karuna(dot)karpe(at)os3infotech(dot)com> |
Cc: | Vinay <vinay(dot)dhoom(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: streaming replication |
Date: | 2011-11-04 01:38:17 |
Message-ID: | CAHGQGwHn8DLQF1vPaizJzwtFk+Y0ciML-zjXct_y6NmZ+BFy6g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Shivakumar Ramannavar | 2011-11-04 09:27:04 | Fwd: My Query to insert and retrieve takes time |
Previous Message | Erdinc Akkaya | 2011-11-02 08:58:07 | process 22254 acquired ShareLock on transaction |