Hey! I’m having trouble trying to setup Airbyte to...
# replication-ask-ai
n
Hey! I’m having trouble trying to setup Airbyte to use a CloudSQL as an external database, and am wondering about your thoughts about the security aspect of using the default database directly in Kubernetes. If the credentials for destinations and connections is saved to this database it would be by far the most sensitive database in my organization and should also ideally be the most secure. My fear is that a sneaky pod from a different namespace could fetch the secrets and env vars for the DB connection, connect to and get credentials stored in the database and worst case use those to fetch our data from third-parties where we can’t enforce much restrictions on API key usage and such. A tight network policy for the namespace might be in order. What measures are taken in the Airbyte OSS installation to make sure that only airbyte can access the database? What other best practices should I do if I decide to go for the default DB in Kubernetes?
k
A message from kapa.ai
New message text here
n
@kapa.ai Can you find any examples or guides to use CloudSQL proxy with Airbyte OSS?
k
A message from kapa.ai
Yes, there is a forum discussion where a user faced issues connecting to Google Cloud SQL proxy with Airbyte OSS. The user was able to resolve the issue by using their local machine's IP address in both
cloud-sql-proxy
via the
--address
flag and as the host in the web UI. You can find the discussion [here](https://discuss.airbyte.io/t/4251). Additionally, the user created a GitHub issue for this problem, which you can find [here](https://github.com/airbytehq/airbyte/issues/24751).
n
@kapa.ai Is the SECRET_PERSISTENCE variable available in the Airbyte Helm deployment? I cannot find any reference to it in the helm values source code
k
A message from kapa.ai
Hmm, I don't know enough to give you a confident answer yet. However, you can refer to the Airbyte documentation for more information on [configuring Airbyte](https://docs.airbyte.com/operator-guides/configuring-airbyte) and [deploying Airbyte on Kubernetes using Helm](https://docs.airbyte.com/deploying-airbyte/on-kubernetes-via-helm).