Not the answer you need?
Register and ask your own question!

Unable to create DB Replication Master->Slave

iovcho.iovchev@gmail.com[email protected] EntrantInactive User Role Beginner
Hello there.
I have two server with the same hardware and software specifications.
The OS is Debian 8.4.
The Percona Version is 5.7.11-4-1.jessie
I use this ( https://www.percona.com/doc/percona-xtrabackup/2.1/howtos/setting_up_replication.html ) documentation for cluster setup.
I have this problem on STEP 1:

[email protected]:~# innobackupex --user=root --password='*******' --apply-log /root/backup/$TIMESTAMP
160418 15:01:58 innobackupex: Starting the apply-log operation

IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints "completed OK!".

innobackupex version 2.4.2 based on MySQL server 5.7.11 Linux (x86_64) (revision id: 8e86a84)
xtrabackup: cd to /root/backup
xtrabackup: Error: cannot open ./xtrabackup_checkpoints
xtrabackup: error: xtrabackup_read_metadata()
xtrabackup: This target seems not to have correct metadata...
InnoDB: Number of pools: 1
InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
xtrabackup: Warning: cannot open ./xtrabackup_logfile. will try to find.
InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
xtrabackup: Fatal error: cannot find ./xtrabackup_logfile.
xtrabackup: Error: xtrabackup_init_temp_log() failed.


If try to create dump without option '--apply-log' , everything is correct:




[email protected]:~# innobackupex --user=root --password='*****' /root/backup/$TIMESTAMP
160418 15:03:15 innobackupex: Starting the backup operation

................

xtrabackup: Transaction log of lsn (2491315) to (2491324) was copied.
160418 15:03:19 completed OK!

Comments

  • iovcho.iovchev@gmail.com[email protected] Entrant Inactive User Role Beginner
    Hi,

    Someone have the same issue or have any information how can I fix it and complete the replication?
    Thanks,
  • LoggerLogger Entrant Current User Role Beginner
    Can you tell us exact steps what you did with result?
  • iovcho.iovchev@gmail.com[email protected] Entrant Inactive User Role Beginner
    I startover with setup and everything is correct. Sorry for my late reply.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.