How to setup transaction-isolation under aurora db on aws

[Karan Zaveri]

We are trying to setup confluence over to an AWS instance, and using aurora as db backend.

When we run the installation of confluence, it complains about the value of transaction-isolation. 

Incorrect isolation level

Your database must use 'READ-COMMITTED' as the default isolation level. Learn more

The link specifies changes in mysql config or in confluence config both of which cannot be implemented due to following reasons - we don't have access to modify aurora config file, and the confluence config file doesn't have the entries as mentioned in the link.

How can we setup the value in aurora ?

Thanks

[Karan Zaveri]

I created an options group, and added single entry for the tx_isolation in it, and then modified the aurora instance and assigned the group to it.

However still the READ-COMMITED is not implemented.

MySQL [(none)]> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;

+-----------------------+-----------------+

| @@GLOBAL.tx_isolation | @@tx_isolation  |

+-----------------------+-----------------+

| REPEATABLE-READ       | REPEATABLE-READ |

+-----------------------+-----------------+

1 row in set (0.00 sec)

[Matt Vermeulen]

Did you ever find a solution to this?