[google-cloud-sql-discuss] Re: Comparison of ways to connect to Google Cloud SQL database from GKE

Hello Aniket,

Please note that Google Groups are reserved for general Google Cloud Platform-end product discussions and not for technical issues, which is why I suggest moving the troubleshooting to Stackoverflow to obtain assistance from our programming community for your question.

--
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/300b6c61-3c5c-416a-a1f8-bb5c40cd8be8%40googlegroups.com.

[google-cloud-sql-discuss] Comparison of ways to connect to Google Cloud SQL database from GKE

I have been exploring ways to securely connect to Google Cloud SQL database. We use Google Kubernetes Engine for deployment of our Java Spring application.

So, https://cloud.google.com/sql/docs/mysql/connect-kubernetes-engine mentions of two methods to connect to cloud sql from kubernetes. We cannot use private IP method since we do not have VPC native clusters. So we choose Cloud SQL Proxy docker image as the connection medium.

Then, considering https://cloud.google.com/sql/docs/postgres/external-connection-methods, there are following options mentioned:

We cannot go by Public IP approach since our kubernetes pod IP address will be ever changing. We have already shortlisted Cloud SQL Proxy docker image. So we are left with JDBC Socket Library.

So, comparing Cloud SQL proxy and JDBC Socket Library:

 - Cloud SQL proxy would be a sidecar container in our kubernetes pod along with our application container. The application container will connect to 'localhost:5432' (proxy) with the cloud sql credentials. The proxy will be given the service account for accessing the cloud sql database. The proxy provides secure connection to cloud sql.

 - JDBC Socket Library also provides secure connection to cloud sql. A Maven dependency needs to added in the application, and the application just has to provide correct database connection string.

From the above comparison, JDBC Socket Library seems to be the better way since we won't be needing a sidecar container - cloud sql proxy.

Is there any advantage that the Cloud SQL Proxy would provide as compared to JDBC Socket Library in the case where the application is deployed in Google Kubernetes Engine?

--
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/2fa64237-801f-4864-acd2-754705127ca8%40googlegroups.com.

Re: [google-cloud-sql-discuss] Google Cloud Database doesn't support MyISAM, so how I am going to achieve this in InnoDB?

This document goes through the AUTO_INCREMENT Handling in InnoDB and provides examples and syntax. The issue with your use case is the lack of a primary unique key which is best practice for row-based replication so specifying a row will be difficult. 

--
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/30cb24f3-5427-4ee2-bdb9-3800ae4ba36f%40googlegroups.com.

Re: [google-cloud-sql-discuss] Google Cloud Database doesn't support MyISAM, so how I am going to achieve this in InnoDB?

I have this application, that needs to order items in specific order. Each listing order start with 0, so when I first loop through the data, item with id 1 gets inserted as a starting point. I could rework this part, where I just compare each id and if id is smaller than previous, then that item gets set as starting item. This aint that much of a problem, other having to spend extra time on reworking a thing that is already working, just because of Google.

The thing is, if database table structure is in way that each row has always unique id, then when user insert new item the frontend has to wait till backend has done the insert query and returned the id of row that was just inserted. After that frontend can create field and user can start filling up that field with information. But when database table structure is in a way that user 1 has items with id 1,2,3 and user 2 has items with 1,2,3,4, then when I, as user 1, was to insert new item, I already know that next item id is going to be 4. So the frontend doesn't have to wait behind backend to be done with insert query and returning the id. While backend is inserting the row, the frontend has already created a field and user can already start filling up that field with information.

On Monday, July 29, 2019 at 8:53:58 PM UTC+3, Pavel Ivanov wrote:

Can you say why do you want to achieve that? What's wrong with all ids
being unique?

