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);