WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Multisite installation with separate databases (10 posts)

  1. crick
    Member
    Posted 2 years ago #

    For installation wordpress multi sites with separate databases on subdomain work the same guide to create a network?
    thanks to help

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

    But you really don't need to. The point is to use one database.

  3. danhgilmore
    Member
    Posted 2 years ago #

    I run multisite with over 14K blogs on one database. Is there a reason you HAVE to do multi-db?

  4. John
    Member
    Posted 2 years ago #

    Purely a performance concern, Dan. I have heard references to a maximum number of tables in Mysql, but if such a limit exists, the odds are that your ability to extract data from the db would have imploded already.

  5. crick
    Member
    Posted 2 years ago #

    ok ,thanks to all

  6. Depends on teh size. WordPress.com uses multiple DBs, but ... they're at like 30,000,000 or something obscene.

  7. John
    Member
    Posted 2 years ago #

    We run multi-db with 16 databases because we may scale to >50,000 sites and would rather not have to split databases when we are staring down the barrel of a gun.

  8. John - That's a pretty tough call to make ;) Most people won't be doing 50k, so we only have to consider it when we get big.

  9. I have heard references to a maximum number of tables in Mysql, but if such a limit exists,

    That reference actually revers to the 32K limits of folders within Linux directories. In theory, people are referring to this and how many files and folders the flat sql files take up.

  10. crick
    Member
    Posted 2 years ago #

    I change my host to a new host with wildcard support.Thanks to all

Topic Closed

This topic has been closed to new replies.

About this Topic