Aurora has a bunch of nice features WRT automatic failover, redundancy, and automatically scaling storage as you push more data into the DB.
Aurora leverages Amazon RDS Multi-AZ in this area. Their implementation has been battle-tested over many years and many many db instances.