Restore innodb backup on other server
Posted on 2011-10-14
We are using Percona Xtrabackup to create a db mirroring setup in many to one method.
Server A --> adam_db --> LIVE server
Server B --> adam_db --> mirror server
m taking a tar backup using innobackupex of adam_db on Server A
then, I am copyinh adam_db.tar to Server B, untaring it and synching all folders and files to /var/lib/mysql on Server B
will the ibdata1 of Server A sync to ibdata1 of Server B?
We were only left with recent innodb backup and previous dbs using innodb when checked were corrupted.
We also tried another method of taking backup.
We added innodb_file_per_table in our my.cnf and we got saperate ibd files for all databases(ibd files were created only for db which are added after we added innodb_file_per_table in my.cnf)
We rsynced the db dir in /var/lib/mysql from live to mirror server. DB were still not working.
In this world isn't a single recognised solution for mirroring dbs from one server to another. Please suggest if any other road is there for mirroring dbs from multiple servers to a server.
Thanks in Advance.