September 2015

Tuesday, September 29, 2015

[google-cloud-sql-discuss] is this a right script to connect cloud sql with php

i am unable to connect my cloud sql with my php script. scirpt is as follow:-

<?php

//Create the connection

$con = new mysqli(':/cloudsql/testingscript3:dbin',

'root', // username

'', // password

'secure_login',

);

// Write query

$strSQL = "INSERT INTO newsfeed (News) VALUES ('hghhgjjhjj')";

// Execute the query.

$query = mysqli_query($con, $strSQL);

if ($query)

{

echo "query is executed";

}

// Close the connection

mysqli_close($con);

--
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/1ff29c26-c3ff-473b-a36a-0d17f9044388%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Sunday, September 27, 2015

[google-cloud-sql-discuss] Re: i deploy my new script but still it run my old script

Hey Manu,

Make sure the new script is defined as default version/module of your application. For more information on this topic, visit these articles: Application hierarchy, Optional elements, Managing Versions.

Sincerely,

Kamran

On Friday, September 25, 2015 at 7:49:06 PM UTC-4, Manu wrote:

i deploy my new script but still it run my old script

--
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/a32613e4-d29a-4441-aea4-fdd00eef3298%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Saturday, September 26, 2015

Re: [google-cloud-sql-discuss] Re: When can I create instance with the same instance ID as instance deleted before?

Thank you Kamran.

Oh, 2 monthes are so long...
I will consider another name.

Hope this restriction is removed in the future...

Sincerely,
Jumpei

Jumpei Ogawa (小川純平)
Software Engineer, GrowAsPeople <http://growaspeople.org>

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

[google-cloud-sql-discuss] mysql connection is established but database is not connected

mysql connection is established but database is not connected.

showing the following error :- " No connection could be made because the target machine actively refused it. "

--
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/4768b675-024d-4263-ad24-09dcec6257c9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: When can I create instance with the same instance ID as instance deleted before?

Hi Jumpei,

As stated in this article, the name of the deleted instance is unavailable for up to two months before it can be reused.

Sincerely,

On Saturday, September 26, 2015 at 12:45:04 AM UTC-4, Jumpei Ogawa wrote:

Hi,

I tried to create instance with instance ID "xxx-master", but I couldn't and got error message:

"This instance ID isn't available because it was used recently"

I have created and deleted an instance named "xxx-master" yesterday, so that seems the reason why I got above error.

But how long do I have to wait to create instance with the same ID again?

# BTW I posted request to remove this restriction on UserVoice:
# http://googlecloudplatform.uservoice.com/forums/302613-cloud-sql/suggestions/9919266-bug-cannot-create-instance-with-the-same-name-as

Thank you in advance,

Jumpei

--
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/d61d3ea6-bdc7-4f58-9122-437df90cd560%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Replication from in-house MySQL (master) to Google SQL (slave)

Hi Easwar,

I am absolutely willing to try it! Feel free to send me an email (mdorfman at mountwashington dot org) if you want to work with me privately, otherwise I look forward to your response here! What are the first steps in doing this?

Another issue which I didn't originally mention-our database is behind a firewall, so I'm guessing I'll have to punch a hole through the firewall before I can do this.

Thanks,

Mike

On Friday, September 25, 2015 at 5:38:54 PM UTC-4, Easwar Swaminathan wrote:

You could create a CloudSQL replica from an on-premises master by using the CloudSQL Admin API. There is no support as of now in the UI or gcloud. But if you are willing to try out with the API, I can help you out in the process. Please let me know.

On Fri, Sep 25, 2015 at 10:46 AM, 'David Newgas' via Google Cloud SQL discuss <google-cloud...@googlegroups.com> wrote:
So the main advantages of Cloud SQL, which you would lose if you went to MySQL on GCE are:
Replication of back end data across multiple zones, allowing easy resilience against zone-level outages.
No need to manage an extra server
Automatic daily backups, kept for one week
Option to stop your instance when it is not in use (probably not relevant for you)
Automatic management of software upgrades.

Coincidentally I just saw a similar request on stack overflow. A fourth option occurred to me: You can use the `mysqlbinlog` command to dump your binary log as SQL statements, which you can send to your Cloud SQL instance without formally making it a slave. This is not super resilient, but might do the job for you (esp as if there is a problem you can just nuke and re-create the Cloud SQL instance).

David

