## 數據庫配置
微擎系統支持數據庫的主從配置(一主多從),只需要進行簡單的配置即可。
| 變量 | 描述 |
| --- | --- |
| $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',
);
~~~
## 系統COOKIE配置項
| 變量 | 描述 |
| --- | --- |
| $config\[‘cookie’\]\[‘pre’\] | cookie前綴,無需更改,系統隨機生成 |
| $config\[‘cookie’\]\[‘domain’\] | cookie作用域 |
| $config\[‘cookie’\]\[‘path’\] | cookie作用目錄,無需更改 |
## 系統設置
| 變量 | 描述 |
| --- | --- |
| $config\[‘setting’\]\[‘charset’\] | 系統編碼 |
| $config\[‘setting’\]\[‘cache’\] | 緩存類型, 默認為mysql, 支持memcache,redis |
| $config\[‘setting’\]\[‘timezone’\] | 時區 |
| $config\[‘setting’\]\[‘memory\_limit’\] | 內存大小 |
| $config\[‘setting’\]\[‘filemode’\] | 文件權限 |
| $config\[‘setting’\]\[‘authkey’\] | 數據加密key |
| $config\[‘setting’\]\[‘founder’\] | 創始人設置 |
| $config\[‘setting’\]\[‘development’\] | 調試模式(開發模式)開關,開發者常用 |
| $config\[‘setting’\]\[‘referrer’\] | 無 |
## Memcache 緩存設置
| 變量 | 描述 |
| --- | --- |
| $config\[‘setting’\]\[‘memcache’\]\[‘server’\] | memcache服務地址 |
| $config\[‘setting’\]\[‘memcache’\]\[‘port’\] | 端口 |
| $config\[‘setting’\]\[‘memcache’\]\[‘pconnect’\] | 連接類型 |
| $config\[‘setting’\]\[‘memcache’\]\[‘timeout’\] | 超時時間 |
| $config\[‘setting’\]\[‘memcache’\]\[‘session’\] | 是否緩存session |
## Redis 緩存設置
| 變量 | 描述 |
| --- | --- |
| $config\[‘setting’\]\[‘redis’\]\[‘server’\] | redis服務地址 |
| $config\[‘setting’\]\[‘redis’\]\[‘port’\] | 端口 |
| $config\[‘setting’\]\[‘redis’\]\[‘pconnect’\] | 連接類型 |
| $config\[‘setting’\]\[‘redis’\]\[‘timeout’\] | 超時時間 |
| $config\[‘setting’\]\[‘redis’\]\[‘session’\] | 是否緩存session |
## 請求代理設置
在負載均衡的環境中,后端服務器可以通過前端服務代理來請求外網的URL
| 變量 | 描述 |
| --- | --- |
| $config\[‘setting’\]\[‘proxy’\]\[‘host’\] | 代理主機信息 |
| $config\[‘setting’\]\[‘proxy’\]\[‘auth’\] | 代理驗證信息 |
## 上傳配置 (已廢棄,統一在系統附件設置中更改)
| 變量 | 描述 |
| --- | --- |
| $config\[‘upload’\]\[‘image’\]\[‘extentions’\] | 上傳圖片的類型 |
| $config\[‘upload’\]\[‘image’\]\[‘limit’\] | 上傳圖片的大小 |
| $config\[‘upload’\]\[‘attachdir’\] | 上傳目錄 |
| $config\[‘upload’\]\[‘audio’\]\[‘extentions’\] | 上傳音頻的類型 |
| $config\[‘upload’\]\[‘audio’\]\[‘limit’\] | 上傳音頻的大小 |