How to setup transaction-isolation under aurora db on aws

Question

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

Matt Vermeulen · Answer

Did you ever find a solution to this?

Karan Zaveri · Answer

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.

@tx_isolation;

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

@tx_isolation |

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

| REPEATABLE-READ       | REPEATABLE-READ |

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

1 row in set (0.00 sec)