# 1.主從配置
微贊系統支持數據庫的主從配置（一主多從），只需要進行簡單的配置即可。
配置主從支持在系統 "data/config.php" 文件中，具體配置如下：
注：部分用戶沒有master項，$config['db']['host'] 等同于 $config['db']['master']['host']
//主庫配置
$config['db']['master']['host'] = '192.168.1.2';
$config['db']['master']['username'] = 'root';
$config['db']['master']['password'] = '123456';
$config['db']['master']['port'] = '3306';
$config['db']['master']['database'] = 'we7_pro';
$config['db']['master']['charset'] = 'utf8';
$config['db']['master']['pconnect'] = 0;
$config['db']['master']['tablepre'] = 'ims_';
//以下選項，如果沒有請自行添加
//從庫配置
$config['db']['slave_status'] = false; //是否開啟主從配置
$config['db']['slave']['1']['host'] = '192.168.1.3'; //從庫配置要與主庫相同
$config['db']['slave']['1']['username'] = 'root';
$config['db']['slave']['1']['password'] = '123456';
$config['db']['slave']['1']['port'] = '3306';
$config['db']['slave']['1']['database'] = 'we7_pro';
$config['db']['slave']['1']['charset'] = 'utf8';
$config['db']['slave']['1']['pconnect'] = 0;
$config['db']['slave']['1']['tablepre'] = 'ims_';
$config['db']['slave']['1']['weight'] = 0; //從庫的權重值，默認0即可
//不進行主從分離的表
$config['db']['common']['slave_except_table'] = array(
'core_sessions',
);
