Configuration in database.php for "Transaction isolation level"

[duxthefux]

Hi,

we currently ran into the situation where we need to set the transaction isolation level for mysql.

We implemented it and thought maybe it makes sense to bring that into laravel core, as laravel currently lacks that possibility, whereas Doctrine provides that possibility.

We currently configure it in database.php

return [
    'connections' => [
          'default' => [
                ...
               'host' => env('DB_HOST'),
               ...
               'isolation_level' => env('DB_ISOLATION_LEVEL', 'REPEATABLE READ'),
              ....
            ]
      ]
];

I could prepare a pull request if it makes sense.

Best

[jorgcastellano]

I'm interested in know if it works, this

[mfn]

I'd say go for a PR; many of these options have been merged (e.g. new addition in \Illuminate\Database\Connectors\MySqlConnector::connect maybe).

[duxthefux]

@mfn created PR laravel/framework#33783

[duxthefux]

PR got merged

[mfn]

@duxthefux congratulations 😄