Re: Default maximum time replication between master and slave databases

On Fri, Jul 10, 2015 at 10:23 AM, Alberto Olivares <
alberto(dot)olivares(at)snowflakesoftware(dot)com> wrote:

> Thanks Guillaume,
>
> maybe. I am trying to find the parameter that controls this value but I
> cannot find it. Last thing I tried was to modify the vacuum parameters on
> the slave but nothing changes.
>
>
>
>
> *Alberto Olivares Colas*Technical Consultant
> Snowflake Software
>
> Tel.: +44 (0)2380 386578
>
> Email: alberto(dot)olivares(at)snowflakesoftware(dot)com
> Website: www.snowflakesoftware.com
> Twitter: @sflakesoftware <http://www,twitter(dot)com(at)sflakesoftware/>
> Follow us on LinkedIn <http://www.linkedin.com/company/snowflake-software>
>
> *Winner of IHS Jane's ATC Award - Enabling Technology*
> *Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*
>
> Registered in England & Wales. Registered Number: 4294244
>
> -----------------------------------------------------------------------------------------
>
>
>
>
> On 10 July 2015 at 15:11, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> wrote:
>
>> Le 10 juil. 2015 4:07 PM, "Alberto Olivares" <
>> alberto(dot)olivares(at)snowflakesoftware(dot)com> a écrit :
>> >
>> > Hi,
>> >
>> > I don't have any write activity on the master, but still this value
>> goes to 60 seconds and then restart constantly from 0 again .
>> >
>>
>> Well, you have. That might be autovacuum doing some vacuum or analyze
>> without you noticing it.
>>
>> --
>> Guillaume
>>
>
>
> *Winner of IHS Jane's ATC Award - Enabling Technology*
> *Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*
>

I still don't think you're understanding how replication works along with
trying to use this function to monitor slave lag. I tried to give a good
summary here.

http://www.keithf4.com/monitoring_streaming_slave_lag/