技术帮助 发表于 2018-7-8 00:58:16

Discuz!-分库一主多从数据库分离-config_global.php-文件范例

<?php

/**
    (C) 2001-2099 Comsenz Inc.

    config_global.php Build at 2012-07-06 10:16:22
*/

$_config = array();

// ----------------------------CONFIG DB----------------------------- //
$db = array(
    'dbhost' => 'localhost',
    'dbuser' => 'root',
    'dbpw' => '111111',
    'dbcharset' => 'gbk',
    'pconnect' => '0',
    'dbname' => 'ultrax',
    'tablepre' => 'pre_'
);
$_config['db']['1'] = $db;

//$_config['db']['1']['slave']['1'] = $db;
//$_config['db']['1']['slave']['1']['weight'] = '0';
//$_config['db']['1']['slave']['2'] = $db;
//$_config['db']['1']['slave']['2']['weight'] = '0';
//$_config['db']['1']['slave']['3'] = $db;
//$_config['db']['1']['slave']['3']['weight'] = '0';

$_config['db']['2'] = $db;
$_config['db']['2']['slave']['1'] = $db;
$_config['db']['2']['slave']['1']['weight'] = '5';
$_config['db']['2']['slave']['2'] = $db;
$_config['db']['2']['slave']['3'] = $db;

$_config['db']['3'] = $db;
$_config['db']['3']['dbname'] = 'ultrax';
$_config['db']['3']['slave']['1'] = $db;
$_config['db']['3']['slave']['2'] = $db;
$_config['db']['3']['slave']['3'] = $db;
$_config['db']['3']['slave']['3']['weight'] = '5';

$_config['db']['slave'] = 1;

$dbthread = '2';
$dbpost = '3';
$_config['db']['map']['forum_debatepost'] = $dbpost;
$_config['db']['map']['forum_post_moderate'] = $dbpost;
$_config['db']['map']['forum_post_tableid'] = $dbpost;
$_config['db']['map']['forum_post'] = $dbpost;
$_config['db']['map']['forum_tradelog'] = $dbthread;
$_config['db']['map']['forum_tradecomment'] = $dbthread;
$_config['db']['map']['forum_trade'] = $dbthread;
$_config['db']['map']['forum_threadmod'] = $dbthread;
$_config['db']['map']['forum_activity'] = $dbthread;
$_config['db']['map']['forum_poll'] = $dbthread;
$_config['db']['map']['forum_thread_moderate'] = $dbthread;
$_config['db']['map']['forum_threadimage'] = $dbthread;
$_config['db']['map']['forum_forumrecommend'] = $dbthread;
$_config['db']['map']['forum_moderator'] = $dbthread;
$_config['db']['map']['common_tagitem'] = $dbthread;
$_config['db']['map']['forum_access'] = $dbthread;
$_config['db']['map']['forum_forumfield'] = $dbthread;
$_config['db']['map']['forum_forum'] = $dbthread;
$_config['db']['map']['forum_thread'] = $dbthread;
$_config['db']['map']['forum_statlog'] = $dbthread;

