mysql - 如何将云sql实例连接到sql集群？

Question

我有集群上的部署yaml文件以及sql实例的连接名称和公共(public)IP地址，那么我应该添加什么以及在哪里才能连接实例和集群？我希望能够向 sql 集群添加一些内容，并且它会自动保存到实例中，反之亦然。

这是部署代码:

    apiVersion: apps/v1
    kind: Deployment
    metadata:
      annotations:
        deployment.kubernetes.io/revision: "1"
      creationTimestamp: 
      generation: 1
      labels:
        app: mysql
      name: mysql
      namespace: default
      resourceVersion: "1420"
      selfLink: 
      uid: 
    spec:
      progressDeadlineSeconds: 600
      replicas: 1
      revisionHistoryLimit: 10
      selector:
        matchLabels:
          app: mysql
      strategy:
        rollingUpdate:
          maxSurge: 25%
          maxUnavailable: 25%
        type: RollingUpdate
      template:
        metadata:
          creationTimestamp: null
          labels:
            app: mysql
        spec:
          containers:
          - env:
            - name: 
              valueFrom:
                secretKeyRef:
                  key: 
                  name: mysql
            image: mysql:5.6
            imagePullPolicy: IfNotPresent
            name: mysql
            ports:
            - containerPort: 3306
              name: mysql
              protocol: TCP
            resources: {}
            terminationMessagePath: /dev/termination-log
            terminationMessagePolicy: File
            volumeMounts:
            - mountPath: /var/lib/mysql
              name: 
          dnsPolicy: ClusterFirst
          restartPolicy: Always
          schedulerName: default-scheduler
          securityContext: {}
          terminationGracePeriodSeconds: 30
          volumes:
          - name: 
            persistentVolumeClaim:
              claimName: 
    status:
      availableReplicas: 1
      conditions:
      - lastTransitionTime: 
        lastUpdateTime: 
        message: Deployment has minimum availability.
        reason: MinimumReplicasAvailable
        status: "True"
        type: Available
      - lastTransitionTime: 
        lastUpdateTime: 
        message: ReplicaSet "mysql" has successfully progressed.
        reason: NewReplicaSetAvailable
        status: "True"
        type: Progressing
      observedGeneration: 1
      readyReplicas: 1
      replicas: 1
      updatedReplicas: 1

Answer 1

您应该使用 Cloud SQL 代理并将其作为 sidecar 添加到您的应用程序中，以对 Cloud SQL 实例进行查询。 Google 找到了建议的最佳实践 here .