Mysql connection recomendations

Community Support
1

We are using temporal with mysql backend and need a little advise on connections setup.

This blog comment suggest that connection size 30 is pretty large. We have some heavy usage for regular workflow execution and also in getting the workflow history. Do you still recommend the default maxCons 20 and default maxIdleConns 10 ?

2

Hi @sp13 thanks for the question! Will double check on this internally and get back to you asap.

1 Like
3

the thread referenced mentions Error 1040: Too many connections, so 30 max conn is pretty large.

the max conn configuration depends on your Temporal hosts size, and MySQL side.
e.g. db.m5.8xlarge can clearly handle more connection then db.m5.xlarge

Do you still recommend the default maxCons 20 and default maxIdleConns 10 ?

the default max conn exists for most low / mid volume use case, if you are going to production, plz do load test and figure out the proper max conn value

1 Like