/** //X876 的测试配置文件
$_config['db']['1']['dbhost'] = 'localhost';
$_config['db']['1']['dbuser'] = 'root';
$_config['db']['1']['dbpw'] = 'root';
$_config['db']['1']['dbcharset'] = 'gbk';
$_config['db']['1']['pconnect'] = '0';
$_config['db']['1']['dbname'] = 'superbase';
$_config['db']['1']['tablepre'] = 'pre_';
$_config['db']['common']['slave_except_table'] = '';
$_config['db']['2']['dbhost'] = '2.cn';
$_config['db']['2']['dbuser'] = 'root';
$_config['db']['2']['dbpw'] = 'root';
$_config['db']['2']['dbcharset'] = 'gbk';
$_config['db']['2']['pconnect'] = '0';
$_config['db']['2']['dbname'] = 'superbase_2';
$_config['db']['2']['tablepre'] = 'pre_';
$_config['db']['3']['dbhost'] = '3.cn';
$_config['db']['3']['dbuser'] = 'root';
$_config['db']['3']['dbpw'] = 'root';
$_config['db']['3']['dbcharset'] = 'gbk';
$_config['db']['3']['pconnect'] = '0';
$_config['db']['3']['dbname'] = 'superbase_3';
$_config['db']['3']['tablepre'] = 'pre_';
$_config['db']['4']['dbhost'] = '4.cn';
$_config['db']['4']['dbuser'] = 'root';
$_config['db']['4']['dbpw'] = 'root';
$_config['db']['4']['dbcharset'] = 'gbk';
$_config['db']['4']['pconnect'] = '0';
$_config['db']['4']['dbname'] = 'superbase_4';
$_config['db']['4']['tablepre'] = 'pre_';
$_config['db']['5']['dbhost'] = '5.cn';
$_config['db']['5']['dbuser'] = 'root';
$_config['db']['5']['dbpw'] = 'root';
$_config['db']['5']['dbcharset'] = 'gbk';
$_config['db']['5']['pconnect'] = '0';
$_config['db']['5']['dbname'] = 'superbase_5';
$_config['db']['5']['tablepre'] = 'pre_';
$_config['db']['6']['dbhost'] = '6.cn';
$_config['db']['6']['dbuser'] = 'root';
$_config['db']['6']['dbpw'] = 'root';
$_config['db']['6']['dbcharset'] = 'gbk';
$_config['db']['6']['pconnect'] = '0';
$_config['db']['6']['dbname'] = 'superbase_6';
$_config['db']['6']['tablepre'] = 'pre_';
$_config['db']['7']['dbhost'] = '7.cn';
$_config['db']['7']['dbuser'] = 'root';
$_config['db']['7']['dbpw'] = 'root';
$_config['db']['7']['dbcharset'] = 'gbk';
$_config['db']['7']['pconnect'] = '0';
$_config['db']['7']['dbname'] = 'superbase_7';
$_config['db']['7']['tablepre'] = 'pre_';
$_config['db']['8']['dbhost'] = '8.cn';
$_config['db']['8']['dbuser'] = 'root';
$_config['db']['8']['dbpw'] = 'root';
$_config['db']['8']['dbcharset'] = 'gbk';
$_config['db']['8']['pconnect'] = '0';
$_config['db']['8']['dbname'] = 'superbase_8';
$_config['db']['8']['tablepre'] = 'pre_';
$_config['db']['9']['dbhost'] = '9.cn';
$_config['db']['9']['dbuser'] = 'root';
$_config['db']['9']['dbpw'] = 'root';
$_config['db']['9']['dbcharset'] = 'gbk';
$_config['db']['9']['pconnect'] = '0';
$_config['db']['9']['dbname'] = 'superbase_9';
$_config['db']['9']['tablepre'] = 'pre_';
$_config['db']['10']['dbhost'] = '10.cn';
$_config['db']['10']['dbuser'] = 'root';
$_config['db']['10']['dbpw'] = 'root';
$_config['db']['10']['dbcharset'] = 'gbk';
$_config['db']['10']['pconnect'] = '0';
$_config['db']['10']['dbname'] = 'superbase_10';
$_config['db']['10']['tablepre'] = 'pre_';
$_config['db']['11']['dbhost'] = '11.cn';
$_config['db']['11']['dbuser'] = 'root';
$_config['db']['11']['dbpw'] = 'root';
$_config['db']['11']['dbcharset'] = 'gbk';
$_config['db']['11']['pconnect'] = '0';
$_config['db']['11']['dbname'] = 'superbase_11';
$_config['db']['11']['tablepre'] = 'pre_';
$_config['db']['12']['dbhost'] = '12.cn';
$_config['db']['12']['dbuser'] = 'root';
$_config['db']['12']['dbpw'] = 'root';
$_config['db']['12']['dbcharset'] = 'gbk';
$_config['db']['12']['pconnect'] = '0';
$_config['db']['12']['dbname'] = 'superbase_12';
$_config['db']['12']['tablepre'] = 'pre_';
$_config['db']['13']['dbhost'] = '13.cn';
$_config['db']['13']['dbuser'] = 'root';
$_config['db']['13']['dbpw'] = 'root';
$_config['db']['13']['dbcharset'] = 'gbk';
$_config['db']['13']['pconnect'] = '0';
$_config['db']['13']['dbname'] = 'superbase_13';
$_config['db']['13']['tablepre'] = 'pre_';
$_config['db']['14']['dbhost'] = '14.cn';
$_config['db']['14']['dbuser'] = 'root';
$_config['db']['14']['dbpw'] = 'root';
$_config['db']['14']['dbcharset'] = 'gbk';
$_config['db']['14']['pconnect'] = '0';
$_config['db']['14']['dbname'] = 'superbase_14';
$_config['db']['14']['tablepre'] = 'pre_';
$_config['db']['15']['dbhost'] = '15.cn';
$_config['db']['15']['dbuser'] = 'root';
$_config['db']['15']['dbpw'] = 'root';
$_config['db']['15']['dbcharset'] = 'gbk';
$_config['db']['15']['pconnect'] = '0';
$_config['db']['15']['dbname'] = 'superbase_15';
$_config['db']['15']['tablepre'] = 'pre_';
$_config['db']['16']['dbhost'] = '16.cn';
$_config['db']['16']['dbuser'] = 'root';
$_config['db']['16']['dbpw'] = 'root';
$_config['db']['16']['dbcharset'] = 'gbk';
$_config['db']['16']['pconnect'] = '0';
$_config['db']['16']['dbname'] = 'superbase_16';
$_config['db']['16']['tablepre'] = 'pre_';
$_config['db']['17']['dbhost'] = '17.cn';
$_config['db']['17']['dbuser'] = 'root';
$_config['db']['17']['dbpw'] = 'root';
$_config['db']['17']['dbcharset'] = 'gbk';
$_config['db']['17']['pconnect'] = '0';
$_config['db']['17']['dbname'] = 'superbase_17';
$_config['db']['17']['tablepre'] = 'pre_';
$_config['db']['18']['dbhost'] = '18.cn';
$_config['db']['18']['dbuser'] = 'root';
$_config['db']['18']['dbpw'] = 'root';
$_config['db']['18']['dbcharset'] = 'gbk';
$_config['db']['18']['pconnect'] = '0';
$_config['db']['18']['dbname'] = 'superbase_18';
$_config['db']['18']['tablepre'] = 'pre_';
$_config['db']['19']['dbhost'] = '19.cn';
$_config['db']['19']['dbuser'] = 'root';
$_config['db']['19']['dbpw'] = 'root';
$_config['db']['19']['dbcharset'] = 'gbk';
$_config['db']['19']['pconnect'] = '0';
$_config['db']['19']['dbname'] = 'superbase_19';
$_config['db']['19']['tablepre'] = 'pre_';
$_config['db']['20']['dbhost'] = '20.cn';
$_config['db']['20']['dbuser'] = 'root';
$_config['db']['20']['dbpw'] = 'root';
$_config['db']['20']['dbcharset'] = 'gbk';
$_config['db']['20']['pconnect'] = '0';
$_config['db']['20']['dbname'] = 'superbase_20';
$_config['db']['20']['tablepre'] = 'pre_';
$_config['db']['map']['common_admincp_perm'] = '2';
$_config['db']['map']['common_admincp_member'] = '2';
$_config['db']['map']['common_mailqueue'] = '3';
$_config['db']['map']['common_mailcron'] = '3';
$_config['db']['map']['common_member_verify_info'] = '4';
$_config['db']['map']['common_member_verify'] = '4';
$_config['db']['map']['common_member_validate'] = '4';
$_config['db']['map']['common_member_field_home_archive'] = '4';
$_config['db']['map']['common_member_field_home'] = '4';
$_config['db']['map']['common_member_field_forum_archive'] = '4';
$_config['db']['map']['common_member_field_forum'] = '4';
$_config['db']['map']['common_member_profile_archive'] = '4';
$_config['db']['map']['common_member_profile'] = '4';
$_config['db']['map']['common_member_status_archive'] = '4';
$_config['db']['map']['common_member_status'] = '4';
$_config['db']['map']['common_member_count_archive'] = '4';
$_config['db']['map']['common_member_count'] = '4';
$_config['db']['map']['common_member_archive'] = '4';
$_config['db']['map']['home_specialuser'] = '4';
$_config['db']['map']['home_show'] = '4';
$_config['db']['map']['common_member'] = '4';
$_config['db']['map']['common_pluginvar'] = '5';
$_config['db']['map']['common_plugin'] = '5';
$_config['db']['map']['forum_imagetype'] = '6';
$_config['db']['map']['common_smiley'] = '6';
$_config['db']['map']['common_stylevar'] = '7';
$_config['db']['map']['common_template'] = '7';
$_config['db']['map']['common_style'] = '7';
$_config['db']['map']['forum_attachment_unused'] = '8';
$_config['db']['map']['forum_attachment'] = '8';
$_config['db']['map']['forum_debatepost'] = '9';
$_config['db']['map']['forum_post_moderate'] = '9';
$_config['db']['map']['forum_post_tableid'] = '9';
$_config['db']['map']['forum_post'] = '9';
$_config['db']['map']['forum_tradelog'] = '10';
$_config['db']['map']['forum_tradecomment'] = '10';
$_config['db']['map']['forum_trade'] = '10';
$_config['db']['map']['forum_threadmod'] = '10';
$_config['db']['map']['forum_activity'] = '10';
$_config['db']['map']['forum_poll'] = '10';
$_config['db']['map']['forum_thread_moderate'] = '10';
$_config['db']['map']['forum_threadimage'] = '10';
$_config['db']['map']['forum_forumrecommend'] = '10';
$_config['db']['map']['forum_moderator'] = '10';
$_config['db']['map']['common_tagitem'] = '10';
$_config['db']['map']['forum_access'] = '10';
$_config['db']['map']['forum_forumfield'] = '10';
$_config['db']['map']['forum_forum'] = '10';
$_config['db']['map']['forum_thread'] = '10';
$_config['db']['map']['forum_statlog'] = '10';
$_config['db']['map']['forum_threadtype'] = '11';
$_config['db']['map']['forum_typeoption'] = '11';
$_config['db']['map']['forum_typevar'] = '11';
$_config['db']['map']['home_blogfield'] = '12';
$_config['db']['map']['home_blog_moderate'] = '12';
$_config['db']['map']['home_blog'] = '12';
$_config['db']['map']['home_pic_moderate'] = '13';
$_config['db']['map']['home_album'] = '13';
$_config['db']['map']['home_picfield'] = '13';
$_config['db']['map']['home_pic'] = '13';
$_config['db']['map']['common_mytask'] = '14';
$_config['db']['map']['common_task'] = '14';
$_config['db']['map']['home_comment_moderate'] = '15';
$_config['db']['map']['home_comment'] = '15';
$_config['db']['map']['home_doing_moderate'] = '16';
$_config['db']['map']['home_doing'] = '16';
$_config['db']['map']['home_share_moderate'] = '17';
$_config['db']['map']['home_share'] = '17';
$_config['db']['map']['portal_article_moderate'] = '18';
$_config['db']['map']['portal_article_title'] = '18';
$_config['db']['map']['portal_article_count'] = '18';
$_config['db']['map']['portal_comment_moderate'] = '19';
$_config['db']['map']['portal_comment'] = '19';
*/
// --------------------------CONFIG MEMORY--------------------------- //
$_config['memory']['prefix'] = 'Yd1234_';
$_config['memory']['eaccelerator'] = '0';
$_config['memory']['xcache'] = 1;
$_config['memory']['memcache']['server'] = '';
$_config['memory']['memcache']['port'] = 11211;
$_config['memory']['memcache']['pconnect'] = 1;
$_config['memory']['memcache']['timeout'] = 1;
$_config['memory']['apc'] = 1;
$_config['memory']['redis']['server'] = '';
$_config['memory']['redis']['port'] = 6379;
$_config['memory']['redis']['pconnect'] = 1;
$_config['memory']['redis']['timeout'] = '0';
$_config['memory']['redis']['serializer'] = 1;

