Announcement

Announcement Module
Collapse
No announcement yet.

pt-online-schema-change slave node index handling

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-online-schema-change slave node index handling

    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?
Working...
X