How can this requirement be met?
Switch to an active/passive database pair using the create-db-instance-read-replica with the – -availability-zone flag.
Specify high availability when creating a new RDS instance, and live-migrate the data.
Modify the RDS instance using the console to include the Multi-AZ option.
Use the modify-db-instance command with the – -ha flag.
Explanations:
Using thecreate-db-instance-read-replicawith the–availability-zoneflag creates a read replica in a specific availability zone, but does not configure high availability. It also doesn’t switch the database to an active/passive configuration.
Specifying high availability when creating a new RDS instance does not allow for live migration of data. To achieve high availability on an existing database, the existing RDS instance needs to be modified.
Modifying the existing RDS instance using the console to include the Multi-AZ option enables high availability by creating a standby instance in another Availability Zone, ensuring failover capability.
Themodify-db-instancecommand does not have an–haflag. The correct way to enable high availability is through theMulti-AZoption.