gotchasqlMinor
Difference between backup methods: Oracle and MySQL
Viewed 0 times
methodsdifferencemysqlbetweenandoraclebackup
Problem
I was reading that Oracle databases have cold, warm, full and redo backups.
Questions
Questions
- How is it possible that MySQL doesn't have as many options?
- I have read that MySQL has cold backups (it puts the DB into a lock mode by itself); are there any other methods?
- How can I implement methods similar to those that Oracle has in MySQL?
Solution
Because MySQL is not as mature.
But there are options, such as Percona's (free) hot backup for innodb:
http://www.percona.com/software/percona-xtrabackup/
There is also MySQL Enterprise Backup from Oracle, but it is not free.
But there are options, such as Percona's (free) hot backup for innodb:
http://www.percona.com/software/percona-xtrabackup/
There is also MySQL Enterprise Backup from Oracle, but it is not free.
Context
StackExchange Database Administrators Q#16642, answer score: 2
Revisions (0)
No revisions yet.