Auto reconnect on Doctrine MySql has gone away exceptions on doctrine/dbal >=2.3, <3.0.
$ composer require adgoal/dbal-fault-toleranceIn order to use DBALFaultTolerance you have to set wrapperClass and driverClass connection params.
You can choose how many times Doctrine should be able to reconnect, setting x_reconnect_attempts driver option. Its value should be an int.
You can force ignore the transaction level using the parameters : force_ignore_transaction_level.
An example of configuration at connection instantiation time:
use Doctrine\DBAL\Configuration;
use Doctrine\DBAL\DriverManager;
$config = new Configuration();
//..
$connectionParams = array(
'dbname' => 'mydb',
'user' => 'user',
'password' => 'secret',
'host' => 'localhost',
// [dbal-fault-tolerance] settings
'wrapperClass' => Adgoal\DBALFaultTolerance\Connection::class,
'driverClass' => Adgoal\DBALFaultTolerance\Driver\PDOMySql\Driver::class,
'driverOptions' => [
'x_reconnect_attempts' => 3,
'force_ignore_transaction_level' => true
]
);
$conn = DriverManager::getConnection($connectionParams, $config);
//..An example of yaml configuration on Symfony 2 projects:
# Doctrine example Configuration
doctrine:
dbal:
default_connection: %connection_name%
connections:
%connection_name%:
host: %database_host%
port: %database_port%
dbname: %database_name%
user: %database_user%
password: %database_password%
charset: UTF8
wrapper_class: 'Adgoal\DBALFaultTolerance\Connection'
driver_class: 'Adgoal\DBALFaultTolerance\Driver\PDOMySql\Driver'
options:
x_reconnect_attempts: 3An example of configuration on Zend Framework 2/3 projects:
return [
'doctrine' => [
'connection' => [
'orm_default' => [
'driverClass' => \Adgoal\DBALFaultTolerance\Driver\PDOMySql\Driver::class,
'wrapperClass' => \Adgoal\DBALFaultTolerance\Connection::class,
'params' => [
'host' => 'localhost',
'port' => '3307',
'user' => '##user##',
'password' => '##password##',
'dbname' => '##database##',
'charset' => 'UTF8',
'driverOptions' => [
'x_reconnect_attempts' => 9,
'force_ignore_transaction_level' => true
]
],
],
],
],
];You can use wrapper class Adgoal\DBALFaultTolerance\Connections\MasterSlaveConnection if you are
using master / slave Doctrine configuration.
To force a reconnection try after a long running task you can call
$em->getConnection()->refresh();before performing any other operation different from SELECT.
Instead, in case your next query will be a SELECT, reconnection will be automagically done.
From v1.6 automagically reconnection is enabled also during $em->getConnection()->beginTransaction() calls,
and this works also during simple $em->flush(), if out of a previous transaction.
Thanks to Dieter Peeters and his proposal on DBAL-275. Check it out if you are using doctrine/dbal <2.3.