setting high value for wal_keep_segments
Hi,
I am going to sync slave with my master which is almost 500 G. I am not
using archive directory instead of I am using wal files for streaming. As
it may take almost 3 hours, I am thinking of setting up 400 for
wal_keep_segments where I have enough space available.
Without the space issue, could there be any other problem in setting up
such high value for "wal_keep_segments"? As this is production, I need to
confirmed.
Thanks.
no problem if you have enough space. we have set it to 4096 one year
ago,everything is OK.
jov
在 2013-8-8 下午9:26，"AI Rumman" <rummandba@gmail.com>写道：
Show quoted text
Hi,
I am going to sync slave with my master which is almost 500 G. I am not
using archive directory instead of I am using wal files for streaming. As
it may take almost 3 hours, I am thinking of setting up 400 for
wal_keep_segments where I have enough space available.Without the space issue, could there be any other problem in setting up
such high value for "wal_keep_segments"? As this is production, I need to
confirmed.Thanks.
On Thu, Aug 8, 2013 at 6:23 AM, AI Rumman <rummandba@gmail.com> wrote:
Hi,
I am going to sync slave with my master which is almost 500 G. I am not
using archive directory instead of I am using wal files for streaming. As
it may take almost 3 hours, I am thinking of setting up 400 for
wal_keep_segments where I have enough space available.Without the space issue, could there be any other problem in setting up
such high value for "wal_keep_segments"? As this is production, I need to
confirmed.
Another data point: I set up SR on two systems recently in production with
the wal_keep_segments set to 10000 (lots of logs were being generated), and
the slaves were about 1TB each. No problems were experienced.
Yeah, I already set it like that and it works.
Thanks.
On Thu, Aug 8, 2013 at 11:59 AM, bricklen <bricklen@gmail.com> wrote:
Show quoted text
On Thu, Aug 8, 2013 at 6:23 AM, AI Rumman <rummandba@gmail.com> wrote:
Hi,
I am going to sync slave with my master which is almost 500 G. I am not
using archive directory instead of I am using wal files for streaming. As
it may take almost 3 hours, I am thinking of setting up 400 for
wal_keep_segments where I have enough space available.Without the space issue, could there be any other problem in setting up
such high value for "wal_keep_segments"? As this is production, I need to
confirmed.Another data point: I set up SR on two systems recently in production with
the wal_keep_segments set to 10000 (lots of logs were being generated), and
the slaves were about 1TB each. No problems were experienced.