On Fri, Sep 25, 2015 at 10:39 AM, Mike Dorfman <mdor...@mountwashington.org> wrote:
Hi David,

Thanks for the reply! Unfortunately, I have an appspot project which accesses this data (see xmountwashington.appspot.com/csc.html), so bullet #3 wouldn't work. The displayed data is assumed to be live and instantaneous (updated every minute), so I'm not sure bullet #2 would work either.

I'm very interested in bullet #1. What pros and cons would Cloud SQL have over MySQL on a GCE instance?

Thanks,
Mike

On Friday, September 25, 2015 at 12:20:26 PM UTC-4, David Newgas wrote:
Hi Mike,

Super exciting to hear about Google Cloud Platform being used for such valuable purposes. Publicly sharing real-time weather data? So cool.

Unfortunately as you noticed replication to Cloud SQL instances from outside is not supported. Some alternatives are:
If you run MySQL on a GCE instance you can make that instance the slave, but then you loose the advantages of Cloud SQL.
If you are willing to suffer some lag you could replace your federation & trigger solution with a periodic export & import.
If you don't need your public dataset to be queriable you could also share it as static files over GCS, for example as a SQL dump (or even csv).
Yours,
David

On Fri, Sep 25, 2015 at 4:37 AM, Mike Dorfman <mdor...@mountwashington.org> wrote:
I have a setup where data flows from various remote sensing sites to a centralized linux (centos) server with a MySQL database. I want to then replicate this database out to Google SQL so the data can be publicly available (read-only). I see that replication is not supported with the master being an in-house MySQL database and slave being Google SQL, but I was wondering what alternatives there may be. I've set up a federated table on my in-house server (essentially a link to the Google SQL table), and I've created a trigger to write to both this federated table as well as our in-house table. This is far from an ideal solution, as it's unbearably slow and has some pretty critical limitations (for example, it doesn't support INSERT...ON DUPLICATE KEY UPDATE, which is very important for my application). This data is critical for the functioning of our organization (whether or not we have internet access), so I don't feel comfortable writing directly to Google SQL and replicating back to our internal MySQL database in case we lose internet access. Are there any alternatives for a setup like this? Have people run into this in the past?

--
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/b73d07fd-ceae-4ac2-a146-9694466b5299%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ef57a530-9fa5-45ca-814a-e8b2e762e888%40googlegroups.com.

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bbvkNDEuEHMkW-dKcGoN%3DWO%2BQHL7cZGuWXcLRZNV67ciQ%40mail.gmail.com.

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/7b480c7c-2fcc-4aa6-b1c0-b498e6433a88%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Friday, September 25, 2015

[google-cloud-sql-discuss] When can I create instance with the same instance ID as instance deleted before?

Hi,

I tried to create instance with instance ID "xxx-master", but I couldn't and got error message:

"This instance ID isn't available because it was used recently"

I have created and deleted an instance named "xxx-master" yesterday, so that seems the reason why I got above error.

But how long do I have to wait to create instance with the same ID again?

# BTW I posted request to remove this restriction on UserVoice:
# http://googlecloudplatform.uservoice.com/forums/302613-cloud-sql/suggestions/9919266-bug-cannot-create-instance-with-the-same-name-as

Thank you in advance,

Jumpei

--
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/33c06596-b70c-424c-adfc-864dceee1bfc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] i deploy my new script but still it run my old script

i deploy my new script but still it run my old script

--
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/f11e063d-cdfb-41ef-9396-41af8b172ece%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] my php script is working fine in GAE but not on the server

thanks a lot bro...

now my script is working fine

--
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/1b668bb9-c3dc-48e2-b518-5cb11814ac1f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Replication from in-house MySQL (master) to Google SQL (slave)

RE: "You could create a CloudSQL replica from an on-premises master by using the CloudSQL Admin API."

Any chance this supports master-master?

--
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/c43c78d9-f665-4853-b892-f406042a81b0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] my php script is working fine in GAE but not on the server

I believe if you are using mysql_connect you need to prepend ':' to the socket. So you should use:

$conn = mysql_connect(':/cloudsql/<your-project-id>:<your-instance-name>',
  'root', // username
  ''      // password
  );
mysql_select_db('<database-name'>);

As shown in our documentation.

On Fri, Sep 25, 2015 at 2:51 PM, help <surveyofca@gmail.com> wrote:

it is still showing the same error.

error message :- Could not get data: Unable to find the socket transport "unix" - did you forget to enable it when you configured PHP?

