Hi guys, i try to connect datahub to google cloud ...
# troubleshootf
few-air-56117
03/11/2022, 1:46 PMHi guys, i try to connect datahub to google cloud sql
I do the network set up and i change de mysql set up on helm
Copy code
global:
sql:
datasource:
host: "<internal_ip>3306"
hostForMysqlClient: "clinet ip"
port: "3306"
url: "jdbc:mysql://<ip>datahub?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8&enabledTLSProtocols=TLSv1.2"
driver: "com.mysql.cj.jdbc.Driver"
username: "datahub"
password:
secretRef: mysql-secrets
secretKey: mysql-root-passwordfew-air-56117
03/11/2022, 2:45 PMAlso i did a ingestion i got this result
Copy code
'warnings': {},
'failures': {},
'tables_scanned': 392,
'views_scanned': 196,
'entities_profiled': 0,
'filtered': [],
'soft_deleted_stale_entities': [],
'query_combiner': None}
Sink (datahub-rest) report:
{'records_written': 588,
'warnings': [],
'failures': [],
'downstream_start_time': datetime.datetime(2022, 3, 11, 16, 33, 5, 315734),
'downstream_end_time': datetime.datetime(2022, 3, 11, 16, 39, 12, 594496),
'downstream_total_latency_in_seconds': 367.278762}e
early-lamp-41924
03/15/2022, 7:44 PMSorry about the late reply. Is this still the case?
f
few-air-56117
03/15/2022, 8:04 PMHi Dexter, I find the problem, i switch the database but i forgot to run datahub-datahub-restore-indices-job-template
e
early-lamp-41924
03/15/2022, 8:13 PMAh so you switched the search index as well?
early-lamp-41924
03/15/2022, 8:13 PMGot it!
early-lamp-41924
03/15/2022, 8:13 PMGlad it worked out!
f
few-air-56117
03/16/2022, 6:51 AMyea, i created a new cluster, and migrated de mysql from the old cluster to cloud sql. And connect the new cluster to cloud sql. It was the first time when i play with elastic search, so , some thinks are strange to me 😂
3 Views