On Mon, Jul 29, 2019 at 10:25 AM Gerth Ermel <gerth...@gmail.com> wrote:
>
> Basically what I want to do is to have Auto Incremental Primary Key id, that resets when two column combo is unique.
>
> This is how the database would look
> +--------+----+---------+
> | grp    | id | name    |
> +--------+----+---------+
> | fish   |  1 | lax     |
> | mammal |  1 | dog     |
> | mammal |  2 | cat     |
> | mammal |  3 | whale   |
> | bird   |  1 | penguin |
> | bird   |  2 | ostrich |
> +--------+----+---------+
>
> and this would be the query that creates table...
>
> CREATE TABLE animals (
>     grp ENUM('fish','mammal','bird') NOT NULL,
>     id MEDIUMINT NOT NULL AUTO_INCREMENT,
>     name CHAR(30) NOT NULL,
>     PRIMARY KEY (grp,id)
> ) ENGINE=MyISAM;
>
>
> ...But as Google Cloud don't support MyISAM, how I can achieve same thing in InnoDB?
>
> --
> 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/1545bd4b-cb3f-42df-8780-935d978b7689%40googlegroups.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/0da0c1e6-9e52-4a2f-a77f-1b845d591632%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud SQL Instance In Stuck/Error/Maintenance State!

Hello, 

Thank you for using Google Groups!

Based on what you described about your issue, I believe Google Cloud Platform Support would have to further investigate this instance for you. You may create a private issue on our Issue Tracker here. Creating an private issue will ensure that your Cloud SQL instance details would not be shared publicly. You may use this link here for creating a private issue.  

Look forward to hearing from you.

--
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/4afdddab-b2f9-40c5-868f-d95c817ea3f4%40googlegroups.com.

Re: [google-cloud-sql-discuss] Google Cloud Database doesn't support MyISAM, so how I am going to achieve this in InnoDB?

Can you say why do you want to achieve that? What's wrong with all ids
being unique?

On Mon, Jul 29, 2019 at 10:25 AM Gerth Ermel <gerth.ermel@gmail.com> wrote:
>
> Basically what I want to do is to have Auto Incremental Primary Key id, that resets when two column combo is unique.
>
> This is how the database would look
> +--------+----+---------+
> | grp | id | name |
> +--------+----+---------+
> | fish | 1 | lax |
> | mammal | 1 | dog |
> | mammal | 2 | cat |
> | mammal | 3 | whale |
> | bird | 1 | penguin |
> | bird | 2 | ostrich |
> +--------+----+---------+
>
> and this would be the query that creates table...
>
> CREATE TABLE animals (
> grp ENUM('fish','mammal','bird') NOT NULL,
> id MEDIUMINT NOT NULL AUTO_INCREMENT,
> name CHAR(30) NOT NULL,
> PRIMARY KEY (grp,id)
> ) ENGINE=MyISAM;
>
>
> ...But as Google Cloud don't support MyISAM, how I can achieve same thing in InnoDB?
>
> --
> 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/1545bd4b-cb3f-42df-8780-935d978b7689%40googlegroups.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/CAAG%3DWUtcsP6n_NE%3DT9Db0gxEPc3GJxOFEzS0obkbT-fubH7V0Q%40mail.gmail.com.

Re: [google-cloud-sql-discuss] Can't connect from AppEngine to CloudSql

How do you connect to your instance? Is it the same as described in https://cloud.google.com/sql/docs/mysql/connect-app-engine, or do you connect using your Cloud SQL instance's IP?

On Mon, Jul 29, 2019 at 6:40 AM Caglar Mehmet Metin <caglarmehmetmetin@gmail.com> wrote:

Hello, 

I have simple Java application. I deployed it to the AppEngine.

When I try to connect to the MySql of GCP CloudSql, I get connectoion error.
It says "Apps in this project. All authorized." 

My java app and CloudSql are in the same GCP app. 

When I add all networks ("0.0.0.0/0"), then it works. However I don't want to add this. 

What could be the reason? Is there something extra that I have to do in order to connect from AppEngine? 

Thanks and regards.

 

