New to the community? Start here

A bit help needed with setting up Multi-DB

Hello everyone

Finally I decided to use your Multi-DB plugin. I’m not a pro but I did my best to understand the whole procedure.

Can you, please, review my description and tell me if I did something stupid before I run this on live site? I’m afraid to break my site so I thought I’ll ask here first…

I decided to go with 16 databases option.

I’m on HSphere server if this matters.

First of all I created 18 databases.

Interesting thing here is that HSphere creates database names using account username, and it won’t allow a second underscore in database names. So I ended up with the following databases:

user_wpmu0

user_wpmu1

…

user_wpmuf

user_wpmuglobal

user_wpmuvip1

Now I started configuring move-blogs.php

//DB Settings

$dbname = “user_wpmu”; – my old WPMU database name here, right?

$blog_table_prefix = ‘wp_’; – I don’t change anything here, right?

$newdb_prefix = ‘user_’; – I’m stuck here. Based upon the list of DBs above, can you tell me if I should type in ‘user_’ or something else?

//We need info to connect to the databases

$dbhost = ‘localhost’; – my database server, I can also type 127.0.0.1 right?

$dbuname = ”; – username of old DB or of new DBs I have created?

$dbpass = ”; – same question as above: pass to old DB or to new DBs?

After this I switch to db-config.php

Here is what I typed in.

add_dc_ip(‘127.0.0.1’, ‘dc1’:wink:; – I guess it’s correct

add_global_table(‘user_wpmuglobal’:wink:; – is this correct?

add_db_server(‘global’, ‘dc1′, 1, 1,’127.0.0.1′,’127.0.0.1’, ‘wpmuglobal’, ‘user’, ‘pass’:wink:; – I use users and passes of new DBs here and below

add_db_server(‘0’, ‘dc1′, 1, 1,’127.0.0.1′,’127.0.0.1’, ‘wpmu0’, ‘user’, ‘pass’:wink:;

add_db_server(‘1’, ‘dc1′, 1, 1,’127.0.0.1′,’127.0.0.1’, ‘wpmu1’, ‘user’, ‘pass’:wink:;

…

add_db_server(‘f’, ‘dc1′, 1, 1,’127.0.0.1′,’127.0.0.1’, ‘wpmuf’, ‘user’, ‘pass’:wink:;

add_db_server(‘vip1’, ‘dc1′, 1, 1,’127.0.0.1′,’127.0.0.1’, ‘wpmuvip1’, ‘user’, ‘pass’:wink:;

Main question about above settings. Should there be ‘wpmu0 … wpmuf’ or ‘user_wpmu0 … user_wpmuf’ used?

That’s it. I don’t want to move main blog into separate DB so I guess I may exclude everything with wpmuvip1. Or should I leave it?

Now my understanding is that I upload db.php and db-config.php files into /wp-content/, move-blogs.php into /wp-content/scripts/ and run http://mysite.com/wp-content/scripts/move-blogs.php from my browser.

Is this all or have I missed something?

Let me know, please :slight_smile:

Thu, 16 Apr 2009 13:30:16
  • Andrew
    • Champion of Loops

    I’m stuck here. Based upon the list of DBs above, can you tell me if I should type in ‘user_’ or something else?

    It would be: user_wpmu

    my database server, I can also type 127.0.0.1 right?

    I’d leave it as localhost. Although the 127.0.0.1 should do just fine.

    username of old DB or of new DBs I have created?

    New databases

    same question as above: pass to old DB or to new DBs?

    New databases

    add_dc_ip(‘127.0.0.1’, ‘dc1’:wink:; – I guess it’s correct

    This needs to be your actual server IP. Ask your host if you don’t know it. Let’s say it’s 99.99.99.99, you would configure it like:

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

    add_global_table(‘user_wpmuglobal’:wink:; – is this correct?

    That section is for global plugin tables. For example, if you’re using the Post Indexer plugin:

    add_global_table(‘site_posts’:wink:;

    Should there be ‘wpmu0 … wpmuf’ or ‘user_wpmu0 … user_wpmuf’ used?

    Yep, you need to use the full db name.

    I don’t want to move main blog into separate DB so I guess I may exclude everything with wpmuvip1. Or should I leave it?

    Comment out the VIP lines.

    Is this all or have I missed something?

    I think you’ve covered all of the areas where people get stuck.

    Thanks,

    Andrew

  • idealizer
    • WPMU DEV Initiate

    Thank you very much Andrew.

    Two more questions – maybe silly ones – but I’m not sure about them.

    1. How do I get the list of global tables?

    I suppose I should go into PHPMyAdmin and see what tables do not have wp_x_ prefix and these will be global and I should include them all. Am I right?

    What about databases with wp_ prefix? Like wp_blogs and so on. Are they global?

    2. In my case how many databases in total do I need?

    Before I have counted 16 user_wpmu0 … user_wpmuf plus user_wpmuglobal and user_wpmuvip1 – so 18 in total.

    But if I’m not moving main blog to separate DB I don’t need user_wpmuvip1

    And based on your comment above I don’t need user_wpmuglobal

    So looks like I only need 16 user_wpmu0 … user_wpmuf and I remove lines:

    add_db_server(‘global’, ‘dc1′, 1, 1,’127.0.0.1′,’127.0.0.1’, ‘wpmuglobal’, ‘user’, ‘pass’:wink:;

    add_db_server(‘vip1’, ‘dc1′, 1, 1,’127.0.0.1′,’127.0.0.1’, ‘wpmuvip1’, ‘user’, ‘pass’:wink:;

    Is this correct?

    Thank you for your support! You are great.

  • Andrew
    • Champion of Loops

    Hiya,

    1. How do I get the list of global tables?

    I suppose I should go into PHPMyAdmin and see what tables do not have wp_x_ prefix and these will be global and I should include them all. Am I right?

    All of our plugins should come with an sql.txt. Just grab the table names from there. Also:

    1) Always remove the prefix “wp_”

    2) Do not list default wpmu global tables (wp_blogs, wp_users, etc)

    2. In my case how many databases in total do I need?

    Before I have counted 16 user_wpmu0 … user_wpmuf plus user_wpmuglobal and user_wpmuvip1 – so 18 in total.

    But if I’m not moving main blog to separate DB I don’t need user_wpmuvip1

    Correct, you won’t need the vip table.

    And based on your comment above I don’t need user_wpmuglobal

    You need the global db. That’s where your global tables go.

    Thanks,

    Andrew

  • idealizer
    • WPMU DEV Initiate

    Good, looks like I’m understanding it!

    All of our plugins should come with an sql.txt. Just grab the table names from there.

    Yeah, got it.

    I also meant global tables that can come from other – not your premium – plugins.

    Very good, so wp_x_ tables are never global, WPMU’s standard (default) tables (like wp_users) are not taken into consideration and if some plugin adds a table like wp_something I list something as a global table.

    Thank you Andrew.