[google-cloud-sql-discuss] Re: This is how I connect my Google instance VM to Cloud SQL/ And setup my Wordpress

Sorry I dont have much experience with that. I did what you asked me regarding to the hostname but got this error: 

Error establishing a database connection

Now regarding to this file I found this informations only inside it:

127.0.0.1 localhost

# The following lines are desirable for IPv6 capable hosts

::1 ip6-localhost ip6-loopback

fe00::0 ip6-localnet

ff00::0 ip6-mcastprefix

ff02::1 ip6-allnodes

ff02::2 ip6-allrouters

ff02::3 ip6-allhosts

169.254.169.254 metadata.google.internal metadata

On Saturday, April 1, 2017 at 12:35:29 AM UTC+3, Adam (Cloud Platform Support) wrote:

The 'hostname' portion of the FQDN is not your external domain name. It is the host name of the machine you're connecting to. For example, if you created an instance called 'mysql-server' for your database, the FQDN would be:

mysql-server.c.ex-growth.internal

Before even trying to connect to a host, you should check that it's even correct first eg. by pinging it. You can also verify the hostname of a machine by SSHing into it and checking /etc/hosts, eg.

$ cat /etc/hosts

The IP and hostname will be listed as the last line of the output.

On Friday, March 31, 2017 at 5:03:47 PM UTC-4, Moh'd Irshaid wrote:

Hi Adam

You mean replace the DB_Host in the wp-config.php file with this exactly:

eystx.com.c.ex-growth.internal

Since the project id is: ex-growth

and the main domain is: eystx.com

I tried this but doesnt work .. 

On Friday, March 24, 2017 at 11:22:50 PM UTC+2, Adam (Cloud Platform Support) wrote:

One step better than connecting via public IP is to connect to the internal private IP address, as you'll have a faster network path and thus reduced latency and higher bandwidth between your app and your database. Using the internal DNS name is preferable to the IP address which can potentially change.

However, you're still limited to a single application instance and a single database instance. If your user traffic increases past the point that a single instance can handle, you'll be in trouble. This is where App Engine is useful, as it can scale out multiple instances of your application on demand to respond to changes in traffic.

There are many solutions to the problem of scaling though, and App Engine is just one of them. It can also be done on Compute Engine using load balancing, managed instance groups, and autoscaling. Yet another solution is Google Container Engine, which uses Docker containers with Compute Engine resources to scale out.

On Friday, March 24, 2017 at 11:23:47 AM UTC-4, Moh'd Irshaid wrote:

Hi,

I've decided to move from normal hosting companies to Google cloud and run my own server; most of my websites are WordPress. but I want to make sure that what I've done is right .. its working until now! but not sure if it is the best thing to do;

I've created my VM instance;

I've installed vesta cpanel.

But for databases I dont want to host it in the same instance! so under the same project I've created SQL instance,

I connect it to my local MySql Workbench and its connected and worked. 

then in Wordpress wp-config.php file

Username and Password used the same for my sql instance

host i change it from the localhost and used the public ip address for my sql instance

its connected! but i don't know if this is the best solution, I'm taking exactly about the hostname

Please let me know, all videos i've found on internet is talking about google app engine, why? why not just hosting the code on the VM instance and the database on SQL instance then link it togather using the ip address? 

CONFIDENTIALITY STATEMENT: This communication is an electronic communication within the meaning of the Electronic Communications Privacy Act, 18 U.S.C. sec. 2510. Its disclosure is strictly limited to the recipient(s) intended by the sender of this message. This transmission and any attachments may contain proprietary, confidential, attorney-client privileged information and/or attorney work product. If you are not the intended recipient, any disclosure, copying, distribution, reliance on, or use of any of the information contained herein is STRICTLY PROHIBITED. Please destroy the original transmission and its attachments without reading or saving in any matter and confirm by return email.

