MySQL Forums
Forum List  »  Backup

Re: Advise required on backup plan
Posted by: Jim Buckley-Barrett
Date: November 22, 2012 09:51AM

Hi Scott,

Thank you for the reply, sorry for my slow reply being one of those weeks!

I'm just looking over Innodb v's MyISAM, I can't remember why I picked MyISAM over Innodb might be I thought Innodb was for bigger databases.

I do a lot of INSERTS, once data is inserted I do a SELECT for a partciular field that should have null value and then do some geocoding and once I get the result of the geocode I do an UPDATE.

Users on the web application mostly do SELECT statements, the odd INSERT OR UPDATE when adding a new asset to the system but that wouldn't be often.

I suppose with that in mind there is no reason why I should switch to Innodb and then set up replications and then do hot copying of the Innodb database for my back up.

Would you agree?

Jim

Options: ReplyQuote


Subject
Views
Written By
Posted
2132
November 20, 2012 04:46AM
1280
November 20, 2012 12:24PM
Re: Advise required on backup plan
1313
November 22, 2012 09:51AM
1184
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.