A SQL client issue

Newbie_Sr · March 9, 2021, 9:56pm

Hi,
I am trying to set up temporal with our vitess cluster (mysql version 8.0). Seems that the SQL client Temporal is using is not compatible with our vitess cluster when have “multiStatements” flag enabled. But I can use a different MySQL go client to connect to vitess with that flag enabled.

I comment out the below line and built a Temporal server docker image, it worked well with our vitess cluster.

github.com

temporalio/temporal/blob/master/common/persistence/sql/sqlplugin/mysql/plugin.go#L56


	isolationLevelAttrName       = "transaction_isolation"
	isolationLevelAttrNameLegacy = "tx_isolation"
	defaultIsolationLevel        = "'READ-COMMITTED'"
	// customTLSName is the name used if a custom tls configuration is created
	customTLSName = "tls-custom"
)

var dsnAttrOverrides = map[string]string{
	"parseTime":       "true",
	"clientFoundRows": "true",
	"multiStatements": "true",
}

type plugin struct{}

var _ sqlplugin.Plugin = (*plugin)(nil)

func init() {
	sql.RegisterPlugin(PluginName, &plugin{})
}

I also filed an issue on github: sql client is not compatible with mysql version 8+ · Issue #1364 · temporalio/temporal · GitHub

Wenquan_Xing · March 9, 2021, 10:29pm

Thanks for reporting this, I will take a look.

FYI, Temporal only officially support MySQL 5.7

Newbie_Sr · March 9, 2021, 10:54pm

Ya, i know 8.0 is not officially supported, but it worked with a different sql client. so it is less likely a mysql server issue

madhu · March 12, 2021, 5:03pm

mysql 8 is not supported yet refer this post
i have tried mysql 5.7.30/31 and it works just fine.

Topic		Replies	Views
SQL Server support with Java Community Support java-sdk , database	3	637	March 14, 2022
Temporal with MySQL Community Support mysql , worker	0	122	March 1, 2024
Temporal-sql-tool no longer in the temporalio/server docker image, should we use temporalio/admin-tools instead? Community Support mysql , docker	15	3401	November 16, 2021
Support for additional RDBMS Community Support	5	962	February 26, 2021
Temporal with Yugabyte db Community Support java-sdk	10	1037	January 4, 2022

A SQL client issue

Related Topics