Dear Geniuses, I have an application requiring ~30 InnoDB tables, which needs to scale up to at least 500 application instances (500 instances * ~30 tables = 15,000 tables).
Discussions in the archives suggest I would be better off having independent databases for each of the application instances (i.e. 500 databases). However, it seems this would be much more difficult/expensive to manage/replicate/cluster than a single large database containing 15,000 tables. Storing all the data from all the application instances in ~30 large tables is not possible. Please could you give me your recommendations and experience? Many thanks, Michael
