Thank you so much for your response. Just to clarify the way I am trying to implement this solution is as follows I have a system with 1 million user base. I am expecting a couple of hundred users to connect at any one time. When the user connects to an instance I was hoping to payload into the http request some user id information.
I would then spin up a DB and download/import data from an external 3rd party storage into the db, the user would then have access to that data for the duration of the instance. I was hoping I could create an empty sql instance as a primary and then clone it and use it for the appengine instance for the user session. Once the user becomes inactive/times out I would delete the cloned db instance. On Monday, January 13, 2020 at 5:57:55 PM UTC, Olu wrote: > > On App Engine, there is no way to restrict specific Instance to particular > Users. Instances are spun up based on configurations on the Application's > App.yaml file[1][2]. Also, depending on the Scaling Options, it is possible > to scale App Engine Standard applications[3] to Zero Instances whenever > there are no incoming requests to be handled. I believe this would simulate > your design to scale to zero whenever your user disconnects, however, the > scaling would only scale to zero based on availability(or unavailability) > of incoming requests, rather than the connection or disconnection from a > specific User. > > Also, App Engine applications can connect with CloudSQL Instances(if you > plan to have a relational DB) and you can choose to create databases within > a single Cloud SQL Instance, however, these Databases could not be shut > down in response to connection or disconnection from a specific User[4]. > > [1]https://cloud.google.com/appengine/docs/standard/python/config/appref > [2] > https://cloud.google.com/appengine/docs/flexible/python/configuring-your-app-with-app-yaml > [3] > https://cloud.google.com/appengine/docs/the-appengine-environments#comparing_high-level_features > [4] > https://cloud.google.com/sql/docs/mysql/start-stop-restart-instance#stop > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/d4490c03-5933-4bcb-b1b0-f91c9a5247a2%40googlegroups.com.
