Friday, October 6, 2017

[google-cloud-sql-discuss] Re: Performance from PHP: Connect to IP or SQL proxy?

Hi Maximiliano,

I could not find neither any documentation that tackles a performance comparison between the two options.

Usually this choice is based focusing on a security perspective. As an example, while working using a GKE applications it is not straightforward to know what will the source IP be. You could certainly whitelist on the SQL instance any IP (0.0.0.0/0). For security reasons that might not be ideal and you might want to use Cloud SQL proxy.

Instinctively Cloud SQL Proxy adds some additional connection elements between your instance and the client (Proxy Client and Proxy Server). My guess is that this could add some additional delay. If you need to make this decision based on performance I would suggest testing both scenarios.

--
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/528da16b-df1d-470e-970c-f322cc931594%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment