Re: [google-cloud-sql-discuss] Re: Exporting (via another instance) still going on after 20+ hours

It seems you are using Serverless Export feature. For long exports, it is recommended to try exporting smaller datasets at a time, and note that serverless export takes longer to do than a standard export, because it takes time to create the temporary instance. But if the export is stuck in operation, as Elliott mentioned, we recommend to contact the premium support or report it via the Issue Tracker so that we would be able to ding into the issue.

On Friday, November 27, 2020 at 7:38:40 PM UTC-5 Ramon Tayag wrote:

Gotcha - thanks. I used this feature:

I'll get support through the link you sent, thanks.

On Sat, Nov 28, 2020 at 4:42 AM 'Elliott (Google Cloud Platform Support)' via Google Cloud SQL discuss <google-cloud...@googlegroups.com> wrote:

Hello Ramon,

To look into this, what kind of database are you exporting? Is it Cloud SQL (MySQL, Postgre, SQL Server)?

What kind of new feature are you using? Can you provide a document link?

I am unable to find common issues at this time. It sounds like you need one on one support. For this, you may consider seeking help from regular support using the link here.

On Friday, November 27, 2020 at 12:39:34 PM UTC-5 Ramon Tayag wrote:

I manually exported a db and it's been going on for 20+ hours already. I can't see the progress, so I don't know if it has stalled or really taking that long (which I doubt). I can't find a way to cancel it, either.

The db has been exported before before without issues, but this time, I saw a new feature to export using another instance, and chose it. I don't know if that has something to do with this.

I'm unable to do most things to this instance while the export runs.

Thanks for any advice in advance!

--
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/0rO-mOfxaJw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6b80932f-30ef-4e0c-8520-d15638a7d44fn%40googlegroups.com.

--

Ramon Tayag

CTO

https://bloom.solutions

+639999935105

--
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/e8aebb7e-2f00-431e-9ae4-2a4772fb9a22n%40googlegroups.com.

Re: [google-cloud-sql-discuss] Re: Exporting (via another instance) still going on after 20+ hours

Gotcha - thanks. I used this feature:

I'll get support through the link you sent, thanks.

On Sat, Nov 28, 2020 at 4:42 AM 'Elliott (Google Cloud Platform Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

Hello Ramon,

To look into this, what kind of database are you exporting? Is it Cloud SQL (MySQL, Postgre, SQL Server)?

What kind of new feature are you using? Can you provide a document link?

I am unable to find common issues at this time. It sounds like you need one on one support. For this, you may consider seeking help from regular support using the link here.

On Friday, November 27, 2020 at 12:39:34 PM UTC-5 Ramon Tayag wrote:

I manually exported a db and it's been going on for 20+ hours already. I can't see the progress, so I don't know if it has stalled or really taking that long (which I doubt). I can't find a way to cancel it, either.

The db has been exported before before without issues, but this time, I saw a new feature to export using another instance, and chose it. I don't know if that has something to do with this.

I'm unable to do most things to this instance while the export runs.

Thanks for any advice in advance!

--
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/0rO-mOfxaJw/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/6b80932f-30ef-4e0c-8520-d15638a7d44fn%40googlegroups.com.

--

Ramon Tayag

CTO

https://bloom.solutions

+639999935105

--
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/CACRsCFFM85E90oht%2BGpi67vY%3DHJKS3ofQhyt7fq%2BH%2Bf4PQ57KQ%40mail.gmail.com.

[google-cloud-sql-discuss] Re: Exporting (via another instance) still going on after 20+ hours

Hello Ramon,

To look into this, what kind of database are you exporting? Is it Cloud SQL (MySQL, Postgre, SQL Server)?

What kind of new feature are you using? Can you provide a document link?

I am unable to find common issues at this time. It sounds like you need one on one support. For this, you may consider seeking help from regular support using the link here.

On Friday, November 27, 2020 at 12:39:34 PM UTC-5 Ramon Tayag wrote:

I manually exported a db and it's been going on for 20+ hours already. I can't see the progress, so I don't know if it has stalled or really taking that long (which I doubt). I can't find a way to cancel it, either.

The db has been exported before before without issues, but this time, I saw a new feature to export using another instance, and chose it. I don't know if that has something to do with this.

I'm unable to do most things to this instance while the export runs.

Thanks for any advice 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/6b80932f-30ef-4e0c-8520-d15638a7d44fn%40googlegroups.com.

[google-cloud-sql-discuss] Exporting (via another instance) still going on after 20+ hours

I manually exported a db and it's been going on for 20+ hours already. I can't see the progress, so I don't know if it has stalled or really taking that long (which I doubt). I can't find a way to cancel it, either.

The db has been exported before before without issues, but this time, I saw a new feature to export using another instance, and chose it. I don't know if that has something to do with this.

I'm unable to do most things to this instance while the export runs.

Thanks for any advice 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/bb5abb4e-4e7b-4298-ba8a-ab8e4bc49567n%40googlegroups.com.

[google-cloud-sql-discuss] Re: How enable pldbgapi in google console postgresql

Hello,

I understand you are inquiring about how to debug the Google Cloud PostgreSQL, perhaps by Installing the PL/pgSQL Debugger Extension (pldbgapi). 

As per this documentation[1], the PL/pgSQL Debugger Extension (pldbgapi) is not one of the supported PostgreSQL extensions supported by CloudSQL. To debug CloudSQL[PostgreSQL], you should probably consider using Cloud Logging[2] or you can enable Query logs by configuring Database flags[3], please keep in mind that this may incur some charges. 

Please go through the details shared in the articles and if you have any further questions, you can post them on this thread. 

[1]https://cloud.google.com/sql/docs/postgres/extensions#postgresql-extensions-supported-by-cloud-sql
[2]https://cloud.google.com/sql/docs/postgres/instance-info#operations_and_logs

[3]https://cloud.google.com/sql/docs/mysql/diagnose-issues#query-logs

On Thursday, November 26, 2020 at 12:14:11 PM UTC-5 kory...@gmail.com wrote:

Good afternoon. Help me, please, how to enable database debugging mode in Postgresql in google console?

--
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/8438288c-e0d5-41ba-8923-a8640e228651n%40googlegroups.com.

[google-cloud-sql-discuss] How enable pldbgapi in google console postgresql

Good afternoon. Help me, please, how to enable database debugging mode in Postgresql in google console?

--
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/8f4b093d-e79f-4cee-8a23-ad6b1931c50cn%40googlegroups.com.

Re: [google-cloud-sql-discuss] SQL Server - .bak file import - "An unknown error occurred"

Hi Ausias,

As you mentioned that restore is getting failed even without starting so we can do two things here to dig down the issue.

1. Run below TSQL first to verify the backup (,bak) file.

RESTORE VERIFYONLY FROM DISK = C:\AdventureWorks.BAK
GO

2. Enable below Trace flags on session level to log more detailed information when you run the restore command.

3604,3004,3605, 3014,3213 

Regards,

Abhishek Madan 

On Thu, Nov 26, 2020 at 11:44 AM Ausias March <ausias@dribia.com> wrote:

Hi everyone,

I've been handed a .bak file from a Microsoft SQL Server DB. I'm trying to import it to newly created SQL Server Instance on Google Cloud. The file is 113 GB and I have stored it in a dedicated GS bucket.

The import starts but after ~15 minutes it fails with an unenlightening error message: "An unknown error occurred".

The Logs log five messages:

• spid55 DBCC TRACEON 3605, server process ID (SPID) 55. This is an informational message only; no user action is required.
  
• spid55 DBCC TRACEON 3014, server process ID (SPID) 55. This is an informational message only; no user action is required.
  
• spid55 Restore(MY_DB_NAME): RESTORE DATABASE started
  
• spid55 Restore(MY_DB_NAME): Opening the backup set
  