CONFIDENTIALITY STATEMENT: This communication is an electronic communication within the meaning of the Electronic Communications Privacy Act, 18 U.S.C. sec. 2510. Its disclosure is strictly limited to the recipient(s) intended by the sender of this message. This transmission and any attachments may contain proprietary, confidential, attorney-client privileged information and/or attorney work product. If you are not the intended recipient, any disclosure, copying, distribution, reliance on, or use of any of the information contained herein is STRICTLY PROHIBITED. Please destroy the original transmission and its attachments without reading or saving in any matter and confirm by return email.

--
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/871b2d58-10d9-4fda-ba0a-146e72fac85f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: This is how I connect my Google instance VM to Cloud SQL/ And setup my Wordpress

The 'hostname' portion of the FQDN is not your external domain name. It is the host name of the machine you're connecting to. For example, if you created an instance called 'mysql-server' for your database, the FQDN would be:

mysql-server.c.ex-growth.internal

Before even trying to connect to a host, you should check that it's even correct first eg. by pinging it. You can also verify the hostname of a machine by SSHing into it and checking /etc/hosts, eg.

$ cat /etc/hosts

The IP and hostname will be listed as the last line of the output.

On Friday, March 31, 2017 at 5:03:47 PM UTC-4, Moh'd Irshaid wrote:

Hi Adam

You mean replace the DB_Host in the wp-config.php file with this exactly:

eystx.com.c.ex-growth.internal

Since the project id is: ex-growth

and the main domain is: eystx.com

I tried this but doesnt work .. 

On Friday, March 24, 2017 at 11:22:50 PM UTC+2, Adam (Cloud Platform Support) wrote:

One step better than connecting via public IP is to connect to the internal private IP address, as you'll have a faster network path and thus reduced latency and higher bandwidth between your app and your database. Using the internal DNS name is preferable to the IP address which can potentially change.

However, you're still limited to a single application instance and a single database instance. If your user traffic increases past the point that a single instance can handle, you'll be in trouble. This is where App Engine is useful, as it can scale out multiple instances of your application on demand to respond to changes in traffic.

There are many solutions to the problem of scaling though, and App Engine is just one of them. It can also be done on Compute Engine using load balancing, managed instance groups, and autoscaling. Yet another solution is Google Container Engine, which uses Docker containers with Compute Engine resources to scale out.

On Friday, March 24, 2017 at 11:23:47 AM UTC-4, Moh'd Irshaid wrote:

Hi,

I've decided to move from normal hosting companies to Google cloud and run my own server; most of my websites are WordPress. but I want to make sure that what I've done is right .. its working until now! but not sure if it is the best thing to do;

I've created my VM instance;

I've installed vesta cpanel.

But for databases I dont want to host it in the same instance! so under the same project I've created SQL instance,

I connect it to my local MySql Workbench and its connected and worked. 

then in Wordpress wp-config.php file

Username and Password used the same for my sql instance

host i change it from the localhost and used the public ip address for my sql instance

its connected! but i don't know if this is the best solution, I'm taking exactly about the hostname

Please let me know, all videos i've found on internet is talking about google app engine, why? why not just hosting the code on the VM instance and the database on SQL instance then link it togather using the ip address? 

CONFIDENTIALITY STATEMENT: This communication is an electronic communication within the meaning of the Electronic Communications Privacy Act, 18 U.S.C. sec. 2510. Its disclosure is strictly limited to the recipient(s) intended by the sender of this message. This transmission and any attachments may contain proprietary, confidential, attorney-client privileged information and/or attorney work product. If you are not the intended recipient, any disclosure, copying, distribution, reliance on, or use of any of the information contained herein is STRICTLY PROHIBITED. Please destroy the original transmission and its attachments without reading or saving in any matter and confirm by return email.

--
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/12974a3f-d22f-4ac0-adc4-ace3f7c860d4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Urgent - All Stored procedures(MYISAM engine) is being automatically roll-backed in our First Generation Google Cloud SQL.

