https://www.udemy.com/aws-certified-solutions-architect-associate/learn/v4/t/lecture/2051702?start=0
Aurora only runs on AWS infrastructure.
Aurora is a MySQL compatible, relational database engine that combi9nes the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Aurora provides up to 5 times better performance than MySQL at a price point 1/10th that of a commercial database (Oracle?) while delivering similar performance and availability.
Scaling
- Starts with 10GB and scales in 10GB increments to 64TB (Storage Autoscaling)
- Compute resources can scale up to 32vCPUs and 244GB RAM
- Not quite ‘push button’. Should be performed during a maintenance window.
- Only takes a couple of minutes.
- 2 copies of your data is contained in each AZ, with a minimum of 3 AZ, so 6 copies of your data.
- Can handle the loss of up to two copies of the data without affecting the database write availability and up to 3 copies without affecting the read availability.
- Storage is self-healing. Data blocks and disks are continuously scanned for errors and repaired automatically.
Replicas
- Aurora Replicas (up to 15)
- If you lose your primary Aurora database, an Aurora Replica will automatically take over.
- You should always use the ‘cluster’ endpoint to connect to the database and not the ‘instance’ endpoint. If the primary (writer) instance fails, AWS will automatically redirect the cluster endpoint to the next tiered instance.
- MySQL Read Replicas (up to 5)
- Loss of the primary MySQL database will NOT automatically cause a Read Replica to take over.