Step by step installation Guide for Multi DB
Introduction
When I first read about Multi DB I was lured by the fact that it could streamline and break my 10,000 Table Single wp-freeblog Database into many such as 16, 256, 4096, databases, “yeah I thought, Millions of Blogs!”.
Whooa down, lets get real you need to be realistic about where you will be in the Future I personally think 256 Databases is a good starting Place lets face it if you get that many you will probably be making some OK money or at least be Making enough to keep developing your Platform Ok pic a number
- 16 Databases Up to 10,000 BLOGS
- 256 Databases Up to 50,000 to 100,000 Blogs
- 4096 Database Up to 4,000,000 Blogs
Step 1
The first thing to do is try to create your databases now this is either Straight Forward or not depending on your server restrictions, if there are restrictions then you will possibly need to change hosts or get the server Folk to CREATE the databases and GRANT PRIVILEGES to your account for these Databases
How I Create Databases thru the Command Line. (Building This now)
Go Now and Create your Databases done then Come Back here when you have got this sorted, As we cannot move on untill its done.