CODEWITHSUNDEEP
amazon-aurora
Noamway
Noamway

Reputation: 195

Does enable "Performance Insights" on Aurora MySQL will make any downtime?

I want to enable the new "Performance Insights" on active RDS. Can I do that without expecting any downtime?

Thanks

Upvotes: 6

Views: 3071

Answers (2)

invertedfjord
invertedfjord

Reputation: 362

At the top it of the article it states "Enabling and disabling Performance Insights doesn't cause downtime, a reboot, or a failover."

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Enabling.html

Upvotes: 2

The-Big-K
The-Big-K

Reputation: 2830

Performance Insights does need you to mention a scheduling rule for modifications [1], which does indicate that it may need to restart the database for changes to take effect.

For Scheduling of Modifications, choose one of the following:

Apply during the next scheduled maintenance window – Wait to apply the Performance Insights modification until the next maintenance window.

Apply immediately – Apply the Performance Insights modification as soon as possible.

However, it does appear to be an instance level setting, which means that if you have a multi instance aurora cluster, then you can modify one instance at a time, and failovers should prevent you from having any downtime.

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Enabling.html

Upvotes: 2

Related Questions