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

1. <?php /** [Discuz!] (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-文件范例