Architect a multi-region active-active database on AWS and explain how you would handle consistency and failover.
