discuz 配置读写分离(主写从读)

最新推荐文章于 2023-12-06 14:47:27 发布

烂笔头.

最新推荐文章于 2023-12-06 14:47:27 发布

阅读量984

点赞数

CC 4.0 BY-SA版权

分类专栏： PHP

本文链接：https://blog.youkuaiyun.com/xfcy1990/article/details/89451724

PHP 专栏收录该内容

26 篇文章

订阅专栏

本文详细介绍了BBS系统的数据库配置方法，包括主库和从库的连接信息设置，如数据库地址、用户名、密码、字符集等关键参数，以及如何启用从服务器进行读写分离，提高系统性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

修改配置文件：config/config_global.php

$_config = array();

// ----------------------------  CONFIG DB  ----------------------------- //
//主库的连接信息
$_config['db']['1']['dbhost'] = 'localhost';
$_config['db']['1']['dbuser'] = 'root';
$_config['db']['1']['dbpw'] = 'password';
$_config['db']['1']['dbcharset'] = 'utf8';
$_config['db']['1']['pconnect'] = '0';
$_config['db']['1']['dbname'] = 'bbs';
$_config['db']['1']['tablepre'] = 'bbs_';
//$_config['db']['slave'] = '';
//$_config['db']['common']['slave_except_table'] = '';


$_config['db']['slave'] = true; //开启从服务器
$_config['db']['1']['slave'] = array();
$_config['db']['1']['slave']['1']['dbhost'] = '192.168.1.25';  //mysql 从库的host
$_config['db']['1']['slave']['1']['dbuser'] = 'root';   //mysql 从库的数据库用户名
$_config['db']['1']['slave']['1']['dbpw'] = 'password';    //mysql 从库的数据库密码
$_config['db']['1']['slave']['1']['dbcharset'] = 'utf8';
$_config['db']['1']['slave']['1']['pconnect'] = '0';
$_config['db']['1']['slave']['1']['dbname'] = 'bbs'; //mysql从库的数据库名
$_config['db']['1']['slave']['1']['tablepre'] = 'bbs_';