WordPress.org

Ready to get started?Download WordPress

Forums

Multiple database schemas or ONE database + multiple prefixes (9 posts)

  1. digitaldux
    Member
    Posted 8 years ago #

    I was wondering if someone tested the performance of multiple
    WordPress installations on one machine.

    The choices would be to use:
    1) Multiple database schemas
    2) ONE database + multiple prefixes

    I like the multiple database option, but have the feeling the
    second option has a better performance.

  2. mattman
    Member
    Posted 8 years ago #

    I was running 5 blogs from a single database with different prefixes due to hosting restrictions.

    I found that to run perfectly well.

    Depending on what in particular you are thinking about doing(if you are going to do something), have you looked at WordPressMU?

  3. dgstinner
    Member
    Posted 8 years ago #

    I also run 5 blogs using one database and different prefixes. It works perfectly fine for me.

  4. Kafkaesqui

    Posted 8 years ago #

    Aside from performance issues, note that if you have an interest in sharing resources between your blogs (say for example the user or link tables), it's far far easier to hack WordPress to do this when they're on the same database.

  5. FeiCai
    Member
    Posted 8 years ago #

    I am planning to run 2 blogs from a single database with different prefixes due to hosting restrictions. And I also want to share the user betwwen these two blogs. what should I do? Could someone help me?

  6. moshu
    Member
    Posted 8 years ago #

    1. Install WP in two different directories and in the wp-config.php file change the table prefix for the second. see http://codex.wordpress.org/Installing_Multiple_Blogs
    2. For sharing the users you'll have to find a hack or write some code - it doesn't work out of the box.

  7. Kafkaesqui

    Posted 8 years ago #

    FeiCai:

    http://wordpress.org/support/topic/42793?replies=8#post-240179

    You'll just need to modify the line for $wpdb->users.

  8. D9r
    Member
    Posted 8 years ago #

    Thank you Kafkaesqui! I had the same question.

  9. FeiCai
    Member
    Posted 8 years ago #

    Thank you Kafdaesqui!
    It's simple and it works! :)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags