Are we seriously still talking about MyISAM? When I first worked with MySQL ten years ago everyone knew that the first thing you did was switch to InnoDB. It’s been the default since 2009.
Yes there are a lot of poor defaults and a lot of gotchas. But none of them is a showstopper, and all of them are predictable: once you learn about one you don’t fall for it again. MySQL has a) a much better ecosystem around it than any alternative: everything supports it, everything integrates with it, and b) a combination of functionality that nothing else matches. There is nothing else free that combines even basic foreign-key/transaction support with a mature replication solution with master-master operation (PostgreSQL comes close but its replication is still immature). I don’t like MySQL by any means, but for many use cases it’s the only option, and honestly it is “good enough”.
Article includes link to very funny PHP takedown. I thought I’d grown tired of that genre, but…its a good one.
Are we seriously still talking about MyISAM? When I first worked with MySQL ten years ago everyone knew that the first thing you did was switch to InnoDB. It’s been the default since 2009.
Yes there are a lot of poor defaults and a lot of gotchas. But none of them is a showstopper, and all of them are predictable: once you learn about one you don’t fall for it again. MySQL has a) a much better ecosystem around it than any alternative: everything supports it, everything integrates with it, and b) a combination of functionality that nothing else matches. There is nothing else free that combines even basic foreign-key/transaction support with a mature replication solution with master-master operation (PostgreSQL comes close but its replication is still immature). I don’t like MySQL by any means, but for many use cases it’s the only option, and honestly it is “good enough”.
I’m not sure why I had to remember 2003, otherwise a good write-up.
Would be nice if the author suggested alternatives, other than just saying: “Other databases are good now, not eventually.”