--
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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3088169e-b8d9-46bf-9830-85030b429046%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Currently we only have support via externals IPs. Note that the SSL support [1] provides a way to secure the connections to Clouud SQL from both GCE and Internet.-- Razvan ME
On Sat, Nov 16, 2013 at 6:02 AM, Jakub Głuszecki <jakub.g...@gmail.com> wrote:
Hi folks!I have a Ruby no Rails application running on Compute Engine VM's.I'm excited about a new possibility to use native mysql connections to CloudSql instances,however I'm not happy to connect using an external IP.Is there any possibility now, or planned in the near future, to connect to CloudSql instance using some sort of internal IP, just like two Compute Engine Vm's can connect to each other using internal subnet?
--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/94128185-6a4a-4ffa-aff8-f6e23a5470de%40googlegroups.com.To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJY7PsCeOU9n2Rs-DG%2BBy1wvht1a%2BgGjhrsm25w57B0Z-9%3DFxg%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAODnL%3Dk12dSveTgETW-nCpzeNU8kMR_nQe2k6THa1WpD6QwN0Q%40mail.gmail.com.
sudo bash -c 'echo 60 > /proc/sys/net/ipv4/tcp_keepalive_time'
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAODnL%3DmznJrUxkZh%3DVvBFwDADXX18OXCyMJRMQNZJo%2BaDQAv8g%40mail.gmail.com.
+1 ;)
Or at least be able to authorize them with something different than the public IP address, which can be a real burden when launching servers dynamically with temporal ip addresses.
Best regards
Sergio
El 19/11/2013 10:36, Jakub Głuszecki escribió:
Thank you Razvan. I confirm that adjusting tcp_keepalive_time solves
the problem.
Call me old-fashioned, I still would love to have the ability to
connect to cloudsql using GCE internal subnet.
2013/11/19 Razvan Musaloiu-E. <raz...@google.com>:
Yup, lowering the keepalive make the mysql client happy. Here is the command
I used:
sudo bash -c 'echo 60 > /proc/sys/net/ipv4/tcp_keepalive_time'
-- Razvan ME
On Mon, Nov 18, 2013 at 6:17 PM, Razvan Musaloiu-E. <raz...@google.com>
wrote:
It seems that you are affected by a limitation in GCE:
Once a connection has been established with an instance, traffic is
permitted in both directions over that connection, until the connection
times out after 10 minutes of inactivity.
Can you try configuring the TCP keepalive [2]?
[1] https://developers.google.com/compute/docs/networking#overview
[2] http://tldp.org/HOWTO/TCP-Keepalive-HOWTO/usingkeepalive.html
-- Razvan ME
On Mon, Nov 18, 2013 at 8:58 AM, Jakub Głuszecki
<jakub.g...@gmail.com> wrote:
I switched to package billing plan plus I have an application making
regular sql queries to cloudsql instance (using GCE health check) but
the problem I reported using mysql client still exists.
2013/11/18 Razvan Musaloiu-E. <raz...@google.com>:
I was able to reproduce the issue reported by Jakub Głuszecki. The
instance
was up so it's not the 15-minute timeout. I'll dig some more to find
the
root cause.
-- Razvan ME
On Mon, Nov 18, 2013 at 8:05 AM, Tony Tseng <t...@google.com> wrote:
Hi there,
The 15 minute window may indicate that your instance has been brought
down
due to inactivity. Is your instance on a per use pricing plan
(https://developers.google.com/cloud-sql/pricing#per_use)? If that's
the
case, that'd explain why the server has gone away.
On Sun, Nov 17, 2013 at 5:50 AM, Jakub Głuszecki
<jakub.g...@gmail.com> wrote:
W dniu niedziela, 17 listopada 2013 13:23:41 UTC+1 użytkownik Jakub
Głuszecki napisał:
Thanks for your answer Razvan,
I'm aware of SSL support, I agree that it improves security, however
I
have some other concerns about connecting using external IP - I'm
afraid of
network/firewall issues. Is there any possibility that some firewall
(on the
Google side) interferes with mysql connections between GCE and
CloudSql
instances? I have some issues with unused connenctions. Everything
works
fine if a connection is busy, but few minutes of inactivity seems to
break
it. I'm going to dig deeper, but maybe You can provide me with some
hints.
W dniu niedziela, 17 listopada 2013 04:22:59 UTC+1 użytkownik Razvan
Musaloiu-E. napisał:
Currently we only have support via externals IPs. Note that the SSL
support [1] provides a way to secure the connections to Clouud SQL
from both
GCE and Internet.
[1] https://developers.google.com/cloud-sql/docs/instances#ssl
-- Razvan ME
On Sat, Nov 16, 2013 at 6:02 AM, Jakub Głuszecki
<jakub.g...@gmail.com>
wrote:
Hi folks!
I have a Ruby no Rails application running on Compute Engine VM's.
I'm excited about a new possibility to use native mysql
connections to
CloudSql instances,
however I'm not happy to connect using an external IP.
Is there any possibility now, or planned in the near future, to
connect to CloudSql instance using some sort of internal IP, just
like two
Compute Engine Vm's can connect to each other using internal
subnet?
--
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+unsub...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/3088169e-b8d9-46bf-9830-85030b429046%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
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
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/94128185-6a4a-4ffa-aff8-f6e23a5470de%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
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
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJY7PsCeOU9n2Rs-DG%2BBy1wvht1a%2BgGjhrsm25w57B0Z-9%3DFxg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to a topic in the
Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/google-cloud-sql-discuss/cLLxUxiS5ck/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg2NOmwKRbi-a3S3XKuZDyhWr%3Dser9pN3MJ3_MYYPtYO%3Dw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
Jakub Głuszecki
--
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
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAODnL%3Dk12dSveTgETW-nCpzeNU8kMR_nQe2k6THa1WpD6QwN0Q%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to a topic in the
Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/google-cloud-sql-discuss/cLLxUxiS5ck/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg1DW9E%2B%3DEZJADtvni%3DjocO5kWSDK%3Dr3AnUxm5H_VceKQw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/528B3806.20503%40gmail.com.To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/3088169e-b8d9-46bf-9830-85030b429046%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
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
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/94128185-6a4a-4ffa-aff8-f6e23a5470de%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
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
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJY7PsCeOU9n2Rs-DG%2BBy1wvht1a%2BgGjhrsm25w57B0Z-9%3DFxg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to a topic in the
Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/google-cloud-sql-discuss/cLLxUxiS5ck/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg2NOmwKRbi-a3S3XKuZDyhWr%3Dser9pN3MJ3_MYYPtYO%3Dw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
Jakub Głuszecki
--
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
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAODnL%3Dk12dSveTgETW-nCpzeNU8kMR_nQe2k6THa1WpD6QwN0Q%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to a topic in the
Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/google-cloud-sql-discuss/cLLxUxiS5ck/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg1DW9E%2B%3DEZJADtvni%3DjocO5kWSDK%3Dr3AnUxm5H_VceKQw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
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+unsubscr...@googlegroups.com.
<jakub.g...@gmail.com> wrote:
an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/3088169e-b8d9-46bf-9830-85030b429046%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
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
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/94128185-6a4a-4ffa-aff8-f6e23a5470de%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
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
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJY7PsCeOU9n2Rs-DG%2BBy1wvht1a%2BgGjhrsm25w57B0Z-9%3DFxg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to a topic in the
Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/google-cloud-sql-discuss/cLLxUxiS5ck/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg2NOmwKRbi-a3S3XKuZDyhWr%3Dser9pN3MJ3_MYYPtYO%3Dw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
Jakub Głuszecki
--
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
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAODnL%3Dk12dSveTgETW-nCpzeNU8kMR_nQe2k6THa1WpD6QwN0Q%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to a topic in the
Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/google-cloud-sql-discuss/cLLxUxiS5ck/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg1DW9E%2B%3DEZJADtvni%3DjocO5kWSDK%3Dr3AnUxm5H_VceKQw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/528B3806.20503%40gmail.com.
--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9264168c-c537-452f-8c3a-c6757e4acb1d%40googlegroups.com.To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.