Apologies for the delay.  We've recently been experiencing heavy volume for community support and greatly appreciate your patience.

Are you still experiencing this issue?  If so and you believe this to be an issue with the platform, please file a new issue on the Issue Tracker using the Public Trackers > Cloud Platform > Storage and Databases > Cloud SQL component.  When doing so, please provide a link to this thread in the issue report so as to avoid troubleshooting the same issue a second time.  I'd also recommend posting a link to the public issue here so that others in the community can follow along.

On Monday, March 13, 2017 at 11:18:44 PM UTC-4, Dhandapani Sattanathan wrote:

George,

Plz send your personal email id. I 'll give the text copy of the failing procedure

Regards,

SATTANATHAN D
PROJECT MANAGER

SSOMENS SOFTWARE DEVELOPMENT

04132333229 /230/231

www.ssomens.com

Education is the most powerful weapon which you can use to change the world

On Tue, Mar 14, 2017 at 2:19 AM, 'George (Cloud Platform Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

At this stage, a text copy of the failing procedure may provide needed information. You may send this confidentially by private email. 

--
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/L7pvTcaARtU/unsubscribe.
To unsubscribe from this group and all its topics, 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/410cf2d8-20b1-4882-9395-bd8d887e307d%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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/ac25eb81-f8f4-4879-8d64-091e1068a7d6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: This is how I connect my Google instance VM to Cloud SQL/ And setup my Wordpress

Hi Adam

You mean replace the DB_Host in the wp-config.php file with this exactly:

eystx.com.c.ex-growth.internal

Since the project id is: ex-growth

and the main domain is: eystx.com

I tried this but doesnt work .. 

On Friday, March 24, 2017 at 11:22:50 PM UTC+2, Adam (Cloud Platform Support) wrote:

One step better than connecting via public IP is to connect to the internal private IP address, as you'll have a faster network path and thus reduced latency and higher bandwidth between your app and your database. Using the internal DNS name is preferable to the IP address which can potentially change.

However, you're still limited to a single application instance and a single database instance. If your user traffic increases past the point that a single instance can handle, you'll be in trouble. This is where App Engine is useful, as it can scale out multiple instances of your application on demand to respond to changes in traffic.

There are many solutions to the problem of scaling though, and App Engine is just one of them. It can also be done on Compute Engine using load balancing, managed instance groups, and autoscaling. Yet another solution is Google Container Engine, which uses Docker containers with Compute Engine resources to scale out.

On Friday, March 24, 2017 at 11:23:47 AM UTC-4, Moh'd Irshaid wrote:

Hi,

I've decided to move from normal hosting companies to Google cloud and run my own server; most of my websites are WordPress. but I want to make sure that what I've done is right .. its working until now! but not sure if it is the best thing to do;

I've created my VM instance;

I've installed vesta cpanel.

But for databases I dont want to host it in the same instance! so under the same project I've created SQL instance,

I connect it to my local MySql Workbench and its connected and worked. 

then in Wordpress wp-config.php file

Username and Password used the same for my sql instance

host i change it from the localhost and used the public ip address for my sql instance

its connected! but i don't know if this is the best solution, I'm taking exactly about the hostname

Please let me know, all videos i've found on internet is talking about google app engine, why? why not just hosting the code on the VM instance and the database on SQL instance then link it togather using the ip address? 

CONFIDENTIALITY STATEMENT: This communication is an electronic communication within the meaning of the Electronic Communications Privacy Act, 18 U.S.C. sec. 2510. Its disclosure is strictly limited to the recipient(s) intended by the sender of this message. This transmission and any attachments may contain proprietary, confidential, attorney-client privileged information and/or attorney work product. If you are not the intended recipient, any disclosure, copying, distribution, reliance on, or use of any of the information contained herein is STRICTLY PROHIBITED. Please destroy the original transmission and its attachments without reading or saving in any matter and confirm by return email.

