This is an old revision of the document!

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.

Parameters

The first two parameters follow the rules as specified in the ADOdb execute() command.

$returnAllResults

The default behavior of the command is to return the result of the execution of the command from first connected server in the pool. If the parameter is set to true, then the results of all executions are collected into an array and returned as a numeric array, ordered by connection.

$existingConnectionsOnly

Usage

/*
* connection to load balancer assumed
*/
 
$SQL = "SET SESSION TIME ZONE";
 
$success = $db->clusterExecute($SQL);