IT Computer Training Articles Tutorials - Submit Your Article - Articles Submission Directory. - http://www.articles.webtechvision.com
How fast and how easy do you want the MySQL Recovery process to be
http://www.articles.webtechvision.com/articles/227/1/How-fast-and-how-easy-do-you-want-the-MySQL-Recovery-process-to-be/Page1.html
arif mahmood
My name is Arif and i am a designer of http://securiour.com.  
By arif mahmood
Published on 08/26/2007
 
Just like planning any other backup implementation, the most important consideration is the recovery process. Here are two key recovery objectives
How fast and how easy do you want the MySQL Recovery process to be


To what point in time will you need to recover your database?
The Recovery Point Objective (RPO) defines to what point in time you have to recover your database. For example, if a user dropped a table by accident at 12:55 pm, you might want to recover to a point in time just before the delete command. In some circumstances you may want to selectively exclude some rogue transactions during the recovery process.

How much time will you have to recover your database?
The Recovery Time Objective (RTO) defines how much time it will take to recover the database. You should carefully consider how long your MySQL application can be offline while you do a recovery.
Therefore, you will need to determine RPO and RTO for MySQL database in your environment and implement your backup solution accordingly.

When planning the recovery process, remember that different circumstances will require different levels of recovery. Depending on the situation, you may need to recover:


The whole server - all databases (in case of disaster recovery)
Specific database
Specific table
Specific transactions
Make sure to periodically test your recovery procedures by actually conducting recoveries. Actual recoveries happen under stress and this is not the time for practice. Once again it is all about recovery when planning your MySQL Backup solution!

By Computer security by securiour.com