[google-cloud-sql-discuss] auto sync table using query

HI friends ,

I am new in Google Big query . Currently I am trying to create a table/view based on data of few different tables.

let us assume the query is like this :

create table datasetC.TableA as

select col1, col2, ..... from (

select col1,col2,col3 ,sum(col5),sum(col6) .....

   datasetA.tableA   left join  datasetA. tableb   left join  datasetA.tablec ) inner join ( select ....... datasetA.tablea ,datasetA.tableb)

union all

select col1, col2, ..... from (

select col1,col2,col3 ,sum(col5),sum(col6) .....

   datasetB.tableB   left join   datasetB.tableC   left join  datasetB.tableD ) inner join ( select ....... datasetB.tablee ,datasetB.tablef)

Now these tables are being refreshed at different times and while loading data in our table, we may have some tables which are yet to be refreshed.

Is there any way to set auto sync of the table just like we have materialised view.

normal view is not reliable as we have very huge data (around 6 tables with 50+ TB of data )  and we get memory issue.

any advice will be helpful .

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/37500f62-52f7-4c07-aa86-c5ff1509ddf2%40googlegroups.com.

[google-cloud-sql-discuss] Connect to Cloud SQL from within another pod using cloud proxy

Hi

I have setup a deployment with the following command:

 ./cloud_sql_proxy  -credential_file=/etc/secrets/mysql-gcp-sa.json -instances=kubeflow-test-servers1:us-central1:bitgrit-db=tcp:0.0.0.0:33

06

When I connect using below command:

mysql -u root --password -h 0.0.0.0

I get an entry in Stackdriver log but after a minute or so I get error:

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 22 "Invalid argument"

/

My stack driver log entry is :

{

insertId: "d1wgvneko75d" 

logName: "projects/kubeflow-test-servers1/logs/cloudaudit.googleapis.com%2Factivity" 

protoPayload: {…} 

receiveTimestamp: "2019-11-29T06:28:49.041963434Z" 

resource: {…} 

severity: "NOTICE" 

timestamp: "2019-11-29T06:28:48.170Z" 

}

What I am I doing wrong?

Why don't I get Sql prompt. Also in the pod I am using image:

gcr.io/cloudsql-docker/gce-proxy:1.14

--
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/e3edf006-27d7-4dc4-92c0-bc3508d92d7f%40googlegroups.com.

[google-cloud-sql-discuss] MySQL Not Updated in 3 years (5.7.14)

Is this product being supported anymore? Google hasn't updated this product in 3 years now. 5.7.14 contains several bugs that drastically effect performance.

We can't wait anymore on years of empty promises. We'd appreciate an official statement on this matter. Please do not post a link to the 3 year old feature request. 

--
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/a4c8b389-d290-49f6-a7fd-41b487ca26bf%40googlegroups.com.

[google-cloud-sql-discuss] Re: Connection timeout on the PostgreSQL instance.

Hello Daniele,

Please note that Google Groups are reserved for general Google Cloud Platform and product discussions and not for reporting issues, which is why I suggest moving the troubleshooting to Issue Tracker, where issues can be turned private in case we need to gather any project specific details.

--
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/f3d8f8b5-6735-406c-aca8-0c29f048656b%40googlegroups.com.

[google-cloud-sql-discuss] Re: Why I can't connect to the PostgreSQL from my webserver on SiteGround?

Hi Daniele,

I assume that you are using public IP connections [1]. You can grant any application access to a Cloud SQL instance by authorizing the public IP addresses that the application uses to connect.

Have you added the IP address of your application? If not, please follow this steps (Described in [1]):

1. Determine the IP address of your application.

2. Authorize your application's IP address to connect to your Cloud SQL Instance [2].

3. You can find the IP address assigned to your instance in its Instance details page. This is the value you need for your application's 

connection string.

If your application is dynamically assigned IP address, then you need to use  Cloud SQL Proxy[3].

Please let me know if this clarifies your inquiries.

[1] https://cloud.google.com/sql/docs/postgres/connect-external-app#appaccessIP

[2] https://cloud.google.com/sql/docs/postgres/configure-ip#add

