I heard that in general, you don't see a single server running sqlserver having more than 100-150 databases on it.
Is this the same case with mysql or postgres?
Database – how many databases can a single server handle
databasescalability
Related Topic
- Mysql – Storing changes to multiple databases in a single centralized database
- Mysql – How to sync a subset of tables between two databases on the same thesql database server
- Database – How to Perform Load Testing and Capacity Planning
- Linux – How to i create in incremental backups of thesql databases
- Database – How to update system databases in SQL Server
Best Answer
number of databases is an irrelevant measure. It's more to do with the number of user connections, the query load & the size of the database.
According to this SQL Server can have 32,767 databases attached to it. You probably won't see this in production, but it is possible!