Slave stops during Backup with percona xtrabackup

[tmad...@gmail.com]

Hello togehter,

I´m running a master-master replication with 2 hosts on mysql 5.6. We are running an active-pasive cluster, so just on db (mysql-db1) is accessed via a virtual IP. On the "standby" master (mysql-db2) the mysql-slave stops close to the end of percona xtrabackup and then starts up automatically again. Where´s the problem and how to fix it?

versions:
xtrabackup 2.1.8-1
mysql-community-client 5.6.31-1ubuntu14.04

Thanks in advance
Thomas

[Roel Van de Paar]

Hi Thomas,

Do you have logs etc.?

[Marcos Albe]

This is natural if using --safe-slave-backup; It will STOP SLAVE to avoid tmp tables; if he uses binlog_format=ROW then he doesn't  needs this.

Best,

Marcos

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to percona-discuss...@googlegroups.com.
To post to this group, send email to percona-d...@googlegroups.com.
Visit this group at https://groups.google.com/group/percona-discussion.
To view this discussion on the web visit https://groups.google.com/d/msgid/percona-discussion/19404efa-b500-41c9-9748-f1260e3af609%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Experts" group.
To post to this group, send email to exp...@percona.com.
Visit this group at https://groups.google.com/a/percona.com/group/experts/.

[tmad...@gmail.com]

Dear Marcos/ Others

thanks a million for your answer!

I´m trying without "--safe-slave-backup" and let you know, if it´s fixed.

Concerning "The backup will fail if Slave_open_temp_tables does not
become zero after --safe-slave-backup-timeout seconds." I´m not using "--safe-slave-backup-timeout" yet. Should I use this option?
Do you have other hints I should consider if running without "--safe-slave-backup"?

Thanks in adavance
Thomas

[oldGarey guan]

i m not use --safe-slave-backup, still encounter 3 times like this, anybody have idea on this? thx

[Roel Van de Paar]

Hi 

My colleague checked the source code and STOP SLAVE is only executed when --safe-slave-backup within waite_for_safe_slave() in backup_mysql.cc

Are you using wrapper script? If so, please provide source for this.

Also, what's datadir size? and ibdata1 size? Need to know to provide further suggestions regarding options to investigate.

[James Wang]

Hi Tom, 

Any update please?

Thanks