[3} https://cloud.google.com/sql/docs/postgres/sql-proxy

--
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/009ad98e-3e2b-40f8-8a20-feffd0f92fb8%40googlegroups.com.

[google-cloud-sql-discuss] Why I can't connect to the PostgreSQL from my webserver on SiteGround?

I have a Google Cloud PostgreSQL instance. I can connect to it by several local IP addresses, after having whitelisted them in the connections tab on GCP. I developed my application and now, when I try to connect the instance from production webserver, it says:

Fatal error: Uncaught PDOException: SQLSTATE[08006] [7] could not connect to server: Connection timed out Is the server running on host "34.65.215.xx" and accepting TCP/IP connections on port 5432? 

the PHP I'm using is:

$db2 = new PDO('pgsql:host=34.65.215.xx;port=5432;dbname=xxxxx', 'postgres', 'xxxxxx');  

I wrote to my webserver support and they answered me by opening the 5432 port in output on the 34.65.215.xx IP. After that I still can't connect to the instance.

The strace says:

0.000120 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 4  0.000043 setsockopt(4, SOL_TCP, TCP_NODELAY, [1], 4) = 0  0.000031 fcntl(4, F_SETFL, O_RDONLY|O_NONBLOCK) = 0  0.000024 fcntl(4, F_SETFD, FD_CLOEXEC) = 0  0.000027 connect(4, {sa_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("34.65.215.xx")}, 16) = -1 EINPROGRESS (Operation now in progress)  0.000112 poll([{fd=4, events=POLLOUT|POLLERR}], 1, 30000) = 1 ([{fd=4, revents=POLLOUT|POLLERR|POLLHUP}])  15.270417 getsockopt(4, SOL_SOCKET, SO_ERROR, [110], [4]) = 0  0.000103 close(4) = 0  

I just don't know what to do next...

Can someone help to understand?

--
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/25841dda-5a45-43cc-9f5f-7eae29cd0868%40googlegroups.com.

[google-cloud-sql-discuss] Connection timeout on the PostgreSQL instance.

I have a Google Cloud PostgreSQL instance. I can connect to it by several local IP addresses, after having whitelisted them in the connections tab on GCP. I developed my application and now, when I try to connect the instance from production webserver, it says:

Fatal error: Uncaught PDOException: SQLSTATE[08006] [7] could not connect to server: Connection timed out Is the server running on host "34.65.215.xx" and accepting TCP/IP connections on port 5432? 

the PHP I'm using is:

$db2 = new PDO('pgsql:host=34.65.215.xx;port=5432;dbname=xxxxx', 'postgres', 'xxxxxx');  

I wrote to my webserver support and they answered me by opening the 5432 port in output on the 34.65.215.xx IP. After that I still can't connect to the instance.

The strace says:

0.000120 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 4  0.000043 setsockopt(4, SOL_TCP, TCP_NODELAY, [1], 4) = 0  0.000031 fcntl(4, F_SETFL, O_RDONLY|O_NONBLOCK) = 0  0.000024 fcntl(4, F_SETFD, FD_CLOEXEC) = 0  0.000027 connect(4, {sa_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("34.65.215.xx")}, 16) = -1 EINPROGRESS (Operation now in progress)  0.000112 poll([{fd=4, events=POLLOUT|POLLERR}], 1, 30000) = 1 ([{fd=4, revents=POLLOUT|POLLERR|POLLHUP}])  15.270417 getsockopt(4, SOL_SOCKET, SO_ERROR, [110], [4]) = 0  0.000103 close(4) = 0  

I just don't know what to do next...

Can someone help to understand?

--
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/12427e11-c7b7-4501-a2e0-dd32fdb3ba24%40googlegroups.com.

[google-cloud-sql-discuss] Re: How do i use the API KEY so i can connect an arduino with the cloud sql --> sql tables

Hello Denis,

What have you tried so far? Maybe a specific question on the steps can help you narrow down the search.

--
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/b9fe5482-9b32-4c84-9bfb-8d7bc10268ab%40googlegroups.com.

[google-cloud-sql-discuss] Re: how can I send data from an arduino to an cloud sql -> sql database -> tables(insert)

