3 points
Community rank #10036
Pratap Kumar Singh
NewbieJust Getting Started
MemberLikes (0)
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
82 pointsCommunity rank #660El PresidenteJust Getting Started
Member
(joined March 2008)
Likes (0)
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.
6593 pointsCommunity rank #9Supreme DeityMember of the MonthLifetime member
Keeper of the Dark Chocolate
(joined July 2007)
Likes (0)
Are you sure that server 1 can see server 2 via the mysql port, 3306? if you have any sort of firewall between the 2 boxes, you have to open it up on the mysql port.
13 pointsCommunity rank #4246SophomoreJust Getting Started
Member
(joined August 2008)
Likes (0)
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'); //Old MySQL-server.
add_dc_ip('79.125.2.', 'dc2'); //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');
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?
7430 pointsCommunity rank #6Supreme DeityMember of the MonthLifetime member
Erstwhile founder
(joined May 2007)
Likes (0)
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?
13 pointsCommunity rank #4246SophomoreJust Getting Started
Member
(joined August 2008)
Likes (0)
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.
239 pointsCommunity rank #211ExpertGunning for gold!
Member
(joined March 2008)
Likes (0)
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.
1002 pointsCommunity rank #58Supreme DeityWPMU DEV StaffLifetime member
Founder & CEO
(joined May 2007)
Likes (0)
Hiya, Andrew's off at the moment but I'm 98% that this version is ready for you to use - if you have any problems let us know (email is ok) and we'll get it sorted.
8421 pointsCommunity rank #4Supreme DeityWPMU DEV StaffLifetime member
Lead Developer
(joined May 2009)
Likes (0)
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.
239 pointsCommunity rank #211ExpertGunning for gold!
Member
(joined March 2008)
Likes (0)
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.
6723 pointsCommunity rank #8Supreme DeityWPMU DEV StaffLifetime member
Developer
(joined June 2008)
Likes (0)
@stergatu - do you want to post the changes you make to the plugin here and then I can check if they are in the current version of the multi-db for you?
239 pointsCommunity rank #211ExpertGunning for gold!
Member
(joined March 2008)
Likes (0)
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.
239 pointsCommunity rank #211ExpertGunning for gold!
Member
(joined March 2008)
Likes (0)
Barry, you can download the files from http://www.patridamou.gr/multidbLena.zip.
I'm getting a [denied mime] error when I'm trying to upload them to the previous posts.
239 pointsCommunity rank #211ExpertGunning for gold!
Member
(joined March 2008)
Likes (0)
Barry, the 3.0 version of the multidb plugin is working fine with the many servers and I didn't have to do any changes in order to upgrade from 2.9.2 to 3.0.1.
Thanks for everything and keep up the good work.
Lena
63 pointsCommunity rank #880El PresidenteJust Getting Started
Member
(joined July 2009)
Likes (0)
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'); //Old MySQL-server.
add_dc_ip('79.125.2.', 'dc2'); //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');
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?
Responses (26)
Member (joined September 2008) Likes (0)
Please support we need urgent help on this
Member (joined January 2008) Likes (0)
Andrew is aware of this as I mentioned this earlier in the week and he said he was looking at it.
Trent
Erstwhile founder (joined May 2007) Likes (0)
Yep, this is still on my list. We're just a bit swamped at the moment.
Thanks,
Andrew
Member (joined March 2008) Likes (0)
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.
Erstwhile founder (joined May 2007) Likes (0)
It's still a known bug. It's top of the list to be fixed in the next major version.
Thanks,
Andrew
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
Are you sure that server 1 can see server 2 via the mysql port, 3306? if you have any sort of firewall between the 2 boxes, you have to open it up on the mysql port.
Erstwhile founder (joined May 2007) Likes (0)
Nah, it's a legit bug.
Thanks,
Andrew
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
Oh, sorry.
Works fine on our 2 box install but we're doing the primary dbs on the second box without any fallover.
Member (joined April 2009) Likes (0)
Any idea when this will be fixed? should not be a big deal right, since you guys must be using multiple DB servers on edublogs and blogs.mu
Will appreciate if you can take a look.
Cheers,
Sam
Erstwhile founder (joined May 2007) Likes (0)
Hiya,
We'll post here when a new version is available.
Thanks,
Andrew
Member (joined August 2008) Likes (0)
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'); //Old MySQL-server.
add_dc_ip('79.125.2.', 'dc2'); //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');
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?
Erstwhile founder (joined May 2007) Likes (0)
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
Member (joined August 2008) Likes (0)
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
Erstwhile founder (joined May 2007) Likes (0)
Hiya,
That's what I would do for now.
Thanks,
Andrew
Member (joined March 2008) Likes (0)
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
Member (joined March 2008) Likes (0)
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
Founder & CEO (joined May 2007) Likes (0)
Hiya, Andrew's off at the moment but I'm 98% that this version is ready for you to use - if you have any problems let us know (email is ok) and we'll get it sorted.
Lead Developer (joined May 2009) Likes (0)
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.
Member (joined March 2008) Likes (0)
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
Developer (joined June 2008) Likes (0)
@stergatu - do you want to post the changes you make to the plugin here and then I can check if they are in the current version of the multi-db for you?
Member (joined March 2008) Likes (0)
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
Member (joined March 2008) Likes (0)
Barry, you can download the files from http://www.patridamou.gr/multidbLena.zip.
I'm getting a [denied mime] error when I'm trying to upload them to the previous posts.
Thanks again
Lena
Member (joined March 2008) Likes (0)
Barry, the 3.0 version of the multidb plugin is working fine with the many servers and I didn't have to do any changes in order to upgrade from 2.9.2 to 3.0.1.
Thanks for everything and keep up the good work.
Lena
Developer (joined June 2008) Likes (0)
@stergatu - good to know :) I did rewrite / tidy up that part for that release but it's good to have it confirmed.
Member (joined July 2009) Likes (0)
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'); //Old MySQL-server.
add_dc_ip('79.125.2.', 'dc2'); //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');
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?
Founder & CEO (joined May 2007) Likes (0)
Hi Sam, please can you post this as a new thread, the plugin has been comprehensively updated since this thread was last put up.
Thanks for viewing this post but this topic has been closed to new replies.
Become a member