[[v5:loadbalancer:reference:Index]]\\ ====== Load Balancer Reference Manual ====== ------------------------------------ ===== Classess ===== | [[v5:reference:loadbalancer:adodbloadbalancer|adodbLoadBalancer]] | The parent class for Load Balancer | | [[v5:reference:loadbalancer:adodbloadbalancerconnection|adodbLoadBalancerConnection]] | Associates an ADOdb connection with the Load Balancer | ===== Variables ===== | [[v5:reference:loadbalancer:enable_sticky_sessionsl|adodbLoadBalancer::$enable_sticky_sessions]] | Defines whether commands executed in the current session should be pinned to a specific connection | ===== Methods ===== | [[v5:reference:loadbalancer:setsessioninitsql|adodbLoadBalancer::setSessionInitSql]] | Defines an SQL statement that will always be initialized whenever a load balancer connection is established | | [[v5:reference:loadbalancer:addconnection|adodbLoadBalancer::addConnection()]] | Adds a new connection to the list of available servers | | [[v5:reference:loadbalancer:removeconnection|adodbLoadBalancer::removeConnection()]] | Removes a connection from the list of available servers | | [[v5:reference:loadbalancer:getloadbalancedconnection|adodbLoadBalancer::getLoadBalancedConnection]] | Returns the id of an appropriate connection for a requested type | | [[v5:reference:loadbalancer:getconnection|adodbLoadBalancer::getConnection]] | Returns the ADODB connection object by database type and ensures that it is connected and the session variables are executed | | [[v5:reference:loadbalancer:setsessionvariable|adodbLoadBalancer::setSessionVariable]] | Allow setting session variables that are maintained across connections | | [[v5:reference:loadbalancer:clusterexecute|adodbLoadBalancer::clusterExecute()]] | Executes the same SQL QUERY on the entire cluster of connections | | [[v5:reference:loadbalancer:isreadonlyquery|adodbLoadBalancer::isReadOnlyQuery()]] | Determines if a SQL query is read-only or not |