Hey folks,
I have a big mailman update that I'd like to test on staging, and I think that my testing would be more realisting if I had some production data on the staging DB. I mostly need public data, I don't need the user accounts or the private lists data for example. I realize that I could dump the prod DB to a text file (excluding private tables), transfer it to my workstation and re-upload it to staging, but I'm talking gigabytes of data here, so I wonder if you know of a better way, that would stay in the Fedora Infra (and possibly in the same datacenter).
Thanks! Aurélien
On Mon, 16 Jan 2017 14:55:05 +0100 Aurelien Bompard abompard@fedoraproject.org wrote:
Hey folks,
I have a big mailman update that I'd like to test on staging, and I think that my testing would be more realisting if I had some production data on the staging DB. I mostly need public data, I don't need the user accounts or the private lists data for example. I realize that I could dump the prod DB to a text file (excluding private tables), transfer it to my workstation and re-upload it to staging, but I'm talking gigabytes of data here, so I wonder if you know of a better way, that would stay in the Fedora Infra (and possibly in the same datacenter).
Make a staging sync playbook. ;)
Look at the ansible/playbooks/manual/staging-sync/koji.yml
it takes the prod db, syncs it over to staging and then runs some sql on it to get it working for staging. ;)
So, basically you just need to do this for your db...
kevin
Done that, but now rbac-playbook says I'm not allowed to run : manual/staging-sync/mailman.yml
Could someone add the ACL for me please? Thanks!
Aurélien
On Tue, 17 Jan 2017 14:46:25 +0100 Aurelien Bompard abompard@fedoraproject.org wrote:
Done that, but now rbac-playbook says I'm not allowed to run : manual/staging-sync/mailman.yml
Could someone add the ACL for me please? Thanks!
Done.
Note that at some point I'll likely be moving the db frmo db01 to the pkgbdr01/02 cluster. :) But thats not happened yet.
kevin
infrastructure@lists.fedoraproject.org