Discussion in 'OT Technology' started by DarthKoRn, Sep 14, 2005.
How many databases can MySQL Server support concurrently.
more than you could fill i'm assuming. Databases in mysql are nothing more than a few rows of metadata and some files in the data folder for each table within the database.
Thats what we are assuming, but it just seems like their WOULD be a limitation. And with the program we are creating, it would very much be possible to fill it up if its in the 100+ range.
Why so many databases? Why not normalize your data?
Why the heck would you require more than one database for the program you're creating? There should be absolutely no reason for multiple databases. And as Sled said, yes, you'll need to utilize data normalization.
only reason i can think of, to use multiple databases, is if you're giving direct access to the end user for their data, and need to restrict permissions. Other than that, i would just normalize that data
Even if that was the case, I would end up writing user authentication on the interface, depending on the user, they would receive access to specific data they request. This could all be done on the software side of things. Having multiple databases is a bad idea. And horrible for optimization if your software will simultaneously be querying both databases.
I complete agree with you, but i have customers that require direct access to mysql and there is no other way than to just grant them access to their own db.
maybe he ment tables?
There are almost no limits, i seen databases spaning 300+ and 2tb in data
Passed along, thanks for the input guys. Im not actually the database guy in our team, so someone will look at this and make a decision. Thanks boys.
Can't you just create permissions for a user IN the database so the user could request specific data? Never had to do that myself, being that I write all my authentication on the interface
MySQL only supports 4gb of data per table. However, I think there is a storage engine that plugs into MySQL that can expand the storage capabilities by up to 16TB