CODEWITHSUNDEEP
postgresqlamazon-web-servicesamazon-rds
klautern
klautern

Reputation: 139

Exclude table from amazon RDS multi az secondary DB sync

I've got an amazon RDS postgres database, with the multi AZ option enabled.

There is a table with an extremely intense number of writes, but with very volatile information. If the information was lost, it wouldn't be a high damage (assuming this is happening almost never).

Is it possible to exclude the sincronization of this table among the main an the secondary database? So if there was a problem with the main database, when the secondary is promoted to be the main, this table would be empty. The idea is to reduce the cost of sincronization.

Upvotes: 1

Views: 253

Answers (1)

Matt Houser
Matt Houser

Reputation: 36073

Amazon RDS's Multi-AZ feature works at the instance-level only. It's not possible to selectively sync at the database level or the table level.

If this is a big concern, you could separate such tables onto a different RDS instance that is not Multi-AZ.

Upvotes: 4

Related Questions