The forums have permanently moved to This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.

Results 1 to 4 of 4

Thread: DB sharding vs partitioning

  1. #1

    DB sharding vs partitioning

    Hi there,
    I came accross DB sharding/partitioning and realised that i will soon have to implement that concept but i am looking for the right option to choose from as it is new territory here.

    Looking at it i would opt for sharding but is this really the way to go.
    In overall i will have a user table that will grow really big and each user will have their comments, posts, messages, followers etc...

    can anybody help me in terms of what i need and waht will be the best approach in terms of growth and reliability please.

    Thanks so much for any help,



  2. #2


    If you want to implement sharding - try out ScaleBase. They shard your database transparently for you.

  3. #3
    Thanks Liran,
    i will have a look at it.
    From hours spent yesterday researching i have the base of how to shard but i would like to achieve something like wordpress, wordpress multisite.
    Do they hold eg. 1million users into a db at a time,including all of users site data.
    in otherwords if i have a million user i will have almost 1million table too (from which comment and post are gonna be big).
    is it the right way of doing such thing? or it does not matter as mysql can handle more than that.

    Thanks again for your input, really appreciate it.


  4. #4


    Hi Jerome,

    I think it's too complex to answer as a reply on a forum. Drop me an email liran dot zelkha at scalebase dot com - I think I can have some alternatives for you that will scale much better.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Home About Meet the Moderators Advertise

 Link to Us


Copyright 1999 - 2012