Deploying Clickhouse to an existing Phoenix Application

[jakewlacey]

Alright, we’re getting further.

How to run ecto.create for an Elixir app?

non-existing domain - :nxdomain usually means that IPv6 needs to be enabled. In order to enable that you will need to make your repo config something like this config :app, App.Repo, ssl: false, socket_options: [:inet6], url: database_url, pool_size: String.to_integer(System.get_env("POOL_SIZE") || "10")

Since this is a private this is only accessible via ipv6, thats my understanding so makes sense why it cannot connect. So the fix would be to enable ipv6.

I’m using Ecto.Adapters.ClickHouse, and inet can be enabled by doing the following.

config :app, App.DigestRepo,
    hostname: "app-clickhouse.internal",
    port: 8123,
    database: "events",
    transport_opts: [inet6: true]

And it worked!