Recommended backup for MyISAM

[Krzysztof Retel]

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