From my understanding regarding consistency :
Standby node on multi AZ : ACID consistency
read replica : BASE consistency (eventual consistency) due to aynsc replication
Am I right ?
Ehh, not really. We generally refer to BASE and ACID as broad characteristics of entire products rather than individual components in the products. S3 follows a BASE consistency model while RDS MySQL is ACID compliant.
Relational Databases like RDS are ACID compliant–even if their read replicas are async. Replicas should really just be thought of as extensions of the main database–all part of the same product.
In fact, to use Read Replicas with RDS MySQL, you must use the InnoDB storage engine, which specifically enforces transactional ACID properties.
Async replication is the base of eventual consistency ? the origin of this eventual consistency( for S3,….)
How RDS can guarantee ACID compliant if we are not sure to retrieve the same information everywhere at the same time ?