book_admin/application/extra/db.php

<?php
/**
 * Created by PhpStorm.
 * User: wangfanchang
 * Date: 18/1/4
 * Time: 下午8:18
 * db_mysql 分库
 */

use think\Env;
return [
    /**
     * 定义shard分库
     *
     * shard_list/user_list 格式说明
     *  0-191 库编号
     *  192.168.1.149:3306 主库IP:端口号
     */
    'shard_num' => Env::get('db.shard_num', 256), //取模库数量
    'shard_tables' => Env::get('db.shard_tables', 'consume,sign,user_recently_read,campaign_consume'), //数据库表名
    'shard_database' => Env::get('db.shard_database', 'cps_shard_$mod'), //数据库名称 $mod：取模编号
    'shard_list' => Env::get('db.shard_list', '0-191:10.250.1.165:3306:10.250.1.185:3306;192-255:10.250.1.164:3306:10.250.1.184:3306'),

    'user_num' => Env::get('db.user_num', 512),
    'user_tables' => Env::get('db.user_tables', 'openid,recharge,user,user_phone,user_match,campaign_consume,share_user,share_source'), //数据库表名
    'user_database' => Env::get('db.user_database', 'cps_user_$mod'), //数据库名称 $mod：取模编号
    'user_list' => Env::get('db.user_list', '0-255:10.250.1.162:3306:10.250.1.182:3306;256-511:10.250.1.163:3306:10.250.1.183:3306'),

    'shelf_num' => Env::get('db.shelf_num', 512),
    'shelf_tables' => Env::get('db.shelf_tables', 'book_shelf,book_shelf_exclude'), //数据库表名
    'shelf_database' => Env::get('db.shelf_database', 'cps_shelf_$mod'), //数据库名称 $mod：取模编号
    'shelf_list' => Env::get('db.shelf_list', '0-255:10.250.1.162:3306:10.250.1.182:3306;256-511:10.250.1.163:3306:10.250.1.183:3306'),
];