ansible做mysql备份和安全加固

最新推荐文章于 2023-08-13 19:29:12 发布

weixin_34194551

最新推荐文章于 2023-08-13 19:29:12 发布

阅读量603

点赞数

文章标签：数据库运维 python

原文链接：https://my.oschina.net/u/259976/blog/815576

版权

2019独角兽企业重金招聘Python工程师标准>>>

1. mysql备份

A patch adding name=all was added to the mysql_db module on May 12, 2015, so the recommended way to dump all databases is:

# Dumps all databases to hostname.sql
- mysql_db: state=dump name=all target=/tmp/{{ inventory_hostname }}.sql

每个数据库一个文件：

---
# This playbook backups all mysql databases into separate files.

- name: backup mysql
  vars:
    - exclude_db:
      - "Database"
      - "information_schema"
      - "performance_schema"
      - "mysql"
  tasks:
    - name: get db names
      shell: 'mysql -u root -p{{ vault_root_passwd }} -e "show databases;" '
      register: dblist
    - name: backup databases
      mysql_db:
        state: dump
        name: "{{ item }}"
        target: "/tmp/{{ item }}.sql"
        login_user: root
        login_password: "{{ vault_root_passwd }}"
      with_items: "{{ dblist.stdout_lines | difference(exclude_db) }}"