GitHub - aslijiasheng/php-cp: pdo and redis tcp connect proxy

php-cp(php-connect-pool),redis and pdo local connect proxy

[中文简介] http://blog.sina.com.cn/s/blog_9eaa0f400102v9fd.html

Provide local connection pool like java

Requirement

PHP 5.3 + (no zts)
linux 2.6+
pdo and redis extension install

Install

phpize=>./configure=>make install=>echo "extensions=xx/connect_pool.so">php.ini

##Technical characteristics:

After each time fetchAll (set/get) call release() method, release the connection to the pool, avoid that the script jammed causing connection occupy high problem.
The maximum and minimum number of connections configuration support.
Support small pressure automatic recovery connection.
Support graceful restart (reload).
Do a lot of optimization, although the request through the connection pool process forward, but no loss of QPS.
When the connection use out,support queue.
Simple! just change the new method and add release function (see demon),you used the tcp pool.
The connection proxy will start the ping process to monitor down list, if available will reflect to the return value of the get_disable_list(), use this function you can do some fun things,like LB.
support Read / write separate and slave load balancing

Example

step 1 move the pool.ini file to /etc/ and modify it as you need.

step 2 start the pool_server process：

```support "start" "stop" "restart"

step 3 modify you php script:

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 redisProxy(); $rs = $obj->connect("192.168.20.130"); $obj->select(5); $obj->set("test", '1111'); var_dump($obj->get("test")); $obj->release(); $obj1 = new pdoProxy('mysql:host=192.168.20.131;dbname=db1', "admin", "admin"); $rs = $obj1->query("show tables"); var_dump($rs->fetchAll()); $obj1->release(); /* * ****************异步 pdo和redis操作********************************************** * 依赖 swoole的event函数 */ include './asyncClass.php'; $obj = new asyncRedisProxy(); $obj->connect("127.0.0.1", "6379"); $obj->set("a", 11111, function($obj, $ret) { $obj->get("a", function($obj, $data) { var_dump($data); $obj->release(); //release to con pool }); }); $obj2 = new asyncPdoProxy('mysql:host=192.168.1.19;dbname=mz_db', "public_user", "1qa2ws3ed"); $obj2->query("select 1 from mz_user where user_id=299", function($obj, $stmt) { $arr = $stmt->fetchAll(); var_dump($arr); $obj->query("select 2 from mz_user where user_id=299", function($obj, $stmt) { $arr = $stmt->fetchAll(); var_dump($arr); $obj->release(); //release to con pool }); }); $obj3 = new asyncPdoProxy('mysql:host=192.168.1.19;dbname=mz_db', "public_user", "1qa2ws3ed"); $obj3->exec("insert into t1(name) values('111111')", function($obj, $data) { var_dump($data); $obj->release(); ////release to con pool }); $obj4 = new asyncPdoProxy('mysql:host=192.168.1.19;dbname=mz_db', "public_user", "1qa2ws3ed"); $stmt = $obj4->prepare("select * from mz_account where user_id=:user_id"); $stmt->bindParam(':user_id', "311"); $stmt->execute(function($stmt, $ret) { $data = $stmt->fetchAll(); var_dump($data); $stmt->release(); }); //*******************use master slave(最新版本支持了读写分离和从库的负载均衡用法如下)***********************/ $config = array( 'master' => array( 'data_source' => "mysql:host=192.168.1.19;dbname=db1", 'username' => "public_user", 'pwd' => "1qa2ws3ed", 'options' => array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_TIMEOUT => 3, PDO::ATTR_CASE => PDO::CASE_UPPER, ), ), 'slave' => array( "0" => array( 'data_source' => "mysql:host=192.168.1.20;dbname=db2", 'username' => "public_user", 'pwd' => "1qa2ws3ed", 'options' => array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_TIMEOUT => 3, PDO::ATTR_CASE => PDO::CASE_UPPER, ), ), "1" => array( 'data_source' => "mysql:host=192.168.1.21;dbname=db3", 'username' => "public_user", 'pwd' => "1qa2ws3ed", 'options' => array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_TIMEOUT => 3, PDO::ATTR_CASE => PDO::CASE_LOWER, ), ), ), ); /* * *************************"select"和"show"开头的语句走随机从库********** */ $obj1 = new pdoProxy($config); $rs = $obj1->query("select * from test limit 1"); var_dump($rs->fetchAll()); //走随机从库 $obj1->release(); /* * **************************读强行走主库*************************** */ $obj1->enable_slave = false; $rs = $obj1->query("select * from test limit 1"); var_dump($rs->fetchAll()); //读主库 $obj1->release(); /* * *************************除了"select"和"show"开头的语句都走主库********** */ $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 */ ``` ## 提示 - pool_server 必须以root用户启动 - redis不支持pub/sub方法 - 当你用完一个连接后（例如：fetchAll调用结束），请调用release来马上释放连接到池子里面(如果事务需要在事务commit或者rollback后release)，如果不想改业务代码可以在框架层每次fetch（或者get/set）用完之后调用release方法。 ## contact us - http://weibo.com/u/2661945152 - 83212019@qq.com - qq群号 538716391

Name		Name	Last commit message	Last commit date
Latest commit History 155 Commits
frame_example/yii1/db		frame_example/yii1/db
include		include
msgpack		msgpack
msgpack7		msgpack7
LICENSE		LICENSE
README.md		README.md
asyncClass.php		asyncClass.php
config.m4		config.m4
connect_pool.c		connect_pool.c
connect_pool_client.c		connect_pool_client.c
cpClientNet.c		cpClientNet.c
cpFunction.c		cpFunction.c
cpMemory.c		cpMemory.c
cpNetWork.c		cpNetWork.c
cpPingWorker.c		cpPingWorker.c
cpServer.c		cpServer.c
cpWorker.c		cpWorker.c
demon.php		demon.php
package.xml		package.xml
php_connect_pool.h		php_connect_pool.h
pool.ini		pool.ini
pool_server		pool_server

License

aslijiasheng/php-cp

Folders and files

Latest commit

History

Repository files navigation

php-cp(php-connect-pool),redis and pdo local connect proxy

Requirement

Install

Example

About

Resources

License

Stars

Watchers

Forks

Languages