I’m stuck on a MySQL question and need an explanation.
Describe in 500 words the disaster recovery plan and who is responsible at your place of employment. Consider the critical business functions and your recovery point objectives and recovery time objectives.
Use at least three sources. Use the Research Databases available from the Danforth Library, not Google. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list. Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragaphs.
Write in essay format not in bulleted, numbered or other list format.
Failover is the process of maintaining uptime for your database. It can be automatic or manually triggered. The enterprise must calculate how much downtime it can tolerate and plan to have less than that. This is sometimes called high availability. The enterprise must also plan for how to handle the loss of a database server. How does it recover? How quickly? What are the sources of failure? How much complexity can your enterprise manage? Will you rely on backup, mirroring, or clustering? Will you use an internal database solution or a third party application?
Sample IBM data disaster recovery plan