MySQL Forums
Forum List  »  MyISAM

Re: Mixed engines within same database
Posted by: Aftab Khan
Date: September 08, 2010 03:35AM

It is important to note pros/cons of taking backup using mysqldump or file system backup

1. If you stop slave, that is, sql_thread only, in this case IO thread will continue to get binary log updates from the master, suppose during backup operation your master database crash, you can quickly bring this slave up, as its IO thread was running during backup thus you won't lose lot of data.

2. If you stop mysqld to take snapshot of data directory and during this task you master database crashes then you are likely to lose more data.

So pls choose which one is more reliable

Options: ReplyQuote


Subject
Views
Written By
Posted
5900
July 29, 2010 11:36PM
2113
September 06, 2010 03:12PM
1848
September 06, 2010 09:56PM
1733
September 06, 2010 10:31PM
1631
September 06, 2010 11:51PM
1647
September 07, 2010 02:10AM
1639
September 07, 2010 10:38PM
Re: Mixed engines within same database
2261
September 08, 2010 03:35AM
1668
September 25, 2010 09:00AM


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.