| CARVIEW |
Recommended Servers for MySQLThe world's most popular open source database
Contact Sales
USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-327-6494
USA - Subscription Renewals: +1-866-830-4410
Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 61 48 95
Sweden: +46 730 207 871
Benelux: +31 6 25003558
Italy: +39 06-99268193
Israel: +31 6 25003558
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191
Australia/NZ: +61 2 42314328
Asia Pacific: +81 3 5843 1140
Global Backup & Recovery for MySQL
A primary responsibility of database professionals is to establish and run proper backup and recovery plans. MySQL provides a variety of ways to backup and recover MySQL database servers, with the most popular being highlighted below.
mysqldump
The most popular method used to backup a MySQL database is the mysqldump utility, which ships with every version of MySQL. The mysqldump utility creates a backup file for one or more MySQL databases that consists of DDL/DML statements needed to recreate the specified databases along with their data. To restore a particular database, the backup file is simply read back into the MySQL utility command prompt as an input file. The mysqldump utility contains many options that allow for different types of backups such as online backups (non-blocking for DML) for InnoDB and other MVCC-based storage engines, backups of just database structures (no data), and much more.
Learn more »
mysqlhotcopy / OS Backup
Another popular method of backing up MySQL databases is to use operating system utilities and the mysqlhotcopy program. With mysqlhotcopy, the tables of the database being backed up are temporarily locked so no changes can be made (although data can still be read), the underlying files used by the database are copied to another physical location using O/S commands, and once the file copy is completed, the database tables are unlocked. Using mysqlhotcopy can result in faster backups depending on the copy speed of the O/S and the size of the database being backed up.
Learn more »
MySQL Replication
Replication is utilized by many MySQL users to create a warm standby server that can be failed over to should the primary database server become unavailable. MySQL replication is a very efficient and safe way to protect databases that are used for critical systems and does not impact the operation of data operations (i.e. it is non-blocking) on the server being replicated.
Learn more »
ZRM for MySQL
Larger databases, shortening backup windows, and security concerns make the job of backup and recovery management more complex than ever for today's MySQL administrator. In addition, managing the scheduling, monitoring, storage capacity, and reporting requirements across many MySQL servers can be very challenging.
To resolve such issues, MySQL provides global backup and recovery management capabilities through ZRM for MySQL. It offers a web-based console that handles the global management of backup and recovery operations across all MySQL servers in an enterprise. It protects key databases by automating all aspects of backup operations and helps even novice MySQL DBA's build solid backup and recovery plans. All MySQL backup methods are supported such as mysqldump, mysqlhotcopy, file system snapshot, cold backup, replication, and more.
Learn more »