CONFIDENTIALITY STATEMENT: This communication is an electronic communication within the meaning of the Electronic Communications Privacy Act, 18 U.S.C. sec. 2510. Its disclosure is strictly limited to the recipient(s) intended by the sender of this message. This transmission and any attachments may contain proprietary, confidential, attorney-client privileged information and/or attorney work product. If you are not the intended recipient, any disclosure, copying, distribution, reliance on, or use of any of the information contained herein is STRICTLY PROHIBITED. Please destroy the original transmission and its attachments without reading or saving in any matter and confirm by return email.

--
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/a1a1968c-09e6-414e-ace6-1977a5841f29%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Option to create ZIP'ed backup?

This seems like a suggestion that would be far better suited for the Issue Tracker.  This forum is aimed at discussions about architecture, best practices and the like.  Should you decide to file a feature request, be sure to link to it here so that others in the community can follow along and include following:

• A use case with pros and cons for backup zipping
  
• Possible workarounds you may currently be using to accomplish backup compression
  
• Any other additional specifications on how you would expect a feature like this to integrate with the current tools (Cloud Console, Cloud SDK, etc.)
  

On Friday, March 31, 2017 at 7:10:50 AM UTC-4, Moh'd Irshaid wrote:

+1 !!! How to create a backup.

On Thursday, March 30, 2017 at 4:29:14 PM UTC+2, Ben Guild wrote:

This would be nice.

--
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/6a9a7434-b7f7-499b-aa65-cf296980116a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] How to apply cloud sql proxy on Workbench?

Hi,

It is relatively easy to use Cloud SQL proxy with MySQL workbench. Just follow steps 1-4 of https://cloud.google.com/sql/docs/mysql/connect-admin-proxy. Then instead of step 5, use MySQL workbench to connect to 127.0.0.1 (or /cloudsql/INSTANCE_CONNECTION_NAME)

If you are on windows, use TCP sockets.

On Thu, Mar 30, 2017 at 8:41 PM, zhen ping wong <wongzp817@gmail.com> wrote:

Hi,

I'm trying to connect to my db instance using cloud sql proxy, as the IP white list on dynamic IP is not very convenient. Looking for a secure and easier way to do this, I'm using workbench.

Appreciate for the advice.

--
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/1f077ce3-1ca7-453e-a2cf-760649ce5942%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CAJZK_bZq-Zh9uqq-Qv4wTNaz_JmGYJozRurkAqedJwoL5J5yBw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Option to create ZIP'ed backup?

+1 !!! How to create a backup.

On Thursday, March 30, 2017 at 4:29:14 PM UTC+2, Ben Guild wrote:

This would be nice.

CONFIDENTIALITY STATEMENT: This communication is an electronic communication within the meaning of the Electronic Communications Privacy Act, 18 U.S.C. sec. 2510. Its disclosure is strictly limited to the recipient(s) intended by the sender of this message. This transmission and any attachments may contain proprietary, confidential, attorney-client privileged information and/or attorney work product. If you are not the intended recipient, any disclosure, copying, distribution, reliance on, or use of any of the information contained herein is STRICTLY PROHIBITED. Please destroy the original transmission and its attachments without reading or saving in any matter and confirm by return email.

--
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/77c2c722-eecb-4b0d-8991-396089696ddb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] How to apply cloud sql proxy on Workbench?

Hi,

I'm trying to connect to my db instance using cloud sql proxy, as the IP white list on dynamic IP is not very convenient. Looking for a secure and easier way to do this, I'm using workbench.

Appreciate for the advice.

--
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/1f077ce3-1ca7-453e-a2cf-760649ce5942%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Option to create ZIP'ed backup?

This would be nice.

--
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/120cae50-b7fe-4f37-bd60-112a33917d93%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Backup restore to different instance, in different project

We have the exact same use case and would love to see this feature.

On Tuesday, 24 January 2017 20:36:57 UTC+2, David Newgas wrote:

Thanks for the context - use cases are really helpful for feature requests!

