v5:reference:loadbalancer:getconnection
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
v5:reference:loadbalancer:getconnection [2017/04/28 00:37] – created mnewnham | v5:reference:loadbalancer:getconnection [2017/05/11 00:51] (current) – [Usage] mnewnham | ||
---|---|---|---|
Line 16: | Line 16: | ||
The method '' | The method '' | ||
- | The returned object is an [[v5: | + | The returned object is an [[v5: |
--------------------------- | --------------------------- | ||
+ | <WRAP tip> | ||
+ | To ensure the accuracy of the response, you should have already executed at least one statement against the load balancer connection, or used a method such as **clusterExecute** | ||
+ | </ | ||
===== Usage ===== | ===== Usage ===== | ||
+ | If the system could not determine whether the command to be executed is read-only or not, for example in a stored procedure, then this method can be used to retrieve a connection of the appropriate type. | ||
<code php> | <code php> | ||
+ | $db = new ADOdbLoadBalancer; | ||
+ | |||
+ | $driver = ' | ||
+ | $database = ' | ||
+ | $user = ' | ||
+ | $password = ' | ||
+ | $host = ' | ||
+ | $db0 = new ADOdbLoadBalancerConnection( $driver, | ||
+ | ' | ||
+ | 10, | ||
+ | false, | ||
+ | $host, | ||
+ | $user, | ||
+ | $password, | ||
+ | $database ); | ||
+ | /* | ||
+ | * Add the connection to the pool | ||
+ | */ | ||
+ | $db-> | ||
+ | $db1 = new ADOdbLoadBalancerConnection( $driver, | ||
+ | ' | ||
+ | 10, | ||
+ | false, | ||
+ | $host, | ||
+ | $user, | ||
+ | $password, | ||
+ | $database ); | ||
+ | /* | ||
+ | * Add the connection to the pool | ||
+ | */ | ||
+ | $db-> | ||
+ | |||
+ | /* | ||
+ | * Execute something to ensure connection accuracy | ||
+ | */ | ||
+ | $db-> | ||
+ | |||
+ | /* | ||
+ | * Find a readwrite connection, pin it for the next statement | ||
+ | */ | ||
+ | $db-> | ||
+ | |||
+ | /* | ||
+ | * Now construct a stored procedure and execute it against $db, | ||
+ | * because it is pinned, it will execute against the ' | ||
+ | */ | ||
+ | $stmt = $db-> | ||
+ | $val1 = ' | ||
+ | $par1 = ' | ||
+ | $db-> | ||
+ | $db-> | ||
</ | </ | ||
v5/reference/loadbalancer/getconnection.1493332650.txt.gz · Last modified: 2017/04/28 00:37 by mnewnham