I'm still not sure why people ever used mysql for anything more than a simple datastore with sql interface.

Since time eternal (the 90's) mysql has been the fastest way on the net to lose your data. (I still remember the many data corruption bugs). Use postgres or if you have the need/money a DB like DB2.