Database Abstraction Layer for PHP https://www.adodb.org/dokuwiki/ 2026-05-17T02:05:22+00:00 https://www.adodb.org/dokuwiki/ https://www.adodb.org/dokuwiki/lib/exe/fetch.php?media=logo.png text/html 2017-04-24T23:08:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:addconnection&rev=1493075311&do=diff addConnection Applies To ADOdb Load Balancer See Also ADOdbLoadBalancerConnection() Syntax bool addConnection( object $ADOdbConnection ) Description The method addConnection() adds an ADOdb connection, created by the instantiation of the ADOdbLoadBalancerConnection() class to the load balancer connection pool. Until the connection is added to the pool it cannot be used by the load balancer. text/html 2017-04-26T23:06:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:adodbloadbalancer&rev=1493247974&do=diff ADOdbLoadBalancer Applies To ADOdb Load Balancer See Also ADOdbLoadBalancerConnection Syntax class ADOdbLoadBalancer() Description The class ADOdbLoadBalancer is the parent class for the ADOdb Load Balancer plugin. Its primary function is to manage database connections that have been accumulated via instantiations of the text/html 2017-04-26T23:07:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:adodbloadbalancerconnection&rev=1493248075&do=diff ADOdbLoadBalancerConnection Applies To ADOdb Load Balancer See Also addConnection() Syntax class ADOdbLoadBalancerConnection( string $driverName, optional string $connectionType='write', optional int $connectionWeight=1, optional bool $persitantConnection=false, optional string $host, optional string $user, optional string $password, optional string $database text/html 2017-04-24T23:11:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:clusterexecute&rev=1493075476&do=diff clusterExecute Applies To ADOdb Load Balancer Syntax mixed clusterExecute( string $sql, optional bool $inputArray = false, optional bool $returnAllResults = false, optional bool $existingConnectionsOnly = true ) Description The method clusterExecute() is used to simultaneously execute an SQL statement across all nodes in the load balancing group. It is primarily used for setting Server parameters. text/html 2017-05-10T23:14:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:enable_sticky_sessionsl&rev=1494458048&do=diff $enable_sticky_sessions Applies To ADOdb Load Balancer See Also AddConnection() Syntax bool $enable_sticky_sessions=true Description The public class variable $enable_sticky_sessions pins the execution of commands to the last connection used. The default value for this is true text/html 2017-04-18T01:05:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:getadodbobject&rev=1492477503&do=diff getAdodbObject Applies To ADOdb Load Balancer See Also ADOdbLoadBalancerConnection() addConnection() Syntax obj getADOdbObject() Description The method getAdodbObject() retrieves a pointer to the ADOdb connection created by the instantiation of the ADOdbLoadBalancerConnection() class. Once retrieved, it must be added to the load balancer pool using text/html 2017-05-10T22:51:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:getconnection&rev=1494456663&do=diff getConnection Applies To ADOdb Load Balancer Syntax obj getConnection( optional string $connectionType = 'write', optional bool $pinConnection = null ) Description The method getConnection() gets a connection of the requested type (write/readonly) text/html 2017-05-10T22:34:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:getloadbalancedconnection&rev=1494455698&do=diff getLoadBalancedConnection Applies To ADOdb Load Balancer Syntax int getLoadBalancedConnection( string $connectionType = 'write|readonly' ) Description The method getLoadBalancedConnection() returns the appropriate node number for the connection type, taking into account the connection type, the connection weight, whether connections are pinned and if there are any failed connection in any of the nodes. text/html 2017-04-24T23:12:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:isreadonlyquery&rev=1493075528&do=diff isReadOnlyQuery Applies To ADOdb Load Balancer Syntax bool isReadOnlyQuery( string $sql ) Description The method isReadOnly() reads a provided SQL statement for elements that might cause a read-write process to be created. The method is used internally by the load balancer to determine if a statement needs to be executed on the primary server but can also be called manually. text/html 2017-04-24T23:09:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:removeconnection&rev=1493075360&do=diff removeConnection Applies To ADOdb Load Balancer See Also AddConnection() Syntax bool removeConnection( int $connectionNumber ) Description The method removeConnection() permanently removes a connection from the Load Balancer connection pool. Connection numbers are currently determined by the order in which a connection is added to the connection pool. If the connection is successfully removed (the integer value provided refers to a valid connection), the return value is text/html 2017-04-24T23:07:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:setsessioninitsql&rev=1493075265&do=diff setSessionInitSql Applies To ADOdb Load Balancer Syntax void setSessionInitSql( string $sql ) Description The method setSessionInitSql() adds to the list of SQL statements that are executed as soon as an ADOdb database connection is established and added to the connection pool. There is no limit to the number of statements that can be added to the list. The method must be called after the load balancer object is instantiated but before the ADOdb object is added to the pool. … text/html 2017-04-24T23:10:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:loadbalancer:setsessionvariable&rev=1493075426&do=diff setSessionVariable Applies To ADOdb Load Balancer Syntax bool setSessionVariable( string $key, string $variable, optional bool $immediateExecution=false ) Description The method setSessionVariable() queues up a key/value pair to be executed using the database specific