David

On Tue, Jan 24, 2017 at 10:35 AM, Dan Gardner <dan.g...@baddogdown.com> wrote:

Thanks David,  I agree.  Was hoping to avoid replacing the CloudSQL backup strategy with rolling our own, but hey ho.  Just FYI our use case is that we need to segregate environments by GCP project +  I always like a daily automatic backsync data from a Production environment back through TEST,SI Ci etc.  I also like to utilise a backup / restore approach as an easy way to also verify the Production backup into the bargain.  Thx.

 

On Tuesday, 24 January 2017 18:08:31 UTC, David Newgas wrote:

Hi,

I just dug into our code and I can confirm that there is not currently a way to do this via our API. I can see that we do have an feature request open internally for this, and I will mention that you are interested in this on it. However I don't expect that it will be implemented in the short term.

The "next best thing" is to restore to an instance in the same project, export the database to GCS and then import it into an instance in another project.

Yours,

David

On Tue, Jan 24, 2017 at 6:53 AM, Dan Gardner <dan.g...@baddogdown.com> wrote:

I'm failing to restore a backup from a source instance to a target instance when each instance is in a different project.  Is this simply not supported ?

I get ambiguous permissions error from the target instance restore cmd**.   Also if I look in the console no option is offered to target instances in diff projects,  resonable I suppose for thr console.  

I guess unless you can pass a project in the restoreBackupContext json, as below, this isn't supported yet ?

  

**  below from https://cloud.google.com/sql/docs/mysql/backup-recovery/restoring#restorebackups   

curl --header "Authorization: Bearer ${ACCESS_TOKEN}" \
     --header 'Content-Type: application/json' \
     --data '{ "restoreBackupContext": {"backupRunId": "[BACKUP_ID]", "instanceId": "[SOURCE_INSTANCE_NAME]", "kind": "sql#restoreBackupContext"}}' \
     -X POST \
     https://www.googleapis.com/sql/v1beta4/projects/[PROJECT-ID]/instances/[TARGET_INSTANCE_NAME]/restoreBackup

--
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/75aa9ab4-fbd2-48cb-96c3-f6ee4b2a86be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/303fedf5-292a-43ca-befc-a83a5ac5e8ee%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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/5339beee-d91c-426f-8740-22d2851dd3d5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Error: "Could not complete the operation."

Hi, I just wanted to update "Maintenance window" settings and after pressing save it alerts "Could not complete the operation." without any other explanation. I had a similar error on some other instance after restarting it I was able to edit settings, but this is a production instance and restart is not a good option. Why this error shows up and what really does it mean?

Thanks in advance.

--
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/19f79e13-d395-45b3-a260-f5dd3accf119%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: How to remove static IP from postgresql instance

Thanks for the help! I think the pricing docs should be updated to reflect this.

On Wednesday, 29 March 2017 11:18:46 UTC+5:30, Kush Goyal wrote:

Hi,

Can anyone guide me how to remove unused static IP from postgresql instance.

Thanks,

Kush

--
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/7255a9d6-97bb-420e-8c34-d24156e2e7a7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: How to remove static IP from postgresql instance

Kush,

That was for First Generation instances. Second generation instances don't have that option.

On Tue, Mar 28, 2017 at 11:20 PM, Kush Goyal <kushgoyal.89@gmail.com> wrote:

Cloud sql mysql has ipv6 and ipv4 static ips. ipv4 address can be removed from the instance because it is chargeable. Is it also possible for postgresql? Or is it in the pipeline?

On Wednesday, 29 March 2017 11:18:46 UTC+5:30, Kush Goyal wrote:

Hi,

Can anyone guide me how to remove unused static IP from postgresql instance.

Thanks,

Kush

--
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/fa322eed-ac18-4523-b3fc-2f4e3f68abea%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Ankush Agarwal

Software Engineer, Cloud SQL

 

There are 10 types of people in this world - those who understand binary and those who don't

