RE: Looking for a job...
Posted in 2006
Topics: Installation, Setup & Upgrades
> Playing devil's advocate, with MySQL all is free, BUT... I had a very > serious hardware crash (disk dead) on an IDS installation and I recovered > Informix from memory, no data loss. I have a power lost problem with MySQL, > innodb was dead and we had to recover from tapes, 24h of data lost. There isn't much point in making statements like this to MySQL people. They will smile smugly and point out how their favorite database occasionally really whacking things out of the park isn't a bug - it is a feature. You just don't understand yet.
Adam Tauno Williams wrote: >> Playing devil's advocate, with MySQL all is free, BUT... I had a very >> serious hardware crash (disk dead) on an IDS installation and I recovered >> Informix from memory, no data loss. I have a power lost problem with MySQL, >> innodb was dead and we had to recover from tapes, 24h of data lost. > > There isn't much point in making statements like this to MySQL people. > They will smile smugly and point out how their favorite database > occasionally really whacking things out of the park isn't a bug - it is > a feature. You just don't understand yet. > According to what he wrote it appears to be a problem caused by a power loss. But he was able to recover from a backup tape, so I don't see how this was MySQL's problem other than for the admin to recover from tape. InnoDB is not a very good product in my not so humble opinion, but it _is_ usable and does provide functional transactions. It will never be IDS or Oracle, and I have never seen it touted as such. Anyway...apparently you have worked with or had experience with some MySQL people that you didn't like, and that's unfortunate. Most of the MySQL people I've worked with have experience with several different database products, including MS-SQL-Server and they understand the limitations of MySQL. Certainly MySQL is not appropriate for everything but it _is_ appropriate for a lot of situations. Use what works for what you're trying to do.