I have a MySQL Percona DB with Master - Master replication setup which has 2.5 TB of data in it. Somewhere a small scale corruption happened which altered some table structure. I was able to recover the Master immediately and send it to production. Now the problem is the slave is not in synch and it is throwing error. I tried everything (skip counter, fill data etc), but I was not able to synch them. Now the only thing I can do is re setup the replication.
For that I believe I will need a master Copy from the Master DB which is not possible for me to take because backing up a 2.5 TB DB by locking the tables is not a possible solution. The configuration of the server is
Dual Hex core CPU,
128 GB RAM,
3.6 TB total disk space in RAID 10
1.1 free space
Fedora 15 OS
My questions will be,
In this scenario, what do you recommend to setup the slave replication and then make it a Master-Master setup?
Please let me know how to go forward. I am totally struck with this thing.
Thank you so much in advance!!