• spid55 Restore(MY_DB_NAME): Processing the leading metadata
  

But nothing about why it fails.

The storage usage increases from 0 to the 113G and drops right when it fails, which makes me believe that during that time it only copies the file.

The memory usage goes nowhere near to the instance limit.

I have tried:

• To give the instance up to 600 GB of SSD storage.
• To use the SQL Server 2017 Enterprise edition.
• Use the command line to do the import.

I would appreciate any insight anyone can give me about why this is happening and about this "An unknown error occurred" error.

Many 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/c3b705be-7d3e-4f76-ab8e-f517a95241fbn%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/CAA1X%3Dn%3DzK%3DqY60tM3KT-KQLU7W6U4oVs%3DD_5KE12DNpV9HvNag%40mail.gmail.com.

[google-cloud-sql-discuss] SQL Server - .bak file import - "An unknown error occurred"

Hi everyone,

I've been handed a .bak file from a Microsoft SQL Server DB. I'm trying to import it to newly created SQL Server Instance on Google Cloud. The file is 113 GB and I have stored it in a dedicated GS bucket.

The import starts but after ~15 minutes it fails with an unenlightening error message: "An unknown error occurred".

The Logs log five messages:

• spid55 DBCC TRACEON 3605, server process ID (SPID) 55. This is an informational message only; no user action is required.
  
• spid55 DBCC TRACEON 3014, server process ID (SPID) 55. This is an informational message only; no user action is required.
  
• spid55 Restore(MY_DB_NAME): RESTORE DATABASE started
  
• spid55 Restore(MY_DB_NAME): Opening the backup set
  
• spid55 Restore(MY_DB_NAME): Processing the leading metadata
  

But nothing about why it fails.

The storage usage increases from 0 to the 113G and drops right when it fails, which makes me believe that during that time it only copies the file.

The memory usage goes nowhere near to the instance limit.

I have tried:

• To give the instance up to 600 GB of SSD storage.
• To use the SQL Server 2017 Enterprise edition.
• Use the command line to do the import.

I would appreciate any insight anyone can give me about why this is happening and about this "An unknown error occurred" error.

Many 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/c3b705be-7d3e-4f76-ab8e-f517a95241fbn%40googlegroups.com.

[google-cloud-sql-discuss] Re: Upgrade Google Cloud PostgreSQL 11 to PostgreSQL13 failed

Hello,

I was able to find a link here indicating that the table may have been created with double quotes. To receive help specific to your project, you may want to consider a Google Issue Tracker support as Google Groups is meant for general discussions.

On Tuesday, November 24, 2020 at 1:42:41 PM UTC-5 bori...@googlemail.com wrote:

  I'm trying to upgrade Google Cloud PostgreSQL 11 to PostgreSQL13 according to https://cloud.google.com/sql/docs/postgres/upgrade-db.

I've exported my db instance in SQL format, saved the dump file into a bucket, created a new instance of v13 and tried to import the dump file into the new db.

The import process failed with an error:

ERROR: relation "one_of_my_views" does not exist

--
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/84b25777-ea84-483c-956f-57019fdb8102n%40googlegroups.com.

[google-cloud-sql-discuss] Upgrade Google Cloud PostgreSQL 11 to PostgreSQL13 failed

  I'm trying to upgrade Google Cloud PostgreSQL 11 to PostgreSQL13 according to https://cloud.google.com/sql/docs/postgres/upgrade-db.

I've exported my db instance in SQL format, saved the dump file into a bucket, created a new instance of v13 and tried to import the dump file into the new db.

The import process failed with an error:

ERROR: relation "one_of_my_views" does not exist

--
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/400d373d-520b-464e-8b53-b0cab3af6780n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Read Replica replication - auth networks

Hello,

While attempting to replicate your issue, I assigned a authorized network to a Cloud PostgreSQL instance and then created a replica. Afterwards, I assigned a different authorized network to the replica and deleted the authorized network on the original. The results were that the replica kept the new authorized network and the original.  

