Thread: New Backup Features in MySQL 6.0

Data administrators have this enormous responsibility to ensure that data in the various databases remains failsafe. They also have to focus on the performance and have to keep the databases tuned optimally for better performance. They-also have to keep a disaster recovery plan in place, for which taking regular database backups is one of the requirements. This database backup can also be used while doing database migration to another servers or while upgrading to a newer version of the database server. Backup and Recovery are two important tasks for the DBA, to be performed on a regular basis.



For MySQL database, a utility called "mysqldump" is available that is used to create the database \>ackup, but the hindrance is that while title backup of the database is taking place the transactions to the database get blocked. And as enterprise databases run into several hundred gigabytes, taking backups will consume a lot of time. Also, the time the enterprise database is being backed up, it will be kept locked from transaction calls. With the alpha release of new MySQL 6.0 Server, a new backup and restore feature has been introduced which answers the problems associated with mysqldump utility.