Multiple Blogs in Single Database – Pros and Cons

  • I have an application for which I will need more than one WP blog. I understand that I can set this up using either a single MySql database with multiple WP tables, or in multiple WP databases. What are the pros and cons of the multiple table-single database versus the single tables in multiple databases options?

    Other than saving on the resource of database connections, is there a clear advantage or disadvantage to one strategy or the other?

    Thanks,

    -Danny.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Is it at all a security concern for users of one blog to have access to the tables of another blog? If so, then you might want to have multiple databases.

    Thread Starter dweiss

    (@dweiss)

    Actually, I’d prefer that users have access to both blogs without having to login more than once, if that is possible.
    – Danny.

    “I’d prefer that users have access to both blogs without having to login more than once’

    And that’s your answer, right there.

    Generally however, it’s preferrable to have multiple databases for exactly the reason of security and “isolation” of data. There are other benefits to having multiple databases like backups/restores and the obvious one of accidentally making changes to the “wrong” table.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Multiple Blogs in Single Database – Pros and Cons’ is closed to new replies.