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

Cloud SQL does not support multitenancy in same way as Datastore. While Datastore supports multitenancy directly, other Google Cloud services do not. If your multitenant app uses other Google Cloud services, you will need to handle multitenancy manually. You may check Namespaces for related information. 

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching the App Engine. For coding and program architecture such as implementing multitenancy in Cloud SQL, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help. 

On Monday, 01 March 2021 at 12:44:42 UTC-5 ketu...@gmail.com wrote:

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/cdb015ce-0303-4afb-8d6c-82973bf5601cn%40googlegroups.com.