<?php
echo 'Hello world!';

$conn = mysql_connect('/cloudsql/testingqweqwe:gh',
'root', // username
'' // password
);
if ($conn)
{
echo "connection established";
}
$checkdb = mysql_select_db('test');
if ($conn)
{
echo "database connected";
}
$sql = "INSERT INTO test (name) VALUES (123)";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
echo "successfully done ";
?>

--
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/6f0efa62-5434-42db-b3cd-ba269d521a38%40googlegroups.com.

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bb3cXYQ34sikTb5_zvB7LUaz%3DRy%3Dp-KP6LnPUe1Ucqszg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] my php script is working fine in GAE but not on the server

it is still showing the same error.

error message :- Could not get data: Unable to find the socket transport "unix" - did you forget to enable it when you configured PHP?

<?php
echo 'Hello world!';

$conn = mysql_connect('/cloudsql/testingqweqwe:gh',
'root', // username
'' // password
);
if ($conn)
{
echo "connection established";
}
$checkdb = mysql_select_db('test');
if ($conn)
{
echo "database connected";
}
$sql = "INSERT INTO test (name) VALUES (123)";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
echo "successfully done ";
?>

--
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/6f0efa62-5434-42db-b3cd-ba269d521a38%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Replication from in-house MySQL (master) to Google SQL (slave)

You could create a CloudSQL replica from an on-premises master by using the CloudSQL Admin API. There is no support as of now in the UI or gcloud. But if you are willing to try out with the API, I can help you out in the process. Please let me know.

On Fri, Sep 25, 2015 at 10:46 AM, 'David Newgas' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

So the main advantages of Cloud SQL, which you would lose if you went to MySQL on GCE are:
Replication of back end data across multiple zones, allowing easy resilience against zone-level outages.
No need to manage an extra server
Automatic daily backups, kept for one week
Option to stop your instance when it is not in use (probably not relevant for you)
Automatic management of software upgrades.

Coincidentally I just saw a similar request on stack overflow. A fourth option occurred to me: You can use the `mysqlbinlog` command to dump your binary log as SQL statements, which you can send to your Cloud SQL instance without formally making it a slave. This is not super resilient, but might do the job for you (esp as if there is a problem you can just nuke and re-create the Cloud SQL instance).

David

On Fri, Sep 25, 2015 at 10:39 AM, Mike Dorfman <mdorfman@mountwashington.org> wrote:
Hi David,

Thanks for the reply! Unfortunately, I have an appspot project which accesses this data (see xmountwashington.appspot.com/csc.html), so bullet #3 wouldn't work. The displayed data is assumed to be live and instantaneous (updated every minute), so I'm not sure bullet #2 would work either.

I'm very interested in bullet #1. What pros and cons would Cloud SQL have over MySQL on a GCE instance?

Thanks,
Mike

On Friday, September 25, 2015 at 12:20:26 PM UTC-4, David Newgas wrote:
Hi Mike,

Super exciting to hear about Google Cloud Platform being used for such valuable purposes. Publicly sharing real-time weather data? So cool.

Unfortunately as you noticed replication to Cloud SQL instances from outside is not supported. Some alternatives are:
If you run MySQL on a GCE instance you can make that instance the slave, but then you loose the advantages of Cloud SQL.
If you are willing to suffer some lag you could replace your federation & trigger solution with a periodic export & import.
If you don't need your public dataset to be queriable you could also share it as static files over GCS, for example as a SQL dump (or even csv).
Yours,
David

On Fri, Sep 25, 2015 at 4:37 AM, Mike Dorfman <mdor...@mountwashington.org> wrote:
I have a setup where data flows from various remote sensing sites to a centralized linux (centos) server with a MySQL database. I want to then replicate this database out to Google SQL so the data can be publicly available (read-only). I see that replication is not supported with the master being an in-house MySQL database and slave being Google SQL, but I was wondering what alternatives there may be. I've set up a federated table on my in-house server (essentially a link to the Google SQL table), and I've created a trigger to write to both this federated table as well as our in-house table. This is far from an ideal solution, as it's unbearably slow and has some pretty critical limitations (for example, it doesn't support INSERT...ON DUPLICATE KEY UPDATE, which is very important for my application). This data is critical for the functioning of our organization (whether or not we have internet access), so I don't feel comfortable writing directly to Google SQL and replicating back to our internal MySQL database in case we lose internet access. Are there any alternatives for a setup like this? Have people run into this in the past?

