An additional question:
I believe that this plugin is intended for scaling an existing multisite installation. However, if I’m just starting a new installation and want to go ahead and utilize multiple databases (to prevent this scaling/migration later), is this advisable?
If so, what is the recommended procedure?
Thanks,
Mark
As a general note, unless you have some poorly written plugins, you will be scaling to multiple web servers, load balancers, caching, etc. long before you need to scale to multiple DB servers.
1) yes, you can configure SharDB per DB, so each DB has it’s own DB connection info. There are brief instructions in db-settings.php for doing that.
2) Not at this time. It’s on the list as something that I might do in the future. This would require server scripting as well as a plugin for WP.
3) The migration script takes about 15 minutes per 1000 sites. I would not implement SharDB until I had at least 50 sites/blogs.
Thanks. Is the migration usually pretty trouble free? (I know you can’t account for user error at my end, but I mean in general…)
The basic migration code has been in the dev version for almost 5 months: http://plugins.trac.ww.wp.xz.cn/log/shardb/
Since I made this change: http://plugins.trac.ww.wp.xz.cn/browser/shardb?rev=357978, it’s worked for everyone who has used it (as far as I know).
The migration script does not do anything to your original DB. So, the worst case is you have to switch back to the original and fix whatever issue you have (ex. DB user doesn’t have permissions on one of the DBs).
