View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 11:33 AM
John Sheppard
 
Posts: n/a
Default Steps to take for MySQL to gaurantee non failure or loss of data

Hello,

I am evaluating mySQL as an alternative to SQL Server...Other guy wants to
go SQL Server, I kinda like mySQL...

What steps can be taken for mySQL so that I can be guaranteed to be ;
a) ideally corruption free
b) 100% safe if corruption does occur

Can anyone recommend any transaction logging tools, hot backup tools. Should
I be worried about mySQL's atomicity? Im still fairly new to databases...I
come from msaccess background...

I have read a fair bit on it but most information I find is dated pre 2004,
I see less people bagging out mySQL after that date....but still a few
things concern me...things i cant articulate at this moment

Thank you
John Sheppard

Reply With Quote