Check MySQL isolation configuration

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

CDP 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.

  1. Log in to MySQL server.
  2. Run the following query:
    SELECT @@GLOBAL.tx_isolation, @@tx_isolation, @@session.tx_isolation;
    1. If the query output is:
      @@GLOBAL.tx_isolation | @@tx_isolation | @@session.tx_isolation
    2. 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)