WordPress.org

1. markb1439
   Member
   Posted 1 year ago #

   Hi,

   A couple of questions:

   1) The installation guide assumes that "your databases all have the same database server, user & password." Does the plugin also support distributing databases across multiple servers? If so, are there any additional instructions for achieving this? (I did purchase the guide as well.)

   2) Of course, databases only represent part of the data on WordPress blogs...there are also user uploads. Do you recommend or offer any solutions for scaling a multisite installation in this regard too (scaling/distributing the uploads)?

   Thanks,

   Mark

   http://wordpress.org/extend/plugins/shardb/

2. markb1439
   Member
   Posted 1 year ago #

   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

3. Ron Rennick
   MultiSite Guru
   Posted 1 year ago #

   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.

4. markb1439
   Member
   Posted 1 year ago #

   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...)

5. Ron Rennick
   MultiSite Guru
   Posted 1 year ago #

   The basic migration code has been in the dev version for almost 5 months: http://plugins.trac.wordpress.org/log/shardb/

   Since I made this change: http://plugins.trac.wordpress.org/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).

6. markb1439
   Member
   Posted 1 year ago #

   Thank you.

Topic Closed

This topic has been closed to new replies.