Hi All,
I would like to ask if you have some example database configuration files (like my.cnf or cassandra.yaml)
with which the application should work the most efficiently? Or you have some recommendations related with database configuration?
Hi Jaroslaw, this is a great question, thank you.
I am not aware of any existing recommendations for fine-tuning Cassandra or mysql for use with Temporal. I am very curious if the community has any wisdom around that.
Any update on this topic?
It would be very useful to have some guide on tuning Cassandra for Temporal deployments specifically.
With its architecture Temporal is in theory always going to hit bottleneck in database (Cassandra) because scaling its server components is straightforward.
I am specifically interested in things like jvm options, optimal heap sizes, garbage collections, compactions and other low level configuration knobs that help with queue like load that Temporal is generating.
This very nice article might help: Choosing the Number of Shards in Temporal History Service | Mikhail Shilkov.
Don’t think we have a specific page in docs yet for db tuning.