--
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/CAAg6v4AHPvJnB7W_LbOgsBJ_v0-br%2BiLrvZNwkHGX0NzZirawg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: How to remove static IP from postgresql instance

Cloud sql mysql has ipv6 and ipv4 static ips. ipv4 address can be removed from the instance because it is chargeable. Is it also possible for postgresql? Or is it in the pipeline?

On Wednesday, 29 March 2017 11:18:46 UTC+5:30, Kush Goyal wrote:

Hi,

Can anyone guide me how to remove unused static IP from postgresql instance.

Thanks,

Kush

--
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/fa322eed-ac18-4523-b3fc-2f4e3f68abea%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: How to remove static IP from postgresql instance

The proxy also uses the static IP to connect to the instance.

On Tue, Mar 28, 2017 at 11:03 PM Kush Goyal <kushgoyal.89@gmail.com> wrote:

I can also connect using cloud sql proxy [1]. I think cloud sql mysql has the option to remove static ip. Unused static ip is chargeable and I am not using the static most the time.

[1] https://cloud.google.com/sql/docs/postgres/connect-admin-proxy

On Wednesday, 29 March 2017 11:18:46 UTC+5:30, Kush Goyal wrote:

Hi,

Can anyone guide me how to remove unused static IP from postgresql instance.

Thanks,

Kush

--
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/ecd760e8-e211-4c7d-a294-18212bcbfd24%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Ankush Agarwal

Software Engineer, Cloud SQL

 

There are 10 types of people in this world - those who understand binary and those who don't

--
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/CAAg6v4AS%3D157WKA3jR1o3hE9_tQFYfQEnUuBQjVj02OwVn5Ruw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: How to remove static IP from postgresql instance

I can also connect using cloud sql proxy [1]. I think cloud sql mysql has the option to remove static ip. Unused static ip is chargeable and I am not using the static most the time.

[1] https://cloud.google.com/sql/docs/postgres/connect-admin-proxy

On Wednesday, 29 March 2017 11:18:46 UTC+5:30, Kush Goyal wrote:

Hi,

Can anyone guide me how to remove unused static IP from postgresql instance.

Thanks,

Kush

--
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/ecd760e8-e211-4c7d-a294-18212bcbfd24%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] How to remove static IP from postgresql instance

Static IPs cannot be disassociated with an instance. 

They are required for connecting to an instance.

On Tue, Mar 28, 2017 at 10:48 PM Kush Goyal <kushgoyal.89@gmail.com> wrote:

Hi,

Can anyone guide me how to remove unused static IP from postgresql instance.

Thanks,

Kush

--
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/3e693f82-9423-4d7a-848f-15a378d17fef%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Ankush Agarwal

Software Engineer, Cloud SQL

 

There are 10 types of people in this world - those who understand binary and those who don't

--
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/CAAg6v4CLs4EuW3jhe6eChYt2iWU8uW_G8zwmGuHmHWOWHEs3NA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] How to remove static IP from postgresql instance

Hi,

Can anyone guide me how to remove unused static IP from postgresql instance.

Thanks,

Kush

--
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/3e693f82-9423-4d7a-848f-15a378d17fef%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Google Cloud SQL instance still suspended after clearing billing issues

Glad to hear that your issue was solved and thanks for confirming.

Regards,

Alex

--
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/67742119-3e6e-446b-9c32-29683ba66340%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Postgres extension request: postgresql-hll

Hi Abe,

Thank you for your feedback!

It does not seems like this extension supports PostgreSQL 9.4 or older, and it does not seems like it's actively maintained.

We only provide 9.6 currently, so it is not likely that we'll be able to add this extension soon.

The good news is that it's licensed under Apache2, so these problems are fixable.

If anybody else would like to use this extension please let us know. It will help us prioritize.

Short-term, I'd recommend to continue using Redis.

Thank you!

