I have mysql server 5.5 with > 300GB data.
I tried create a slave from this master server.
When i run innobackupex, it died at SET SESSION lock_wait_timeout=31536000
This is error:
DBD::mysql::db do failed: MySQL server has gone away at /usr/bin/innobackupex line 3045. innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3048 main::mysql_query('HASH(0x19b4fed0)', 'SET SESSION lock_wait_timeout=31536000') called at /usr/bin/innobackupex line 3456 main::mysql_lock_tables('HASH(0x19b4fed0)') called at /usr/bin/innobackupex line 1991 main::backup() called at /usr/bin/innobackupex line 1601 innobackupex: Error: Error executing 'SET SESSION lock_wait_timeout=31536000': DBD::mysql::db do failed: MySQL server has gone away at /usr/bin/innobackupex line 3045. 150322 21:25:24 innobackupex: Waiting for ibbackup (pid=30331) to finish
I tried repeat 2 times but same errors.
I read tutorial at http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/improved_ftwrl.html
and set options same this tut but not success.
Sorry, my english is very poor