Yii2 DB Auto Reconnect

Inspired by:

https://github.com/xjflyttp/yii2-db-reconnect

Installation

composer require mkubenka/yii2-db-reconnect

or

"require": {
    "mkubenka/yii2-db-reconnect": "~1.0"
},

Configuration

'db' => [
    'class' => 'mkubenka\dbreconnect\mysql\Connection',
    'reconnectMaxCount' => 2,
    'dsn' => 'mysql:host=127.0.0.1;dbname=test',
    'username' => 'root',
    'password' => '',
    'charset' => 'utf8',
],

Logging

'log' => [
    'targets' => [
        [
            'class' => 'yii\log\FileTarget',
            'levels' => ['error', 'info'],
            'maxLogFiles' => 20,
            'maxFileSize' => 2048,
            'categories' => [
                'mkubenka\dbreconnect\*',
            ],
            'logFile' => '@frontend/runtime/logs/dbreconnect.log',
        ],
    ],
],

Known limitations

This method only works for non transactional statements.