I have Percona server farm setup with master and slave nodes, slave has indexes built on some of the fields that master has not. When pt-online-schema-change is applied on master the indexes from the slave were gone. How it works internally in the tool? My understanding was it calls CREATE TABLE LIKE statement, that would yield appropriate structures for master and slave? Do I miss something here or is there a way to work around the issue?
Login or Sign Up
- Log in with Facebook