saltstack实现数据库基于GTID的主从复制
# salt '*' state.slsmysql.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 *.* tomiao@'172.25.88.%'> Result: True
Comment: Command "mysql -pZoe++007 -e "grant replication slave on *.* tomiao@'172.25.88.%'> Started: 00:57:20.904105
Duration: 248.09 ms
Changes:
----------
pid:
2697
retcode:
0
stderr:
mysql: 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
页:
[1]