Replication delay
От | ascot.moss@gmail.com |
---|---|
Тема | Replication delay |
Дата | |
Msg-id | 942DF7FF-967F-44FD-ADD1-4B6FBDAA8A0C@gmail.com обсуждение исходный текст |
Ответ на | Re: Postgres 9.3 beta log (Bruce Momjian <bruce@momjian.us>) |
Ответы |
replication server: LOG: invalid magic number 0000 in log file 169, segment 77, offset 4325376
Re: Replication delay |
Список | pgsql-general |
Hi, I have a pair of PG servers, a master and a replica, all read-write queries are handled by the master, read-only ones areby the replica. From time to time the replica itself is too busy, all read-only queries will get inconsistent results because of replicationlag, sometimes it can be longer than 6 minutes. I am thinking to add multiple replicas to off-load read-onlyqueries, can you please suggest a way to monitor and failover the read-only query when the replication lag in areplica is more than 5 minutes? regards
В списке pgsql-general по дате отправления: