MySQL Forums
Forum List  »  Merge Storage Engine

Recommended backup for MyISAM
Posted by: Krzysztof Retel
Date: November 27, 2009 05:19AM

Hi All,

I was looking around the forum to find out which backup method MySQL Community recommends for the MyISAM DB.

We have two DBs (A and B), where one (A) is design to have heavy inserts where each insert fires a trigger to populate data across to some tables in other DB.
The second DB (B) has a heavy usage for CRUD operations.

Requirements:
1. Do not lock neither of these two DBs.
2. Minimise the impact of lossing data.
3. Perform backup every night.
4. Truncate the CRUD related DB (B) say every 7 or 31 days.

My thoughts are really to have a two instances of MySQL server on same machine. Do a replication from Master to Slave, when doing backup put down slave, do backup, restore Slave. However, I am not sure about truncating the slave and master DBs.

I would appreciated any responses recommendations.

Thanks,
Krzysztof

Options: ReplyQuote


Subject
Views
Written By
Posted
Recommended backup for MyISAM
9832
November 27, 2009 05:19AM


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.