MySQL Forums
Forum List  »  PostgreSQL

Re: mysqldump vs pg_dump
Posted by: Harrison Fisk
Date: October 20, 2004 06:47PM

Hi,

If you are using InnoDB, then you can do the same thing that pg_dump does by using the --single-transaction option for mysqldump. That will allow InnoDB to use the fact that it can do non-locking reads in order to take the backup. There also is a commercial tool available that allows you to take an online binary backup, which has the advantage of being faster for backup and restoring.

With MyISAM tables, then you can not do non-locking reads, so it will have to set locks no matter what (normally done during a scheduled maintence or such).

Also if you need to have 24/7 access, which is what your question implies, then you should definitely look into something such as replication, in which case you can can take a backup off that without impacting performance at all (even with InnoDB, as copying all of the data takes a bit of disk i/o)

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
9413
October 20, 2004 12:06PM
Re: mysqldump vs pg_dump
5779
October 20, 2004 06:47PM
3828
October 21, 2004 11:00AM
4285
October 24, 2004 07:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.