Which should the database specialist do to allow the database team to create the test tables?
Contact AWS Support to disable read-only mode on the read replica. Reboot the read replica. Connect to the read replica and create the tables.
Change the read_only parameter to false (read_only=0) in the default parameter group of the read replica. Perform a reboot without failover. Connect to the read replica and create the tables using the local_only MySQL option.
Change the read_only parameter to false (read_only=0) in the default parameter group. Reboot the read replica. Connect to the read replica and create the tables.
Create a new DB parameter group. Change the read_only parameter to false (read_only=0). Associate the read replica with the new group. Reboot the read replica. Connect to the read replica and create the tables.
Explanations:
The read replica cannot have its read-only status disabled via AWS Support. It’s not a manual process.
Changing theread_onlyparameter in the default parameter group affects all instances using that group. Modifying this setting on a read replica is not recommended or effective in this case.
Changing theread_onlyparameter in the default parameter group directly impacts all instances using it. This change cannot be applied on the read replica alone without a custom parameter group.
Creating a new DB parameter group and changing theread_onlyparameter tofalse(read_only=0) allows for customization of settings on the read replica without affecting the default parameter group. A reboot is necessary to apply the changes.