PHP pdo_connect_poolの例

コード例 #1

ファイル: demon.php プロジェクト: ly95/php-cp

$rs = $obj->query("show tables");
var_dump($rs->fetchAll());
//*****************use pool（使用了连接池）*********************************/
$obj = new redis_connect_pool();
$rs = $obj->connect("192.168.20.130");
$obj->select(5);
$obj->set("test", '1111');
var_dump($obj->get("test"));
$obj->release();
$obj1 = new pdo_connect_pool('mysql:host=192.168.20.131;dbname=db1', "admin", "admin");
$rs = $obj1->query("show tables");
var_dump($rs->fetchAll());
$obj1->release();
//*******************use master slave(最新版本支持了读写分离和从库的负载均衡 用法如下)***********************/
$config = array('master' => array('data_source' => "mysql:host=192.168.1.19;dbname=db1", 'username' => "public_user", 'pwd' => "1qa2ws3ed"), 'slave' => array("0" => array('data_source' => "mysql:host=192.168.1.18;dbname=db1", 'username' => "public_user", 'pwd' => "1qa2ws3ed"), "1" => array('data_source' => "mysql:host=192.168.1.17;dbname=db1", 'username' => "public_user", 'pwd' => "1qa2ws3ed")));
$obj1 = new pdo_connect_pool($config);
$rs = $obj1->query("select * from test limit 1");
var_dump($rs->fetchAll());
//走随机从库
$obj1->release();
$sql = "insert into `test` (tid) values (5)";
$rs = $obj1->exec($sql);
//走主库
$obj1->release();
/* tips：
 * 1、The relase() method will release the connections to the pool that the process holds.
 * 2、after rshutdown/mshutdown will trigger the release() function.
 */
/* 说明：
 * 1、relase方法：通知中间件,可以将这个进程持有的链接放回连接池
 * 2、请求结束（rshutdown/mshutdown阶段）会调用自动调用release

コード例 #2

ファイル: demon.php プロジェクト: jeftom/php-cp

<?php

//don't use pool
$obj = new Redis();
$rs = $obj->connect("192.168.20.130");
$obj->select(5);
$obj->set("test", '1111');
var_dump($obj->get("test"));
$obj = new PDO('mysql:host=192.168.20.130;dbname=test1', "admin", "admin");
$rs = $obj->query("show tables");
var_dump($rs->fetchAll());
//use pool
$obj = new redis_connect_pool();
$rs = $obj->connect("192.168.20.130");
$obj->select(5);
$obj->set("test", '1111');
var_dump($obj->get("test"));
$obj->release();
$obj1 = new pdo_connect_pool('mysql:host=192.168.20.131;dbname=db1', "admin", "admin");
$rs = $obj1->query("show tables");
var_dump($rs->fetchAll());
$obj1->release();
/* tips：
 * 1、The relase() method will release the connections to the pool that the process holds.
 * 2、after rshutdown/mshutdown will trigger the release() function.
 */
/* 说明：
 * 1、relase方法：通知中间件,可以将这个进程持有的链接放回连接池
 * 2、请求结束（rshutdown/mshutdown阶段）会调用自动调用release
 */