Check MySQL isolation configuration

Before migrating a MySQL database for CDH Sentry to Cloudera Ranger, you must check and set isolation configuration to READ-COMMITTED.

Cloudera Ranger MySQL database must have isolation set to READ-COMMITTED.

You must check the isolation configuration of the MySQL database used for CDH Sentry before migrating to Ranger. IF the isolation configuration for CDH Sentry setting is REPEATABLE-READ, you must change the isolation setting to READ-COMMITTED.

Run the following query:

SELECT @@GLOBAL.tx_isolation, @@tx_isolation, @@session.tx_isolation;

If the query output is:

--------------------------------------------------------------------------
@@GLOBAL.tx_isolation | @@tx_isolation | @@session.tx_isolation
--------------------------------------------------------------------------
REPEATABLE-READ | REPEATABLE-READ | REPEATABLE-READ

Then, set the isolation to READ-COMMITTED,using the following query:

mysql> SET tx_isolation = 'READ-COMMITTED';
Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL tx_isolation = 'READ-COMMITTED';
Query OK, 0 rows affected (0.00 sec)