Comments on: pt-online-schema-change (if misused) can’t save the day https://www.percona.com/blog/pt-online-schema-change-if-misused-cant-save-the-day/ Wed, 07 Aug 2019 13:29:13 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Igor https://www.percona.com/blog/pt-online-schema-change-if-misused-cant-save-the-day/#comment-10968535 Tue, 10 Oct 2017 10:28:03 +0000 https://www.percona.com/blog/?p=35653#comment-10968535 Was using on pt-online-schema-change with –set-vars=”SQL_LOG_BIN=OFF” to prevent propagation to the connected slave. I was expecting the change will take place on 3 nodes Galera cluster but will be missed on connected Slave. Well, the change indeed happen on Galera cluster, but the table on 2 Galera nodes is EMPTY! BEWARE!!!

]]> By: zhuomin chen https://www.percona.com/blog/pt-online-schema-change-if-misused-cant-save-the-day/#comment-10968221 Thu, 29 Jun 2017 02:43:42 +0000 https://www.percona.com/blog/?p=35653#comment-10968221 This should NOT be the issue, even though trigger on Original table on Slave is NOT firing,
Rows on New table on Master should be replicated to New table on Slave over via binlog.
I do not see the need for slave firing trigger at all.

Jimmy

]]> By: Todd Lomaro https://www.percona.com/blog/pt-online-schema-change-if-misused-cant-save-the-day/#comment-10967077 Fri, 30 Sep 2016 17:24:58 +0000 https://www.percona.com/blog/?p=35653#comment-10967077 What if you have Master-Master enabled?

]]> By: Piotr Mazurkiewicz https://www.percona.com/blog/pt-online-schema-change-if-misused-cant-save-the-day/#comment-10966517 Wed, 25 May 2016 12:42:55 +0000 https://www.percona.com/blog/?p=35653#comment-10966517 MariaDB has ability to run triggers on slave for row-based replication starting from 10.1.1. Which I have ported to PS 5.6 successfully.

]]>