Limit on databases on single server

Rohan Jones 291 Reputation points
2020-05-18T02:19:15.917+00:00

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

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
842 questions
0 comments No comments
{count} votes

Accepted answer
  1. Rohan Jones 291 Reputation points
    2020-05-18T16:32:34.117+00:00

    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Sam Cogan 10,742 Reputation points MVP
    2020-05-18T08:35:49.423+00:00

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

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.