ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:loadbalancer:mysql_replication:creating_connections

This is an old revision of the document!


Creating A Connection Pool

Each of the connections in the connection pool are defined in the exact same way as a normal ADOdb connection, which makes it simple to add the functionality of existing code. This is shown below:

Existing ADOdb Connection Load Balance
Instantiate Load Balancer as $db
Instantiate ADOdb as $db Instantiate ADOdb as $db0, designating the connection as the primary (read-write) connection
Connect $db to database using normal connection parameters Connect $db0 to database using normal connection parameters
Add connection $db0 to connection pool $db
Instantiate ADOdb as $db1, designating the connection as a secondary (read-only) connection
Add Connection $db1 to connection pool $db
Repeat for available number of secondary servers
Execute commands against connection $db Execute commands against connection pool $db
v5/loadbalancer/mysql_replication/creating_connections.1476236787.txt.gz · Last modified: 2017/04/21 11:30 (external edit)