Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #933232
  2. Comment #4

Comment 4 for bug 933232

Revision history for this message
gu lei (gulei-om) wrote : Re: pt-online-schema-change and triggers break replication

Hi, Daniel Nicher:

Thanks.

The triggers are created by pt-online-schema-change.

Also the triggers would write binlog if any rows changed when pt-online-schema-change is working.

You can insert one row to the table when pt-online-schema-change is working. Then replication would be broken.

Hi, Baron Schwartz:

Thanks.

I think people may need some guide in http://www.percona.com/doc/percona-toolkit/2.0/pt-online-schema-change.html before you get a good solution. For example, users should create __tmp_<table name> table on slaves before start pt-online-schema-change.

pt-online-shcema-change is a good tool.