Wednesday, December 28, 2016

[google-cloud-sql-discuss] Re: Google cloud SQL for production purpose

Hello Vaishnavi,


You are to some extent right, when you express concern about the performance of an app engine application using CloudSQL 2nd Generation: network latency for connections between App Engine standard environment and Second Generation instances is approximately double the latency for connections to First Generation instances. Also, at present, there is no support for query caching.


Besides Cloud SQL, you have the choice of other storage products, that may better suit your purpose.


Regarding scaling, it may be worthwhile bringing to mind that Datastore is designed with scalability in mind, whereas MySQL does not scale well in practice.


This being said, you may design your application from bottom up with scalability in mind, following useful generally applicable good design practices: designing for scale.


You may have a look at other options, such as setting up and managing your own high-performance SQL server instance using the Compute Engine. This way, you can implement query caching as desired at relatively low cost.

--
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/dbc4b141-08ed-4fe5-be2d-d9cd17511f66%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment