New to the community? Start here

MUltiDb not accessing multiple servers

We need urgent support…

We have installed the plugin for multiple databases and on different servers..Now what is happening here is although we have made the required entries in db-list.php and db-config.php but somehow the code is still not accessing it from different servers..its always going to one server ..Please let us know the possible solution for the same urgently..Your help will be appreciated a lot

Wed, 10 Sep 2008 7:32:40
  • ZappoMan
    • Design Lord, Child of Thor

    Did this issue ever get fixed or addressed?

    I just started to try to use this feature (placing the db’s in different servers) and I am getting similar behavior. I’m not sure if I’ve got the configuration wrong or if this is a bug or a not yet implemented feature.

    The behavior I’m seeing is that basically no matter what I list for host or lhost all DB access seems to go through the “first” dbhandle, which always points to the first server.

    I just downloaded all of the revisions of this plugin and I don’t see any changes to the code near this general section, e.g. db_connect().

    FYI, I just renewed my Premium subscription for a year hoping that I’d get an update that fixes this problem or some support on what I might be doing wrong.

    Thanks.

  • Mats
    • WPMU DEV Initiate

    Is there no fix for this yet?

    I’m getting the same problem as described above with Multi-DB 2.8.5 and WPMU 2.8.6

    I have a 4096 database setup with the following 2 datacenters added in db-config.php:

    add_dc_ip(‘85.118.206.’, ‘dc1’:wink:; //Old MySQL-server.

    add_dc_ip(‘79.125.2.’, ‘dc2’:wink:; //New MySQL-server.

    I’ve created the database blog_ecc on the new MySQL-server at IP 79.125.2.179 and copied all the tables from the old MySQL-server.

    I changed the old add_db_server for database blog_ecc to:

    add_db_server(‘ecc’, ‘dc2′, 1, 1,’79.125.2.179′,’79.125.2.179’, ‘blog_ecc’, ‘blog_user’, ‘pass’:wink:;

    It seemed to work at first, but I then renamed the database /var/lib/mysql/blog_ecc to /var/lib/mysql/blog_ecc_old on the old MySQL-server and tried to access a blog on that database. I then got the message:

    “The blog you have requested is not installed properly. Please contact the system administrator.”, which shows it still tried to connect to the old MySQL-server database.

    Is there anything I’ve missed?

    There are just 2 places to do changes in db-config.php (the new add_dc_ip and the edited add_db_server), right?

  • Andrew
    • Champion of Loops

    Hiya,

    Multi-DB is on our priority list for early 2010.

    As for you’re particular problem, I’m really not sure I understand what you’re trying to do. Are you trying to use Multi-DB to help you migrate from one db server to another?

    Thanks,

    Andrew

  • Mats
    • WPMU DEV Initiate

    Hi Andrew!

    I’m trying to transfer some databases for blogs that have a lot of visitors from the old server to a new one in order to get the load down on the old server.

    Or maybe I should transfer all databases to the new server?

    There will be a point in time when one MySQL-server won’t be enough to handle the load, so it would be great to have the problem solved.

    Anyway, thanks for a great script! I recently moved 37000+ blogs from 1 to 4096 databases and it worked just fine.

    Thanks,

    Jack

  • stergatu
    • Site Builder, Child of Zeus

    Hi, Andrew.

    I need to make a major upgrade from 1.3.3. to wp3.0 having 16 databases in 4 servers.

    Did you have a fix for the issue with the multiple DB servers which I can use with the 1.0.1 multidb plugin?

    Thanks in advance

    Lena

  • stergatu
    • Site Builder, Child of Zeus

    Hi again,

    Andrew, you said that “Multi-DB is on our priority list for early 2010.”

    That means that you have fixed it already?

    I have made a small hack on the code in order to process with the upgrade, but it would be great is you can tell us in which version of multidb is it fixed or if we have to wait.

    Thanks in advance

    Lena

  • Aaron
    • Ex Staff

    We’ve released an update for almost every WP version. You are WAY behind, so I don’t know that a straight upgrade will work for you. You may need to go 1 or 2 WP + corresponding multi-db versions at a time untill you finally get to 3.0.

    Of course no harm in trying it straight off first as long as you’re ready to restore from your backup.

  • stergatu
    • Site Builder, Child of Zeus

    Thanks James and Aaron for the quick response.

    But my problem is that multidb plugin (in every version I used so far) doesn’t work if the databases are spread in more than 1 database server, as Pratap Kumar Singh and Zappo Man saying in their posts and not how to get to wp3.0.

    So I have to mess with the multidb plugin’s code (in every corresponding version I used so far) in order to make it work and do my upgrades (now at wpmu2.7.5 version and still have upgrades to do).

    My question is if this problem is fixed in any newer version multidb plugin, in order to use it “as it is” and don’t mess with its code.

    Thanks in advance

    Lena

  • stergatu
    • Site Builder, Child of Zeus

    That’s great!!

    Thanks Barry.

    I attached both files of 2.8 version ( Maybe I do something wrong in the db-config.php file).

    My changes are in the &db_connect function of the db.php file(Look for the comment word eleni).

    They are ugly but worked for me, for upgrading from 1.3 to 1.5, 2.6, 2.7.1 and 2.8.6 untill now.

    I hope in the plugin version for 2.9 and 3.0 you have fixed the issue, cause I pretty sure that my changes aren’t the right way to do it.

    Thanks again Barry.

    Bests

    Lena

  • hwong
    • Design Lord, Child of Thor

    I’m having this problem with version 3.02. I must still have the old global database in the old server when i shifted to two servers

    Sam

    jackboulinMember

    Reputation:13+

    Posted on 28th December 2009 (11 months ago) #

    Is there no fix for this yet?

    I’m getting the same problem as described above with Multi-DB 2.8.5 and WPMU 2.8.6

    I have a 4096 database setup with the following 2 datacenters added in db-config.php:

    add_dc_ip(‘85.118.206.’, ‘dc1’:wink:; //Old MySQL-server.

    add_dc_ip(‘79.125.2.’, ‘dc2’:wink:; //New MySQL-server.

    I’ve created the database blog_ecc on the new MySQL-server at IP 79.125.2.179 and copied all the tables from the old MySQL-server.

    I changed the old add_db_server for database blog_ecc to:

    add_db_server(‘ecc’, ‘dc2′, 1, 1,’79.125.2.179′,’79.125.2.179’, ‘blog_ecc’, ‘blog_user’, ‘pass’:wink:;

    It seemed to work at first, but I then renamed the database /var/lib/mysql/blog_ecc to /var/lib/mysql/blog_ecc_old on the old MySQL-server and tried to access a blog on that database. I then got the message:

    “The blog you have requested is not installed properly. Please contact the system administrator.”, which shows it still tried to connect to the old MySQL-server database.

    Is there anything I’ve missed?

    There are just 2 places to do changes in db-config.php (the new add_dc_ip and the edited add_db_server), right?