// ---------------------------CONFIG CACHE--------------------------- //
$_config['cache']['main']['type'] = '';
$_config['cache']['main']['file']['path'] = 'data/ultraxcache';
$_config['cache']['type'] = 'sql';

// --------------------------CONFIG OUTPUT--------------------------- //
$_config['output']['charset'] = 'gbk';
$_config['output']['forceheader'] = 1;
$_config['output']['gzip'] = '1';
$_config['output']['tplrefresh'] = 1;
$_config['output']['language'] = 'zh_cn';
$_config['output']['staticurl'] = 'static/';
$_config['output']['ajaxvalidate'] = '0';
$_config['output']['iecompatible'] = '0';

// --------------------------CONFIG COOKIE--------------------------- //
$_config['cookie']['cookiepre'] = 'DlWe_';
$_config['cookie']['cookiedomain'] = '';
$_config['cookie']['cookiepath'] = '/';

// -------------------------CONFIG SECURITY-------------------------- //
$_config['security']['authkey'] = '1dab222dvEFEtjZA';
$_config['security']['urlxssdefend'] = '0';
$_config['security']['attackevasive'] = '0';
$_config['security']['querysafe']['status'] = 1;
$_config['security']['querysafe']['dfunction']['0'] = 'load_file';
$_config['security']['querysafe']['dfunction']['1'] = 'hex';
$_config['security']['querysafe']['dfunction']['2'] = 'substring';
$_config['security']['querysafe']['dfunction']['3'] = 'if';
$_config['security']['querysafe']['dfunction']['4'] = 'ord';
$_config['security']['querysafe']['dfunction']['5'] = 'char';
$_config['security']['querysafe']['daction']['0'] = 'intooutfile';
$_config['security']['querysafe']['daction']['1'] = 'intodumpfile';
$_config['security']['querysafe']['daction']['2'] = 'unionselect';
$_config['security']['querysafe']['daction']['3'] = '(select';
$_config['security']['querysafe']['daction']['4'] = 'unionall';
$_config['security']['querysafe']['daction']['5'] = 'uniondistinct';
$_config['security']['querysafe']['dnote']['0'] = '/*';
$_config['security']['querysafe']['dnote']['1'] = '*/';
$_config['security']['querysafe']['dnote']['2'] = '#';
$_config['security']['querysafe']['dnote']['3'] = '--';
$_config['security']['querysafe']['dnote']['4'] = '"';
$_config['security']['querysafe']['dlikehex'] = 1;
$_config['security']['querysafe']['afullnote'] = 1;

