It is a pity that the MySQL was claimed not to do transactions. MySQL has supported transactions, if you use InnoDB tables, for *many years*. Unlike most other databases MySQL also supports lighter weight table types that do not support transactions.
I have actual experience that demonstrates rolling back many updates of several tables works as advertised. If you are looking for things missing from MySQL then OLTP support is probably a good place to start looking.
I suspect that the OLTP support is MySQL is somewhere between nonexistent and minimal but my knowledge might be out of date.