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
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
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?