How should the Data...
 
Notifications
Clear all

How should the Database Specialist edit the script to fix this issue?

1 Posts
1 Users
0 Likes
61 Views
Mario
(@sitesmario)
Noble Member
Joined: 7 months ago
Posts: 413
Topic starter  

A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL.

The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.

How should the Database Specialist edit the script to fix this issue?

  • A . Stop the source instances before stopping their read replicas
  • B . Delete each read replica before stopping its corresponding source instance
  • C . Stop the read replicas before stopping their source instances
  • D . Use the AWS CLI to stop each read replica and source instance at the same time

Show Answer Hide Answer

Suggested Answer: B

Explanation:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html

"The following are some limitations to stopping and starting a DB instance: You can't stop a DB instance that has a read replica, or that is a read replica." So if you cant stop a db with a read replica, you have to delete the read replica first to then stop it??? https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MySQL.Replication.ReadReplicas.html#USER_MySQL.Replication.ReadReplicas.StartStop

   
Quote
Share: