mysql configure:
slave_parallel_type=LOGICAL_CLOCK
slave_parallel_workers=0
log_bin=binlog
server=101
When I user xtrabackup backup mysql,
innobackup --defaults-file=/etc/my.cnf --user=muser --host=localhost --password=mpassword --slave-info --socket=/tmp/mysql.sock --port=3306 /backupdata/
When backup complete then copy to another server and apply log:
innobackup --apply-log /backupdata/2017-09-11_20_14_37/
then copy back:
innobackup --copy-back --defaults-file=/etc/my.cnf /backupdata/2017-09-11_20_14_37/
finally start mysql and change log,the log position is from the file:xtrabackup_slave_info
but when I change master and start slave,it says:
Could not execute Write_rows event on table table_schema.table_name; Duplicate entry '53589766' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.xxxx, end_log_pos 919535803
when uses:
slave_parallel_type=DATABASE
slave_parallel_workers=0
It works well;
It's that a issue? or something error?
System:CentOS 7.1
Package:mysql5.7.17
mysql configure: type=LOGICAL_ CLOCK workers= 0
slave_parallel_
slave_parallel_
log_bin=binlog
server=101
When I user xtrabackup backup mysql, file=/etc/ my.cnf --user=muser --host=localhost --password= mpassword --slave-info --socket= /tmp/mysql. sock --port=3306 /backupdata/
innobackup --defaults-
When backup complete then copy to another server and apply log: 2017-09- 11_20_14_ 37/
innobackup --apply-log /backupdata/
then copy back: file=/etc/ my.cnf /backupdata/ 2017-09- 11_20_14_ 37/
innobackup --copy-back --defaults-
finally start mysql and change log,the log position is from the file:xtrabackup _slave_ info
but when I change master and start slave,it says: table_name; Duplicate entry '53589766' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_ FOUND_DUPP_ KEY; the event's master log mysql-bin.xxxx, end_log_pos 919535803
Could not execute Write_rows event on table table_schema.
when uses: type=DATABASE workers= 0
slave_parallel_
slave_parallel_
It works well;
It's that a issue? or something error?