Oh MySQL I hate you

Don't use MySQL, then.<p>I don't want to sound flippant, but really- the wealth of database choices out there is astounding. And it's already largely known that Postgres is a better database than MySQL in most use cases. So go use it.

Switch to MongoDB and you'll start loving MySQL.