-name: install repository
yum :
name: https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
state: present- name: copy globalmy.cnf
template:
src: templates/my.cnf.j2
dest:/etc/my.cnf- name: install mysql '{{ mysql_version }}'yum:
name:'mysql-community-server-{{ mysql_version }}'state: present
enablerepo: mysql57-community
disablerepo: mysql80-community-name: start mysql
service:
name: mysqld
state: started-name: Find temporary password
shell:>echo `grep'temporary.*root@localhost' "{{ mysqld_error_log }}" | sed 's/.*root@localhost: //'`
register: mysql_root_password_temp- name: Set new password formysql root user
shell:>mysql-NBe "alter user USER() identified by '{{ mysql_root_password }}';"
--connect-expired-password -uroot -p'{{ mysql_root_password_temp.stdout }}'
-name: uninstall validate_password plugin
shell:>mysql-NBe "uninstall plugin validate_password" -uroot -p'{{ mysql_root_password }}'
- name: install MySQL-python
yum:
name: MySQL-python
state: latest-name: create replication user
mysql_user:
name:"{{ mysql_repl_user }}"host:"%"password:"{{ mysql_repl_password }}"priv:"*.*:REPLICATION SLAVE"state: present
login_user: root
login_password:"{{ mysql_root_password }}"when: mysql_role== "master"tags:- create-repl-user-name: change master to
mysql_replication:
mode: changemaster
master_host:"{{ master_ip }}"master_user: repl
master_password: repl
master_auto_position: yes
login_user: root
login_password:"{{ mysql_root_password }}"when: mysql_role== 'slave'
-name: start slave
mysql_replication:
mode: startslave
login_user: root
login_password:"{{ mysql_root_password }}"when: mysql_role== "slave"