Hello Denis,

Can you please provide details on how you are trying to send data from Arduino to SQL?

--
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/6d7291e4-ff6f-40c1-8a00-13e5b21780a9%40googlegroups.com.

[google-cloud-sql-discuss] how can I send data from an arduino to an cloud sql -> sql database -> tables(insert)

Hi!

Ive got a problem which im working for 5 hours straight and I still dont get it how i can send data from arduino to sql.

--
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/ed321d9a-780e-47ea-8563-6e65237d8582%40googlegroups.com.

[google-cloud-sql-discuss] How do i use the API KEY so i can connect an arduino with the cloud sql --> sql tables

Im searching the whole web just to find out how can send data from an arduino to the cloud sql to save it in the sql database tables.

--
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/51e117f5-335f-4402-8db6-6b5a359e54bb%40googlegroups.com.

[google-cloud-sql-discuss] Re: Tablespace **** exists

Hello Raphael,

Please note that Google Groups are reserved for general Google Cloud Platform and product discussions and not for reporting issues, which is why I suggest moving the troubleshooting to Issue Tracker, where issues can be turned private in case we need to gather any project specific details.

--
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/8271a2fb-d64b-4f17-9b29-169b88d6170d%40googlegroups.com.

[google-cloud-sql-discuss] Tablespace **** exists

Hi Google Cloud SQL team,

When running a Google Cloud Mysql instance, second generation with MySQL 5.7, we are stuck with one ghost tablespace that cannot be deleted.

The error that we have if we want to create the table that has been dropped not cleanly is "Tablespace `users`' exists."

This tablespace cannot be dropped and is not visible when using :

SELECT LOGFILE_GROUP_NAME, FILE_NAME, EXTRA

     FROM INFORMATION_SCHEMA.FILES;

It seems that the file './users.ibd' has not be cleaned and cannot be cleaned.

Maybe we are missing something, can you please have a look at that or tell us what we can do?

--
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/a3f1fe81-c30e-41e5-891f-b9e6d2e7191b%40googlegroups.com.

[google-cloud-sql-discuss] Re: go sql driver unable to connect to cloud sql - googleapi: got HTTP response code 404 with body: Not Found

Hello Vishwanath,

Please note that Google Groups are reserved for general Google Cloud Platform and product discussions and not for reporting issues, which is why I suggest moving the troubleshooting to Issue Tracker, where issues can be turned private in case we need to gather any project specific details.

--
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/f1dc681e-7725-4dea-9943-66d85ff3a0e7%40googlegroups.com.

[google-cloud-sql-discuss] go sql driver unable to connect to cloud sql - googleapi: got HTTP response code 404 with body: Not Found

We have found that since yesterday, when our 2nd generation cloud sql instance got updated, the go-sql code that was used to connect to the cloud sql instance has been consistently failing. The error we get when calling the db.Ping API from go code is:

"ensure that the account has access to "[project]:us-central1:sql-1" (and make sure there's no typo in that name). Error during createEphemeral for [project]:us-central1:sql-1: googleapi: got HTTP response code 404 with body: Not Found"

Immediately after this error I see the following error by the go sql client - "Throttling refreshCfg(scio-deployment:us-central1:sql-1): it was only called 41.673428426s ago" . To re-iterate this code has been working perfectly for months but broke yesterday without any code change on our part. Any pointers to diagnose this issue is much appreciated! Thanks Vish

--
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/36128286-d354-44ca-b9fb-1472ed4b4391%40googlegroups.com.

[google-cloud-sql-discuss] Re: Private Access to Cloud SQL Postgres from GCE (New Region, Same VPC)

Hello Derek,

Please note that Google Groups are reserved for general Google Cloud Platform and product discussions and not for reporting issues, which is why I suggest moving the troubleshooting to Issue Tracker, where issues can be turned private in case we need to gather any project specific details.

--
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/cb579eb3-aca1-4011-8539-77a7e6debd36%40googlegroups.com.

[google-cloud-sql-discuss] Private Access to Cloud SQL Postgres from GCE (New Region, Same VPC)

