| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
- # db2
- - name: Upload db_file to node if it is cached
- synchronize:
- src: "{{ file_path_cached }}"
- dest: "{{ file_path_cached }}"
- mode: push
- - name: Restore database
- mysql_db:
- name: all
- state: import
- target: "{{ file_path_cached }}"
- login_user: "{{ db_user }}"
- login_password: "{{ db_password }}"
- - name: show var
- debug:
- msg: "groups['mariadb_ha_nodes'][0]{{ groups['mariadb_ha_nodes'][0] }}"
- - name: Get master binlog file name and binlog position
- mysql_replication:
- mode: getprimary
- login_user: "{{ db_user }}"
- login_password: "{{ db_password }}"
- delegate_to: "{{ groups['mariadb_ha_nodes'][0] }}"
- register: repl_info
- - name: Stop replica
- mysql_replication:
- mode: stopreplica
- login_user: "{{ db_user }}"
- login_password: "{{ db_password }}"
- - name: Change master to db01 for db02
- mysql_replication:
- mode: changeprimary
- master_host: "{{ hostvars[groups['mariadb_ha_nodes'][0]]['ansible_host'] }}"
- master_log_file: "{{ repl_info.File }}"
- master_log_pos: "{{ repl_info.Position }}"
- master_user: "repl"
- master_password: "{{ repl_password | d(db_password) }}"
- login_user: "{{ db_user }}"
- login_password: "{{ db_password }}"
- ignore_errors: true
- - name: Start replica
- mysql_replication:
- mode: startreplica
- login_user: "{{ db_user }}"
- login_password: "{{ db_password }}"
|
