ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:loadbalancer:index

Differences

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

Link to this comparison view

Next revision		Previous revision
v5:loadbalancer:index [2016/05/30 14:48] – created mnewnhamv5: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.
Line 14: Line 15:
 ===== More Information ===== ===== More Information =====
    
-Reference Documentation+[[v5:loadbalancer:reference|Reference Documentation]]
  
 ===== Tutorials ===== ===== Tutorials =====
-Basic Implementation+<WRAP> 
 +<wrap left 180px>[[v5:loadbalancer:mysql_replication:introduction|Basic MySql Implementation]]</wrap> 
 +<wrap left 450px>Implementing ADOdb Load Balancer against a MySql 2 server replication system</wrap> 
 +</WRAP> 
 +-------------------------- 
v5/loadbalancer/index.1464612528.txt.gz · Last modified: (external edit)