1.安装mysqlnd_ms插件
pecl install mysqlnd_ms
2.配置
编辑:vim /opt/service/php/lib/php.ini
增加下面配置项
[mysqlnd_ms]
extension=mysqlnd_ms.so
mysqlnd_ms.enable=1
mysqlnd_ms.config_file=/opt/service/php/lib/mysqlnd_ms_plugin.ini
extension=mysqlnd_ms.so
mysqlnd_ms.enable=1
mysqlnd_ms.config_file=/opt/service/php/lib/mysqlnd_ms_plugin.ini
编辑:vim /opt/service/php/lib/mysqlnd_ms_plugin.ini
增加下面配置
{
"myapp": {
"master": {
"master_0": {
"host": "master",
"port": "3306"
}
},
"slave": {
"slave_0": {
"host": "slave",
"port": "3306"
}
},
"trx_stickiness": "master",
"server_charset" : "utf8"
}
}
"myapp": {
"master": {
"master_0": {
"host": "master",
"port": "3306"
}
},
"slave": {
"slave_0": {
"host": "slave",
"port": "3306"
}
},
"trx_stickiness": "master",
"server_charset" : "utf8"
}
}
3.重启php-fpm
4.更多请查看http://php.net/manual/zh/book.mysqlnd-ms.php
转载请注明:小Y » php读写分离负载均衡插件mysqlnd_ms安装使用