|
[iyunv@ansible mysql5.6]# ansible-playbook -i hosts run.yml
PLAY [slave] ******************************************************************
GATHERING FACTS ***************************************************************
ok: [192.168.0.104]
TASK: [slave | 获取当前的主服务器复制状态] ***********************
ok: [192.168.0.104 -> 192.168.0.105]
TASK: [slave | 改变从服务器上的需要复制的主服务器信息] *****
failed: [192.168.0.104] => {"failed": true, "parsed": false}
Traceback (most recent call last):
File "/root/.ansible/tmp/ansible-tmp-1449993157.54-210054776103660/mysql_replication", line 2008, in <module>
main()
File "/root/.ansible/tmp/ansible-tmp-1449993157.54-210054776103660/mysql_replication", line 379, in main
changemaster(cursor, chm, chm_params)
File "/root/.ansible/tmp/ansible-tmp-1449993157.54-210054776103660/mysql_replication", line 174, in changemaster
cursor.execute(query, chm_params)
File "/usr/local/python27/lib/python2.7/site-packages/MySQLdb/cursors.py", line 207, in execute
if not self._defer_warnings: self._warning_check()
File "/usr/local/python27/lib/python2.7/site-packages/MySQLdb/cursors.py", line 117, in _warning_check
warn(w[-1], self.Warning, 3)
_mysql_exceptions.Warning: Sending passwords in plain text without SSL/TLS is extremely insecure.
...ignoring
TASK: [slave | 从服务器开启复制状态] ********************************
changed: [192.168.0.104]
PLAY RECAP ********************************************************************
192.168.0.104 : ok=4 changed=1 unreachable=0 failed=0
../tasks/main.yml 内容:
---
- name: 获取当前的主服务器复制状态
mysql_replication: login_user=root
login_password={{ mysql_master_root_password }}
mode=getmaster
delegate_to: "{{ master }}"
register: repl_stat
- name: 改变从服务器上的需要复制的主服务器信息
mysql_replication: login_user=root
login_password={{ mysql_master_root_password }}
mode=changemaster
master_host={{ master }}
master_log_file={{ repl_stat.File }}
master_log_pos={{ repl_stat.Position }}
master_user={{ mysql_repl_user }}
master_password={{ mysql_repl_passwd }}
ignore_errors: True
- name: 从服务器开启复制状态
mysql_replication: login_user=root
login_password={{ mysql_slave_root_password }}
mode=startslave
#
----
这里是搭建mysql主从复制,这个tasks可以完成。但是抛出的警告信息有点刺眼,除了改源代码注释警告信息,还有其他方法吗?
|
|