question

RohanJones-0800 avatar image
0 Votes"
RohanJones-0800 asked azure-cxp-api edited

Limit on databases on single server

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

azure-database-mysql
5 |1600 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
0 Votes"
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.

5 |1600 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
1 Vote"
Sam-Cogan answered

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


5 |1600 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.