How many tables/databases AWS Aurora cloud database server can handle?

Question

Currently we are on Google Cloud and we have 5000 databases on their single Cloud SQL instance, and the server just stops every few hours, and it won't start for a few hours because of the number of the tables.

Based on their documentation, which they modified lately, they support maximum 10.000 tables per instance, and in our case we can have maximum 250 databases (we have 40 tables per database).

We are trying to find other solutions to fit our needs, and we have 40.000 databases and want a scalable cloud solution, mysql/postgresql compatible.

Can Aurora handle this ?

Answer 1

40,000 databases will NOT be a problem for a single AWS Aurora instance.

For one of our projects, we are running a multi-tenant database architecture. With tens of thousands of tenants, we are looking at more than 40k databases on one of the instances, with close to 900k InnoDB tables (with file per table enabled).

We have a similar setup on AWS Aurora and on a simple self-managed MySQL server on EC2 instances. Both setups handle a large number of tables / databases nicely. RDS shouldn't have a problem with many DBs/tables as well. It's all a matter of a sane configuration.