InnoDB: Thousands of Tables or Hundreds of Databases?
Posted by: Michael Addyman
Date: February 09, 2009 06:22PM

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. Storing 1 table type per database (i.e. ~30 databases) also seems very difficult, although I think this is probably the best solution.

Please could you give me your recommendations and experience?

Many thanks,

Michael

Options: ReplyQuote


Subject
Written By
Posted
InnoDB: Thousands of Tables or Hundreds of Databases?
February 09, 2009 06:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.