Trips Platform is the backend stack that powers the shiny post booking trips experience on Expedia® for both mobile app and website. This system processes all the bookings made on Expedia. As you can imagine, it processes numerous bookings every day. The platform is read & write heavy where reads are more than double the number of writes. We were using 4 Amazon RDS MySQL databases. We ran a spike and found Amazon Aurora to be better suited to our needs in many aspects.
Amazon Aurora provides 5x the throughput of standard MySQL
With Aurora, you can provision up to 15 replicas, and replication is performed in milliseconds. By contrast, RDS allows only 5 replicas and the replication process is slower.
Amazon Aurora automatically maintains 6 copies of data across 3 Availability Zones (AZs) and will automatically attempt to recover the database in a healthy AZ with no data loss.
These are just a few of the features provided by Aurora. More details can be found here.
#aws #mysql #aurora mysql #rds