HiveBrain v1.2.0
Get Started
← Back to all entries
gotchasqlMinor

Difference between backup methods: Oracle and MySQL

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
methodsdifferencemysqlbetweenandoraclebackup

Problem

I was reading that Oracle databases have cold, warm, full and redo backups.

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.

Context

StackExchange Database Administrators Q#16642, answer score: 2

Revisions (0)

No revisions yet.