--
Vladimir Rusinov
PostgreSQL SRE, Google Ireland

Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland
Registered in Dublin, Ireland
Registration Number: 368047

On Sun, Mar 26, 2017 at 11:56 PM, Abe Voelker <abe@abevoelker.com> wrote:

This extension adds support for a HyperLogLog data structure - useful for counting distinct values while using a reasonable amount of space: https://github.com/aggregateknowledge/postgresql-hll

In the meantime a Redis instance tuned for persistence can be used instead, as Redis natively supports HyperLogLog. But I would like to get rid of the additional dependency if possible.

--
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/112a5fd4-978e-4181-a668-27a871536a1d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CAE1wr-yuxpuVTeSW%3D0uF3waN1h4eqjjdFsW-eKNNTL1NYF1EgA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Create Locales or change Template1 locale

Unfortunately current release of CloudSQL for PostgreSQL does not include extra locales.

This is something we aware of. We should be able to include more locales in one of the next releases.

--
Vladimir Rusinov
PostgreSQL SRE, Google Ireland

Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland
Registered in Dublin, Ireland
Registration Number: 368047

On Tue, Mar 28, 2017 at 1:13 PM, Oscar Serrano <oscar.serrano.sacristan@gmail.com> wrote:

Hi Nick,

well, of course I pretend to use UTF8, but when sorting results (collation), it's not the same sorting in English than in Spanish.

For example, this set: Óscar, Peter, Angel, in english get sorted like this: Angel, Peter, Óscar. But in Spanish, the order would be: Angel, Óscar, Peter.

There are many languages which letters allow tildes, special accents, etc, that would need special locales?

Is it too complex to implement?

Thank you very much.

2017-03-27 23:22 GMT+02:00 'paynen' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com>:

Hey Oscar,

Thanks for this report. I've replicated your findings. I'm unsure at the moment what solution to offer. Could you explain more about your use-case, and why you can't just store UTF-8 data without setting any locale?

Cheers,

Nick
Cloud Platform Community Support

On Monday, March 20, 2017 at 11:54:45 AM UTC-4, Oscar Serrano wrote:

Hi,

I'm trying to create a new postgresql database, but I cannot use the spanish Location. I've tried this:

create database mydb with ENCODING = 'UTF-8' LC_CTYPE = 'es_ES' LC_COLLATE = 'es_ES';

But I get an error: invalid Locale Name es_ES

How do I create it?

I've tried this:

postgres=> create collation es (locale="es_ES.utf8");ERROR: could not create locale "es_ES.utf8": Success
As you can say, it says Success, but also I get the error.How should I proceed?
Thank you.

--
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/mISMIL3PNFY/unsubscribe.
To unsubscribe from this group and all its topics, 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/396f11c6-1349-4510-83c8-a82f9dae81cf%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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/CANX%3DucTm-QQMs-bmEohvwDtTgrM%2B%3D%2B4iX%3DW6dpqBPvPZPuCv%2Bg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--
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/CAE1wr-yRcqFagYiGBc75jEBsVAuNmbE2Zim78PBpF21Pd-VkwA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Create Locales or change Template1 locale

Hi Nick,

well, of course I pretend to use UTF8, but when sorting results (collation), it's not the same sorting in English than in Spanish.

For example, this set: Óscar, Peter, Angel, in english get sorted like this: Angel, Peter, Óscar. But in Spanish, the order would be: Angel, Óscar, Peter.

There are many languages which letters allow tildes, special accents, etc, that would need special locales?

Is it too complex to implement?

Thank you very much.

2017-03-27 23:22 GMT+02:00 'paynen' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com>:

Hey Oscar,

Thanks for this report. I've replicated your findings. I'm unsure at the moment what solution to offer. Could you explain more about your use-case, and why you can't just store UTF-8 data without setting any locale?

Cheers,

Nick
Cloud Platform Community Support

On Monday, March 20, 2017 at 11:54:45 AM UTC-4, Oscar Serrano wrote:

Hi,