--
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/b73d07fd-ceae-4ac2-a146-9694466b5299%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ef57a530-9fa5-45ca-814a-e8b2e762e888%40googlegroups.com.

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bbvkNDEuEHMkW-dKcGoN%3DWO%2BQHL7cZGuWXcLRZNV67ciQ%40mail.gmail.com.

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CANuxmaKSj5%2BQeEW_Mk3-QWFZCJyANdtPQ-xMX59bcZHG5kv0pA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] my php script is working fine in GAE but not on the server

Hi,

As documented, when connecting from Google App Engine to Google Cloud SQL you should not connect by IP, instead you should connect to a socket at /cloudsql/<your-project-id>:<your-instance-name> (normally with username 'root' and blank password).

Yours,

David

On Fri, Sep 25, 2015 at 2:21 PM, help <surveyofca@gmail.com> wrote:

my php script is working fine in GAE but not on the server. If i run this script on my computer it is working fine , cloud sql database is also updated but this script is not working on cloud. Show error :- Could not get data: Unable to find the socket transport "unix" - did you forget to enable it when you configured PHP?

script is as follow :-

<?php

$conn = mysql_connect('173.194.249.431',
'anurag', // username
'sdsdsZcz' // password
);
if ($conn)
{
echo "connection established";
}
$checkdb = mysql_select_db('test');
if ($conn)
{
echo "database connected";
}
$sql = "INSERT INTO test (name) VALUES (123)";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
echo "successfully done ";
?>

--
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/d1eeea7b-8816-4ea0-9fbf-615b125adc8a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bYJS%2BfhWsGLOgL%3DeGP1tTLQx0sQXWNxTzyLF3dRBUzOTA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] my php script is working fine in GAE but not on the server

my php script is working fine in GAE but not on the server. If i run this script on my computer it is working fine , cloud sql database is also updated but this script is not working on cloud. Show error :- Could not get data: Unable to find the socket transport "unix" - did you forget to enable it when you configured PHP?

script is as follow :-

<?php

$conn = mysql_connect('173.194.249.431',

'anurag', // username

'sdsdsZcz' // password

);

if ($conn)

{

echo "connection established";

}

$checkdb = mysql_select_db('test');

if ($conn)

{

echo "database connected";

}

$sql = "INSERT INTO test (name) VALUES (123)";

$retval = mysql_query( $sql, $conn );

if(! $retval )

{

die('Could not get data: ' . mysql_error());

}

echo "successfully done ";

--
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/d1eeea7b-8816-4ea0-9fbf-615b125adc8a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Replication from in-house MySQL (master) to Google SQL (slave)

So the main advantages of Cloud SQL, which you would lose if you went to MySQL on GCE are:

Replication of back end data across multiple zones, allowing easy resilience against zone-level outages.
No need to manage an extra server
Automatic daily backups, kept for one week
Option to stop your instance when it is not in use (probably not relevant for you)
Automatic management of software upgrades.

Coincidentally I just saw a similar request on stack overflow. A fourth option occurred to me: You can use the `mysqlbinlog` command to dump your binary log as SQL statements, which you can send to your Cloud SQL instance without formally making it a slave. This is not super resilient, but might do the job for you (esp as if there is a problem you can just nuke and re-create the Cloud SQL instance).

David

On Fri, Sep 25, 2015 at 10:39 AM, Mike Dorfman <mdorfman@mountwashington.org> wrote:

Hi David,

Thanks for the reply! Unfortunately, I have an appspot project which accesses this data (see xmountwashington.appspot.com/csc.html), so bullet #3 wouldn't work. The displayed data is assumed to be live and instantaneous (updated every minute), so I'm not sure bullet #2 would work either.

I'm very interested in bullet #1. What pros and cons would Cloud SQL have over MySQL on a GCE instance?

Thanks,
Mike

On Friday, September 25, 2015 at 12:20:26 PM UTC-4, David Newgas wrote:
Hi Mike,

Super exciting to hear about Google Cloud Platform being used for such valuable purposes. Publicly sharing real-time weather data? So cool.

Unfortunately as you noticed replication to Cloud SQL instances from outside is not supported. Some alternatives are:
If you run MySQL on a GCE instance you can make that instance the slave, but then you loose the advantages of Cloud SQL.
If you are willing to suffer some lag you could replace your federation & trigger solution with a periodic export & import.
If you don't need your public dataset to be queriable you could also share it as static files over GCS, for example as a SQL dump (or even csv).
Yours,
David

