A company runs several write-heavy, multi-tenant applications using a single MySQL database on one EC2 instance. The company requires a highly available database solution that handles multi-tenant write activity. Which migration target should the SysOps admin choose?

The correct choice is to migrate to an Amazon Aurora multi-master DB cluster. This solution provides high availability and fault tolerance with multiple read/write master instances across different Availability Zones, ensuring continuous operation even if one master fails. It also handles write-heavy workloads efficiently due to its distributed, fault-tolerant, self-healing storage system. Provisioning a second EC2 instance as a MySQL read replica would improve read scalability but not write availability or fault tolerance for the primary database. Migrating to an Amazon Aurora DB cluster with a single Aurora Replica would offer high availability for reads and failover for the primary, but it wouldn't provide multi-master write capabilities. Migrating to a single Amazon RDS for MySQL DB instance, even with Multi-AZ, would still have a single primary writer and wouldn't meet the multi-tenant, write-heavy, highly available requirement as effectively as Aurora Multi-Master.