With RDS Custom for SQL Server, what will be preserved after a failover and how long does failover take?
0
For example, what happens to long running transactions and cache in memory?
Langue
English
demandé il y a 10 mois343 vues
1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
Please note that RDS Custom for SQL Server has slight differences between RDS SQL Server. In RDS Custom for SQL Server, failover takes 60-120 seconds. Block-level, synchronous replication is used. (That means, when the disk is confirmed as written on the primary, it has been written on the 2ndary.) When failing over: (1) you will lose the hot memory cache. (2) if you have long-running transactions that are not yet committed and a failover occurs, they will roll back.
Please note that this answer is current as of July 2023. Be sure to check documentation for any updates.
répondu il y a 10 mois
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 7 mois
AWS OFFICIELA mis à jour il y a 2 ans- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 4 ans
- AWS OFFICIELA mis à jour il y a 2 ans
Here comes aws doc
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZSingleStandby.html#Concepts.MultiAZ.Failover