saltstack实现数据库基于GTID的主从复制

websyhg

[root@server1 ~]# salt '*' state.sls  mysql.service　　server3.lalala.com:
　　----------
　　ID: pkg-install
　　Function: pkg.installed
　　Result: True
　　Comment: All specified packages are already installed
　　Started: 00:57:19.765213
　　Duration: 1153.547 ms
　　Changes:
　　----------
　　ID: mysql-group
　　Function: group.present
　　Name: mysql
　　Result: True
　　Comment: Group mysql is present and up to date
　　Started: 00:57:20.920669
　　Duration: 1.525 ms
　　Changes:
　　----------
　　ID: mysql-user
　　Function: user.present
　　Name: mysql
　　Result: True
　　Comment: User mysql is present and up to date
　　Started: 00:57:20.925427
　　Duration: 3.069 ms
　　Changes:
　　----------
　　ID: mysql-install
　　Function: pkg.installed
　　Result: True
　　Comment: All specified packages are already installed
　　Started: 00:57:20.930287
　　Duration: 1.757 ms
　　Changes:
　　----------
　　ID: mysql-password
　　Function: cmd.run

　　Name: /etc/init.d/mysqld start ;cd /var/log  ;passwd=`cat mysqld.log |grep  'temporary password'|awk {'print $NF'}` ;mysql -p$passwd -e "alter user root@localhost>　　Result: True
　　Comment: unless execution succeeded
　　Started: 00:57:20.934090
　　Duration: 14.475 ms
　　Changes:
　　----------
　　ID: mysql-config
　　Function: file.managed
　　Name: /etc/my.cnf
　　Result: True
　　Comment: File /etc/my.cnf is in the correct state
　　Started: 00:57:20.956275
　　Duration: 138.318 ms
　　Changes:
　　----------
　　ID: replication-config
　　Function: cmd.run
　　Name: mysql -pZoe++007 -e "change master to master_host='172.25.88.2',master_user='miao',master_password='Zoe++007' ,master_auto_position=1;start slave; "  --connect-expired-password
　　Result: True
　　Comment: unless execution succeeded
　　Started: 00:57:21.094874
　　Duration: 18.675 ms
　　Changes:
　　----------
　　ID: mysql-init
　　Function: cmd.run
　　Name: chkconfig --add mysqld
　　Result: True
　　Comment: unless execution succeeded
　　Started: 00:57:21.115328
　　Duration: 15.975 ms
　　Changes:
　　----------
　　ID: mysql-init
　　Function: service.running
　　Name: mysqld
　　Result: True
　　Comment: The service mysqld is already running
　　Started: 00:57:21.134324
　　Duration: 102.086 ms
　　Changes:
　　Summary for server3.lalala.com
　　------------
　　Succeeded: 9
　　Failed:    0
　　------------
　　Total states run:     9
　　Total run time:   1.449 s
　　server2.lalala.com:
　　----------
　　ID: pkg-install
　　Function: pkg.installed
　　Result: True
　　Comment: All specified packages are already installed
　　Started: 00:57:19.640339
　　Duration: 1109.781 ms
　　Changes:
　　----------
　　ID: mysql-group
　　Function: group.present
　　Name: mysql
　　Result: True
　　Comment: Group mysql is present and up to date
　　Started: 00:57:20.751699
　　Duration: 1.176 ms
　　Changes:
　　----------
　　ID: mysql-user
　　Function: user.present
　　Name: mysql
　　Result: True
　　Comment: User mysql is present and up to date
　　Started: 00:57:20.755638
　　Duration: 2.436 ms
　　Changes:
　　----------
　　ID: mysql-install
　　Function: pkg.installed
　　Result: True
　　Comment: All specified packages are already installed
　　Started: 00:57:20.759704
　　Duration: 1.455 ms
　　Changes:
　　----------
　　ID: mysql-password
　　Function: cmd.run

　　Name: /etc/init.d/mysqld start ;cd /var/log  ;passwd=`cat mysqld.log |grep  'temporary password'|awk {'print $NF'}` ;mysql -p$passwd -e "alter user root@localhost>　　Result: True
　　Comment: unless execution succeeded
　　Started: 00:57:20.763005
　　Duration: 13.151 ms
　　Changes:
　　----------
　　ID: mysql-config
　　Function: file.managed
　　Name: /etc/my.cnf
　　Result: True
　　Comment: File /etc/my.cnf is in the correct state
　　Started: 00:57:20.783348
　　Duration: 120.448 ms
　　Changes:
　　----------
　　ID: replication-config
　　Function: cmd.run

　　Name: mysql -pZoe++007 -e "grant replication slave on *.* to  miao@'172.25.88.%'>　　Result: True

　　Comment: Command "mysql -pZoe++007 -e "grant replication slave on *.* to  miao@'172.25.88.%'>　　Started: 00:57:20.904105
　　Duration: 248.09 ms
　　Changes:
　　----------
　　pid:
　　2697
　　retcode:
　　0
　　stderr:
　　mysql: [Warning] Using a password on the command line interface can be insecure.
　　stdout:
　　----------
　　ID: mysql-init
　　Function: cmd.run
　　Name: chkconfig --add mysqld
　　Result: True
　　Comment: unless execution succeeded
　　Started: 00:57:21.154072
　　Duration: 14.785 ms
　　Changes:
　　----------
　　ID: mysql-init
　　Function: service.running
　　Name: mysqld
　　Result: True
　　Comment: The service mysqld is already running
　　Started: 00:57:21.171797
　　Duration: 100.02 ms
　　Changes:
　　Summary for server2.lalala.com
　　------------
　　Succeeded: 9 (changed=1)
　　Failed:    0
　　------------
　　Total states run:     9
　　Total run time:   1.611 s