3 pointsGetting my WPMU DEV WingsI'm new here
Pratap Kumar Singh
Member
—
10th September 2008 (3 years ago)
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
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
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 pointsLike some sort of WPMU DEV GodExceptionally helpfulLifetime member
Keeper of the Dark Chocolate
—
8th May 2009 (3 years ago)
#
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.
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 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Erstwhile founder
—
29th December 2009 (2 years ago)
#
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?
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.
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.
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.
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.
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.
@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?
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.
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.
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
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 — 10th September 2008 (3 years ago) #
Please support we need urgent help on this
Member — 10th September 2008 (3 years ago) #
Andrew is aware of this as I mentioned this earlier in the week and he said he was looking at it.
Trent
Erstwhile founder — 10th September 2008 (3 years ago) #
Yep, this is still on my list. We're just a bit swamped at the moment.
Thanks,
Andrew
Member — 8th May 2009 (3 years ago) #
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 — 8th May 2009 (3 years ago) #
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 — 8th May 2009 (3 years ago) #
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 — 8th May 2009 (3 years ago) #
Nah, it's a legit bug.
Thanks,
Andrew
Keeper of the Dark Chocolate — 9th May 2009 (3 years ago) #
Oh, sorry.
Works fine on our 2 box install but we're doing the primary dbs on the second box without any fallover.
Member — 1st June 2009 (2 years ago) #
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 — 1st June 2009 (2 years ago) #
Hiya,
We'll post here when a new version is available.
Thanks,
Andrew
Member — 28th December 2009 (2 years 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?
Erstwhile founder — 29th December 2009 (2 years ago) #
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 — 29th December 2009 (2 years ago) #
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 — 29th December 2009 (2 years ago) #
Hiya,
That's what I would do for now.
Thanks,
Andrew
Member — 26th July 2010 (1 year ago) #
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 — 28th July 2010 (1 year ago) #
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 — 29th July 2010 (1 year ago) #
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 — 29th July 2010 (1 year ago) #
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 — 29th July 2010 (1 year ago) #
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 — 29th July 2010 (1 year ago) #
@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 — 29th July 2010 (1 year ago) #
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 — 29th July 2010 (1 year ago) #
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 — 30th July 2010 (1 year ago) #
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 — 30th July 2010 (1 year ago) #
@stergatu - good to know :) I did rewrite / tidy up that part for that release but it's good to have it confirmed.
Member — 7th December 2010 (1 year ago) #
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 — 7th December 2010 (1 year ago) #
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