Saturday, February 27, 2021

[google-cloud-sql-discuss] MySQL options for multi tenant application

Hello,

Currently we have a LAMP stack application using multi tenant approach for each subdomain. Each our customer gets a separate subdomain and separate database in the same cloud sql instance. Each database about 60 tables. Currently based I see max google cloud sql suggest is 10000 tables per instance. which means we are limited to about ~150 databases per instance. If we have about 2000 customers this will result in several instances and lot of overhead to manage the instances. 

I'm trying to understand what  are our options with GCP to support a multi tenant approach for mysql? 

Thanks

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/adaa6eff-6442-40dd-b89e-3513439cc391n%40googlegroups.com.

No comments:

Post a Comment