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

problem with mirroring backup

alokalok EntrantInactive User Role Beginner
Hello All,

we have the below setup

Server A --> adam_db (LIVE SERVER)
Server B --> adam_db (MIRROR SERVER)

on Server A --

we are taking stream backup of adam_db

Step 1:

/usr/bin/innobackupex-1.5.1 --databases="adam_db" --stream=tar ./ >> /home/DBbackup.tar

Step 2:

copy DBbackup.tar file to Server B

Server B --

Step 1:

tar -ixf /home/DB_backup/DBbackup.tar -C /home/DB_backup/

Step 2:

rsync -trv --exclude=xtrabackup* --exclude=DBbackup.tar --exclude=ibdata1 --exclude=backup-my* /home/DB_backup/* /var/lib/mysql/

Above process fails even we sync ibdata1 file.

Any suggestions?

Regards,
Alok.N

Comments

  • xaprbxaprb Mentor Inactive User Role Beginner
    I don't see where you say what the failure is, but I'm guessing that MySQL won't start. I suggest you RTFM because it looks like you haven't prepared the backup.
  • alokalok Entrant Inactive User Role Beginner
    Could you let us know how can we create an ibdata1 file for a single database.
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.