I'm trying to create a new postgresql database, but I cannot use the spanish Location. I've tried this:

create database mydb with ENCODING = 'UTF-8' LC_CTYPE = 'es_ES' LC_COLLATE = 'es_ES';

But I get an error: invalid Locale Name es_ES

How do I create it?

I've tried this:

postgres=> create collation es (locale="es_ES.utf8");ERROR: could not create locale "es_ES.utf8": Success
As you can say, it says Success, but also I get the error.How should I proceed?
Thank you.

--
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/mISMIL3PNFY/unsubscribe.
To unsubscribe from this group and all its topics, 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/396f11c6-1349-4510-83c8-a82f9dae81cf%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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/CANX%3DucTm-QQMs-bmEohvwDtTgrM%2B%3D%2B4iX%3DW6dpqBPvPZPuCv%2Bg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] CloudSQL connection issues with deployed Bookshelf tutorial app (App Engine/NodeJS)

I'm trying to learn Google Cloud Platform and going through the Cloud SQL bookshelf app tutorial for NodeJS (https://cloud.google.com/nodejs/getting-started/using-cloud-sql) and had no problem setting up the project, app engine, and running locally with the Cloud SQL proxy. But when deployed, I get an error (connect ECONNREFUSED 127.0.0.1:3306) when loading the app URL ([PROJECT_ID].appspot.com).

I searched for fixes and found some saying that the issue is that the NODE_ENV being looked at in the model-cloudsql.js checks to see if it is "production", but nowhere else is it defined as that, so it is trying to use localhost. So I tried adding that to the config.json and adding to env vars in config.js, and deploying, but then I get a different error (connect ENOENT /cloudsql/bookshelf-nodejs-tutorial:us-central1:bookshelf-mysql). So at least it looks like it is using the socketPath, but I can't figure out where to go from here to get the app working.

Here's some of the code I changed:

config.json:

{
  "GCLOUD_PROJECT": "************************",
  "DATA_BACKEND": "cloudsql",
  "MYSQL_USER": "****",
  "MYSQL_PASSWORD": "*******",
  "INSTANCE_CONNECTION_NAME": "bookshelf-nodejs-tutorial:us-central1:bookshelf-mysql",
  "NODE_ENV": "production"
}

config.js:

'use strict';

const nconf = module.exports = require('nconf');
const path = require('path');


nconf
  // 1. Command-line arguments
  .argv()
  // 2. Environment variables
  .env([
    'DATA_BACKEND',
    'GCLOUD_PROJECT',
    'MONGO_URL',
    'MONGO_COLLECTION',
    'MYSQL_USER',
    'MYSQL_PASSWORD',
    'PORT',
    'NODE_ENV'
  ])
  // 3. Config file
  .file({ file: path.join(__dirname, 'config.json') })
  // 4. Defaults
  .defaults({
    // dataBackend can be 'datastore', 'cloudsql', or 'mongodb'. Be sure to
    // configure the appropriate settings for each storage engine below.
    // If you are unsure, use datastore as it requires no additional
    // configuration.
    DATA_BACKEND: 'datastore',

    // This is the id of your project in the Google Cloud Developers Console.
    GCLOUD_PROJECT: '',

    // MongoDB connection string
    // https://docs.mongodb.org/manual/reference/connection-string/
    MONGO_URL: 'mongodb://localhost:27017',
    MONGO_COLLECTION: 'books',

    MYSQL_USER: '',
    MYSQL_PASSWORD: '',

    // Port the HTTP server
    PORT: 8080
  });

All other files remained the same. Any help would be appreciated so I can move on to the next sections of the tutorial.

https://[YOUR_PROJECT_ID].appspot.com

https://[YOUR_PROJECT_ID].appspot.com

https://[YOUR_PROJECT_ID].appspot.com

https://[YOUR_PROJECT_ID].appspot.com

--
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/a53619e5-082f-4330-9801-2a16dd178970%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.