MySQL Forums
Forum List  »  Backup

Advise required on backup plan
Posted by: Jim Buckley-Barrett
Date: November 20, 2012 04:46AM

Hi,

Currently our database is 9GB and growing around 1GB a month. All the tables are MyISAM and our largest two tables have over 16 million records. We do a lot of INSERTS and UPDATES and very few deletes.

We’re currently using MySQLDump to create a midnight backup of the database but we are having issues with that recently which is causing our application to slow down considerably during the back up.

What I would like to do is create a full daily back up with differential backups as well as weekly and monthly backups - your normal backup schema, 6 days, 5 weeks, 12 months.

I've been considering replication but I don’t know for sure if I really need that.

So I’m looking for advice on what backup software to use?

Should I look at replication?

Should I be saving my backups to a separate drive to help with READ/WRITES?

Should the database be on its own drive for READ/WRITES?

Thanks,
Jim

Options: ReplyQuote


Subject
Views
Written By
Posted
Advise required on backup plan
2185
November 20, 2012 04:46AM
1310
November 20, 2012 12:24PM
1208
November 25, 2012 03:17PM


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.