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.

Usage

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