On Fri, Sep 25, 2015 at 4:37 AM, Mike Dorfman <mdor...@mountwashington.org> wrote:
I have a setup where data flows from various remote sensing sites to a centralized linux (centos) server with a MySQL database. I want to then replicate this database out to Google SQL so the data can be publicly available (read-only). I see that replication is not supported with the master being an in-house MySQL database and slave being Google SQL, but I was wondering what alternatives there may be. I've set up a federated table on my in-house server (essentially a link to the Google SQL table), and I've created a trigger to write to both this federated table as well as our in-house table. This is far from an ideal solution, as it's unbearably slow and has some pretty critical limitations (for example, it doesn't support INSERT...ON DUPLICATE KEY UPDATE, which is very important for my application). This data is critical for the functioning of our organization (whether or not we have internet access), so I don't feel comfortable writing directly to Google SQL and replicating back to our internal MySQL database in case we lose internet access. Are there any alternatives for a setup like this? Have people run into this in the past?

--
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/b73d07fd-ceae-4ac2-a146-9694466b5299%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ef57a530-9fa5-45ca-814a-e8b2e762e888%40googlegroups.com.

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bbvkNDEuEHMkW-dKcGoN%3DWO%2BQHL7cZGuWXcLRZNV67ciQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Replication from in-house MySQL (master) to Google SQL (slave)

Hi David,

Thanks for the reply! Unfortunately, I have an appspot project which accesses this data (see xmountwashington.appspot.com/csc.html), so bullet #3 wouldn't work. The displayed data is assumed to be live and instantaneous (updated every minute), so I'm not sure bullet #2 would work either.

I'm very interested in bullet #1. What pros and cons would Cloud SQL have over MySQL on a GCE instance?

Thanks,

Mike

On Friday, September 25, 2015 at 12:20:26 PM UTC-4, David Newgas wrote:

Hi Mike,

Super exciting to hear about Google Cloud Platform being used for such valuable purposes. Publicly sharing real-time weather data? So cool.

Unfortunately as you noticed replication to Cloud SQL instances from outside is not supported. Some alternatives are:
If you run MySQL on a GCE instance you can make that instance the slave, but then you loose the advantages of Cloud SQL.
If you are willing to suffer some lag you could replace your federation & trigger solution with a periodic export & import.
If you don't need your public dataset to be queriable you could also share it as static files over GCS, for example as a SQL dump (or even csv).
Yours,
David

On Fri, Sep 25, 2015 at 4:37 AM, Mike Dorfman <mdor...@mountwashington.org> wrote:
I have a setup where data flows from various remote sensing sites to a centralized linux (centos) server with a MySQL database. I want to then replicate this database out to Google SQL so the data can be publicly available (read-only). I see that replication is not supported with the master being an in-house MySQL database and slave being Google SQL, but I was wondering what alternatives there may be. I've set up a federated table on my in-house server (essentially a link to the Google SQL table), and I've created a trigger to write to both this federated table as well as our in-house table. This is far from an ideal solution, as it's unbearably slow and has some pretty critical limitations (for example, it doesn't support INSERT...ON DUPLICATE KEY UPDATE, which is very important for my application). This data is critical for the functioning of our organization (whether or not we have internet access), so I don't feel comfortable writing directly to Google SQL and replicating back to our internal MySQL database in case we lose internet access. Are there any alternatives for a setup like this? Have people run into this in the past?

--
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/b73d07fd-ceae-4ac2-a146-9694466b5299%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ef57a530-9fa5-45ca-814a-e8b2e762e888%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Replication from in-house MySQL (master) to Google SQL (slave)

Hi Mike,

Super exciting to hear about Google Cloud Platform being used for such valuable purposes. Publicly sharing real-time weather data? So cool.

Unfortunately as you noticed replication to Cloud SQL instances from outside is not supported. Some alternatives are:

If you run MySQL on a GCE instance you can make that instance the slave, but then you loose the advantages of Cloud SQL.
If you are willing to suffer some lag you could replace your federation & trigger solution with a periodic export & import.
If you don't need your public dataset to be queriable you could also share it as static files over GCS, for example as a SQL dump (or even csv).

Yours,

David

On Fri, Sep 25, 2015 at 4:37 AM, Mike Dorfman <mdorfman@mountwashington.org> wrote:

