small / doctrine-dbal-swoole-pdo-driver
Requires
- php: >=8.3
- ext-pdo: *
- doctrine/dbal: 4.0.*
- small/swoole-patterns: >=22.2.0
This package is not auto-updated.
Last update: 2024-11-13 07:17:28 UTC
README
OpenSwoole and Doctrine
Connection issue
The doctrinal issue is that coroutines use the same connection.
On a service with many connections, users end up waiting for SQL queries to finish one after the other.
Solutions
1) Create a connection for each request
This solution has been adopted in the package diego-ninja/swoole-mysql-doctrine-driver : diego-ninja/swoole-mysql-doctrine-driver
Two issues arise:
- We are in a long-time process, and connections consume RAM.
- Under heavy load, database server may block due to a large number of open connections.
2) Use a connection pool
The connection pool is a class replacing native driver that store and reuse connections. You can define the max number of concurent connections, determined by the size of your database server.
The process is simple :
For example : we use a pool of 10 connections.
If there is a free connection, we get the connection. Send the connection and release the connection.
If there is no free connections, we sleep a short time and retry.
small/swoole-pdo-doctrine-driver
This package use small/swoole-patterns abstract pool's class.
Here is an example to configure it with symfony :
doctrine:
dbal:
driver: Small\SwooleDbalPdo
url: '%env(resolve:DATABASE_URL)%'
The source code is available on https://git.small-project.dev/lib/small-swoole-doctine-dbal-pdo
The composer package is available on https://packagist.org/packages/small/small-swoole-doctine-dbal-pdo