New to the community? Start here

Multi-DB config terms

I’m want to install multi-db to add 16 databases, but I’m not quite sure what some of the terms in the db-config.php file mean.

What am I setting here, and what values will I be looking to add?

add_dc_ip('123.123.123.', 'dc1');

What is this table for? What is the table for? (Hints needed for naming)

add_global_table('some_global_table');

Do I modify this, and what do I modify?

add_db_server('global', 'dc1', 1, 1,'64.120.23.72','192.168.0.101',

'wpmu_global', 'db_user_name', 'db_user_name_pass');

How about this? Do I leave it as is?

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');

What is this?

add_vip_blog(1, 'vip1');

Thanks,

Kirk

Sat, 8 May 2010 18:42:35
  • Andrew
    • Champion of Loops

    Hiya,

    add_dc_ip(‘123.123.123.’, ‘dc1’:wink:;

    This is your service ip.

    add_global_table(‘some_global_table’:wink:;

    Any and all global plugin tables need to be defined in wp-config.php. You need to add the table name minus the prefix. So “site_posts” instead of “wp_site_posts”. All of our plugins that have global tables come with an sql.txt file. For other plugins you’ll need to look through the code to figure out if they have any global tables.

    Do I modify this, and what do I modify?

    Erm, yeah you need to modify that. Give this a read:

    http://bavatuesdays.com/wpmu-multi-db-tutorial/

    How about this? Do I leave it as is?

    I’d just comment out that bit and ignore it.

    What is this?

    Comment out and ignore that bit as well.

    Note that Multi-DB is definitely one of our most advanced offerings. If you’re not really comfortable with PHP and MySQL then you may want to consider hiring someone to install Multi-DB for you. Also unless you plan on your site getting rather large I wouldn’t worry with Multi-DB.

    Thanks,

    Andrew

  • Kirk Ward
    • Syntax Hero

    edit: Moved to the Multi-DB subforum

    Sorry … didn’t see the Multi-DB sub-forum.

    If you’re not really comfortable with PHP and MySQL then you may want to consider hiring someone to install Multi-DB for you.

    I’m in a range where I can comprehend it, and I’m not scared of it. My ego isn’t so great I’m afraid of going out and hiring someone. I just like to go through things and understand them.

    And, since the site under development is so new, it gives me a chance to learn. I am at the stage where I can wipe the whole thing out and start over if need be.

    Thanks,

  • drmike
    • DEV MAN’s Mascot

    Sorry … didn’t see the Multi-DB sub-forum.

    It’s not an issue. I know on some forums, they request the mods to make such an announcement when they do such a thing. Never been clear about here.

    Gotta admit that if you;re planning any expansion on this site, I;d go with 256. There really isn;t an upgrade path for 16 -> 256.

  • Kirk Ward
    • Syntax Hero

    Gotta admit that if you;re planning any expansion on this site, I;d go with 256

    That may be a good idea. This is for someone who said I could learn on his time. He is a promoter and this could grow. I know he has a minimum of 40,000 on his email list.