Hakari CP DB Settings?
-
Hi, I found a post where an official linked to the Hikari "Knobs" page and said that most of those should be able to be set in the fusionauth.properties file. I have set several of them while trying to troubleshoot a managed Postgres DB timeout issue, but I am unsure if they are being utilized.
- Can someone confirm if I have set the following values correctly in the .properties file?
# settings necessary to avoid AWS RDS timeouts database.initializationFailTimeout=5000 database.minimumIdle=5 database.maximumPoolSize=10 database.maxLifetime=300000 database.keepaliveTime=30000- Is there a logging mode or some way for me to determine if FusionAuth is picking up and honoring the settings I have specified?
-
Can anyone help?
-
Some of this might be covered in a related thread.
HTH!
Josh
-
@joshua Hi, that is the thread where I got the links to the settings from. However, I don't see any indication that FusionAuth is honoring them, although I think it is because we've gone 5 days now with no DB timeout errors.
Is there a dev at FusionAuth who can comment as to whether the settings, as I have specified them, are the correct way to have them honored in the fusionauth.properties file?
-
@matt-1 said in Hakari CP DB Settings?:
However, I don't see any indication that FusionAuth is honoring them, although I think it is because we've gone 5 days now with no DB timeout errors.
It is not necessarily about FusionAuth honoring timeouts as much as it is about the managed database properly informing the connection pool when it intends to remove or modify a database connection.
As probably evidenced from the related thread - tuning a managed database so that it properly integrates with a connection pool is a task unto itself. I would recommend reviewing Hikari docs, and. the documentation. that comes with the DB that you are working with.
Also to note, FusionAuth has a few folks that are using managed databases. They may yet be able to provide input if they see this thread.
Thanks,
Josh -
@joshua said in Hakari CP DB Settings?:
It is not necessarily about FusionAuth honoring timeouts as much as it is about the managed database properly informing the connection pool when it intends to remove or modify a database connection. [...] As probably evidenced from the related thread - tuning a managed database so that it properly integrates with a connection pool is a task unto itself. I would recommend reviewing Hikari docs, and. the documentation. that comes with the DB that you are working with.
I believe you're missing the point. I'm simply asking you to let me know if I have put the settings into your application configuration file to that they are passed to Hakari properly. I'm not asking you to solve the managed DB problem for me.
That said, it seems they are because we haven't seen the DB timeouts in 6 FusionAuth environments in over 2 weeks now.
-
@matt-1 said in Hakari CP DB Settings?:
That said, it seems they are because we haven't seen the DB timeouts in 6 FusionAuth environments in over 2 weeks now.
Hi @matt-1 Yes, I believe that I misunderstood your question. I believe that you are correct.
Josh
