[GENERAL] Logical slot preservation after physical failover
Hi all,
I am working with the following topology:
- Physical replication between server A1 and A2
- Physical replication between server B1 and B2
- A1 and B1 are masters, and both have a virtual IP attached
- Logical replication between A1 and B1 using the virtual IP addresses
- On failure of (A1,B1) (A2,B2) will be promoted and the virtual IP address moved
I threw together a diagram to help visualize the environment.
Is there any way to retain the items which are associated with a logical slot when I fail from A1 to A2 (so the virtual address is attached to A2, and A2 has been promoted)?
I saw that there was some discussion about 'failover slots' and then 'logical replication on standbys' but it's unclear where this is going.
Not having this feature essentially means that logical replication is a toy feature in Enterprise (where HA clustering is the general rule), as it always comes with a high possibility of data loss. This is compounded as it seems logical replication sends transactions in sequence (ie xid 2 blocks xid 3 until it commits).
Any thoughts / hints / hacks?
Cheers,
James Sewell,
PostgreSQL Team Lead / Solutions Architect
Suite 112, Jones Bay Wharf, 26-32 Pirrama Road, Pyrmont NSW 2009
The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.
В списке pgsql-general по дате отправления:
Предыдущее
От: Andres FreundДата:
Сообщение: Re: [GENERAL] [PERFORM] Questionaire: Common WAL write rates on busy servers.
Следующее
От: Glen HuangДата:
Сообщение: [GENERAL] json_agg doesn't generate the smallest json possible?