facile-it/doctrine-mysql-come-back

Auto reconnect on Doctrine MySql has gone away exceptions on doctrine/dbal

Friday, April 20, 2018
by peelandsee
Repository
40 Watchers
96 Stars
291,283 Installations

PHP
3 Dependents
0 Suggesters
24 Forks
3 Open issues
16 Versions
13 % Grown

The README.md

, _(*1)

, _(*2)

DoctrineMySQLComeBack

This library tries to solve the infamous "MySQL has gone away" issue, and similar ones., _(*3)

It does so by providing a doctrine/dbal driver wrapper that automatically reconnects to the database server when applicable; to avoid consistency issues, the reconnection is not attempted when writes are concerned (i.e. open transaction, timeout on write queries)., _(*4)

Installation

If you're using DBAL 3.6+, _(*5)

$ composer require facile-it/doctrine-mysql-come-back ^2.0

If you're using DBAL ^2.3, _(*6)

$ composer require facile-it/doctrine-mysql-come-back ^1.0

Configuration

In order to use DoctrineMySQLComeBack you have to set the wrapperClass connection parameter. You can choose how many times Doctrine should be able to reconnect, setting x_reconnect_attempts driver option. Its value must be an int., _(*7)

If you're using DBAL v2, you also need to set the driverClass parameter too; please refer to the previous version of this readme for that., _(*8)

An example of configuration at connection instantiation time:, _(*9)

use Doctrine\DBAL\Configuration;
use Doctrine\DBAL\DriverManager;

$config = new Configuration();

//..

$connectionParams = [
    'dbname' => 'mydb',
    'user' => 'user',
    'password' => 'secret',
    'host' => 'localhost',
    // [doctrine-mysql-come-back] settings
    'wrapperClass' => 'Facile\DoctrineMySQLComeBack\Doctrine\DBAL\Connection',
    'driverOptions' => [
        'x_reconnect_attempts' => 3
    ],
];

$conn = DriverManager::getConnection($connectionParams, $config);

//..

An example of yaml configuration on Symfony projects:, _(*10)

doctrine:
    dbal:
        connections:
            default:
                # DATABASE_URL would be of "mysql://db_user:db_password@127.0.0.1:3306/db_name" 
                url: '%env(resolve:DATABASE_URL)%'
                wrapper_class: 'Facile\DoctrineMySQLComeBack\Doctrine\DBAL\Connection'
                options:
                    x_reconnect_attempts: 3

An example of configuration on Laminas Framework 2projects:, _(*11)

return [
    'doctrine' => [
        'connection' => [
            'orm_default' => [
                'wrapperClass' => \Facile\DoctrineMySQLComeBack\Doctrine\DBAL\Connection::class,
                'params' => [
                    'host' => 'localhost',
                    'port' => '3307',
                    'user' => '##user##',
                    'password' => '##password##',
                    'dbname' => '##database##',
                    'charset' => 'UTF8',
                    'driverOptions' => [
                        'x_reconnect_attempts' => 9,
                    ]
                ],
            ],
        ],
    ],
];

You can use wrapper class Facile\DoctrineMySQLComeBack\Doctrine\DBAL\Connections\PrimaryReadReplicaConnection if you are using a primary/replica Doctrine configuration:, _(*12)

use Doctrine\DBAL\Configuration;
use Doctrine\DBAL\DriverManager;

$config = new Configuration();

//..

$connectionParams = [
    'wrapperClass' => 'Facile\DoctrineMySQLComeBack\Doctrine\DBAL\PrimaryReadReplicaConnection',
    'primary' => [
        // ...
        'driverOptions' => [
            'x_reconnect_attempts' => 3
        ],
    ],   
];

$conn = DriverManager::getConnection($connectionParams, $config);

//..

Usage

Since DBAL v3, Connection::refresh does not exist anymore, so you don't need to do anything else to leverage the reconnection, it will be automagically done., _(*13)

From v1.6 of this library automagically reconnection is enabled also during $em->getConnection()->beginTransaction() calls, and this works also during simple $em->flush(), if out of a previous transaction., _(*14)

Thanks

Thanks to Dieter Peeters and his proposal on DBAL-275. Check it out if you are using doctrine/dbal <2.3., _(*15)

The Versions

20/04 2018

dev-master

9999999-dev

Auto reconnect on Doctrine MySql has gone away exceptions on doctrine/dbal

library doctrine-mysql-come-back

Auto reconnect on Doctrine MySql has gone away exceptions on doctrine/dbal

facile-it/doctrine-mysql-come-back

The README.md

DoctrineMySQLComeBack

Installation

Configuration

Usage

Thanks

The Versions

dev-master

The Requires

The Development Requires

by luca bo

v1.6.5

The Requires

The Development Requires

by luca bo

v1.6.4

The Requires

The Development Requires

by luca bo

dev-dbal_2.6_compat

The Requires

The Development Requires

by luca bo

dev-drop_older_deps

The Requires

The Development Requires

by luca bo

v1.6.3

The Requires

The Development Requires

by luca bo

v1.6.2

The Requires

by luca bo

v1.6.1

The Requires

by luca bo

v1.6

The Requires

by luca bo

v1.5.3

The Requires

by luca bo

v1.5.1

The Requires

by luca bo

v1.5.2

The Requires

by luca bo

v1.5

The Requires

by luca bo

v1.4

The Requires

by luca bo

v1.3

The Requires

by luca bo

v1.2

The Requires

by luca bo