[pgpool-general: 6022] Streaming Replication Check

[Mathias Buresch]

Hi there,

maybe someone can help me to understand how “Streaming Replication Check” is working.

Is it checking replication lag by using pg_last_xlog_receive_location() and pg_last_xlog_replay_location() ??
Am I right that those check should not be dependent from database I use?
If it is like that why I need “sr_check_database”?

Also why “delay_threshold” cannot be 0? Why 0 is disabling it?

The reason I ask is that a customer has problem with inserting something and “directly” read the insert and don’t get the correct answer – maybe because it is not synced and loadbalancing is forwarding to slave?!

Mit herzlichen Grüßen

Mathias Buresch
Systems Engineer
--
mathias.buresch at de.clara.net
Tel: +49 (69) 40 80 18 - 265
Fax: +49 (69) 40 80 18 - 129

Claranet GmbH
Hanauer Landstraße 196
60314 Frankfurt

Geschäftsführung Olaf Fischer
Hrb 50381 AG Frankfurt am Main
Vat-ID de 812918694

http://www.claranet.de

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180405/652fc26d/attachment.html>