// --------------------------CONFIG ADMINCP-------------------------- //
// -------- Founders: $_config['admincp']['founder'] = '1,2,3'; --------- //
$_config['admincp']['founder'] = '859,776,80629';
$_config['admincp']['forcesecques'] = '0';
$_config['admincp']['checkip'] = 1;
$_config['admincp']['runquery'] = 1;
$_config['admincp']['dbimport'] = 1;

// ---------------------------CONFIG DEBUG--------------------------- //
$_config['debug'] = 'discuz';

// --------------------------CONFIG SERVER--------------------------- //
$_config['server']['id'] = 1;

// -------------------------CONFIG DOWNLOAD-------------------------- //
$_config['download']['readmod'] = 2;
$_config['download']['xsendfile']['type'] = '0';
$_config['download']['xsendfile']['dir'] = '/down/';

// --------------------------CONFIG REMOTE--------------------------- //
$_config['remote']['on'] = 1;
$_config['remote']['dir'] = 'remote';
$_config['remote']['appkey'] = '62cf0b3c3e6a4c9468e7216839721d8e';
$_config['remote']['cron'] = 1;

// ---------------------------CONFIG INPUT--------------------------- //
$_config['input']['compatible'] = '0';


// -------------------THE END-------------------- //

?>Discuz!-分库一主多从-config_global.php-文件范例

页: [1]
查看完整版本: Discuz!-分库一主多从数据库分离-config_global.php-文件范例