Today, we will delve into the two logging mechanisms in MySQL: Redo Log and Binlog ... transaction consistency is an important goal, and the two-phase commit (2PC) is a common method to achieve this ...

The following mostly applies only for ISAM, MyISAM, and HEAP tables. If you only use transaction-safe tables (BDB tables) in an a update, you can do COMMIT and ROLLBACK also with MySQL. The problem ...