MySQL Suitability for mission-critical data?
Posted on 2007-11-19
I've been using MySQL for years for small web based databases, never had any problems though demand is close to zero on them.
However recently the company I work for has the requirement to upgrade their database system. The data here really is mission-critical and we can't afford to loose any of it, and we need 24-7 uptime, with good performance (we have lots of clients so there'll be heavy load), any downtime will cost us.
What I'd like to hear is peoples own experiences with MySQL Enterprise, good or bad, and if it's up to the job.
Looking around the net I've seen lots of supposed expert DBAs saying that there's no argument; you should go with one of the "big 3", these being DB2, Oracle or MSSQL. However I get the feeling Oracle and DB2 would be a massive task to configure, and MSSQL - well it runs on Windows, we can't have any downtime no matter how good people say it is these days.
So my idea was; InnoDB on 3 servers - a master and 2 replication slaves, with one slave off-site down a 10Mb line (wide enough pipe?). We use the on-site slave to run our daily backups, and point our reporting web sites at it too. the off site is for worst-case scenario disaster recovery.
How much would we be better off spending more ÃƒÂƒÃ‚Â‚ÃƒÂ‚Ã‚Â£ on one of the "big 3"? Would our data be safer on these? Would we get better performance with these?
Is there a better model I could use for the MySQL setup?
I'm really reaching out here though guys, I'd love to hear experiences with different systems, views on the safety of our data, performance, and of course your pedigree ;-).