I have debian box with big database.
I want to do a lot of risky operation with this database.
Its about updating the sofware which works with this db.
I can stop database for 5 min, but not for more time.
Db files is innodb files on lvm logical volume.
When I doing backup, I do it with lvm snapshots.
I am pretty sure, that I need more then one try for updating, something always going bad.
My idea is: What if I do lvm snapshot (with big size), mount it, start another mysql instance and do all risky work on this instance.
If problem occurs, I just remove snapshot and start again.
If all be correct, and all test will be passed (it probably take 1-2 days) - I do backup from second instance, and move it to first instance.
I need something for start second instance without touch my first instance. What I can use?
- Do debootstrap and chroot?
- Install kvm ?
I need your advices.