MySQL beidzot ir izdzirdējuši lietotāju lūgumus un izveidojuši transakciju atbalstu. Tagad MySQL datubāzēs varēs veikt ACID-savietojamas transakcijas, izmantojot InnoDB engine.
Iespējas:

• Full transaction support, with commit, rollback and crash recovery
  capabilities to ensure full data consistency, even if hardware fails


• Advanced row-level locking without requiring lock escalation for maximum
  read/write concurrency without compromising lock integrity


• Multi-versioning to provide concurrency while maintaining maximum data
  integrity


• Non-locking reads, consistent with Oracle’s style, to enable fast reads
  even when the database is engaged in heavy updates

Sīkāk skatīt šeit