Time to recover RDS connection

0

When we restart server instance, we have 30 minutes to recover connection for RDS. It's not acceptable, what is the way to reduce this time ?

i-066debb375826c69f (node-api) on eu-west-3

Best regards JC DEVOS

3 Answers
1

Hi, I assume you don't have a disaster recovery in place, so I will suggest Implementing a disaster recovery plan. we can't actually advise how to reduce time to less than 30 min, it all depends on the current infrastructure in place, which can help reduce this time shorter, some ideas are below... For a production environment, it is important to take precautions so that you can recover if there’s an unexpected event. While Amazon RDS provides a highly available Multi-AZ configuration, it can’t protect from every possibility, such as a natural disaster, a malicious actor, or logical corruption of a database. To maintain business continuity, it is important to design and test a DR plan.

Amazon RDS backups Backups are a key component of a DR plan for your database. Amazon RDS supports two different types of backups: automated backups, and manual snapshots.

Amazon RDS backups follow these rules:

Your DB instance must be in the ACTIVE state for backups to occur. Automated backups and automated snapshots do not occur while a copy is executing in the same Region for the same DB instance. The first snapshot of a DB instance contains the data of the full DB instance. The snapshots taken after the first snapshot are incremental snapshots. This means that only the latest changed data is captured and saved. If it’s a Multi-AZ configuration, backups occur on standby to reduce the impact on the primary. Note: Automated backups and manual snapshots are stored in an S3 bucket that is owned and managed by the Amazon RDS service. Hence, you are not able to see them from your Amazon S3 console.

You can read more here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html

Yawar
answered 2 years ago
1

It's not clear what you are asking. Are you saying it takes 30 minutes for you to connect to RDS after you restart an instance? Have you looked at what your application and operating system is doing in that 30 minutes?

If you are asking about restarting an RDS instance, then have you looked at the timeout on the connection you have to the database? See https://nodejs.org/api/net.html#netcreateconnection

profile pictureAWS
answered 2 years ago
0

Hello, yes it takes 30 minutes to connect the RDS services, my application can't restart without RDS connection. If we attemp to restart in this mode (application trt to connect RDS services) the timer restart for a new 30 minutes for recover RDS connection. MySQL timeout are standard ones.

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions