Multi-db, how to split into remote server

Using multi-db 3.2.4 to split db into different db’s under two different server.

eg:

first server: 127.0.0.1(local server contain wordpress multiste)

second server: 127.0.0.2 (remote server to split db)

first server contain my wordpress default db and site contents. Split db in First server within that server works fine. But i try to use both servers to split it gets error:

“Houston, we have a problem!

Looks like you need to create your new db’s! If you’re lucky, this link still works – click me

Database Error:”

Settings done:

db-config.php

add_db_server(‘global’, ‘dc1′, 1, 1,’127.0.0.2′,’127.0.0.1’, ‘db_global’, ‘sam’, ‘123’:wink:;

add_db_server(‘0’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_0’, ‘sam’, ‘123’:wink:;

add_db_server(‘1’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_1’, ‘sam’, ‘123’:wink:;

add_db_server(‘2’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_2’, ‘sam’, ‘123’:wink:;

add_db_server(‘3’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_3’, ‘sam’, ‘123’:wink:;

add_db_server(‘4’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_4’, ‘sam’, ‘123’:wink:;

add_db_server(‘5’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_5’, ‘sam’, ‘123’:wink:;

add_db_server(‘6’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_6’, ‘sam’, ‘123’:wink:;

add_db_server(‘7’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_7’, ‘sam’, ‘123’:wink:;

add_db_server(‘8’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_8’, ‘sam’, ‘123’:wink:;

add_db_server(‘9’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_9’, ‘sam’, ‘123’:wink:;

add_db_server(‘a’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_a’, ‘sam’, ‘123’:wink:;

add_db_server(‘b’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_b’, ‘sam’, ‘123’:wink:;

add_db_server(‘c’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_c’, ‘sam’, ‘123’:wink:;

add_db_server(‘d’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_d’, ‘sam’, ‘123’:wink:;

add_db_server(‘e’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_e’, ‘sam’, ‘123’:wink:;

add_db_server(‘f’, ‘dc1′, 1, 1,’1270.0.2′,’127.0.0.1’, ‘db_f’, ‘sam’, ‘123’:wink:;

move-blogs.php

$dbname = “db”;

$blog_table_prefix = ‘wp_’;

$newdb_prefix = ‘db_’

$dbhost = ‘127.0.0.1’;

$dbuname = ‘sam’;

$dbpass = ‘123’;

Is there any mistake? otherwise give me a solution to split db into both remote server and local server too.

  • aristath
    • Recruit

    Hello there @taylor, I hope you’re well today!

    First of all, I think there’s a typo there…

    1270.0.2 should be 127.0.0.2 (there’s a missing dot).

    Also, if this is not on the same server but on a different machine you’ll probably need to configure the port as well, so 127.0.0.2 should be 127.0.0.2:3306 (or whatever other port you’re using).

    I hope that helps!

    Cheers,

    Ari.

  • Taylor
    • Flash Drive

    Hi,

    Thanks for your reply.

    Actually the problem seems in move-blogs.php like:

    "Houston, we have a problem!

    Looks like you need to create your new db's! If you're lucky, this link still works – click me

    Database Error: Unknown database 'tblog_d'"

    means that actual WP db's are in main server, but the new db's created on remote server(ie. tblog_d).

  • Ash
    • WordPress Hacker

    Hello @taylor

    I hope you are well today.

    I am tagging an available developer from second level support line in this thread for his valuable opinion on this issue. Please note that, developer response might be slower than usual staff response, so we appreciate your patience on this.

    Cheers

    Ash

  • Ash
    • WordPress Hacker

    Hello @taylor

    I hope you are well today.

    I am sorry for the delay, somehow this thread is slipped from my feed :slight_frown:

    I have talked to the SLS developer and this is something that we can’t offer in our support package, I am afraid. You may need to hire a developer to do this. Also, if you need to customise this then you can post a job in our job board where you can hire a developer to assist further: https://premium.wpmudev.org/wpmu-jobs/ Please note that, no WPMU official staffs are allowed to work in the job board.

    Cheers

    Ash

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.