0

Using mysql 8 on windows 10 MySql replication master-slave using GTID based(binlog-format = mixed;) . mysqlreplicate ,mysqlrplcheck,mysqlrplshow,mysqlrpladmin commands are ok but mysqlfailover command got ERROR: Query failed. 1694 (HY000): Cannot modify @@session.sql_log_bin inside a transaction.

How do you fix this problem?

  • First, please explain why you need to do such. – Rick James Jan 8 at 5:46
  • MySql replication master slave using GTID based. binlog-format = mixed; Using mysql 8 on windows 10. mysqlreplicate ,mysqlrplcheck,mysqlrplshow,mysqlrpladmin commands are ok but mysqlfailover command got error. ERROR: Query failed. 1694 (HY000): Cannot modify @@session.sql_log_bin inside a transaction. – chan Jan 8 at 10:57
  • Sounds like a bug to report at bugs.mysql.com – Rick James Jan 8 at 21:05

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.