I am working on a website that I need to make scalable and I remembered all the scalability threads here. I was wondering if you guys could answer a few simple questions.
1. What is the advantage of separating the databases by a hash of the blog id instead of by splitting the database by blog id (ids 1-500, 500-1000)?
2. What are the advantages of having 4096 databases instead of 16? I would think that managing 4k databases would be a pain in the ass.
3. For those of you splitting your databases by the blog id hash, what are your database names (curious as to what those 16-4096 names are)?
Thanks guys.