ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:loadbalancer:adodbloadbalancerconnection

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
v5:reference:loadbalancer:adodbloadbalancerconnection [2017/04/18 03:06] – mnewnhamv5:reference:loadbalancer:adodbloadbalancerconnection [2017/04/25 03:14] – mnewnham
Line 3: Line 3:
 <WRAP right box> <WRAP right box>
 == Applies To == == Applies To ==
-ADOdb Load Balancer+[[v5:loadbalancer:index|ADOdb Load Balancer]]
 == See Also == == See Also ==
-[[v5:reference:loadbalancer:getadodbobject|getADODbObject()]]\\ 
 [[v5:reference:loadbalancer:addconnection|addConnection()]] [[v5:reference:loadbalancer:addconnection|addConnection()]]
 == Syntax == == Syntax ==
Line 20: Line 19:
 </WRAP> </WRAP>
 ===== Description ===== ===== Description =====
-The class ''ADOdbLoadBalancerConnection'' is the replacement for [[v5:reference:connection:adonewconnection|adoNewConnecton()]] and instantiates an ADOdb connection that can be retrieved and added to the connection pool. +The class ''ADOdbLoadBalancerConnection'' is the replacement for [[v5:reference:connection:adonewconnection|adoNewConnecton()]] and creates a template ADOdb connection that can be retrieved and added to the connection pool. 
 + 
 +Note that a connection is not established when the class is instantiated, it is delayed until an ADOdb command such as //**execute**// is issued, or a Load Balancer internal command such as [[v5:reference:loadbalancer:clusterexecute|clusterExecute()]] is issued. This means that a connection number is consumed even if the connection parameters are invalid. Care should be taken when using commands such as [[v5:reference:loadbalancer:removeconnection|removeConnection()]] that rely on a connection number. 
 ------------------------ ------------------------
 ===== Parameters ===== ===== Parameters =====
 ==== $driverName ==== ==== $driverName ====
-The name of the ADOdb driver to be used to  establish the connection. Currently only the drivers [[v5:drivers:mysql|mysqli]] and [[v5:drivers:postgres|postgres9]] can be used.+The name of the ADOdb driver to be used to  establish the connection. Currently only the drivers [[v5:database:mysql|mysqli]] and [[v5:database:postgresql|postgres9]] can be used.
 ==== $connectionType ==== ==== $connectionType ====
-A connection may be of the type ''write'', which designates the primary server through which all update operations are passed, and ''readonly'' , which signifies a secondary server through which all read-only operations are passed. Only one ''write'' connection can be designated, but there is no limit to the number of ''readonly'' connections.+A connection may be of the type ''write'', which designates the primary server through which all update operations are passed, and ''readonly'' , which signifies a secondary server through which some or all of the read-only operations are passed. Only one ''write'' connection can be designated, but there is no limit to the number of ''readonly'' connections.
 ==== $connectionWeight ==== ==== $connectionWeight ====
 For ''readonly'' connections, specifying a weight for the connection will influence how many queries are routed through a specific server. The higher the weight, the more often the server is used. If all ''readonly'' servers are defined with the same weight, then a connection randomiser effect is obtained. For ''readonly'' connections, specifying a weight for the connection will influence how many queries are routed through a specific server. The higher the weight, the more often the server is used. If all ''readonly'' servers are defined with the same weight, then a connection randomiser effect is obtained.
  
 ==== $persistantConnection ==== ==== $persistantConnection ====
 +This parameter forces the ADOdb connection to be made with a [[v5:reference:connection:pconnect|persistant]] connection.
 ==== Other Parameters ==== ==== Other Parameters ====
 The other parameters are defind the same as the equivalent connection parameters in ADOdb . The other parameters are defind the same as the equivalent connection parameters in ADOdb .
Line 37: Line 39:
 ===== Usage ==== ===== Usage ====
 <code php> <code php>
-$driver = 'mysqli'; 
-$db = new ADOdbLoadBalancer( $driver ); 
  
 +$db = new ADOdbLoadBalancer;
 +
 +$driver = 'mysqli';
 $database = 'employees'; $database = 'employees';
 $user     = 'adodb'; $user     = 'adodb';
Line 53: Line 56:
   $password,    $password, 
   $database );   $database );
-$db0->getADODbObject();+
 $db->addConnection( $db0 ); $db->addConnection( $db0 );
  
Line 66: Line 69:
   $password,    $password, 
   $database );   $database );
-$db1->getADODbObject();+
 $db->addConnection( $db1 ); $db->addConnection( $db1 );
  
Line 79: Line 82:
   $password,    $password, 
   $database );   $database );
-$db2->getADODbObject(); 
 $db->addConnection( $db2 ); $db->addConnection( $db2 );
  
 </code> </code>
  
v5/reference/loadbalancer/adodbloadbalancerconnection.txt · Last modified: 2017/04/27 01:07 by mnewnham