WordPress.org

Support

Support » Plugins and Hacks » SharDB » [Resolved] [Plugin: SharDB] Multiple Servers?

[Resolved] [Plugin: SharDB] Multiple Servers?

  • 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/

Viewing 5 replies - 1 through 5 (of 5 total)
  • 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

    Plugin Author Ron Rennick

    @wpmuguru

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

    Plugin Author Ron Rennick

    @wpmuguru

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

    Thank you.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Resolved] [Plugin: SharDB] Multiple Servers?’ is closed to new replies.
Skip to toolbar