I have a setup where data flows from various remote sensing sites to a centralized linux (centos) server with a MySQL database. I want to then replicate this database out to Google SQL so the data can be publicly available (read-only). I see that replication is not supported with the master being an in-house MySQL database and slave being Google SQL, but I was wondering what alternatives there may be. I've set up a federated table on my in-house server (essentially a link to the Google SQL table), and I've created a trigger to write to both this federated table as well as our in-house table. This is far from an ideal solution, as it's unbearably slow and has some pretty critical limitations (for example, it doesn't support INSERT...ON DUPLICATE KEY UPDATE, which is very important for my application). This data is critical for the functioning of our organization (whether or not we have internet access), so I don't feel comfortable writing directly to Google SQL and replicating back to our internal MySQL database in case we lose internet access. Are there any alternatives for a setup like this? Have people run into this in the past?

--
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/b73d07fd-ceae-4ac2-a146-9694466b5299%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_ba443smrtS2J1RXD8PV-LDbQ0-Dj97wj%2B01STDVbdA3%3Dg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Replication from in-house MySQL (master) to Google SQL (slave)

I have a setup where data flows from various remote sensing sites to a centralized linux (centos) server with a MySQL database. I want to then replicate this database out to Google SQL so the data can be publicly available (read-only). I see that replication is not supported with the master being an in-house MySQL database and slave being Google SQL, but I was wondering what alternatives there may be. I've set up a federated table on my in-house server (essentially a link to the Google SQL table), and I've created a trigger to write to both this federated table as well as our in-house table. This is far from an ideal solution, as it's unbearably slow and has some pretty critical limitations (for example, it doesn't support INSERT...ON DUPLICATE KEY UPDATE, which is very important for my application). This data is critical for the functioning of our organization (whether or not we have internet access), so I don't feel comfortable writing directly to Google SQL and replicating back to our internal MySQL database in case we lose internet access. Are there any alternatives for a setup like this? Have people run into this in the past?

--
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/b73d07fd-ceae-4ac2-a146-9694466b5299%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Wednesday, September 23, 2015

[google-cloud-sql-discuss] Re: replica over multiple regions

Hey Theo,

Feel free to make feature requests in the Public Issue Tracker for Cloud SQL. As far as inter-regional replication until your feature request is implemented (one can hope), you could always use Compute Engine to deploy a simple MySQL 5.5 intance, and set up External Replication to that.

On Tuesday, September 22, 2015 at 4:41:12 PM UTC-4, Theo Overboom wrote:

I'm trying to figure out how I can setup a replica of 2 cloud sql instances over 2 regions (europe and us) Unfortunately the console doesn't allow "inter regional replication" --> would be a nice feature.

The documentation only describes a way to have local replica.

Anybody a thought how I can setup a replica?

thanks for your feedback,

Theo.

--
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/ecf7556b-4c85-48ed-a1b9-9c719ccde1bb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cloud SQL and MariaDB10.1?

RE "The replication story on Cloud SQL is a little different but is something that we are working on internally."

Any chance that will include something like the CONNECT Engine features of MariaDB 10.1 ?

--
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/9478cce9-2c05-4679-9d4c-1eab5247a623%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Tuesday, September 22, 2015

[google-cloud-sql-discuss] replica over multiple regions

I'm trying to figure out how I can setup a replica of 2 cloud sql instances over 2 regions (europe and us) Unfortunately the console doesn't allow "inter regional replication" --> would be a nice feature.

The documentation only describes a way to have local replica.

Anybody a thought how I can setup a replica?

thanks for your feedback,

Theo.

Disclaimer:

Als je dit bericht per ongeluk hebt ontvangen, zend het dan niet door aan iemand anders (het kan vertrouwelijke en/of persoonlijke informatie bevatten), maar verwijder het, inclusief alle bijlagen. Laat de afzender weten dat het bij de verkeerde persoon werd afgeleverd. Bedankt.

--
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/eca5c560-0ae7-43aa-8713-290d9144918d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cloud SQL and MariaDB10.1?

Thanks for the feedback.

I don't think you will see MariaDB on Cloud SQL in the near term. However a native JSON type and multiple triggers of the same type are part of MySQL 5.7, so these will probably be coming to Cloud SQL that way. The replication story on Cloud SQL is a little different but is something that we are working on internally.

David