As you had a different experience can you provide the exact steps you took. As a note if you were to delete and then recreate the replica it would only have authorized network on the original. 

On Thursday, November 19, 2020 at 12:24:18 PM UTC-5 tibor....@ackee.cz wrote:

Hi, I have question about sql replication. I can't find how replications works for authorized networks.

I do have authorized networks on primary DB. After I delete one authorized networks, all others networks are deleted from read replica. After this point no auth networks are replicated. Even when I add manually auth network on Read replica, after redeploy it's deleted.

I would like to be able to have different auth networks on primary DB and read replica, for analytical purposes.

Database version is PostgreSQL 11.

We are using Terraform to provision DBs.

Thank 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/944ea9d5-fd1c-498c-b09d-a1603ed02a02n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud SQL MySQL8 crashes every day

Hi Elliott,

do you have any ideas why this is happening? Or how to inspect that behavior? I attached some images, showing stable resources for CPU and IO but a fluttering memory.

The reason for the decreasing memory is an automatic restart / crash, resulting in all our services loosing connection.

seba...@squidex.io schrieb am Freitag, 6. November 2020 um 20:30:25 UTC+1:

Yes, I have seen it. But the images do not provide that much value anyway. The first image would have shown that the memory usage is high but stable and the second image would have shown that the memory usage starts at around 3GB, increased during 1 or 2 days to the maximum and goes down again when mysql crashs.

On Friday, November 6, 2020 at 7:45:47 PM UTC+1 Elliott (Google Cloud Platform Support) wrote:

Hello,

The images that you provided did not make it through. Please provide REDACTED information, meaning not to reveal personal or project specific information.

Thank you.

On Friday, November 6, 2020 at 12:02:10 PM UTC-5 seba...@squidex.io wrote:

Hello together,

we have recently migrated our data from a MySQL5 instance to MySQL8 and also added more resources.

The specs of the old server are:

* 1 vCPU, 3.75 GB Memory, 84 GB SSD

The specs of the new server are:

* 2 vCPU, 7.5 GB Memory, 84 GB SSD  

The old server was at its limit but very stable. For example the memory usage was always very high but it never crashed:

The new server is a totally different story.

It crashes very often. The memory increases until it reaches the maximum and then the server crashes. In the logs we see nothing except a few bad queries that we had before and are about to optimize and the log output that mysql has been started.

We have no good idea and plan what to do at the moment.

--
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/b99745f7-ad6a-4f2f-b88b-44434d95f2b3n%40googlegroups.com.

[google-cloud-sql-discuss] Re: lamp stack, set the mysql server… log_bin=ON

Hi,

If I understand properly, you are attempting a replication (from ___, external? Which provider?) to Cloud SQL and you cannot turn on binary logs with Google.

Since Cloud SQL is a managed service, you will be restricted from certain accesses. For example, superuser is disabled and to turn on binlogs, you do it according to these[1] instructions.

If you have further issues after this, please link us the official article of the replication process at the source database. Without that, it's hard to tell if we are following standard procedure. From our end, the official procedure looks like this[2], make sure you're not missing any official steps from both providers.

[1] https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#enablingpitr

[2] https://cloud.google.com/sql/docs/mysql/replication/replication-from-external

On Tuesday, November 17, 2020 at 12:03:10 PM UTC-5 dac...@gmail.com wrote:

Hi i have a lamp stack and wish to migrate database to cloud sql. I have managed to set the server_id  to 1 and gtid_mode. ON 

however cant resolve this is the error.

mysql> SET GLOBAL log_bin=ON ; ERROR 1238 (HY000): Variable 'log_bin' is a read only variable

I create the replica but recieve this error ...   unable to connect to source database server.

I am assuming that it is because log_bin is OFF.

thanks mulilo

--
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/87573284-07ff-4153-acf6-83565725ff06n%40googlegroups.com.

[google-cloud-sql-discuss] Unable to Import SQL or CSV file to Google Cloud SQL

Hello,

