nalgoo/cluster-connection

Doctrine 的 Galera 集群驱动程序

1.5.3 2023-04-05 10:03 UTC

This package is auto-updated.

Last update: 2024-09-05 13:15:57 UTC


README

允许 Doctrine 连接到 Galera 集群(多个“主”节点)。初始连接将建立到节点1,但如果查询因“集群未就绪”错误失败,则会连接到另一个节点并重新执行查询。

用法

$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');

$connection = ClusterConnection::createFromUrl('mysql://user:pass@node1,node2:3000,node3/db_name');
$em = EntityManager::create($connection, $config);

待办事项

  • 管理节点优先级
  • 事务支持

许可协议

MIT