--
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/f6c3ac39-c157-4471-8cd7-167789f9d1b5%40googlegroups.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/CAAG%3DWUsKAwWLhyq2mUyKe7K1yYBJbc7wa7h-Qeex6HUTVr%3D6JA%40mail.gmail.com.

[google-cloud-sql-discuss] Google Cloud Database doesn't support MyISAM, so how I am going to achieve this in InnoDB?

Basically what I want to do is to have Auto Incremental Primary Key id, that resets when two column combo is unique.

This is how the database would look

+--------+----+---------+
| grp    | id | name    |
+--------+----+---------+
| fish   |  1 | lax     |
| mammal |  1 | dog     |
| mammal |  2 | cat     |
| mammal |  3 | whale   |
| bird   |  1 | penguin |
| bird   |  2 | ostrich |
+--------+----+---------+

and this would be the query that creates table...

CREATE TABLE animals (
    grp ENUM('fish','mammal','bird') NOT NULL,
    id MEDIUMINT NOT NULL AUTO_INCREMENT,
    name CHAR(30) NOT NULL,
    PRIMARY KEY (grp,id)
) ENGINE=MyISAM;

...But as Google Cloud don't support MyISAM, how I can achieve same thing in InnoDB?

--
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/1545bd4b-cb3f-42df-8780-935d978b7689%40googlegroups.com.

[google-cloud-sql-discuss] Can't connect from AppEngine to CloudSql

Hello, 

I have simple Java application. I deployed it to the AppEngine.

When I try to connect to the MySql of GCP CloudSql, I get connectoion error.
It says "Apps in this project. All authorized." 

My java app and CloudSql are in the same GCP app. 

When I add all networks ("0.0.0.0/0"), then it works. However I don't want to add this. 

What could be the reason? Is there something extra that I have to do in order to connect from AppEngine? 

Thanks and regards.

 

--
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/f6c3ac39-c157-4471-8cd7-167789f9d1b5%40googlegroups.com.

[google-cloud-sql-discuss] Re: Problem with the Public IP at the replica

Ok, thank you ever so much for your answer.

--
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/2e53e384-574a-4b25-aa7f-55cd05ae2123%40googlegroups.com.

[google-cloud-sql-discuss] Cloud SQL Instance In Stuck/Error/Maintenance State!

On a Postgres instance I set max_connections to 262142 (one below the max) and now the instance is stuck in an error loop! I can't stop it, reset it, or edit it!!! This is crazy! It appears the UI/system is generating invalid config files and I can't edit the instance b/c an update is in process, now the update has timed out with "unknown error" and only the DELETE button works and gcloud says an operation is in progress. 

HELP! How do we unset this flag to get the instance back to life? 

 I 2019-07-29T01:21:07.055077Z [1]: [2-1] db=,user= FATAL: configuration file "/pgsql/data/postgresql.conf" contains errors 

I 2019-07-29T01:21:10.824534Z [1]: [1-1] db=,user= LOG:  invalid value for parameter "max_connections": 262142    undefined  

--
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/093597e3-fdb7-4854-af4b-290fec8352fc%40googlegroups.com.

[google-cloud-sql-discuss] Re: Feature request: log to single lines

Hello,

Please note that Google Groups are reserved for general Google Cloud Platform-end product discussions and not for feature requests, which is why I suggest using Issue Tracker to create one.

--
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/b76378bb-68dd-4e98-bef6-fee372ffb469%40googlegroups.com.

[google-cloud-sql-discuss] Feature request: log to single lines

Feature Request: Make auditing of database operations in stackdriver easier

Problem: Postgres log creates one line per row in SQL statements, which means that the in Stackdriver is multi-line. In other words, no single log captures a single event. This makes the logging hard to read, and nearly impossible to mine/ monitor.

Possible solution:

If you know what the limit is on your particular platform, you could adjust the chopping-point constant in elog.c (source)

Context: 

in order to audit postgres on Stackdriver logging, I set  log_statement=all

