Question

How can we verify that the standby node of managed db is db syncing?

Posted December 7, 2021 144 views
DigitalOcean Managed MySQL Database

I cannot find how we can access to the standby note to check the database.

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
2 answers

Hello @SandyLightCyanShrimp ,

Are you looking for any specific Managed DB?

You can check replication status from by rs.status() command. You will need to specify what you actually looking for.

There is no connection parameters available in the cloud panel to directly connect to standby nodes. Standby nodes become active only when their primary cluster goes down.

https://docs.mongodb.com/manual/reference/method/rs.status/
https://docs.mongodb.com/manual/reference/method/db.getReplicationInfo/

Hope this helps!

Cheers,
Sri Charan

@SandyLightCyanShrimp :

Standby nodes are managed by the DigitalOcean end and you won’t be able to directly access the standby node and check replication status.
Standby nodes are copies of the primary node that automatically take over if the primary node fails and there won’t be any significant lag noticed.

For more information on the standby node:
https://docs.digitalocean.com/products/databases/#high-availability
https://docs.digitalocean.com/products/databases/mysql/how-to/add-standby-nodes/

If you are facing any issue and the standby node does not backup when the primary node fails, Please feel free to open a support ticket with us.

https://docs.digitalocean.com/support/

I hope this helps!

Regards,
Rajkishore