## 數據庫配置 微擎系統支持數據庫的主從配置（一主多從），只需要進行簡單的配置即可。 | 變量 | 描述 | | --- | --- | | $config\[‘db’\]\[‘master’\]\[‘host’\] | 數據庫主機地址 | | $config\[‘db’\]\[‘master’\]\[‘username’\] | 數據庫用戶名 | | $config\[‘db’\]\[‘master’\]\[‘password’\] | 數據庫密碼 | | $config\[‘db’\]\[‘master’\]\[‘port’\] | 數據庫端口 | | $config\[‘db’\]\[‘master’\]\[‘database’\] | 數據庫名 | | $config\[‘db’\]\[‘master’\]\[‘charset’\] | 數據庫編碼 | | $config\[‘db’\]\[‘master’\]\[‘pconnect’\] | 數據庫連接類型 | | $config\[‘db’\]\[‘master’\]\[‘tablepre’\] | 數據庫表前綴 | | $config\[‘db’\]\[‘slave\_status’\] | 讀寫分離開關 | | $config\[‘db’\]\[‘slave’\]\[‘1’\] | 只讀實例配置項，1為只讀實例編碼，多臺實例可新增\[2\],\[3\],\[4\] | | $config\[‘db’\]\[‘common’\]\[‘slave\_except\_table’\] | 不進行主從分離的表 | 配置主從支持在系統 “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',); ~~~