Has anybody had experience with creating thousand of mySQL databases and connecting to them via JDBC. We are afraid that the tables won't scale to our needs so we were looking at creating thousands of databases for thousand of users and users would be restricted to particular database to retrieve certain information. Please let me know if you have any experience in this.<br><br>Thanks,<br><br>Allen<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating thousands of database
- Thread starter romeroax
- Start date
I can't imagine how creating thousands of databases would scale better than large tables. <br><br>Perhaps you would be better off creating many tables, or better yet changing your database design to a more relational one.<br><br>If you really need tables of such sheer size, you will also have to be careful about the operating system you use and the version of MySQL you use. If you notice the post right next to this one about the 4GB file size limit, you will need a non x86 architecture with one of the later betas of MySQl 3.23.xx to have a more or less unlimited table size.<br><br>You might consider PostgreSQL because it has no OS-based limitations on table size (AFAIK), along with a few other sophisticated options that MySQL doesn't have.<br><br>
- Status
Similar threads
