mysql tools配置_通过mysqltools全自动安装配置mysql复制环境

ansible-playbook install_master_slaves.yaml

PLAY [ms1]****************************************************************************************TASK [Gathering Facts]****************************************************************************ok: [master-slave17]

ok: [master-slave19]

ok: [master-slave18]

TASK [create mysql user]**************************************************************************changed: [master-slave17]

changed: [master-slave18]

changed: [master-slave19]

TASK [create and config/etc/my.cnf] **************************************************************changed: [master-slave18]

changed: [master-slave17]

changed: [master-slave19]

TASK [transfer mysqlinstall package to remote host and unarchive to /usr/local/] *****************changed: [master-slave17]

changed: [master-slave18]

changed: [master-slave19]

TASK [change owner to mysql user]*****************************************************************changed: [master-slave18]

changed: [master-slave17]

changed: [master-slave19]

TASK [make link /usr/local/mysql-xx.yy.zz to /usr/local/mysql] ************************************changed: [master-slave17]

changed: [master-slave18]

changed: [master-slave19]

TASK [export mysql shareobject (*.os)] ***********************************************************ok: [master-slave17]

ok: [master-slave18]

ok: [master-slave19]

TASK [load shareobject] **************************************************************************changed: [master-slave18]

changed: [master-slave17]

changed: [master-slave19]

TASK [export pathenv variable] *******************************************************************ok: [master-slave17]

ok: [master-slave18]

ok: [master-slave19]

TASK [export pathenv to /root/.bashrc] ***********************************************************ok: [master-slave17]

ok: [master-slave18]

ok: [master-slave19]

TASK [make link /usr/local/mysql-xx.yy.zz to /usr/local/mysql] ************************************ok: [master-slave17]

ok: [master-slave18]

ok: [master-slave19]

TASK [create libmysqlclient_r.sofile for php-5.6] ************************************************changed: [master-slave17]

changed: [master-slave18]

changed: [master-slave19]

TASK [create datadir]*****************************************************************************changed: [master-slave17]

changed: [master-slave18]

changed: [master-slave19]

TASK [initialize-insecure] ************************************************************************changed: [master-slave17]

changed: [master-slave18]

changed: [master-slave19]

TASK [create systemd configfile] *****************************************************************changed: [master-slave17]

changed: [master-slave19]

changed: [master-slave18]

TASK [enable mysqld service]**********************************************************************changed: [master-slave19]

changed: [master-slave17]

changed: [master-slave18]

TASK [start mysql(sytemctl)]**********************************************************************changed: [master-slave17]

changed: [master-slave18]

changed: [master-slave19]

TASK [config mysql.service start up on boot]******************************************************changed: [master-slave18]

changed: [master-slave17]

changed: [master-slave19]

TASK [config sysv start script]*******************************************************************skipping: [master-slave17]

skipping: [master-slave18]

skipping: [master-slave19]

TASK [start mysql(service)]***********************************************************************skipping: [master-slave17]

skipping: [master-slave18]

skipping: [master-slave19]

TASK [config mysql.service start up on boot]******************************************************skipping: [master-slave17]

skipping: [master-slave18]

skipping: [master-slave19]

TASK [stransfer sql to remote host]***************************************************************changed: [master-slave18]

changed: [master-slave17]

changed: [master-slave19]

TASK [create replication user on master/ start slave on slave] ***********************************changed: [master-slave17]

changed: [master-slave19]

changed: [master-slave18]---TASK [transfer sql statement to remonte]**********************************************************skipping: [master-slave18]

skipping: [master-slave19]

changed: [master-slave17]

TASK [make mysql secure] **************************************************************************skipping: [master-slave18]

skipping: [master-slave19]

changed: [master-slave17]

TASK [remove tempfile /tmp/make_mysql_secure.sql] ************************************************skipping: [master-slave18]

skipping: [master-slave19]

systemctl stop mysql

changed: [master-slave17]

PLAY RECAP****************************************************************************************master-slave17 : ok=23 changed=18 unreachable=0 failed=0master-slave18 : ok=20 changed=15 unreachable=0 failed=0master-slave19 : ok=20 changed=15 unreachable=0 failed=0