csadewa
Hi all, is there a recommended way to setup & supervise Ecto.Repo for unreliable & uncritical database?
For additional context, i have an application which connect to PostgreSQL (DB A) using standard Ecto.Repo supervision. This service then needs a new connection to another PostgreSQL Business Intelligence database (DB B) for implementing non-critical feature, but DB B is known to be unreliable and i don’t want the application to crash due to DB B failure escalation on supervision tree. For easy solution, i could just set supervision max_restart Ecto.Repo for DB B to be very high number, but is there a better way to handle the situation?.
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Bringing learning, work and compliance together since 1987.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 3- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
dimitarvp
You could also increase the connection timeout?
csadewa
Yes, that could also be one of quick solutions. The thing I am worried about unreliable Ecto.Repo is that supervisor seems should only be used to supervise critical component to application (see link) with expectation that if critical component fail repeatedly it should be escalated to supervisor (which is not behavior i want from DB B, as it’s non-critical), but Ecto.Repo would require supervision as part of it’s setup.
vfsoraki
Apart from increasing timeouts and wrapping your uncritical queries with proper error handling, you can also start your DB B repo in a separate supervisor and increase the parameters of that supervisor alone so that it doesn’t crash if the repo of DB B crashed often.
Supervisor crash resiliency works with number of crashes in a given time frame. You should set them high enough so the supervisor itself doesn’t crash, like a max restart of 100 times in 1 second. Of course, you have to find these values yourself.