Hi,

We have a production Cloud SQL Postgres instance running in us-west2. We also have a number of compute engine instances running in the same region which are using private access to that Cloud SQL instance.

We recently added a new region, us-central1, within the same VPC. When trying to access the Postgres instance from the new region, we cannot connect. I am unable to find any VPC firewall rules or routes that would prevent this, but have reached a roadblock. Does anyone have any guidance on where to look for this?

Thanks!

--
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/f705ff2c-290f-4401-a9d7-668a18e2a7fd%40googlegroups.com.

[google-cloud-sql-discuss] Re: Unable to fetch CloudSql metrics for Specific Database Instance

Expected string is "metric.label.instance_name". You use "metric.labels.instance_name = \"my-instance-id\" with an extra "s" in "labels". 

All this is above the scope of this discussion group, in fact off-topic. You should post such questions to StackOverflow, or other similar forums. This forum is meant for general discussion on Cloud Platform and its services. By contrast, in StackOverflow, you get in contact with experienced programmers, who are happy to help. 

--
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/c5d5c1a7-f273-4a57-8006-625158a04653%40googlegroups.com.

[google-cloud-sql-discuss] Unable to fetch CloudSql metrics for Specific Database Instance

Hello,

I am trying to fetch CPU Utilization percentage for a specific database instance. But, That gives me an exception to unable to use multiple metrics at a time. Your documentation suggests you can use multiple metrics in single request.

https://cloud.google.com/monitoring/custom-metrics/reading-metrics#monitoring_read_timeseries_fields-java

metric.type = "compute.googleapis.com/instance/cpu/usage_time"
AND (metric.label.instance_name = "your-instance-id" OR
  metric.label.instance_name = "your-other-instance-id")

The below is java code : 

public Double readCloudSqlCpuLevel() throws IOException {

  final MetricServiceClient metricServiceClient = MetricServiceClient.create();

  // Trying to read last 3 minutes data only.
  long startMillis = System.currentTimeMillis() - ((60 * 3) * 1000);

  final TimeInterval interval = TimeInterval.newBuilder()
      .setStartTime(Timestamps.fromMillis(startMillis))
      .setEndTime(Timestamps.fromMillis(System.currentTimeMillis()))
      .build();

  final String filter = "metric.type=\"cloudsql.googleapis.com/database/cpu/utilization\" AND metric.labels.instance_name = \"my-instance-id\" ";
  final ListTimeSeriesRequest.Builder requestBuilder = ListTimeSeriesRequest.newBuilder()
      .setName(projectName.toString())
      .setFilter(filter)
      .setInterval(interval)
      .setView(ListTimeSeriesRequest.TimeSeriesView.FULL);

  final ListTimeSeriesRequest request = requestBuilder.build();
  final MetricServiceClient.ListTimeSeriesPagedResponse response = metricServiceClient.listTimeSeries(request);

  Double cpuLevel = 0.0D;
  for (TimeSeries ts : response.iterateAll()) {

    for (Point pt : ts.getPointsList()) {
      cpuLevel = pt.getValue().getDoubleValue() * 100;
    }

  }
  log.info("cpuLevel : {} ", cpuLevel);
  metricServiceClient.shutdownNow();
  return cpuLevel;
}

This code gives me :

c.i.b.t.g.s.c.CloudSqlCpuCacheService    : Unable to fetch Cloud SQL CPU level from GCloud StackDriver Monitoring API : error : io.grpc.StatusRuntimeException: NOT_FOUND: The metric referenced by the provided filter is unknown. Check the metric name and labels.
g.s.c.CloudSqlCpuCacheMaintenanceService : Unable to get Cloud SQL CPU level from GCloud API : Error : com.google.api.gax.rpc.NotFoundException: io.grpc.StatusRuntimeException: NOT_FOUND: The metric referenced by the provided filter is unknown. Check the metric name and labels.

Please suggest any solution, please.

--
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/1e888152-e6f6-4917-b7f5-210ecf1a227d%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud MySql SSD to HDD?

Hello Jesse,

