mysql 创建数据库
- hosts: localhost
remote_user: root
tasks:
- name: test mysql
mysql_db:
name: mhc
state: present
login_user: root
login_password: root.123
register: mhc
- debug: var=mhc
--------------------------------------------------------
修改docker容器内的mysql 配置文件 /etc/my.cnf
执行： ansible-playbook config.yml -e "key=tmp_table_size" -e "value=99m"
- hosts: localhost
remote_user: root
tasks:
- name: add container to inventory
add_host:
name: compose_mysql_1
ansible_connection: docker
ansible_user: root
changed_when: false
- name: get remote my.cnf
delegate_to: compose_mysql_1
shell: cat /etc/my.cnf
register: mhc
- name: write local my.cnf
shell: echo "{{ mhc.stdout }}" > /tmp/my.cnf
- name: update my.cnf
shell: ansible-handler update_mysql_configs '{"action":"update","path":"/tmp/my.cnf","configs":{"mysqld":{"{{ key }}":"{{ value }}"}}}'
- name: send new my.cnf
delegate_to: compose_mysql_1
template: src=/tmp/my.cnf dest=/etc/my.cnf owner=root group=root mode=0644
notify: restart container
- name: delete tmp my.cnf
file: path=/tmp/my.cnf state=absent
handlers:
- name: restart container
debug: msg="hahahahahahahahahha"
--------------------------------------------------------------------------------
---
- hosts: localhost
tasks:
- name: include vars
include_vars: var.yml
- name: add container to inventory
add_host:
name: hehe_mysql_1
ansible_connection: docker
ansible_user: root
changed_when: false
- name: get or modify cnf file
delegate_to: hehe_mysql_1
cnf_file:
action: "{{ action }}"
section: "{{ section }}"
option: "{{ option }}"
value: "{{ value }}"
path: "{{ path }}"
register: sh
- debug: var=sh
when: sh.stdout is defined
var.yml:
---
action: get
section:
option:
value:
path: /etc/my.cnf
-------------------------------------------------------------
---
- hosts: localhost
tasks:
- name: include vars
include_vars: var.yml
- name: add container to inventory
add_host:
name: hehe_mysql_1
ansible_connection: docker
ansible_user: root
changed_when: false
- name: get or modify cnf file
delegate_to: hehe_mysql_1
cnf_file:
action: update
section: "{{ item.section }}"
option: "{{ item.option }}"
value: "{{ item.value }}"
path: "{{ path }}"
with_items:
- { section: 'mysqld', option: 'tmp_table_size', value: '133m'}
- { section: 'mysqld', option: 'aa', value: 'bb'}
- { section: 'mysqld', option: 'aa2', value: 'bb2'}
register: sh
- debug: var=sh
when: sh.stdout is defined
----------------------------------------------------------------------------------------
cnf_file.yml:
---
- name: get or modify cnf file in docker container
delegate_to: "{{ container_name }}"
cnf_file:
action: "{{ action }}"
section: "{{ section }}"
option: "{{ option }}"
value: "{{ value }}"
path: "{{ path }}"
when: container_name is defined
register: sh
- name: get or modify cnf file
cnf_file:
action: "{{ action }}"
section: "{{ section }}"
option: "{{ option }}"
value: "{{ value }}"
path: "{{ path }}"
when: container_name is undefined
register: sh2
add_host.yml:
---
- name: add container to inventory
add_host:
name: "{{ container_name }}"
ansible_connection: docker
ansible_user: root
changed_when: false
main.yml
---
- hosts: localhost
tasks:
- import_tasks: add_host.yml
vars:
container_name: hehe_mysql_1
- import_tasks: cnf_file.yml
vars:
container_name: hehe_mysql_1
action: get
section:
option:
value:
path: /etc/my.cnf
- debug: var=sh
main2.yml
---
- hosts: localhost
tasks:
- import_tasks: add_host.yml
vars:
container_name: hehe_mysql_1
- include_tasks: cnf_file.yml
vars:
container_name: hehe_mysql_1
action: delete
section: "{{ item.section }}"
option: "{{ item.option }}"
value:
path: /etc/my.cnf
with_items:
- { section: 'mysqld', option: 'aa'}
- { section: 'mysqld', option: 'aa2'}
- debug: var=sh
