MySQL options for multi tenant application

[Kevin Patel]

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

[George (Cloud Platform Support)]

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.