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