ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:loadbalancer:mysql_replication:automatic_control

This is an old revision of the document!


Automatic Control Of Statement Execution

The load balancer automatically controls the execution of SQL statements through ADOdb by parsing the statement and directing the execution to the appropriate server:

  1. Statements that require read-write access to the database are directed to the primary server.
  2. Statements that require read-only access to the database are directed to the next available second

In this way, expensive or long running queries that might impact the performance of the primary server are offloaded to a secondary device.

v5/loadbalancer/mysql_replication/automatic_control.1492768208.txt.gz · Last modified: 2017/04/28 02:18 (external edit)