You have a relational database that crashes during peak traffic periods, but its replica fails to be promoted to primary. How do you prevent this from happening again?