Config Options

[jackcb123]

Hi again! Got this working well, appreciate all the help in previous posts :) and apologies for continuing the question onslaught!...

Is there a list somewhere of all the config options allowed? Right now my config looks like this:

production:
primary:
adapter: postgresql_proxy
host: *****
password: *****
username: *****
database: *****
port: <%= ENV["STATEMENT_TIMEOUT"] ? 5432 : 6432 %>
pool: 30
prepared_statements: false
connect_timeout: 5
checkout_timeout: 5
variables:
statement_timeout: <%= ENV["STATEMENT_TIMEOUT"] || "60s" %>

primary_replica:
adapter: postgresql
replica: true
host: 127.0.0.1
password: *****
username: *****
database: *****
port: <%= ENV["STATEMENT_TIMEOUT"] ? 5432 : 6432 %>
pool: 30
prepared_statements: false
connect_timeout: 5
checkout_timeout: 5
variables:
statement_timeout: <%= ENV["STATEMENT_TIMEOUT"] || "60s" %>

In the old makara setup we had some of this stuff:
blacklist_duration: 5
master_ttl: 5
master_strategy: round_robin
sticky: true
rescue_connection_failures: false

Just curious if you have any helpful additions, or where I should go to see all the options!

[mateuscruz]

Hello again @jackcb123.

First, I would appreciate if you could start using the "Discussions" section of the repo to ask your questions moving forward as the issues tab is meant for reporting bugs or security vulnerabilities.

Here's what you're looking for:

• Basic configuration (proxy delay and checkout timeout): https://github.com/Nasdaq/active_record_proxy_adapters?tab=readme-ov-file#configuration
• Logging configuration: https://github.com/Nasdaq/active_record_proxy_adapters?tab=readme-ov-file#logging
• Caching configuration: https://github.com/Nasdaq/active_record_proxy_adapters?tab=readme-ov-file#caching-configuration

Makara's primary_ttl is equivalent to ARPA's proxy_delay but we expect an ActiveSupport::Duration object instead of an integer.

These makara options don't have an equivalent option for ARPA:

• blacklist_duration (we don't do blacklisting)
• primary_strategy (we don't do load balancing: https://github.com/Nasdaq/active_record_proxy_adapters?tab=readme-ov-file#why-do-i-need-this)
• sticky (this is the default behaviour)
• rescue_connection_failures (this option does not exist in latest makara version)

If blacklisting and load balancing are important to you, you can implement a custom adapter and a custom proxy to add that functionality.

I should mention that, while this gem is inspired by makara, it is not a hot swap replacement. Not all features are supported, config options are set differently and we don't read any configs from config/database.yml other than the usual Rails database properties (adapter, host, port, user, password, etc). All gem configuration is done via a .configure block (which in Rails apps is probably best to be put in an initializer under config/initializers/.

If you're interested in the source code for the config, here it is: https://github.com/Nasdaq/active_record_proxy_adapters/blob/main/lib/active_record_proxy_adapters/configuration.rb#L9

[OskarEichler]

This issue was actually related to #78 so can be closed.