- my question is what is the best development workflow? How can I best backup the multiple databases with Multi-DB installed? Or is it better/possible to use BackupBuddy, not install Multi-DB for the time being and add Multi-DB later (by which time, perhaps, BackupBuddy may be Multi-DB compatible)?
Like most of us, I'm hoping that the network I'm developing may prove very popular - therefore is there any reason not to install 4096 databases immediately? (I'm on bluehost)
And, is there any reason not to try to integrate WP-Networks or Networks+ into this setup? Anyone know whether they are compatible with Multi-DB and/or BackupBuddy?
- my question is what is the best development workflow? How can I best backup the multiple databases with Multi-DB installed? Or is it better/possible to use BackupBuddy, not install Multi-DB for the time being and add Multi-DB later (by which time, perhaps, BackupBuddy may be Multi-DB compatible)?
Like most of us, I'm hoping that the network I'm developing may prove very popular - therefore is there any reason not to install 4096 databases immediately? (I'm on bluehost)
And, is there any reason not to try to integrate WP-Networks or Networks+ into this setup? Anyone know whether they are compatible with Multi-DB and/or BackupBuddy?
You should really only go for 4096 if you believe the site is going to reach >1m sites. Edublogs has been going for years, is the second-largest Multisite on the web and only fairly recently reached that level so it's unlikely you will anytime soon. I'd advise starting small. If you get to the point where you need to increase you should be earning enough to pay for a DB guru to make the switch.
We've seen many issues with Networks+ and can't really support it I'm afraid because of the way it changes the fundamental set up of WP.
Thanks Phil - that's very helpful.
I'll take exactly that approach now..
One thing now clear in the installation instructions for the Multi-DB plugin is:
at the stage where one is creating the databases in phpmyadmin, does one enter the wpms database first, before selecting the "SQL" tab?
When I first enter phpmyadmin on my host, I see two databases listed on the left hand side as per the attached screenshot. I am able to click SQL on the top which presents an empty field. But presumably I need to be inside the xxx_wpms database first before this step?
Thanks Phil - in the end I discovered that bluehost does not allow root access, therefore sql script cannot function. Manually added, but a fail at the final hurdle which I have just posted up on a new post..
Just a note to others on bluehost thinking of using Multi-DB: be aware that when creating new databases (one-by-one, ouch!) via the wizard, that it seems to force one to create a new user for each new database. These users can subsequently be deleted via the SQL admin area, and one can assign main user to all: this will probably simplify the Multi-DB setup down the line..
Responses (8)
Sales & Support Pro — 24th January 2012 #
Hiya!
There are plugins (such as WP-DB-Backup) which just ask WordPress for the database tables available so that you can choose which to back up.
It might be that this will show all the Multi-DB tables without having to wait for any compatibility fix...
Thanks,
Phil
Member — 24th January 2012 #
Thanks Phil. I'll take a look at WP-DB-Backup as an interim solution.
Any clue on the two other issues, i.e. re 4096db, and Networks+ compatibility?
Sales & Support Pro — 24th January 2012 #
You should really only go for 4096 if you believe the site is going to reach >1m sites. Edublogs has been going for years, is the second-largest Multisite on the web and only fairly recently reached that level so it's unlikely you will anytime soon. I'd advise starting small. If you get to the point where you need to increase you should be earning enough to pay for a DB guru to make the switch.
We've seen many issues with Networks+ and can't really support it I'm afraid because of the way it changes the fundamental set up of WP.
Thanks
Member — 24th January 2012 #
Thanks Phil - that's very helpful.
I'll take exactly that approach now..
One thing now clear in the installation instructions for the Multi-DB plugin is:
at the stage where one is creating the databases in phpmyadmin, does one enter the wpms database first, before selecting the "SQL" tab?
When I first enter phpmyadmin on my host, I see two databases listed on the left hand side as per the attached screenshot. I am able to click SQL on the top which presents an empty field. But presumably I need to be inside the xxx_wpms database first before this step?
Sales & Support Pro — 24th January 2012 #
It actually doesn't matter where inside phpMyAdmin you execute the SQL - as long as you are logged in as the correct user it should work.
The only difference will be whether you see the newly created databases appear in the left hand bar.
Thanks
Member — 24th January 2012 #
Thanks Phil - in the end I discovered that bluehost does not allow root access, therefore sql script cannot function. Manually added, but a fail at the final hurdle which I have just posted up on a new post..
Sales & Support Pro — 25th January 2012 #
That's a shame, but good to know in case we get anybody else on Bluehost, so thanks for sharing!
Member — 25th January 2012 #
Just a note to others on bluehost thinking of using Multi-DB: be aware that when creating new databases (one-by-one, ouch!) via the wizard, that it seems to force one to create a new user for each new database. These users can subsequently be deleted via the SQL admin area, and one can assign main user to all: this will probably simplify the Multi-DB setup down the line..
Become a member