I'm creating an application that every business will have;
some-business-name database, I need to create a new database for each business and use the unique business name as the database name
Is there a limit to the number of databases in AWS RDS for MYSQL? If so how can I solve this problem?
Note: I had to use aws to create this application
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
View RDS FAQ to see "How many databases are there" or can I run the schema in a database instance? "Part. Accordingly:
edit
You asked in the comments if this would be suitable for your application. I personally have always found the "one environment per client" setup to be challenging. You must have good database upgrade scripting and coding practices. Debugging individual clients means understanding the code they run and the architecture they have. A multi-tenant solution may be easier, but comes with its own set of challenges when partitioning database data among customers. Yes, your solution will work. You didn't mention the server side other than the CDK, but if you're also going to partition your code that way, it'll be hard to know which client is running what software.
No matter how you decide to do this, keep detailed information about each customer and the software version and database they are using. Hopefully the software you use will automatically update the schema as needed.