Hello Friends,
I am in need of some help in ansible.
I am pretty new to ansible and I want to achieve the following as part of
my work:
- As part of regular deployment of our application, we would have a sql
script(which would alert tables, add tables etc) which needs to be run on
say 3 schema in a region and 5 schema in another. The application is in aws
and the database is arora db(RDS). My problem is I am not sure how do I
parametrize to make it run on each schema, first one after the other and
then can upgrade that to run in parallel.
I did the following in a playbook:
- hosts: localhost
vars:
script_file: "{{ path }}"
tasks:
- name: rds_manage_user - run .sql script to alert and create new tables
shell: "mysql -h {{ item.host }} -u {{ item.user }} -p{{ item.password }
} < {{ script_file }} >> /usr/local/testscript.log"
with_items:
- { host: testhost1.com, user: testuser1, password: "testpass1" }
- { host: testhost2.com, user: testuser2, password: "testpass2" }
This works and I get the desired output. But how do I pass these hostname,
user and password from an external file and it can run through the file and
get the script executed in all schemas.
Any help/suggestions would be greatly appreciated. Thanks in advance
--
You received this message because you are subscribed to the Google Groups
"Ansible Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to ansible-devel+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-devel/300db963-3d13-46e0-9a5e-f39baa2d9094%40googlegroups.com.
