备份问题:[root@ppdb01 backup]# innobackupex --defaults-file=/home/h5act3306/my.cnf --user=root --password=dba默认密码 --host=127.0.0.1 --port=3306 --slave-info /data/backup/
[root@ppdb01 backup]# innobackupex --defaults-file=/home/h5act3306/my.cnf --user=root --password=xiadeng@eebbk.mysql# --host=127.0.0.1 --port=3306 --slave-info /data/backup/
171213 16:24:19 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
171213 16:24:19 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=127.0.0.1;port=3306;mysql_socket=/tmp/mysqlh5act3306.sock1' as 'root' (using password: YES).
171213 16:24:19 version_check Connected to MySQL server
171213 16:24:19 version_check Executing a version check against the server...
171213 16:24:19 version_check Done.
171213 16:24:19 Connecting to MySQL server host: 127.0.0.1, user: root, password: set, port: 3306, socket: /tmp/mysqlh5act3306.sock1
Using server version 5.7.19-17-log
The --slave-info option requires GTID enabled for a multi-threaded slave.
解决方法:
方法1、innobackupex --defaults-file=/home/h5act3306/my.cnf --user=root --password=dba默认密码 --host=127.0.0.1 --port=3306 /data/backup/
去掉 --slave-info参数。
方法2、