Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Failed to create new system journal: No space left on device Question Question
need solution for this "Inbound DDoS Detected" Question Question

Question

How to test database cluster automatic failover and high availability

Posted October 14, 2020 824 views
High AvailabilityDigitalOcean Managed PostgreSQL DatabaseNeeds Product Answer

Hi,

I have set up a PostgreSQL database cluster with 1 Primary and 1 Standby Node.

How do I test/ensure that replication between the Primary and Standby node, automatic failover and high availability are working?

Any help is appreciated.

Thanks,

Akbar

Add a comment
trefore
By:
trefore
edited by AHA

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Failed to create new system journal: No space left on device Question Question
need solution for this "Inbound DDoS Detected" Question Question
Add a comment
1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer
Rajkishore May 24, 2021

Hi @trarbr @trefore,

There is no option to test automatic failover to a standby node manually from your end.

All managed database clusters have automated failover, meaning they automatically detect and replace degraded or failing nodes. In order for the failover to happen, The database cluster will have primary and standby nodes.

The standby nodes maintain a copy of the primary node. In the event of a failure, The standby node is immediately promoted to primary and begins serving requests while a replacement standby node is provisioned in the background.

For more information on high availability:
https://www.digitalocean.com/docs/databases/#high-availability

You can add standby nodes during cluster creation as well as to an existing database cluster.

The below link has information on how to add a standby node

https://www.digitalocean.com/docs/databases/postgresql/how-to/add-standby-nodes/

Regards,
Rajkishore

Reply Report

Related

Looking for something else?

Ask a new question Search for more help