I have created a MySQL Cloud SQL instance on SSD. I then edited the settings to find out there is no option to change to HDD as you intend. The workaround, as you have discovered is to migrate the data.

--
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/e2a51969-ed0c-43f0-bfe4-c594f0049db2%40googlegroups.com.

[google-cloud-sql-discuss] Cloud MySql SSD to HDD?

We currently have a Google Cloud MySQL project that was created with SSD disks.  Are running we realize that we really don't need the SSD capacity but there is no directly apparent way to migrate the disks from SSD to the standard HDD.

Would the best course of action be to create a new instance on HDD and migrate the data?

Thoughts are options for this newbie?

JJ

--
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/895ee770-4a01-4945-a118-3f2ed5365995%40googlegroups.com.

[google-cloud-sql-discuss] Re: Upgrading Postgres from 9.6 to 11

I am facing the same problem. need to upgrade 9.6 to 11 and I think that manual migration is BAD!

On Thursday, September 19, 2019 at 4:57:49 PM UTC-7, Alex Gonopolskiy wrote:

I'd like to be able to upgrade my existing cloudsql postgres 9.6 instance to 11 to use some new pg 11 features.

I've been trying to figure out a good migration plan but it seems like the only option available is sql dump and restore.  The database is 100Gig+ so this will take quite some time, and I'd like to avoid downtime as much as possible.  Are there any options available? I was considering enabling statement logging: log_statement=mod, creating a dump, importing it into a pg-11 instance taking down the db + then scraping the logs to reply the latest updates into the pg-11 instance by downloading the logs and writing a script to re-run the inserts.  Seems doable but I am wondering if anyone faced this before and has had any other solutions?

--
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/7218b7b3-ec08-4c60-8ef6-d568dc47dc68%40googlegroups.com.

[google-cloud-sql-discuss] Re: Upgrading Postgres from 9.6 to 11

George, I think this is a legit question by Alex! I have a few database with lots and lots of securitie  around them. Migrating the existing 9.6 to 11 manually could break the system depending on the DB. I think there should be a supported way by GCP to do in-place upgrade.

Thoughts?

On Friday, September 20, 2019 at 10:24:24 AM UTC-7, George (Cloud Platform Support) wrote:

Hello Alex, 

You may also consider creating a replica and performing the export operation from that replica. There are various strategies to reduce impact on users when migrating your database; you may find relevant information on the Web, for instance the "Time reduction battle while migrating databases from hosted PostgreSQL to Google Cloud SQL" page. 

It may be worthwhile noting here that Google Groups are reserved for general product discussions. We cannot provide you any advice on your system's architecture, and related best solutions. For programming, database management, system architecture, you may publish detailed information in forums such as stackoverflow, where experienced programmers are happy to help.

--
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/0c73c188-7877-4f31-8845-01de94476085%40googlegroups.com.

Re: [google-cloud-sql-discuss] Temporary IP access to SQL

Thank you!

I send a request=)

Il giorno martedì 5 novembre 2019 22:23:32 UTC+1, Elliott (Google Cloud Platform Support) ha scritto:

Hello Kappa,

I noticed that you are requesting a functionality that does not exist in Cloud SQL, which is to allow public IP access for one hour.

I have found some information, which describes how you may improve Google Cloud Platform by reporting bugs and to add new features here.

The best way to proceed is to create a feature request, which will allow you to ask something to be implemented.

Please note that there is no ETA nor guarantee that a feature would be implemented but our Engineering team will consider your ideas.

--
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/c98ed894-f456-43bc-a3a7-80a22b51a7db%40googlegroups.com.

[google-cloud-sql-discuss] Re: How can I upgrade limit create number instance SQL cloud database

Hello,

I was able to find the information here. The next step is for you to complete the form here for quota increase.

--
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/ba09e10c-57d8-40c6-9057-b7d8cbc94244%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud SQL Server Instaces updating a long time

Hello Luan,

Please note that Google Groups are reserved for general Google Cloud Platform and product discussions and not for reporting issues, which is why I suggest moving the troubleshooting to Issue Tracker, where issues can be turned private in case we need to gather any project specific details.

