/
db-config-sample-16.php
67 lines (61 loc) · 4.52 KB
/
db-config-sample-16.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<?php
//------------------------------------------------------------------------//
//---DB Scaling-----------------------------------------------------------//
//------------------------------------------------------------------------//
// 16,256,4096
define ('DB_SCALING', '16');
//------------------------------------------------------------------------//
//---DC IPs---------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_dc_ip(IP, DC)
// EX: add_dc_ip('123.123.123.', 'dc1');
add_dc_ip('123.123.123.', 'dc1');
//------------------------------------------------------------------------//
//---Global Tables--------------------------------------------------------//
//------------------------------------------------------------------------//
// Do not include default global tables
// Leave off base prefix (eg: wp_)
// You don't really have to register these, they will work fine without.
// However registering at least your busiest ones might shave a few milliseconds off by avoiding some regexes.
//
// Usage: add_global_table(TABLE_NAME)
// EX: add_global_table('something');
add_global_table('some_global_table');
//------------------------------------------------------------------------//
//---DB Servers-----------------------------------------------------------//
//------------------------------------------------------------------------//
// Database servers grouped by dataset.
// R can be 0 (no reads) or a positive integer indicating the order
// in which to attempt communication (all locals, then all remotes)
//
// Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)
// EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
//
// Note: you can also place this section in a file called db-list.php in wp-content
add_db_server('global', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_global', 'db_user_name', 'db_user_name_pass');
add_db_server('0', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_0', 'db_user_name', 'db_user_name_pass');
add_db_server('1', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_1', 'db_user_name', 'db_user_name_pass');
add_db_server('2', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_2', 'db_user_name', 'db_user_name_pass');
add_db_server('3', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_3', 'db_user_name', 'db_user_name_pass');
add_db_server('4', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_4', 'db_user_name', 'db_user_name_pass');
add_db_server('5', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_5', 'db_user_name', 'db_user_name_pass');
add_db_server('6', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_6', 'db_user_name', 'db_user_name_pass');
add_db_server('7', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_7', 'db_user_name', 'db_user_name_pass');
add_db_server('8', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_8', 'db_user_name', 'db_user_name_pass');
add_db_server('9', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_9', 'db_user_name', 'db_user_name_pass');
add_db_server('a', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_a', 'db_user_name', 'db_user_name_pass');
add_db_server('b', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_b', 'db_user_name', 'db_user_name_pass');
add_db_server('c', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_c', 'db_user_name', 'db_user_name_pass');
add_db_server('d', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_d', 'db_user_name', 'db_user_name_pass');
add_db_server('e', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_e', 'db_user_name', 'db_user_name_pass');
add_db_server('f', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_f', 'db_user_name', 'db_user_name_pass');
//------------------------------------------------------------------------//
//---VIP Blogs------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_vip_blog(BLOG_ID, DS)
// EX: add_vip_blog(1, 'vip1');
// Only use VIP blogs if you meet 2 criteria, otherwise they are pointless:
// 1. You have a specific blog that gets crazy crazy traffic to the point that it warrants it's own DB server
// 2. You host it on it's own PHYSICAL db server
add_db_server('vip1', 'dc1', 1, 1,'64.120.23.72','192.168.0.101', 'wpmu_vip_1', 'db_user_name', 'db_user_name_pass');
add_vip_blog(1, 'vip1');