0

I'm trying to connect my local standalone MySQL with Cloud Fusion to create and test a data pipeline. I have deployed the driver successfully. Also, I have configured the pipeline properties with correct values of jdbc string, user name and password but connectivity isn't getting established.

Connection String: jdbc:mysql://localhost:3306/test_database

I have also tried to test the connectivity via data wrangling option but that is also not getting succeeded.

Do I need to bring both the environments under same network by setting up some VPC and tunneling?

Balajee Venkatesh
  • 1,041
  • 2
  • 18
  • 39

2 Answers2

3

In your example, I see that you specified localhost in your Connection String. localhost is only advertised to other services running local to your machine, and Cloud Data Fusion (running in GCP) will not be able to reach the MySQL instance (running on your machine). Hence you're seeing the connectivity issue.

I highly recommend looking at this answer on SO that will help you setup a quick proof-of-concept.

Mikkin Patel
  • 31
  • 1
1

I think that your question is more related to the way how to connect some on-premise environments to GCP networking system that gathering Google cloud instances or resources throughout VPC connection model.

Admitting the fact that GCP is actually leveraging different approaches for connection methods within a Hybrid cloud concepts, I would encourage you to learn some fundamental principles of Cloud VPN as a essential part of performing secure connection between particular VPN Peer Gateway and Cloud VPN Gateway and further creating a VPN tunnel between parties.

I guess there is even dedicated chapter in GCP documentation about Data Fusion VPC peering implementation that might be helpful in your user case.

Nick_Kh
  • 5,089
  • 2
  • 10
  • 16