--
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/e8b2d7da-b7ee-47c6-a2b2-d031167b02d8%40googlegroups.com.

Re: [google-cloud-sql-discuss] Temporary IP access to SQL

Hello Kappa,

I noticed that you are requesting a functionality that does not exist in Cloud SQL, which is to allow public IP access for one hour.

I have found some information, which describes how you may improve Google Cloud Platform by reporting bugs and to add new features here.

The best way to proceed is to create a feature request, which will allow you to ask something to be implemented.

Please note that there is no ETA nor guarantee that a feature would be implemented but our Engineering team will consider your ideas.

--
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/28ab4fd3-d055-47cf-baaf-3cdbb321e593%40googlegroups.com.

[google-cloud-sql-discuss] Re: about Cloud SQL connection through Cloud Proxy

Hello, 

Quotas related to Cloud SQL are listed on the "Quotas and limits" documentation page. There is no quota per second on that page. For details on Cloud SQL Proxy, you may visit About the Cloud SQL Proxy. 

--
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/0cb6a8ed-a465-4281-ad86-47502c709dbe%40googlegroups.com.

[google-cloud-sql-discuss] How can I upgrade limit create number instance SQL cloud database

How can I upgrade limit create number instance SQL cloud database more than 40

--
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/697629b3-1e5f-4a20-a9ec-8f2e6503d308%40googlegroups.com.

[google-cloud-sql-discuss] Cloud SQL Server Instaces updating a long time

Cloud SQL Server instances have been updating for a long time and I can't edit delete / disable.

--
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/cf8fd439-51ad-4b7f-8183-ba6aa0e37ccb%40googlegroups.com.

[google-cloud-sql-discuss] Re: Are there alternatives for CloudSQL PostgreSQL logical replication for now?

Based on Cloud Roadmap ( Oct 2019):

https://drive.google.com/file/d/1T82o5aiBb3quCknoopgA8DvZ8cRKRLIz/view

Both External replica and Cross Region Replication is coming to CloudSQL (PostgreSQL)  in H2-2020 - H1-2021.

On Tuesday, November 5, 2019 at 12:02:57 AM UTC, Petrus Gomes wrote:

Hi, any updates about this feature request?
Thanks

On Thursday, June 21, 2018 at 11:30:04 AM UTC-3, Katayoon (Cloud Platform Support) wrote:

Yes, currently Cloud SQL for PostgreSQL does not support replication from an external master or external replicas for Cloud SQL instances. I should note that the Cloud SQL product team are working on this feature request and it is planned to be available soon, however we cannot provide you any ETA for the implementation.

Another storage option can be using Cloud Spanner which is ideal for relational, structured data that requires transactional reads and writes.

Applying Dataflow option depends on the amount/frequency of your transactions. So, I recommend that you contact Google Cloud Platform sales team and discuss your project with them. If you have a Premium support package, the architecture advisory service is available for you as well.

I should note that Google Groups are reserved for general product discussions. We cannot provide you any advice on your system's architecture.

--
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/d660524a-ddb1-49c9-8301-ab9ef7ca91a1%40googlegroups.com.

[google-cloud-sql-discuss] Re: Are there alternatives for CloudSQL PostgreSQL logical replication for now?

Hi, any updates about this feature request?
Thanks

On Thursday, June 21, 2018 at 11:30:04 AM UTC-3, Katayoon (Cloud Platform Support) wrote:

Yes, currently Cloud SQL for PostgreSQL does not support replication from an external master or external replicas for Cloud SQL instances. I should note that the Cloud SQL product team are working on this feature request and it is planned to be available soon, however we cannot provide you any ETA for the implementation.

Another storage option can be using Cloud Spanner which is ideal for relational, structured data that requires transactional reads and writes.

Applying Dataflow option depends on the amount/frequency of your transactions. So, I recommend that you contact Google Cloud Platform sales team and discuss your project with them. If you have a Premium support package, the architecture advisory service is available for you as well.

I should note that Google Groups are reserved for general product discussions. We cannot provide you any advice on your system's architecture.

--
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/fa99897f-f25d-4c6c-bfa1-9a3aca261e50%40googlegroups.com.