Run temporal failed in MYSQL binlog STATEMENT

[Zzzz1111]

Expected Behavior

Successful run

Actual Behavior

run failed with error
{"level":"error","ts":"2025-09-13T14:38:49.570Z","msg":"error returned","component":"fx","name":"go.temporal.io/server/temporal.ApplyClusterMetadataConfigProvider()","kind": "provide","module":"",""error":"received non-nil error from function 'go.tem
poral.io/server/temporal'.ApplyClusterMetadataConfigProvider(/Users/bytedance/dev/eps/docker-builds/temporal/temporal/fx)go:571): SaveClusterMetadata operation failed. Error Error 10565 (HY000): Cannot execute statement: impossible to write tobina
ry log since BINLOG_FORMAT = STATEMENT and at least onetable uses a storage engine limited to row-based loggingg. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.","errorverbose":"received non
nil error from function 'go.temporal.io/server/temporall".ApplyClusterMetadataConfigProvider\n\t/Users/bytedance/dev/eps/docker-builds/temporal/temporal/fx.go:57l:\nSSaveClusterMetadata operation failed. Error Error 1665 (HY000): Cannot execute stat
ement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table usesa storage engine limited to row-based logging. InnnoDB is limited to row-logging when transaction isplation level is READ COMMITTED or READ UNCOMMITT
ED.", "logging-call-at":"/Users/bytedance/dev/eps/docker--builds/temporal/temporal/fx.go:1095","stacktrace":"go.temporal.io/server/common/log.(*zapLogger).Error\n\t/Users/bytedance/dev/eps/docker-builds/temporal/common/log/zaap_logger.go:132\ngo.tempor
al.io/server/temporal.(*fxLogAdapter).LogEvent\n\t/Userss/bytedance/dev/eps/docker-builds/temporal/temporal/fx.g0:1095\ngo.uber.org/fx.(*module).provide.funcl\n\t/Users/bytedance/go/pkg/mod/go.uber.org/fx@vl.23.0/module.go:1199\ngo.uber.org/dig.(*cons
tructorNode).Call.funcl\n\t/Üsers/bytedance/go/pkg/mod/ggo.uber.org/dig@v1.18.0/constructor.go:167\ngo.uber.org/dig.(*constructorNode).Call\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@vl.18.0/constructor.go:189\ngo.uber.org/dig.paramSingle.Build\n
\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@vl.18.0/param.go:288 /ngo.uber.org/dig.paramObjectField.Build\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@v1.18.0/param.go:485\ngo.uber.org/dig.paramObject.Build\n\t/Users/bytedance/go/pkg/mod/go.uber.
org/dig@vl.18.0/param.go:413\ngo.uber.org/dig.paramList.BuildList\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@vl.18.0/param.go:151\ngo.uber.org/dig.(*constructorNode).Call\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@v1.18.0/constrัuctor.go:155
ngo.uber.org/dig.paramGroupedSlice.callGroupProviders\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@v1.18.0/param.go:610\ngo.uber.org/dig.paramGroupedSlice.Build\n\t/Users/bytedance/go/pkg/mod/go.ubef.org/dig@vl.18.0/param.go:640\ngo.uber.org/dig.p
aramObjectField.Build\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@vl.18.0/param.go:485\ngo.uber.org/dig.parammObject.Build\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@v1.18.0/param.go:413\ngo.uber.org/dig.paramList.BuilldList\n\t/Users/bytedance
/go/pkg/mod/go.uber.org/dig@vl.18.0/param.go:151\ngo.ubeer.org/dig.(*constructorNode).Call\n't/Users/bytedance/go/pkg/mod/go.uber.org/dig@vl.18.0/constructor.go:155\ngo.uber.org/dig.paramŠingle.Build\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@vl.
18.0/param.go:288\ngo.uber.org/dig.paramList.BuildList\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@v1.18.0/param.go:151\ngo.uber.org/dig.(*Scope).Invoke\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@vl.18.0/invoke.go:123'ngo.uber.org/dig.(*Čonta
iner).Invoke\n\t/Users/bytedance/go/pkg/mod/go.uber.org/dig@vl.18.0/invoke.go:83\ngo.uber.org/fx.runInvoke\n\t/Users/bytedance/go/pkg/mod/go.uber.org/fx@vl.23.0/invoke.go:109\ngo.uber.org/fx.(*module).executeInvoke\n\t/Userrs/bytedance/go/pkg/mod/go.
uber.org/fx@v1.23.0/module.go:322\ngo.uber.org/fx.(*module).executeInvokes\n\t/Users/bytedance/go/pkg/mod/go.uber.org/fx@v1.23.0/module.go:308\ngo.uber.org/fx.New\n\t/Users/bytedance/go/pkg/mod/go.uber.org/fx@vl.23.0/app.go:517\ngo.temporal.io/serve
r/temporal.NewServerFx\n\t/Üsers/bytedance/dev/eps/docker-builds/temporal/temporal/fx.go:148\ngo.temporal.io/server/temporal.NewServer\n\t/Users/bytedance/dev/eps/docker-builds/temporal/temporal/server.go:45\nmain.buildCLİ.func4\n\t/Users/bytedance/
dev/eps/docker-builds/temporal/cmd/server/main.go:214\nggithub.com/urfave/cli/v2.(*Command).Run\n\t/Users/bytedance/go/pkg/mod/github.com/urfave/cli/v2@v2.27.5/command.go:276\ngithub.com/urfave/cli/v2.(*Command).Run\n\t/Userrs/bytedance/go/pkg/mod/git
hub.com/urfave/cli/v2@v2.27.5/command.go:269\ngithub.com/urfave/cli/v2.(*App).RunContext\n\t/Users/bytedance/go/pkg/mod/github.com/urfave/cli/v2@v2.27.5/app.go:333\ngithub.com/urfave/cli/v2.(*App).Run\n\t/Users/bytedance/go/pkg/mod/github.com/unfave
/cli/v2@v2.27.5/app.go:307\nmain\n\n\t/Users/bytedance/dev/eps/docker-builds/temporal/cmd/serveer/main.go:36\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:283"}

Steps to Reproduce the Problem

1. set mysql binlog_format to STATEMENT
   2.run temporal

Specifications

• Version:
• Platform: all

I Find temporal default mysql session transaction_isolation is 'READ-COMMITTED' , when the mysql binlog_format is STATEMENT , there will be a conflict. so , i think temporal can set default binlog_format .
eg: