# Sql\_log\_bin not supported in M-M-S replication on new pt-online-schema-change?

**URL:** <https://forums.percona.com/t/sql-log-bin-not-supported-in-m-m-s-replication-on-new-pt-online-schema-change/28361>\
**Category:** Percona Toolkit\
**Tags:** percona\
**Created:** [February 9, 2024, 12:58pm UTC](https://forums.percona.com/t/sql-log-bin-not-supported-in-m-m-s-replication-on-new-pt-online-schema-change/28361 "2024-02-09T12:58:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![asavanidba](https://avatars.discourse-cdn.com/v4/letter/a/b77776/32.png) [@asavanidba](https://forums.percona.com/u/asavanidba)\
**Post date:** [February 9, 2024, 12:58pm UTC](https://forums.percona.com/t/sql-log-bin-not-supported-in-m-m-s-replication-on-new-pt-online-schema-change/28361/1 "2024-02-09T12:58:47Z")

</div>

Hi Team,

We are facing some issue with updated version of pt-online-schema-change.

Issue : set sql\_log\_bin=OFF variable is not working with MMS (Master-Master-Slave) topology.

Below are details:  
percona-toolkit-3.0.13-1.el7.x86\_64  
Mariadb Version : 10.3  
Topology Used:  
Slave------\<—Master–\<-----\>-Master-----\>----Slave  
server4 server 1 server 2 server 3

Log slave update is enabled on server 1 & server 2  
Replication format: row based.

Below is the final actual command

/usr/bin/pt-online-schema-change -uadmin --ask-pass -P3310 --nocheck-unique-key-change --progress=“time,10” -S/dbdata/mariadb-data/mariadb.sock --preserve-triggers --print --no-version-check --skip-check-slave-lag --execute --alter " " --set-vars=“sql\_log\_bin=OFF,max\_statement\_time=0” --max-load=“Threads\_running=600” --critical-load=“Threads\_running=450” --chunk-size=3000 D=property,t=whatsapp\_tracking --execute

Please provide the solution, As per my observation, slave was down due to only pt trigger was replicating on slave side.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [February 9, 2024, 3:37pm UTC](https://forums.percona.com/t/sql-log-bin-not-supported-in-m-m-s-replication-on-new-pt-online-schema-change/28361/2 "2024-02-09T15:37:38Z")

</div>

What exactly are you trying to do? Your --alter command is empty. What are you expecting here? Why are you trying to disable the binary logs (and by extension, disable replication)?