shieldproject / shield-boshrelease

BOSH Release for shield
MIT License
11 stars 17 forks source link

prefix configuration for storing backup in specific database #140

Closed ghost closed 5 years ago

ghost commented 6 years ago

Hi, we have deployed v8.0.11 , for this the backup stores without prefix. is there any configuration where i can provides the prefix of all databases?

jhunt commented 6 years ago

What do you mean by "prefix of all databases"?

jhunt commented 6 years ago

Also, this Issue Tracker is for the SHIELD Bosh release, not for general questions about SHIELD, or bugs with the SHIELD software itself.

ghost commented 6 years ago

This is related to shield Bosh release only. When we are creating tenants that time we declare storage for that tenant like access key, secret access key and bucket name. we have deployed shield on dev environment , for dev env we have shield-dev-bucket in that there are different folders like ccdb ,uaadb, etc.

But for this backup it stored directly into bucket in 2018 folder, we want it will backup into specific folders. So is there any option that means backup will take place inside specific folders. I tried with prefix but all ccdb , uaadb, diegodb, and routingdb backups going into the one which I given.

like below:-

          tenants:
            - name: Mysql
              members:
                - user: admin@local
                  role: admin
              storage:
                - name: s3
                  agent: #ip#
                  plugin: s3
                  config:
                    bucket: ((client-shield.backups_bucket))
                    access_key_id: ((client-shield.access_key_id))
                    secret_access_key: ((client-shield.secret_access_key))
                    **prefix: "/ccdb"**   ( its going to store all databases backup into ccdb folder")
              policies:
                - name: Short-Term
                  days: 7
                - name: Long-Term
                  days: 90

              systems:
                - name: CCDB.........

previously we had shield v6.0.6 , in which there was autoprovision property which had that store, prefix all. But as it removed in v8 The auto-provisioning properties stores, targets, retention-policies, and jobs have all been removed, in favor of the new buckler import-based import errand.

jhunt commented 6 years ago

The prefix s3 storage plugin configuration value is the one you want.

http://shieldproject.io/docs/plugins/#amazon-s3

Is that not working?

Also, how is this related to the BOSH release? It sounds like a SHIELD and/or operator problem to me.

ghost commented 6 years ago

Thanks for help, As we have created mysql tenant in that there are systems like ccdb, uaadb, routingdb, diegodb. I used prefix ccdb then all database's backup going into ccdb folder. Here we have multiple prefix, i tried to define prefix inside systems, but still it creating seperate folder 2018 and all backup going inside that folder.

jhunt commented 6 years ago

Prefix is set on a per-store basis, as it is a property of the s3 plugin (among others).