Galera cluster driver for Doctrine
Alows Doctrine to connect to Galera cluster (multiple “master” nodes). Initial connection will be made to node1,
but when query fails because of “cluster not ready” error, connection will be made to another node and query will
be executed again.
$em = EntityManager::create(
[
'url' => 'mysql://user:pass@node1/db_name',
'wrapperClass' => ClusterConnection::class,
'driverClass' => ClusterAwarePDOMysqlDriver::class
],
$config
);
$em->getConnection()->addNode('node2:3000');
$em->getConnection()->addNode('node3');
OR
$connection = ClusterConnection::createFromUrl('mysql://user:pass@node1,node2:3000,node3/db_name');
$em = EntityManager::create($connection, $config);
MIT