On Tue, Sep 22, 2015 at 10:07 AM, Robert Dyas <robert.dyas@parasql.com> wrote:

Native JSON support, multiple triggers of same type per table (for integration solutions based on triggers added to existing systems), multi-master (assuming one master can be on premises). Basically all of these are related one way or another to migrating legacy systems to Cloud SQL for use with www.parasql.com apps and reporting.

On Tue, Sep 22, 2015 at 12:27 PM David Newgas <dnewgas@google.com> wrote:
Not that I know of. Is there any particular feature you are interested in?

David

On Tue, Sep 22, 2015 at 9:18 AM, <robert.dyas@parasql.com> wrote:
Is there any unofficial guesstimate for when Cloud SQL might offer MariaDB10.1 features?

--
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/4cc7ff06-02ab-47af-9cb5-5365f2ec7b61%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Robert Dyas
robert.dyas@parasql.com
ParaSQL LLC
www.parasql.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/CAJZK_bY5GeFsGoUKX01WEDLAvZnxuN3dchXSVPzDV4SL7q%2Bdig%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cloud SQL and MariaDB10.1?

Native JSON support, multiple triggers of same type per table (for integration solutions based on triggers added to existing systems), multi-master (assuming one master can be on premises). Basically all of these are related one way or another to migrating legacy systems to Cloud SQL for use with www.parasql.com apps and reporting.

On Tue, Sep 22, 2015 at 12:27 PM David Newgas <dnewgas@google.com> wrote:

Not that I know of. Is there any particular feature you are interested in?

David

On Tue, Sep 22, 2015 at 9:18 AM, <robert.dyas@parasql.com> wrote:
Is there any unofficial guesstimate for when Cloud SQL might offer MariaDB10.1 features?

--
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/4cc7ff06-02ab-47af-9cb5-5365f2ec7b61%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Robert Dyas
robert.dyas@parasql.com
ParaSQL LLC
www.parasql.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/CABoH82hFh8L%2BJ7%3DoNW3UZgs0JNfDE8y_R%2B%2BCmwSpxQij6SF-ZA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Cloud SQL and MariaDB10.1?

Not that I know of. Is there any particular feature you are interested in?

David

On Tue, Sep 22, 2015 at 9:18 AM, <robert.dyas@parasql.com> wrote:

Is there any unofficial guesstimate for when Cloud SQL might offer MariaDB10.1 features?

--
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/4cc7ff06-02ab-47af-9cb5-5365f2ec7b61%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bahuXTBaOd6tHZ0%3Di2bBeuK7Bsgbg42rFbXqEQu6dMnbA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Cloud SQL and MariaDB10.1?

Is there any unofficial guesstimate for when Cloud SQL might offer MariaDB10.1 features?

--
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/4cc7ff06-02ab-47af-9cb5-5365f2ec7b61%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Monday, September 21, 2015

[google-cloud-sql-discuss] Re: 1030 Got error 28 from storage engine...

Hi Hans,

From reading your question, this looks like something more of a fit for Stack Overflow, as you're trying to get rid of a precise error. I would therefore suggest you go post your question there. We do monitor the Google Cloud Platform tags, so you might get an answer from one of the support team, or from the Stack community itself.

Do keep in mind you will need to provide a lot more information to get this resolved though. I don't even know where this error appears, or what code causes it to be thrown. Include all that information into your Stack Overflow question, this will help in getting a quicker, more accurate answer.

Cheers!

On Saturday, September 19, 2015 at 1:40:28 PM UTC-4, Hans Simtanda Caspersen wrote:

Why on do i always get > 1030 Got error 28 from storage engine SQL=SHOW FULL COLUMNS FROM `hlf_23062015xipt_settings` < error on my joomla sites regardless of my bootdisk size?

--
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/3f5a63c2-e7eb-4081-9a27-e7ddf31426db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Saturday, September 19, 2015

[google-cloud-sql-discuss] 1030 Got error 28 from storage engine...

Why on do i always get > 1030 Got error 28 from storage engine SQL=SHOW FULL COLUMNS FROM `hlf_23062015xipt_settings` < error on my joomla sites regardless of my bootdisk size?

--
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/60c1c311-a041-46aa-b9d0-b7df577b20f3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Wednesday, September 16, 2015

Re: [google-cloud-sql-discuss] Database instance gone / and the backups with it.

HI David,

Thanks, i've sent you a mail.

Cheers

Tim

