8586 pointsCommunity rank #4Supreme DeityWPMU DEV StaffLifetime member
Lead Developer
(joined May 2009)
Likes (0)
Can you paste a sample from the top of your db-config script? Just enough so we can see a bit of everything, we don't need the whole list of dbs. Be sure to blank out the passwords.
12 pointsCommunity rank #4781SophomoreJust Getting Started
Member
(joined May 2010)
Likes (0)
<?php
// Plugin Name: Multi-DB
// Plugin URI: http://premium.wpmudev.org/project/Multiple-Databases
// Author: Andrew Billits (Incsub)
// Version: 2.9.2
//------------------------------------------------------------------------//
//---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('85.92.83.', 'dc1');
//------------------------------------------------------------------------//
//---Global Tables--------------------------------------------------------//
//------------------------------------------------------------------------//
// Do not include default global tables
// Leave off base prefix (eg: wp_)
//
// 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,'localhost','localhost', 'bloggy_blogsglobal', 'user*****', 'password****');
8586 pointsCommunity rank #4Supreme DeityWPMU DEV StaffLifetime member
Lead Developer
(joined May 2009)
Likes (0)
Ok, what I thought. You defined your main blog as a vip blog, so you will need to move it's tables (starting with wp_1) to the vip db. I think they will be in the "c" table.
Or you can just comment out the line and leave it alone.
12 pointsCommunity rank #4781SophomoreJust Getting Started
Member
(joined May 2010)
Likes (0)
@aaron
yea i found wp_1_* in table c
i moved them all to vip1 and it is still not working,,,
but i really need to separate the main blog from other blogs
Thanks,
Moe!
12 pointsCommunity rank #4781SophomoreJust Getting Started
Member
(joined May 2010)
Likes (0)
hey Andrew,
WPMU is installed in bloggy_blogs
and i defined the bloggy_vip1 as the VIP DB.
why do i need my DB to be in a separate DB because my marketing plan for the site is big enough so i expect to have many users sooner.
PS: 16 DBs is just for test purpose once i install everything carefully and successfully i will move everything to the real domain with a fresh installation.
8586 pointsCommunity rank #4Supreme DeityWPMU DEV StaffLifetime member
Lead Developer
(joined May 2009)
Likes (0)
Hey there, the VIP feature is probably not necessary for your needs. It's mainly for if you have a VERY popular blog(s) and want to segment just those onto a different Physical db server.
Just move those blog tables back into c and comment out the vip line.
Responses (19)
Lead Developer (joined May 2009) Likes (0)
You now need to move your blog's db tables to the correct dbs using the move-blogs.php script (configure your db details in it first).
Member (joined May 2010) Likes (0)
i did and i still have the same error
check it yourself http://bloggydo.com/wp-content/scripts/move-blogs.php
Member (joined May 2010) Likes (0)
hey Aaron,
i just checked a sub blog and it seems to be working fine http://newborn.bloggydo.com/
it seems that the problem is for the main blog only!
PS: my vip1 db is empty
Thanks,
Moe!
Lead Developer (joined May 2009) Likes (0)
Can you paste a sample from the top of your db-config script? Just enough so we can see a bit of everything, we don't need the whole list of dbs. Be sure to blank out the passwords.
Member (joined May 2010) Likes (0)
<?php// Plugin Name: Multi-DB
// Plugin URI: http://premium.wpmudev.org/project/Multiple-Databases
// Author: Andrew Billits (Incsub)
// Version: 2.9.2
//------------------------------------------------------------------------//
//---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('85.92.83.', 'dc1');
//------------------------------------------------------------------------//
//---Global Tables--------------------------------------------------------//
//------------------------------------------------------------------------//
// Do not include default global tables
// Leave off base prefix (eg: wp_)
//
// 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,'localhost','localhost', 'bloggy_blogsglobal', 'user*****', 'password****');
add_db_server('0', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs0', 'user*****', 'password****');
add_db_server('1', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs1', 'user*****', 'password****');
add_db_server('2', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs2', 'user*****', 'password****');
add_db_server('3', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs3', 'user*****', 'password****');
add_db_server('4', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs4', 'user*****', 'password****');
add_db_server('5', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs5', 'user*****', 'password****');
add_db_server('6', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs6', 'user*****', 'password****');
add_db_server('7', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs7', 'user*****', 'password****');
add_db_server('8', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs8', 'user*****', 'password****');
add_db_server('9', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogs9', 'user*****', 'password****');
add_db_server('a', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogsa', 'user*****', 'password****');
add_db_server('b', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogsb', 'user*****', 'password****');
add_db_server('c', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogsc', 'user*****', 'password****');
add_db_server('d', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogsd', 'user*****', 'password****');
add_db_server('e', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogse', 'user*****', 'password****');
add_db_server('f', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogsf', 'user*****', 'password****');
add_db_server('vip1', 'dc1', 1, 1,'localhost','localhost', 'bloggy_blogsvip1', 'user*****', 'password****');
//------------------------------------------------------------------------//
//---VIP Blogs------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_vip_blog(BLOG_ID, DS)
// EX: add_vip_blog(1, 'vip1');
add_vip_blog(1, 'vip1');
?>
Lead Developer (joined May 2009) Likes (0)
Ok, what I thought. You defined your main blog as a vip blog, so you will need to move it's tables (starting with wp_1) to the vip db. I think they will be in the "c" table.
Or you can just comment out the line and leave it alone.
Member (joined May 2010) Likes (0)
yea i found wp_1_* in table c
i moved them all to vip1 and it is still not working,,,
but i really need to separate the main blog from other blogs
Thanks,
Moe!
Member (joined May 2010) Likes (0)
hey Aaron,
hope you still here and can help!
i'm sorry i know i'm asking alot, but it is my 2nd day with WPMU
Thanks,
Moe!
Founder & CEO (joined May 2007) Likes (0)
@moehassan as per the right hand side message it's a longt time past 5PM CST now so Aaron / Andrew will probably not be back on till tomorrow AM.
Member (joined May 2010) Likes (0)
@james Thank you James :) i appreciate your notice ... i was just waiting
i'm gonna have some rest and wait for Aaron ;)
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
Andrew/ James, can the install instructions be amended to suggest folks *NOT* do that? Or explain what the purpose of a VIP blog is?
Seems to be a common problem with many who install multidb.
Member (joined May 2010) Likes (0)
@aaron
yea i found wp_1_* in table c
i moved them all to vip1 and it is still not working,,,
but i really need to separate the main blog from other blogs
Thanks,
Moe!
Member (joined May 2010) Likes (0)
@aaron
are you there yet?!
Erstwhile founder (joined May 2007) Likes (0)
Hiya,
Which tables have you added to your vip db? Also, why do you need the main blog to be in it's own db?
Thanks,
Andrew
Member (joined May 2010) Likes (0)
hey Andrew,
WPMU is installed in bloggy_blogs
and i defined the bloggy_vip1 as the VIP DB.
why do i need my DB to be in a separate DB because my marketing plan for the site is big enough so i expect to have many users sooner.
PS: 16 DBs is just for test purpose once i install everything carefully and successfully i will move everything to the real domain with a fresh installation.
Thanks,
Moe!
Lead Developer (joined May 2009) Likes (0)
Hey there, the VIP feature is probably not necessary for your needs. It's mainly for if you have a VERY popular blog(s) and want to segment just those onto a different Physical db server.
Just move those blog tables back into c and comment out the vip line.
Member (joined May 2010) Likes (0)
Wow it works :)
i really don't know how to thank you but there is a BIG thank you guys
specially @aaron @andrew @james @drmike
i will get back to you soon ;) i have tons of questions moving around my head but i'm just doing things step by step ;)
Thanks,
Moe!
Lead Developer (joined May 2009) Likes (0)
Glad to hear it. As drmike said we should probably update the documentation about VIPs as it throws a lot of people off.
Founder & CEO (joined May 2007) Likes (0)
Yeh, Multi DB documentation is in serious need of updating!!!
WordPress Questions?
We've got answers!
Find out more »