Our Oracle data source is hosted in On-Premises server. We already set the VPC communication channel between Oracle and Google Cloud and using a Oracle credentials we can also watch the some Oracle tables from objects preview section in Cloud Data Fusion (cDF).
We can access to consume only the Oracle tables which are using SYNONYMS. The problem is with remaining tables, which are using schema, for instance SCHEMA_NAME.TABLE_NAME, without use synonyms, we can not access from cDF, neither even to valide in Preview environment.
¿Is that an issue of cDF? ¿How can I solve it? and to consume also the tables which are using schema's sintaxis. Please your help and guidance.
Hi,
As seen on the public issue and the internal one, the feature for setting optimizer-switch=block_nested_loop=off is still under the evaluation of the Cloud SQL Engineering team. Please kindly note that there is no ETA or guarantee on the implementation. Thank you.
On Sunday, May 16, 2021 at 5:49:59 PM UTC-4 feja...@gmail.com wrote:Hi,Please how were you able to resolve this eventually, I am also stuck in the same situation.ThanksOn Thursday, 4 April 2019 at 08:53:38 UTC+1 krzysz...@gmail.com wrote:Thanks, I issued https://issuetracker.google.com/issues/129897196
On Thu, Apr 4, 2019 at 1:57 AM 'Harmit Rishi (Cloud Platform Support)'
via Google Cloud SQL discuss
<google-cloud...@googlegroups.com> wrote:
>
> Thank you for using Google Groups.
>
>
> Considering that Cloud SQL offers MySQL instances, I believe this issue should be brought to the attention of the engineering team behind the Cloud SQL product. Due to this, I encourage you to follow the steps to file a Public Issue Tracker here[1].
>
>
> Also, doing so will ensure that this issue is getting the appropriate exposure to the engineering team as Google Groups is meant for discussion purposes. Let me know if you are able to file a Public Issue Tracker for this.
>
>
> [1] Public Issue Tracker: https://cloud.google.com/support/docs/issue-trackers
>
> On Wednesday, February 27, 2019 at 2:26:49 PM UTC-5, Krzysztof Drys wrote:
>>
>> Recently we experienced problems with our MySQL instance. One hour our db was running fine (CPU usage at about 20%), next hour CPU is at 100% and queries are stuck at "creating sort index" phase. After restarting DB everything was normal again.
>>
>> We suspect that it was MySQL Bug #69721 (https://bugs.mysql.com/bug.php?id=69721). As suggested here (https://community.sugarcrm.com/thread/33079-queries-getting-stuck-on-creating-sort-index-slowing-sugar-down), one option to mitigate this bug is to set optimizer-switch=block_nested_loop=off.
>>
>> However, as far as I can see, it is not possible to set this option in Cloud MySQL. Do you know any other way to work around this bug?
>>
>> Thanks,
>> Krzysztof Dryś
>
> --
> 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/cPeyrQ4Rbz0/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/68475f91-8f40-4dbb-80ff-64e76e5f0dc0%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
I have two projects 1 and 2 and two vpc networks vpc1 and vpc2 in the respective projects. I need to connect to sql instance in vpc2 (project2) from vm in vpc1 project1 using private IP. After trying diiferent methods and exploring options like vpc peering, cloud NAT (which wouldn't work for me) I found the cloud VPN solution. I am following this google docs link - https://cloud.google.com/sql/docs/postgres/configure-private-ip#vpn to connect to cloudSQL instance using its private IP. I have setup VPN Tunneling and all the necessary steps that were mentioned in the steps 1 and 2 in the link itself, but not able to connect to the instance. I have tested the VPN connectivity as well. I am able to ping a vm2 in vpc2 (project2) from vm1 in vpc1 (project1).
I suspect the problem is in the final steps over here:
https://i.stack.imgur.com/aIyq8.png
No problem in step a and step b is also clear, but what exactly needs to be done in step c is not clear. Can you explain what needs to be done over there.
Hello, i'm new member here, i have a problem for connecting my Cloud SQL DB from AWS Ec2, now i have VPN S2S between AWS and GCP and it's now already work for ping and remote vm each other, but when i want to connect database from AWS EC2 always fail and can't connect with error "ERROR 2003 (HY000): Can't connect to MySQL server on '10.xx.xx.xx' (110)" what must be to do?thanks
I have been tasked with upgrading our existing GCP hosted PostgreSQL databases from version 9.6 to version 13.The instructions I found (https://cloud.google.com/sql/docs/postgres/upgrade-db)say that we need to create a new database and then"Make sure the target instance has... The same user accounts, with the same PostgreSQL privileges and passwords"We have a number of databases with dozens of users and roles, we allow users to connect directly and set their own passwords.We would like to perform the database upgrade without changing all the passwords.I've looked at using pg_dumpall to copy the users to a new database, but it fails as I don't have permission to read pg_authid.It seems that we need a superuser account to be able to read pg_authid, and GCP does not permit superuser accounts.Is there any way to upgrade the databases and keep the existing passwords?
