Ansible dynamic inventory for MySQL with Python Script - ansible-dynamic-inventory-mysql

Ansible dynamic inventory for MySQL with Python Script. Here I have created test dynamic inventory script with python to get data from MySQL and Ansible will use it as an inventory source as long as it returns a JSON structure with the —list option.

Usage

Simply call the script like the following

ansible-playbook -i dynamic_inventory.py example_playbook.yml
# or
ansible -i dynamic_inventory.py group_name -m ping

Python script run and its sample json output

./dynamic_inventory.py --list
output ---
{
    "all": ["localdb", "local", "localhost"],
    "REDHAT": ["local", "localhost"],
    "WINDOWS": ["localdb"],
    "app": ["localhost"],
    "db": ["localdb", "local", "localhost"]
}

Author Informations

This python script was created by Avinash Pawar.