WordPress.org

Forums

[resolved] Multisite Databases (17 posts)

  1. woolfcom
    Member
    Posted 1 year ago #

    Can I run a separate database using the Multi-site set up?

    So one database per sub site?

  2. I don't think so. Multisite uses one database for all the sites.

    If you want to use separate databases for each site, why not just set them up as separate sites?

    If you are thinking that it will be easier to manage plugin/theme updates in one dashboard, then just look at something like Manage WP instead. https://managewp.com/

  3. woolfcom
    Member
    Posted 1 year ago #

    Yes.Thanks.

    It is the management of the admin from one dashboard which is the biggest issue.

    Is there another plugin which allows you to manage the content between the multisites?

    Or perhaps easy to switch between admin panels simply [without having to log out and log in elsewhere?

  4. Please note: Multisite is multiple separate sites. Not 'One big site with children I can control from one admin panel.' So you should keep that in mind.

    You CAN split up the DB, but there's no point, since the tables are separate anyway.

    Is there another plugin which allows you to manage the content between the multisites?

    No, you're supposed to go to each site to manage it's content. You don't have to logout and login, just click on the site from the sites dropdown and you're in. If you have to re-login in, then it's a cookie issue.

  5. woolfcom
    Member
    Posted 1 year ago #

    "Is there another plugin which allows you to manage the content between the multisites?"

    The point of splitting the databases is an vital one, since I have limited space per database and WANT to have separate database per each site.

    - In which case how do I run each site on separate databases?
    - Can I add multisite capability to an existing single site?
    - Is there somewhere I can get this uploaded/enabled automatically?

    Presumably, if I run each sub site in sub directories to the root - then each site is entirely standalone in all but admin panel?

  6. How small a DB are we talking?

    You may need a new host then if that's your predicament, because the tools you need to split the DB will still require a sizable DB.

    Alternately you can read http://markjaquith.wordpress.com/2012/05/26/wordpress-skeleton/ and try doing a WP skeleton project, but neither that nor Multisite is what I would call easy.

  7. woolfcom
    Member
    Posted 1 year ago #

    1 gig each max.

    When you say "split" - I want to run each sub site of the multi site on SEPARATE databases.

    How would that be possible [is it?]

  8. Oh heck, 1 GIG for a DB?

    You're fine on Multisite with one DB for a while. And by a while what I mean is years, unless you're a site letting everyone sign up and spam away with no moderation.

    I work for a Webhost, and I've seen some massive sites out there. I've yet to see a WP site go over 500megs. Heck I have a forum thats less than a Gig :)

  9. woolfcom
    Member
    Posted 1 year ago #

    My sites is a classifieds [a large one].

    It hosts a large amount of images.

    One site already has 300 meg used and it is only just getting going.

    To repeat the question - How would I run separate databases?

  10. Well. You will hate this.

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

    http://wordpress.org/plugins/hyperdb/

    Good luck man, but I think your best fix is a host that doesn't limit you like that.

  11. woolfcom
    Member
    Posted 1 year ago #

    yeah I hear you....and I am being tight budgetarily until the moment it is economically viable to get a larger database.....the project needs to be scalable without headache migrations....

    It is one of the downsides of hosting with GoDaddy - but in all the years we have used them - you can't tell 'em see!

  12. You still might want to checkout something like MangeWP -- which will let you not only manage the admin of all your separate, single installs on one dashboard, but let you post content and install plugins to multiple sites. That's going to be WAY simpler than SharDB.

    And you can always migrate single installs INTO a multisite once you scale the project.

  13. woolfcom
    Member
    Posted 1 year ago #

    yes....I will evaluate the build out programme...

    thanks for the heads up....

  14. http://support.godaddy.com/help/article/1482/do-you-limit-mysql-databases-size

    Huh. I did not know that.

    Running a Multisite, a LARGE one, on a budget is grounds for insanity :/ You're going to have to be on a VPS at the very least by the way.

  15. woolfcom
    Member
    Posted 1 year ago #

    Running a multisite which will grind to halt when the money runs out due to poor planning on budgeting is grounds for stupidity....touche!

    But yes on the VPS, but their database scale up charges are such a big jump its not funny....

    It is one of the downsides of hosting with GoDaddy - but in all the years we have used them - you can't tell 'em see!

  16. I try not to call things stupid :) I find people stop listening ;)

    It may be a fair idea to point out to them that the added complexity of this process may cost them more in manhours for dev and support than the freakin' DB would.

  17. woolfcom
    Member
    Posted 1 year ago #

    ta

Topic Closed

This topic has been closed to new replies.

About this Topic