question

RohanJones-0800 avatar image
RohanJones-0800 asked ·

Limit on databases on single server

Is there a limit to the number of databases on a single server?

azure-database-mysql
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

RohanJones-0800 avatar image
RohanJones-0800 answered ·

Thanks for that @Sam-Cogan.

For MySQL, I researched there is no limit to the number of databases that can be created in a server for Azure Database for MySQL. However, multiple databases share server resources, and performance requirements rise as the number of databases grows. I recommend that you create multiple servers running Azure Database for MySQL.

Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sam-Cogan avatar image
Sam-Cogan answered ·

Yes, for MSSQL it is 5000 databases per server. You can find all the limits here


Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.