gcloud sql instances patch MY_INSTANCE_NAME --database-flags log_statement=all




Additional reading:

• About setting CloudSQL flags
• Postgres Docs: log_statement flag
• Setting the flag does not trigger database restart

• https://stackoverflow.com/questions/722221/how-to-log-postgresql-queries

• https://stackoverflow.com/a/722236

--
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/85efb420-27e7-4994-ba03-a59d225559a2%40googlegroups.com.

[google-cloud-sql-discuss] Re: Problem with the Public IP at the replica

Hello, 

Thank you for posting on Google Groups!

Based on the screenshots and description given, it seems like you had a lot of pending actions going on. This can be seen with the number "9" on the top right corner of the screenshots. Additionally, screenshot #2 shows "Private IP" being enabled on your master which means your replica will likely have the same configurations as your master (I.e: Screenshot #3). You may wait until the actions are fully processed verify if the changes made are being reflected on your instances.  

--
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/a810942e-b4b6-4f6c-a942-a22211c597fd%40googlegroups.com.

[google-cloud-sql-discuss] Problem with the Public IP at the replica

Hello, help me please with one question.

When I upgrade the SQL master my SQL replica loses its Public IP. Is this a BUG or not?

Example:

1) There is the public IP at the replica

2) Upgrade the master

3) The replica's public IP was lost.

Thank you ever so much for your answers.

--
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/ee6b622d-1be6-4e0b-bbb4-c0a8840e3956%40googlegroups.com.

[google-cloud-sql-discuss] Re: Google cloud sql service can not drop database

Hello, 

Thank you for using Google Groups!

Seems like we will need to do some additional investigation for this issue. I would kindly request that you create a private issue with us on our Public Issue Tracker here. Creating the issue private will ensure that your database and project details will not be shared publicly. 

Looking forward to hearing from you.

--
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/d152632a-ab23-416c-87ae-632f8791cfa4%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud MySQL Orphan Tables

Hello Devin, please note that Google Groups are reserved for general Google Cloud Platform-end product discussions and not for technical issues, which is why I suggest moving the troubleshooting to Stackoverflow to obtain assistance from our programming community for your question. 

--
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/eb6a4f1e-31eb-4e5c-94b0-ceb9309072a8%40googlegroups.com.

Re: [google-cloud-sql-discuss] VPC Network Setup for Private IP access from GKE to Cloud SQL

When you create a cluster, you'll notice a link below the CPU and memory information that says something like "Availability, network, security, (...)". Click it and you'll have access to more options. One of them is the network where your cluster will operate. Choose your custom VPC and you're set.

--
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/CA%2BkCevvGaUtGkJU2-8FfKbxYv0EAG8Q4yGAZbEqaZZQrs3DuYg%40mail.gmail.com.

[google-cloud-sql-discuss] Google cloud sql service can not drop database

Hi everyone,

When I want drop my database from cloud sql I got the following message :

Operation failed: Invalid parameter: Couldn't delete database: Error 1010: Error dropping database (can't rmdir './kjw', errno: 39) .

How can I do to resolve this problem ?

--
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/3e7ac2f8-77f1-45aa-9cf6-42dcfe878127%40googlegroups.com.

Re: [google-cloud-sql-discuss] VPC Network Setup for Private IP access from GKE to Cloud SQL

Hi Pedro,

Please can you tell how you did the first point, i.e. creation of VPC network for the Kubernetes deployment? I'm not find a way to assign a network for a kubernetes deployment

On Tuesday, July 23, 2019 at 4:48:03 PM UTC+5:30, Pedro Castro Silva wrote:

Hi Aniket,

I did something similar last week and it's quite easy.

1. Create the VPC network for the Kubernetes deployment, including IP ranges and stuff

