機能
- リモートホストからMySQLデータベースの追加/削除を行う。
使用例
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
- name: Create a new database with name 'bobdata' mysql_db: name: bobdata state: present - name: Create new databases with names 'foo' and 'bar' mysql_db: name: - foo - bar state: present # Copy database dump file to remote host and restore it to database 'my_db' - name: Copy database dump file copy: src: dump.sql.bz2 dest: /tmp - name: Restore database mysql_db: name: my_db state: import target: /tmp/dump.sql.bz2 - name: Dump multiple databases mysql_db: state: dump name: db_1,db_2 target: /tmp/dump.sql - name: Dump multiple databases mysql_db: state: dump name: - db_1 - db_2 target: /tmp/dump.sql - name: Dump all databases to hostname.sql mysql_db: state: dump name: all target: /tmp/dump.sql - name: Import file.sql similar to mysql -u <username> -p <password> < hostname.sql mysql_db: state: import name: all target: /tmp/dump.sql - name: Delete database with name 'bobdata' mysql_db: name: bobdata state: absent - name: Make sure there is neither a database with name 'foo', nor one with name 'bar' mysql_db: name: - foo - bar state: absent |
参考サイト
mysql_db – Add or remove MySQL databases from a remote host — Ansible Documentation
https://docs.ansible.com/ansible/2.9/modules/mysql_db_module.html#mysql-db-module
Database modules — Ansible Documentation
https://docs.ansible.com/ansible/2.9/modules/list_of_database_modules.html