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

Usage

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