设为首页收藏本站

 找回密码
 立即注册
搜索
热搜: 活动 交友 discuz
DZ起点网_免费Discuz视频教程»首页 › Discuz开发资源 › discuz代码大全 › Discuz!-分库一主多从数据库分离-config_global.php-文 ...
返回列表 发新帖
查看: 5001|回复: 4

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

 火 [复制链接]
技术帮助
发表于 2018-7-8 00:58:16 | 显示全部楼层 |阅读模式
  1. <?php

  3. /**
  4.     [Discuz!] (C) 2001-2099 Comsenz Inc.

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

  9. $_config = array();

  11. // ----------------------------  CONFIG DB  ----------------------------- //
  12. $db = array(
  13.     'dbhost' => 'localhost',
  14.     'dbuser' => 'root',
  15.     'dbpw' => '111111',
  16.     'dbcharset' => 'gbk',
  17.     'pconnect' => '0',
  18.     'dbname' => 'ultrax',
  19.     'tablepre' => 'pre_'
  20. );
  21. $_config['db']['1'] = $db;

  23. //$_config['db']['1']['slave']['1'] = $db;
  24. //$_config['db']['1']['slave']['1']['weight'] = '0';
  25. //$_config['db']['1']['slave']['2'] = $db;
  26. //$_config['db']['1']['slave']['2']['weight'] = '0';
  27. //$_config['db']['1']['slave']['3'] = $db;
  28. //$_config['db']['1']['slave']['3']['weight'] = '0';

  30. $_config['db']['2'] = $db;
  31. $_config['db']['2']['slave']['1'] = $db;
  32. $_config['db']['2']['slave']['1']['weight'] = '5';
  33. $_config['db']['2']['slave']['2'] = $db;
  34. $_config['db']['2']['slave']['3'] = $db;

  36. $_config['db']['3'] = $db;
  37. $_config['db']['3']['dbname'] = 'ultrax';
  38. $_config['db']['3']['slave']['1'] = $db;
  39. $_config['db']['3']['slave']['2'] = $db;
  40. $_config['db']['3']['slave']['3'] = $db;
  41. $_config['db']['3']['slave']['3']['weight'] = '5';

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

  45. $dbthread = '2';
  46. $dbpost = '3';
  47. $_config['db']['map']['forum_debatepost'] = $dbpost;
  48. $_config['db']['map']['forum_post_moderate'] = $dbpost;
  49. $_config['db']['map']['forum_post_tableid'] = $dbpost;
  50. $_config['db']['map']['forum_post'] = $dbpost;
  51. $_config['db']['map']['forum_tradelog'] = $dbthread;
  52. $_config['db']['map']['forum_tradecomment'] = $dbthread;
  53. $_config['db']['map']['forum_trade'] = $dbthread;
  54. $_config['db']['map']['forum_threadmod'] = $dbthread;
  55. $_config['db']['map']['forum_activity'] = $dbthread;
  56. $_config['db']['map']['forum_poll'] = $dbthread;
  57. $_config['db']['map']['forum_thread_moderate'] = $dbthread;
  58. $_config['db']['map']['forum_threadimage'] = $dbthread;
  59. $_config['db']['map']['forum_forumrecommend'] = $dbthread;
  60. $_config['db']['map']['forum_moderator'] = $dbthread;
  61. $_config['db']['map']['common_tagitem'] = $dbthread;
  62. $_config['db']['map']['forum_access'] = $dbthread;
  63. $_config['db']['map']['forum_forumfield'] = $dbthread;
  64. $_config['db']['map']['forum_forum'] = $dbthread;
  65. $_config['db']['map']['forum_thread'] = $dbthread;
  66. $_config['db']['map']['forum_statlog'] = $dbthread;

  68. /** //X876 的测试配置文件
  69. $_config['db']['1']['dbhost'] = 'localhost';
  70. $_config['db']['1']['dbuser'] = 'root';
  71. $_config['db']['1']['dbpw'] = 'root';
  72. $_config['db']['1']['dbcharset'] = 'gbk';
  73. $_config['db']['1']['pconnect'] = '0';
  74. $_config['db']['1']['dbname'] = 'superbase';
  75. $_config['db']['1']['tablepre'] = 'pre_';
  76. $_config['db']['common']['slave_except_table'] = '';
  77. $_config['db']['2']['dbhost'] = '2.cn';
  78. $_config['db']['2']['dbuser'] = 'root';
  79. $_config['db']['2']['dbpw'] = 'root';
  80. $_config['db']['2']['dbcharset'] = 'gbk';
  81. $_config['db']['2']['pconnect'] = '0';
  82. $_config['db']['2']['dbname'] = 'superbase_2';
  83. $_config['db']['2']['tablepre'] = 'pre_';
  84. $_config['db']['3']['dbhost'] = '3.cn';
  85. $_config['db']['3']['dbuser'] = 'root';
  86. $_config['db']['3']['dbpw'] = 'root';
  87. $_config['db']['3']['dbcharset'] = 'gbk';
  88. $_config['db']['3']['pconnect'] = '0';
  89. $_config['db']['3']['dbname'] = 'superbase_3';
  90. $_config['db']['3']['tablepre'] = 'pre_';
  91. $_config['db']['4']['dbhost'] = '4.cn';
  92. $_config['db']['4']['dbuser'] = 'root';
  93. $_config['db']['4']['dbpw'] = 'root';
  94. $_config['db']['4']['dbcharset'] = 'gbk';
  95. $_config['db']['4']['pconnect'] = '0';
  96. $_config['db']['4']['dbname'] = 'superbase_4';
  97. $_config['db']['4']['tablepre'] = 'pre_';
  98. $_config['db']['5']['dbhost'] = '5.cn';
  99. $_config['db']['5']['dbuser'] = 'root';
  100. $_config['db']['5']['dbpw'] = 'root';
  101. $_config['db']['5']['dbcharset'] = 'gbk';
  102. $_config['db']['5']['pconnect'] = '0';
  103. $_config['db']['5']['dbname'] = 'superbase_5';
  104. $_config['db']['5']['tablepre'] = 'pre_';
  105. $_config['db']['6']['dbhost'] = '6.cn';
  106. $_config['db']['6']['dbuser'] = 'root';
  107. $_config['db']['6']['dbpw'] = 'root';
  108. $_config['db']['6']['dbcharset'] = 'gbk';
  109. $_config['db']['6']['pconnect'] = '0';
  110. $_config['db']['6']['dbname'] = 'superbase_6';
  111. $_config['db']['6']['tablepre'] = 'pre_';
  112. $_config['db']['7']['dbhost'] = '7.cn';
  113. $_config['db']['7']['dbuser'] = 'root';
  114. $_config['db']['7']['dbpw'] = 'root';
  115. $_config['db']['7']['dbcharset'] = 'gbk';
  116. $_config['db']['7']['pconnect'] = '0';
  117. $_config['db']['7']['dbname'] = 'superbase_7';
  118. $_config['db']['7']['tablepre'] = 'pre_';
  119. $_config['db']['8']['dbhost'] = '8.cn';
  120. $_config['db']['8']['dbuser'] = 'root';
  121. $_config['db']['8']['dbpw'] = 'root';
  122. $_config['db']['8']['dbcharset'] = 'gbk';
  123. $_config['db']['8']['pconnect'] = '0';
  124. $_config['db']['8']['dbname'] = 'superbase_8';
  125. $_config['db']['8']['tablepre'] = 'pre_';
  126. $_config['db']['9']['dbhost'] = '9.cn';
  127. $_config['db']['9']['dbuser'] = 'root';
  128. $_config['db']['9']['dbpw'] = 'root';
  129. $_config['db']['9']['dbcharset'] = 'gbk';
  130. $_config['db']['9']['pconnect'] = '0';
  131. $_config['db']['9']['dbname'] = 'superbase_9';
  132. $_config['db']['9']['tablepre'] = 'pre_';
  133. $_config['db']['10']['dbhost'] = '10.cn';
  134. $_config['db']['10']['dbuser'] = 'root';
  135. $_config['db']['10']['dbpw'] = 'root';
  136. $_config['db']['10']['dbcharset'] = 'gbk';
  137. $_config['db']['10']['pconnect'] = '0';
  138. $_config['db']['10']['dbname'] = 'superbase_10';
  139. $_config['db']['10']['tablepre'] = 'pre_';
  140. $_config['db']['11']['dbhost'] = '11.cn';
  141. $_config['db']['11']['dbuser'] = 'root';
  142. $_config['db']['11']['dbpw'] = 'root';
  143. $_config['db']['11']['dbcharset'] = 'gbk';
  144. $_config['db']['11']['pconnect'] = '0';
  145. $_config['db']['11']['dbname'] = 'superbase_11';
  146. $_config['db']['11']['tablepre'] = 'pre_';
  147. $_config['db']['12']['dbhost'] = '12.cn';
  148. $_config['db']['12']['dbuser'] = 'root';
  149. $_config['db']['12']['dbpw'] = 'root';
  150. $_config['db']['12']['dbcharset'] = 'gbk';
  151. $_config['db']['12']['pconnect'] = '0';
  152. $_config['db']['12']['dbname'] = 'superbase_12';
  153. $_config['db']['12']['tablepre'] = 'pre_';
  154. $_config['db']['13']['dbhost'] = '13.cn';
  155. $_config['db']['13']['dbuser'] = 'root';
  156. $_config['db']['13']['dbpw'] = 'root';
  157. $_config['db']['13']['dbcharset'] = 'gbk';
  158. $_config['db']['13']['pconnect'] = '0';
  159. $_config['db']['13']['dbname'] = 'superbase_13';
  160. $_config['db']['13']['tablepre'] = 'pre_';
  161. $_config['db']['14']['dbhost'] = '14.cn';
  162. $_config['db']['14']['dbuser'] = 'root';
  163. $_config['db']['14']['dbpw'] = 'root';
  164. $_config['db']['14']['dbcharset'] = 'gbk';
  165. $_config['db']['14']['pconnect'] = '0';
  166. $_config['db']['14']['dbname'] = 'superbase_14';
  167. $_config['db']['14']['tablepre'] = 'pre_';
  168. $_config['db']['15']['dbhost'] = '15.cn';
  169. $_config['db']['15']['dbuser'] = 'root';
  170. $_config['db']['15']['dbpw'] = 'root';
  171. $_config['db']['15']['dbcharset'] = 'gbk';
  172. $_config['db']['15']['pconnect'] = '0';
  173. $_config['db']['15']['dbname'] = 'superbase_15';
  174. $_config['db']['15']['tablepre'] = 'pre_';
  175. $_config['db']['16']['dbhost'] = '16.cn';
  176. $_config['db']['16']['dbuser'] = 'root';
  177. $_config['db']['16']['dbpw'] = 'root';
  178. $_config['db']['16']['dbcharset'] = 'gbk';
  179. $_config['db']['16']['pconnect'] = '0';
  180. $_config['db']['16']['dbname'] = 'superbase_16';
  181. $_config['db']['16']['tablepre'] = 'pre_';
  182. $_config['db']['17']['dbhost'] = '17.cn';
  183. $_config['db']['17']['dbuser'] = 'root';
  184. $_config['db']['17']['dbpw'] = 'root';
  185. $_config['db']['17']['dbcharset'] = 'gbk';
  186. $_config['db']['17']['pconnect'] = '0';
  187. $_config['db']['17']['dbname'] = 'superbase_17';
  188. $_config['db']['17']['tablepre'] = 'pre_';
  189. $_config['db']['18']['dbhost'] = '18.cn';
  190. $_config['db']['18']['dbuser'] = 'root';
  191. $_config['db']['18']['dbpw'] = 'root';
  192. $_config['db']['18']['dbcharset'] = 'gbk';
  193. $_config['db']['18']['pconnect'] = '0';
  194. $_config['db']['18']['dbname'] = 'superbase_18';
  195. $_config['db']['18']['tablepre'] = 'pre_';
  196. $_config['db']['19']['dbhost'] = '19.cn';
  197. $_config['db']['19']['dbuser'] = 'root';
  198. $_config['db']['19']['dbpw'] = 'root';
  199. $_config['db']['19']['dbcharset'] = 'gbk';
  200. $_config['db']['19']['pconnect'] = '0';
  201. $_config['db']['19']['dbname'] = 'superbase_19';
  202. $_config['db']['19']['tablepre'] = 'pre_';
  203. $_config['db']['20']['dbhost'] = '20.cn';
  204. $_config['db']['20']['dbuser'] = 'root';
  205. $_config['db']['20']['dbpw'] = 'root';
  206. $_config['db']['20']['dbcharset'] = 'gbk';
  207. $_config['db']['20']['pconnect'] = '0';
  208. $_config['db']['20']['dbname'] = 'superbase_20';
  209. $_config['db']['20']['tablepre'] = 'pre_';
  210. $_config['db']['map']['common_admincp_perm'] = '2';
  211. $_config['db']['map']['common_admincp_member'] = '2';
  212. $_config['db']['map']['common_mailqueue'] = '3';
  213. $_config['db']['map']['common_mailcron'] = '3';
  214. $_config['db']['map']['common_member_verify_info'] = '4';
  215. $_config['db']['map']['common_member_verify'] = '4';
  216. $_config['db']['map']['common_member_validate'] = '4';
  217. $_config['db']['map']['common_member_field_home_archive'] = '4';
  218. $_config['db']['map']['common_member_field_home'] = '4';
  219. $_config['db']['map']['common_member_field_forum_archive'] = '4';
  220. $_config['db']['map']['common_member_field_forum'] = '4';
  221. $_config['db']['map']['common_member_profile_archive'] = '4';
  222. $_config['db']['map']['common_member_profile'] = '4';
  223. $_config['db']['map']['common_member_status_archive'] = '4';
  224. $_config['db']['map']['common_member_status'] = '4';
  225. $_config['db']['map']['common_member_count_archive'] = '4';
  226. $_config['db']['map']['common_member_count'] = '4';
  227. $_config['db']['map']['common_member_archive'] = '4';
  228. $_config['db']['map']['home_specialuser'] = '4';
  229. $_config['db']['map']['home_show'] = '4';
  230. $_config['db']['map']['common_member'] = '4';
  231. $_config['db']['map']['common_pluginvar'] = '5';
  232. $_config['db']['map']['common_plugin'] = '5';
  233. $_config['db']['map']['forum_imagetype'] = '6';
  234. $_config['db']['map']['common_smiley'] = '6';
  235. $_config['db']['map']['common_stylevar'] = '7';
  236. $_config['db']['map']['common_template'] = '7';
  237. $_config['db']['map']['common_style'] = '7';
  238. $_config['db']['map']['forum_attachment_unused'] = '8';
  239. $_config['db']['map']['forum_attachment'] = '8';
  240. $_config['db']['map']['forum_debatepost'] = '9';
  241. $_config['db']['map']['forum_post_moderate'] = '9';
  242. $_config['db']['map']['forum_post_tableid'] = '9';
  243. $_config['db']['map']['forum_post'] = '9';
  244. $_config['db']['map']['forum_tradelog'] = '10';
  245. $_config['db']['map']['forum_tradecomment'] = '10';
  246. $_config['db']['map']['forum_trade'] = '10';
  247. $_config['db']['map']['forum_threadmod'] = '10';
  248. $_config['db']['map']['forum_activity'] = '10';
  249. $_config['db']['map']['forum_poll'] = '10';
  250. $_config['db']['map']['forum_thread_moderate'] = '10';
  251. $_config['db']['map']['forum_threadimage'] = '10';
  252. $_config['db']['map']['forum_forumrecommend'] = '10';
  253. $_config['db']['map']['forum_moderator'] = '10';
  254. $_config['db']['map']['common_tagitem'] = '10';
  255. $_config['db']['map']['forum_access'] = '10';
  256. $_config['db']['map']['forum_forumfield'] = '10';
  257. $_config['db']['map']['forum_forum'] = '10';
  258. $_config['db']['map']['forum_thread'] = '10';
  259. $_config['db']['map']['forum_statlog'] = '10';
  260. $_config['db']['map']['forum_threadtype'] = '11';
  261. $_config['db']['map']['forum_typeoption'] = '11';
  262. $_config['db']['map']['forum_typevar'] = '11';
  263. $_config['db']['map']['home_blogfield'] = '12';
  264. $_config['db']['map']['home_blog_moderate'] = '12';
  265. $_config['db']['map']['home_blog'] = '12';
  266. $_config['db']['map']['home_pic_moderate'] = '13';
  267. $_config['db']['map']['home_album'] = '13';
  268. $_config['db']['map']['home_picfield'] = '13';
  269. $_config['db']['map']['home_pic'] = '13';
  270. $_config['db']['map']['common_mytask'] = '14';
  271. $_config['db']['map']['common_task'] = '14';
  272. $_config['db']['map']['home_comment_moderate'] = '15';
  273. $_config['db']['map']['home_comment'] = '15';
  274. $_config['db']['map']['home_doing_moderate'] = '16';
  275. $_config['db']['map']['home_doing'] = '16';
  276. $_config['db']['map']['home_share_moderate'] = '17';
  277. $_config['db']['map']['home_share'] = '17';
  278. $_config['db']['map']['portal_article_moderate'] = '18';
  279. $_config['db']['map']['portal_article_title'] = '18';
  280. $_config['db']['map']['portal_article_count'] = '18';
  281. $_config['db']['map']['portal_comment_moderate'] = '19';
  282. $_config['db']['map']['portal_comment'] = '19';
  283. */
  284. // --------------------------  CONFIG MEMORY  --------------------------- //
  285. $_config['memory']['prefix'] = 'Yd1234_';
  286. $_config['memory']['eaccelerator'] = '0';
  287. $_config['memory']['xcache'] = 1;
  288. $_config['memory']['memcache']['server'] = '';
  289. $_config['memory']['memcache']['port'] = 11211;
  290. $_config['memory']['memcache']['pconnect'] = 1;
  291. $_config['memory']['memcache']['timeout'] = 1;
  292. $_config['memory']['apc'] = 1;
  293. $_config['memory']['redis']['server'] = '';
  294. $_config['memory']['redis']['port'] = 6379;
  295. $_config['memory']['redis']['pconnect'] = 1;
  296. $_config['memory']['redis']['timeout'] = '0';
  297. $_config['memory']['redis']['serializer'] = 1;

  299. // ---------------------------  CONFIG CACHE  --------------------------- //
  300. $_config['cache']['main']['type'] = '';
  301. $_config['cache']['main']['file']['path'] = 'data/ultraxcache';
  302. $_config['cache']['type'] = 'sql';

  304. // --------------------------  CONFIG OUTPUT  --------------------------- //
  305. $_config['output']['charset'] = 'gbk';
  306. $_config['output']['forceheader'] = 1;
  307. $_config['output']['gzip'] = '1';
  308. $_config['output']['tplrefresh'] = 1;
  309. $_config['output']['language'] = 'zh_cn';
  310. $_config['output']['staticurl'] = 'static/';
  311. $_config['output']['ajaxvalidate'] = '0';
  312. $_config['output']['iecompatible'] = '0';

  314. // --------------------------  CONFIG COOKIE  --------------------------- //
  315. $_config['cookie']['cookiepre'] = 'DlWe_';
  316. $_config['cookie']['cookiedomain'] = '';
  317. $_config['cookie']['cookiepath'] = '/';

  319. // -------------------------  CONFIG SECURITY  -------------------------- //
  320. $_config['security']['authkey'] = '1dab222dvEFEtjZA';
  321. $_config['security']['urlxssdefend'] = '0';
  322. $_config['security']['attackevasive'] = '0';
  323. $_config['security']['querysafe']['status'] = 1;
  324. $_config['security']['querysafe']['dfunction']['0'] = 'load_file';
  325. $_config['security']['querysafe']['dfunction']['1'] = 'hex';
  326. $_config['security']['querysafe']['dfunction']['2'] = 'substring';
  327. $_config['security']['querysafe']['dfunction']['3'] = 'if';
  328. $_config['security']['querysafe']['dfunction']['4'] = 'ord';
  329. $_config['security']['querysafe']['dfunction']['5'] = 'char';
  330. $_config['security']['querysafe']['daction']['0'] = 'intooutfile';
  331. $_config['security']['querysafe']['daction']['1'] = 'intodumpfile';
  332. $_config['security']['querysafe']['daction']['2'] = 'unionselect';
  333. $_config['security']['querysafe']['daction']['3'] = '(select';
  334. $_config['security']['querysafe']['daction']['4'] = 'unionall';
  335. $_config['security']['querysafe']['daction']['5'] = 'uniondistinct';
  336. $_config['security']['querysafe']['dnote']['0'] = '/*';
  337. $_config['security']['querysafe']['dnote']['1'] = '*/';
  338. $_config['security']['querysafe']['dnote']['2'] = '#';
  339. $_config['security']['querysafe']['dnote']['3'] = '--';
  340. $_config['security']['querysafe']['dnote']['4'] = '"';
  341. $_config['security']['querysafe']['dlikehex'] = 1;
  342. $_config['security']['querysafe']['afullnote'] = 1;

  344. // --------------------------  CONFIG ADMINCP  -------------------------- //
  345. // -------- Founders: $_config['admincp']['founder'] = '1,2,3'; --------- //
  346. $_config['admincp']['founder'] = '859,776,80629';
  347. $_config['admincp']['forcesecques'] = '0';
  348. $_config['admincp']['checkip'] = 1;
  349. $_config['admincp']['runquery'] = 1;
  350. $_config['admincp']['dbimport'] = 1;

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

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

  358. // -------------------------  CONFIG DOWNLOAD  -------------------------- //
  359. $_config['download']['readmod'] = 2;
  360. $_config['download']['xsendfile']['type'] = '0';
  361. $_config['download']['xsendfile']['dir'] = '/down/';

  363. // --------------------------  CONFIG REMOTE  --------------------------- //
  364. $_config['remote']['on'] = 1;
  365. $_config['remote']['dir'] = 'remote';
  366. $_config['remote']['appkey'] = '62cf0b3c3e6a4c9468e7216839721d8e';
  367. $_config['remote']['cron'] = 1;

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


  373. // -------------------  THE END  -------------------- //

  375. ?>
复制代码
Discuz!-分库一主多从-config_global.php-文件范例

回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|小黑屋|Discuz代码分析|Discuz目录结构|DZ起点网 ( 蜀ICP备13000518号-15 )

GMT+8, 2024-12-23 11:40 , Processed in 0.045733 second(s), 17 queries .

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

快速回复 返回顶部 返回列表