Differences

This shows you the differences between two versions of the page.

--- v5:reference:loadbalancer:clusterexecute [2017/04/20 00:33] – [$returnAllResults] mnewnham
+++ v5:reference:loadbalancer:clusterexecute [2017/04/25 01:11] (current) – mnewnham
@@ Line 3: / Line 3: @@
 <WRAP right box>
 == Applies To ==
-ADOdb Load Balancer
+[[v5:loadbalancer:index|ADOdb Load Balancer]]
 == Syntax ==
   mixed clusterExecute(
@@ Line 23: / Line 23: @@
 * Connection pool with 3 MySQL servers
 */
-$a = $db->clusterExecute('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE',false,false,false);
+$a = $db->clusterExecute('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE',
+                         false,
+                         false,
+                         false);
 print_r($a);
 /*
@@ Line 62: / Line 65: @@
 */
-$a = $db->clusterExecute('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE',false,true,false);
+$a = $db->clusterExecute('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE',
+                         false,
+                         true,
+                         false);
 print_r($a);
 /*
@@ Line 78: / Line 84: @@
 </code>
 ===== $existingConnectionsOnly ====
-===== Usage ====
+If the ''existingConnectionsOnly'' flag is set to true, the command passed to clusterExecute will only be executed against connections that are already in use, otherwise, the clusterExecute command will establish a connection to the database and then execute the command.
-<code php>
-/*
-* connection to load balancer assumed
-*/
-$SQL = "SET SESSION TIME ZONE";
-$success = $db->clusterExecute($SQL);
-</code>