Skip to content

CloudSQL Import - Replace the need to share the dump file publicly#458

Description

@an0rak-dev

Hello,

First, thanks for those samples, it helps me a lot everyday ! 馃槃

In the Import CloudSQL sample, one of the prerequisites is to publicly share the SQL Dump. I think that this could be a bad practice and leads to security flaws ( https://github.com/GoogleCloudPlatform/deploymentmanager-samples/tree/master/examples/v2/cloudsql_import#prerequsites ).

Maybe, we can change the orchestration of the DM script this way :

  • Create the Cloud SQL Instance
  • Create the GCS bucket & add the dump in it (from SourceRepo for example)
  • Add the CloudSQL service account with role Storage Object Viewer permission to the GCS bucket
  • Make the actual import

I can do the actual PR if you want so 馃槂

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions