The Ultimate Guide to High Availability with MariaDB

Comments - SET TRANSACTION

6 years ago Patrick Dung
Re: SET TRANSACTION

READ COMMITTED As of MariaDB/MySQL 5.1, if you use READ COMMITTED or enable innodb_locks_unsafe_for_binlog, you must use row-based binary logging.

REPEATABLE READ This is the only transaction level that can be used with the row based binary logging.

So row based binary logging support REPEATABLE READ only or does it support both REPEATABLE READ and READ COMMITTED?

 
6 years ago Ian Gilfillan
Re: SET TRANSACTION

The limitation mentioned in REPEATABLE READ has been removed.

 
6 years ago Patrick Dung
Re: SET TRANSACTION

Thanks for the clarification.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.