2. Create the Cloud SQL instance on VPC network defined in step 1 and activate Private IP access. Let Google create the interconnection between the database network (which you can't control) and the VPC defined in step 1.

3. Voilá! You can now access your database through the private IP.

Manual VPC peering setups are trickier but I you'll probably not going to need one.

Cheers,

Pedro

Aniket Bhadane <abha...@avaya.com> escreveu no dia terça, 23/07/2019 à(s) 09:25:

Our Spring 4 Application runs on Google Kubernetes Engine (GKE). I was going through articles for accessing Cloud SQL DB using Private IP. But I'm struggling in setting up the VPC requirements for this. From my understanding, we would need one VPC network where the Cloud SQL instance would exist. And we would need another VPC network in which our kubernetes deployment in running. And then we would have to peer the two networks. How does google facilitate creation of VPC network for Kubernetes deployment, how do you peer the two VPC networks in google cloud, what is the scope of network assignment (project, cluster, etc.), what are the conditions of IP ranges, etc. Is there any guide for setting up VPC networks for connecting GKE application to Cloud 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/68d19e67-8e06-475c-9763-8206f25ef441%40googlegroups.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/e97addf5-ca6e-43a9-8e47-ba2cbc0386ee%40googlegroups.com.

[google-cloud-sql-discuss] Cloud MySQL Orphan Tables

I have a number of orphan tables that I am unable to remove.

https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html describes how to find them

using the query:

SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%#sql%';

and returns the following results

TABLE_ID, NAME, FLAG, N_COLS, SPACE, FILE_FORMAT, ROW_FORMAT, ZIP_PAGE_SIZE, SPACE_TYPE
'10790334', 's/#sql-ib10651620-992396264', '33', '10', '15069', 'Barracuda', 'Dynamic', '0', 'Single'
'11386494', 's/#sql-ib11176578-758128583', '33', '10', '15865', 'Barracuda', 'Dynamic', '0', 'Single'
'11715795', 's/#sql-ib11550885-968245244', '33', '56', '16593', 'Barracuda', 'Dynamic', '0', 'Single'
'11884112', 's/#sql-ib11854996-1155811138', '33', '63', '16936', 'Barracuda', 'Dynamic', '0', 'Single'
'12648506', 's/#sql-ib11883996-1143057998', '33', '31', '18549', 'Barracuda', 'Dynamic', '0', 'Single'
'12877658', 's/#sql-ib11884055-1196159549', '33', '34', '19856', 'Barracuda', 'Dynamic', '0', 'Single'
'15159365', 's/#sql-ib15000139-4079941189', '33', '58', '24560', 'Barracuda', 'Dynamic', '0', 'Single'

I am unable to select any of these tables, for example:

use s;
SELECT * FROM `#mysql50##sql-ib10651620-992396264` limit 10;

Following mariadb.com/resources/blog/get-rid-of-orphaned-innodb-temporary-tables-the-right-way/, 
I tried creating a table with the same name.

I figured out which tables these orphans came from with help from the query 

SELECT * FROM
 `information_schema`.`innodb_sys_tables`
 JOIN `information_schema`.`innodb_sys_columns` USING (TABLE_ID)
 WHERE `information_schema`.`innodb_sys_tables`.`NAME` LIKE '%#sql%'

I then copied the create table statement for the related table and edited the table name.

CREATE TABLE `s`.`#sql-ib10651620-992396264` ( `ID` int(11) NOT NULL AUTO_INCREMENT, ...) ENGINE=InnoDB DEFAULT CHARSET=utf8;

and then tried to drop it

drop table `s`.`#mysql50##sql-ib10651620-992396264`;

but it could not find the table.  After dropping the created table with

drop table `#sql-ib10651620-992396264`;

the orphan table still persists.

Not a huge issue, but it would be nice to reclaim this disk space.

--
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/9b9b654f-d7ac-44de-8cf4-f0441a2952fd%40googlegroups.com.

[google-cloud-sql-discuss] Re: external replicas for PostgreSQL

Hello Barbara,

At this time, it is not possible to create external replicas for PostgreSQL per the documentation.

--
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/ee5e4a9d-02b9-4473-96f1-bc518e7b1c9a%40googlegroups.com.

[google-cloud-sql-discuss] Re: I do not connect to my BD from the shell

yes indeed, I understood it.

thank you so much

Le mardi 23 juillet 2019 16:42:08 UTC-4, Willy Kouagnia a écrit :

hi david,

thanks for your answer. it worked.

Le mercredi 17 juillet 2019 16:35:30 UTC-4, David (Cloud Platform Support) a écrit :

Hello Willy, Please note that the Cloud Shell connections do not support SSL. Connections attempted from Cloud Shell will fail if the instance is configured to accept only SSL connections. Please make sure this is not the case for your Cloud SQL instance.

--
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/fb1014b2-367e-4358-ad9d-d14e47f2d067%40googlegroups.com.

[google-cloud-sql-discuss] Re: I do not connect to my BD from the shell

hi david,

thanks for your answer. it worked.

Le mercredi 17 juillet 2019 16:35:30 UTC-4, David (Cloud Platform Support) a écrit :

Hello Willy, Please note that the Cloud Shell connections do not support SSL. Connections attempted from Cloud Shell will fail if the instance is configured to accept only SSL connections. Please make sure this is not the case for your Cloud SQL instance.

--
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/ea9fa5e5-eaf9-4f82-b800-0db82a71d367%40googlegroups.com.

[google-cloud-sql-discuss] external replicas for PostgreSQL

It is possible create external replicas for MySQL, but not for PostgreSQL.

--
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/e2b8fb57-2deb-4094-b0d4-ccd7525b46e4%40googlegroups.com.

[google-cloud-sql-discuss] Re: Console output

You can get a JSON/CSV log output from Stackdriver logs but it the message would likely only occur when the client is closed as that is when it is logged so it may not be possible to export a log before the client is closed. Stackdriver monitoring also provides details on viewing Cloud SQL metrics, including instance summary information, usage data, operation logs, and database logs. 

A small number of those errors may be expected but if it is frequent and/or causing latency it may be an issue with connection management, this document provides details on best practices suggestions. If you are implementing the best practices, please specify your use case (what service(s) are connecting with the proxy, the frequency of the connection issues etc.) as there are many causes of these connection issues or if it is expected. 

Please note that if the proxy process is terminated, all existing connections through it are dropped so making Cloud SQL proxy a persistent service is suggested. Simply restarting the proxy whenever the error occurs is likely not the solution as it would cause all existing connections to end which can cause issues for users. 

--
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/ee1549be-1984-4962-b48b-707846b5ff15%40googlegroups.com.

[google-cloud-sql-discuss] Re: Connecting Cloud SQL from Multiple GKE Replica Pods

Its difficult to determine the expected performance of the Cloud SQL proxy as it may be different for different use cases. If it seems your proxy is behaving inappropriately, opening an issue tracker will allow us to take a look at it. I have not found any specifics on Cloud SQL proxy expected performance however it helps to configure Cloud SQL and GKE around the same location. 

Private IP is the easiest way to connect from Google Kubernetes Engine if your cluster meets the requirements. If you are planning on using Public IP, the Cloud SQL proxy is needed to secure the connection. Full details on how to connect via Cloud SQL proxy and private IP is detailed here.

--
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/dfe5c4f0-5695-4ee8-ac0e-a03c90dfd6e9%40googlegroups.com.

[google-cloud-sql-discuss] Re: VPC Network Setup for Private IP access from GKE to Cloud SQL

This document goes though connecting GKE with Cloud SQL and one of the prerequisites before connection is creating a VPC-native cluster. The IPs are naively routable within the GCP network (including via VPC Network Peering) so you can set one up, create a Cloud SQL instance and configure it with private IP which includes using that same VPC Network peering that is connected with the GKE (configuring private services access is also necessary). 

--
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/1ee22de1-295e-4550-b8a7-676dbbc361f1%40googlegroups.com.

Re: [google-cloud-sql-discuss] VPC Network Setup for Private IP access from GKE to Cloud SQL

Hi Aniket,

I did something similar last week and it's quite easy.

1. Create the VPC network for the Kubernetes deployment, including IP ranges and stuff

2. Create the Cloud SQL instance on VPC network defined in step 1 and activate Private IP access. Let Google create the interconnection between the database network (which you can't control) and the VPC defined in step 1.

3. Voilá! You can now access your database through the private IP.

Manual VPC peering setups are trickier but I you'll probably not going to need one.

Cheers,

Pedro

Aniket Bhadane <abhadane@avaya.com> escreveu no dia terça, 23/07/2019 à(s) 09:25:

Our Spring 4 Application runs on Google Kubernetes Engine (GKE). I was going through articles for accessing Cloud SQL DB using Private IP. But I'm struggling in setting up the VPC requirements for this. From my understanding, we would need one VPC network where the Cloud SQL instance would exist. And we would need another VPC network in which our kubernetes deployment in running. And then we would have to peer the two networks. How does google facilitate creation of VPC network for Kubernetes deployment, how do you peer the two VPC networks in google cloud, what is the scope of network assignment (project, cluster, etc.), what are the conditions of IP ranges, etc. Is there any guide for setting up VPC networks for connecting GKE application to Cloud 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/68d19e67-8e06-475c-9763-8206f25ef441%40googlegroups.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/CA%2BkCevvu%3DU%3DpFjarUqqtNU58WfoEbUPOtkY1G0Rz1V7P9%3DHY0g%40mail.gmail.com.

[google-cloud-sql-discuss] Mysql Online Training

 MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, UNIX and Windows. What is the latest version of MySQL?How do I find my MySQL database host?

MySql Online Training

--
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/2605a53e-cbbd-4d7e-901d-d94d73bbf8f6%40googlegroups.com.

[google-cloud-sql-discuss] Connecting Cloud SQL from Multiple GKE Replica Pods

We have a Spring 4 application running of GKE and JPA for ORM. Our minimum Replica set is 4. We want to connect to Cloud SQL from these replica pods.

1. If we go by the Cloud SQL Proxy approach, the cloud sql proxy would be a sidecar container in each of the pods. Are there any resource consumption and and performance results for the cloud sql proxy? How much resources does a cloud sql proxy consume for a given rate of requests. We would obviously do this test, but are there any results from Google?

2. What is better way of communicating with Cloud SQL when there are multiple gke replica pods connecting to the cloud sql db? Cloud SQL Proxy or Private IP? 

--
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/bc031f3f-8ec1-41ff-b393-389ddc39a693%40googlegroups.com.

[google-cloud-sql-discuss] VPC Network Setup for Private IP access from GKE to Cloud SQL

Our Spring 4 Application runs on Google Kubernetes Engine (GKE). I was going through articles for accessing Cloud SQL DB using Private IP. But I'm struggling in setting up the VPC requirements for this. From my understanding, we would need one VPC network where the Cloud SQL instance would exist. And we would need another VPC network in which our kubernetes deployment in running. And then we would have to peer the two networks. How does google facilitate creation of VPC network for Kubernetes deployment, how do you peer the two VPC networks in google cloud, what is the scope of network assignment (project, cluster, etc.), what are the conditions of IP ranges, etc. Is there any guide for setting up VPC networks for connecting GKE application to Cloud 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/68d19e67-8e06-475c-9763-8206f25ef441%40googlegroups.com.

[google-cloud-sql-discuss] Console output

Hi,

I am running the Windows version of the tool.

sometimes. i am getting the message 

Client closed the local connection

I would like to monitor the tool and whenever this message appers, I want to restart the proxy

what's the best way to do it?

I've tried to export the console output to a text file, but it's exported only once the client is closed.

is there any option to export a log file while the proxy tool is running?

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/ca2c0f47-9613-4bc9-9b6f-ff9cdcf5498c%40googlegroups.com.