But on MyISAM transactions and rollbacks are not supported

They are also quite old and can be unstable. I never did find out why but I had some intermittent data loss from MyISAM so I am now using Aria tables instead, or InnoDB if I really need to enforce referrential integrity (which is rare).

The only downside I have found with the Aria storage engine is that MySQL Workbench doesn't recognise them so can't generate forward engineered code. But that has the positive of improving my DDL familiarity which had got very rusty!