config.db.php,数据库配置（$config[db]）

## 数据库配置

微擎系统支持数据库的主从配置(一主多从)，只需要进行简单的配置即可。

| 变量 | 描述 |

| --- | --- |

| $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',);

~~~