On Wednesday, 16 September 2015 18:54:02 UTC+2, David Newgas wrote:

Hi Timothy,

Unfortunately I don't believe you can revert deleting an instance, however I might be able to arrange this for you. Can you reply (off-list) to me with your project ID and the name of the deleted instance? I will then see what I can do.

Yours,
David

On Wed, Sep 16, 2015 at 1:22 AM, Timothy Gratton <in...@gccs.be> wrote:

We use CloudSQL, however we created a replica of the original instance and then promoted it to master.
Since this morning our old instance has disappeared along with the backups.
Is their anyway we could recover this?

--
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/224220c5-9351-4cb8-a661-efbf526fc0f6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/bd205e7c-e291-4ce8-b49f-7bb630794422%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Database instance gone / and the backups with it.

Hi Timothy,

Unfortunately I don't believe you can revert deleting an instance, however I might be able to arrange this for you. Can you reply (off-list) to me with your project ID and the name of the deleted instance? I will then see what I can do.

Yours,

David

On Wed, Sep 16, 2015 at 1:22 AM, Timothy Gratton <info@gccs.be> wrote:

We use CloudSQL, however we created a replica of the original instance and then promoted it to master.
Since this morning our old instance has disappeared along with the backups.
Is their anyway we could recover this?

--
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/224220c5-9351-4cb8-a661-efbf526fc0f6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bZT6ZoMozcNzNKuRbZF0Rf2ECf%2Bh8O%2B2HsH-hTBRRVujA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Database instance gone / and the backups with it.

We use CloudSQL, however we created a replica of the original instance and then promoted it to master.

Since this morning our old instance has disappeared along with the backups.

Is their anyway we could recover this?

--
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/224220c5-9351-4cb8-a661-efbf526fc0f6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Monday, September 14, 2015

[google-cloud-sql-discuss] Re: C# best connection method?

Salutations Ryan,

RESTful API is one option. If you are ok with using Java or Python you can also use endpoints which gives you more control over the data passed back and forth. You can then use any email address (simply include it in the call and check Datastore if they are allowed access).

On Friday, September 11, 2015 at 12:07:00 PM UTC-4, Ryan Johnson wrote:

Hey guys,

Pretty new to MySQL and google cloud as well.

I have a c# WPF & Xamarin Android application that uses a SQlite Database to input some data and read it for my small business.
Now I want to expand it to the cloud so that multiple people can read/write information and share the same database.

I understand about RESTful web api and found some example code for PHP that i deployed to the app engine and it works without issue.
Problem is i dont think its as secure as it should be? anyone can visit my app engine URL which costs money each time they do and might open the app for them to figure out how to POST,GET information.

So the access options were to assign whitelisted IP's which is near impossible as mobile devices and broadband IP's change on a daily or weekly basis.
Second option was to whitelist gmail accounts, which i really dont want to force users to sign up for gmail if they dont have it.

So can someone please explain what is the best method to connect to a Cloud SQL Database, i think i am half way there with the the app engine REST php script.

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/956df94e-03ca-4369-9226-acffe1ed1893%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thursday, September 10, 2015

[google-cloud-sql-discuss] C# best connection method?

Hey guys,

Pretty new to MySQL and google cloud as well.

I have a c# WPF & Xamarin Android application that uses a SQlite Database to input some data and read it for my small business.

Now I want to expand it to the cloud so that multiple people can read/write information and share the same database.

I understand about RESTful web api and found some example code for PHP that i deployed to the app engine and it works without issue.

Problem is i dont think its as secure as it should be? anyone can visit my app engine URL which costs money each time they do and might open the app for them to figure out how to POST,GET information.

So the access options were to assign whitelisted IP's which is near impossible as mobile devices and broadband IP's change on a daily or weekly basis.
Second option was to whitelist gmail accounts, which i really dont want to force users to sign up for gmail if they dont have it.

So can someone please explain what is the best method to connect to a Cloud SQL Database, i think i am half way there with the the app engine REST php script.

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/abca1f52-a2fa-41df-8a33-3c50441be297%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Pages

Tuesday, September 29, 2015

Sunday, September 27, 2015

Saturday, September 26, 2015

Friday, September 25, 2015

Wednesday, September 23, 2015

Tuesday, September 22, 2015

Monday, September 21, 2015

Saturday, September 19, 2015

Wednesday, September 16, 2015

Monday, September 14, 2015

Thursday, September 10, 2015