如何开启微擎数据库读写分离状态

•  2018-03-15
• (点击 368 次)
• 0

微擎主从库开启，在data/config.php设置的读写分离状态主要代码，包含微擎开启主从库的设置，注意主从库是2个数据库，不能同一个库。

$config['db']['master']['host'] = '127.0.0.1'; //主库地址
$config['db']['master']['username'] = 'admin'; //用户名
$config['db']['master']['password'] = '123456'; //密码
$config['db']['master']['port'] = '3306';  //端口
$config['db']['master']['database'] = 'we7';  数据库名
$config['db']['master']['charset'] = 'utf8';
$config['db']['master']['pconnect'] = 0;
$config['db']['master']['tablepre'] = 'ims_';

从库的开启修改下面，地址需要从数据库供应商获取，不可把普通的数据库用作从库，否则出现错误。开启微擎远程redis缓存 相关配置

$config['db']['slave_status'] = true;  //从库，默认false
$config['db']['slave']['1']['host'] = '127.0.0.2'; //从库地址
$config['db']['slave']['1']['username'] = 'admin';  //账户
$config['db']['slave']['1']['password'] = '234567';  //密码
$config['db']['slave']['1']['port'] = '3307';  //端口
$config['db']['slave']['1']['database'] = 'we8'; //数据库名
$config['db']['slave']['1']['charset'] = 'utf8';
$config['db']['slave']['1']['pconnect'] = 0;
$config['db']['slave']['1']['tablepre'] = 'ims_';
$config['db']['slave']['1']['weight'] = 0;
$config['db']['common']['slave_except_table'] = array('core_sessions');

这样就设置完成了，注意2个地址一般是购买云库使用，主库写入权限，从库读取权限。用户缓解服务器的压力，不可随意搞个数据库就开启读写分离状态，这样是会出错的。开启微擎性能优化redis 微擎memcache

本站内容均为原创，请注明出处：https:///dis/69.html

微擎,微擎主从库