I am unable to import SQL data from Google Cloud, from an external software (Superuser rights needed) or directly from Google Cloud, when I import the SQL file nothing happen:

And if I have a look on the logs I can see the error here:

There is no way to import existing SQL data. From an software or directly from Google cloud I have this error.

Thank 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/dfcd7369-b55d-4f4b-a725-22d87a78af3fn%40googlegroups.com.

[google-cloud-sql-discuss] Read Replica replication - auth networks

Hi, I have question about sql replication. I can't find how replications works for authorized networks.

I do have authorized networks on primary DB. After I delete one authorized networks, all others networks are deleted from read replica. After this point no auth networks are replicated. Even when I add manually auth network on Read replica, after redeploy it's deleted.

I would like to be able to have different auth networks on primary DB and read replica, for analytical purposes.

Database version is PostgreSQL 11.

We are using Terraform to provision DBs.

Thank 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/c7e19cde-727b-4eeb-80a3-eeec4a06c5bdn%40googlegroups.com.

[google-cloud-sql-discuss] Re: About delete binary logs file on Cloud Sql

Hello,

Binary logs cannot be manually deleted according to this document. After you disable PITR, you will need to wait about seven days.

I hope this helps.

On Wednesday, November 18, 2020 at 12:44:10 PM UTC-5 thienp...@gmail.com wrote:

I have a question about binary log on Google Cloud Sql. Now that storage on Cloud SQL is constantly increasing, I want to delete the binary logs files. I have read the documentation about it, but it is not clear that when I disable the binary logs function, will the files be deleted immediately or have to wait for the next 7 days for the files to be deleted.

 https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#disk-usage

Thank 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/d894cea7-ce6b-4b4e-9ca2-55a90b5f10c7n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Google Cloud - MySQL Database to Google Maps

Hello Paul,

That's some project but this forum is about Cloud SQL general discussions. For the community to assist you, do you have some questions specifically for Cloud SQL?

On Wednesday, November 18, 2020 at 12:44:09 PM UTC-5 paul...@gmail.com wrote:

Hi 

I am doing a project in which i have a GPS device and i have stored all of the information from the GPS into a table on mySQL database within Google Cloud Services.

Basically, for each entry in my table, i want to take this and display it on Google Maps as pins to show each of the co-ordinates.

Question 1:  To do this can i do this within the cloud seeing i am using Google Cloud Services and mySQL within Google Cloud Services.

Question 2:  Can someone tell me where to start looking to find out my next steps, link to any documentation?  

Question 3:  On a difficulty factor (for a newbie with limited programming skills) how easy/difficult is this?

Many thanks

Paul

--
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/f69458e3-ad15-4459-ba05-6a62249292a4n%40googlegroups.com.

[google-cloud-sql-discuss] Google Cloud - MySQL Database to Google Maps

Hi 

I am doing a project in which i have a GPS device and i have stored all of the information from the GPS into a table on mySQL database within Google Cloud Services.

Basically, for each entry in my table, i want to take this and display it on Google Maps as pins to show each of the co-ordinates.

Question 1:  To do this can i do this within the cloud seeing i am using Google Cloud Services and mySQL within Google Cloud Services.

Question 2:  Can someone tell me where to start looking to find out my next steps, link to any documentation?  

Question 3:  On a difficulty factor (for a newbie with limited programming skills) how easy/difficult is this?

Many thanks

Paul

--
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/393ea661-407a-4b6c-8f51-845cbf7ff755n%40googlegroups.com.

[google-cloud-sql-discuss] About delete binary logs file on Cloud Sql

I have a question about binary log on Google Cloud Sql. Now that storage on Cloud SQL is constantly increasing, I want to delete the binary logs files. I have read the documentation about it, but it is not clear that when I disable the binary logs function, will the files be deleted immediately or have to wait for the next 7 days for the files to be deleted.

 https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#disk-usage

Thank 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/557bb521-48f8-4111-86ae-bd76e7f8b5een%40googlegroups.com.