Considering MySQL? Use something else. Already on MySQL? Migrate. For every successful project built on MySQL, you could uncover a history of time wasted mitigating MySQL's inadequacies, masked by a hard-won, but meaningless, sense of accomplishment over the effort spent making MySQL behave. -- http://grimoire.ca/mysql/choose-something-else
MySQL is the PHP of databases. Available everywhere, tons of tools and people that work well with it, but ultimately it's broken by design.
- Bad and dangerous defaults
- Silent conversion of inputs to fit the schema
- Silent truncation of data on schema change
- UTF8 as 3 bytes by default WUT
- Owned by Oracle 🧌