discuz3.2 开启读写分离

POST TIME:2016-11-13 20:09 READ:

找到根目录 config/ config_global.php  文件

增加
/*读写分离*/

  $_config['db']['1']['slave']['1']['dbhost'] = '数据库地址';
  $_config['db']['1']['slave']['1']['dbuser'] = '数据库密用户名';
  $_config['db']['1']['slave']['1']['dbpw'] = '数据库密码';
  $_config['db']['1']['slave']['1']['dbcharset'] = 'utf8';
  $_config['db']['1']['slave']['1']['pconnect'] = '0';
  $_config['db']['1']['slave']['1']['dbname'] = '数据库名称';
  $_config['db']['1']['slave']['1']['tablepre'] = 'pre_';
  $_config['db']['1']['slave']['1']['weight'] = '100'; //权重:数据越大权重越高

/*增加第二台读写分离*/

  $_config['db']['1']['slave']['2']['dbhost'] = '数据库地址';
  $_config['db']['1']['slave']['2']['dbuser'] = '数据库密用户名';
  $_config['db']['1']['slave']['2']['dbpw'] = '数据库密码';
  $_config['db']['1']['slave']['2']['dbcharset'] = 'utf8';
  $_config['db']['1']['slave']['2']['pconnect'] = '0';
  $_config['db']['1']['slave']['2']['dbname'] = '数据库名称';
  $_config['db']['1']['slave']['2']['tablepre'] = 'pre_';
  $_config['db']['1']['slave']['2']['weight'] = '100'; //权重:数据越大权重越高

//启用从服务器的开关
$_config['db']['slave'] = true;

$_config['db']['common']['slave_except_table'] = 'common_session, common_member';



15.5K

呃,好文章总是百看不厌,耐人寻味,您也可以收藏分享哟 :)