ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:loadbalancer:index

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
v5:loadbalancer:index [2016/05/30 14:53]
mnewnham
v5:loadbalancer:index [2017/04/17 02:21] (current)
mnewnham
Line 1: Line 1:
 ====== ADOdb Load Balancer ====== ====== ADOdb Load Balancer ======
 +**This feature is available from ADOdb version 5.21 onwards**
 ===== Introduction ===== ===== Introduction =====
-**//ADOdb Load Balancer//** is a standalone code library that can be integrated into an existing ADOdb code base, and provides the ability to automatically, or manually, force read/write and read-only code segments to run on specific servers. In it's default configuration:+**//ADOdb Load Balancer//** is a standalone code library that can be integrated into an existing ADOdb code base, and provides the ability to automatically, or manually, force read/write and read-only code segments to run on specific servers. It is currently only available for **MySQL** or **Postgres** database systems. In it's default configuration:
  
   * A Primary server is designated to run all read-write code within a transaction   * A Primary server is designated to run all read-write code within a transaction
   * A Secondary server is designated to run all other read requests    * A Secondary server is designated to run all other read requests 
  
-This allows a simple replication system, for example the [[|MySQL replication service]], to emulate a cluster configuration, and enhance the performance of the main server by delegating resource-intensive intensive queries to a secondary server.+This allows a simple replication system, for example the [[|MySQL replication service]], to emulate a cluster configuration, and enhance the performance of the main server by delegating resource-intensive queries to a secondary server. Note that the feature does not delegate the execution of the PHP code, only the execution of the SQL statement on the server.
  
 More complex configurations can be made, including features such as manual assignation of target servers as well as  transactional assignation of servers and multiple primaries with a randomized connection pool when used in a cluster configuration. More complex configurations can be made, including features such as manual assignation of target servers as well as  transactional assignation of servers and multiple primaries with a randomized connection pool when used in a cluster configuration.
v5/loadbalancer/index.1464612804.txt.gz ยท Last modified: 2017/04/21 11:29 (external edit)