Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

12. Protecting Your Investment > Backup Utilities and OS-Level Solutions

Backup Utilities and OS-Level Solutions

Oracle provides the InnoDB Hot Backup solution for backing up InnoDB and MyISAM tables. Additionally, there are several third-party solutions for performing backups on MySQL. You can also perform some unsophisticated but effective backups at the operating system level.

The final section of this chapter briefly discusses the most popular alternatives:

  • InnoDB Hot Backup

  • Physical file copy

  • The mysqldump utility

  • XtraBackup

  • Logical Volume Manager snapshots

There are other options as well, but most are similar in purpose to these.

The InnoDB Hot Backup Application

If you use InnoDB as your only storage engine, or regularly back up InnoDB tables without backing up other types, you can use the InnoDB Hot Backup application from Oracle. InnoDB Hot Backup is a commercial product. Its great advantage is that you can keep databases running for both queries and updates during the backup—you don’t have to take the server offline or lock the tables explicitly.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint