WordPress.org

Ready to get started?Download WordPress

Forums

SharDB or HyperDB? (3 posts)

  1. hdlee
    Member
    Posted 4 years ago #

    Without digging into the code first, I'd like to know the difference between shardb and hyperdb.

    What are the features in shardb that are not available in hyperdb?

    Thanks.

  2. Ron Rennick
    MultiSite Guru
    Posted 4 years ago #

    The main difference is the sharding structure.

    SharDB supports 16, 256 or 4096 database shards for site/blog tables.

    HyperDB is significantly more advanced in that area and theoretically supports an unlimited number of database servers & databases.

  3. hdlee
    Member
    Posted 4 years ago #

    Thanks for your reply, Ron. Maybe I'm wrong, but seems like SharDB has functions that are premade for "sharding" the databases, while with hyperdb, it is left to us to figure out an algorithm to do that with the my_db_callback function.

    So with hyperdb, it's still left to us to make sure the partitioning the tables correctly and efficiently. That opens up rooms for mistakes unless one is also good at codes and databases.

Topic Closed

This topic has been closed to new replies.

About this Topic