← Extractions

Multi-region data governance in Rails application

Miron Marczuk's first-ever public tech talk (wroclove.rb 2023) walks through how Apply4 migrated a single-region multi-tenant Rails SaaS into a fully separated multi-region multi-tenant architecture. He covers the decision to fully split applications, a two-stage rollout (first redirecting users via DNS geolocation and load balancer path rules, then bucketing and separating database records and files), and practical go-live advice.

Model

claude-opus-4-7

Ingestion

482550a6

Input tokens

243,430

fresh: 133,180
cached: 94,500
cache write: 15,750

Output tokens

10,902

Duration

168.7s

Roundtrips

Tool calls

Cost

$0.00

Nodes/edges extracted

25 / 44

Read set (nodes/edges)

102 / 2

Nodes (25)

create Amazon Web Services tool

kind (empty) → tool

name (empty) → Amazon Web Services

slug (empty) → amazon-web-services

attrs (empty) → {"category" => "platform"}

description (empty) → Cloud infrastructure platform used by Apply4 for the multi-region Rails deployment. The app runs in containers on ECS...

short_description (empty) → Amazon's cloud infrastructure platform.

create Amazon ECS tool

kind (empty) → tool

name (empty) → Amazon ECS

slug (empty) → amazon-ecs

attrs (empty) → {"category" => "service"}

description (empty) → AWS managed container orchestration service. Apply4 deploys its Ruby on Rails container to ECS on EC2.

short_description (empty) → AWS managed container orchestration service.

update Miron Marczuk person

attrs (empty) → {"country" => "Poland", "first_talk" => "wroclove.rb 2023"}

description Conference speaker. → Polish Ruby on Rails developer. Works at Apply4 (a permitting SaaS for the film and event industry) through Secret So...

short_description Conference speaker. → Ruby/Rails developer at Apply4 and Secret Source; wroclove.rb 2023 speaker.

update Multi-region data governance in Rails application talk

description Talk at wroclove.rb 2023. → Miron Marczuk's wroclove.rb 2023 talk (his first public tech talk). Tells the story of Apply4's journey from a single...

short_description Talk at wroclove.rb 2023. → wroclove.rb 2023 talk on moving a Rails SaaS from single-region to multi-region multi-tenant.

create Apply4 company

kind (empty) → company

name (empty) → Apply4

slug (empty) → apply4

attrs (empty) → {"industry" => "permitting SaaS / film and event"}

description (empty) → SaaS platform Miron Marczuk works on. Provides permitting software for authorities in the UK, Canada, USA and New Zea...

short_description (empty) → Permitting SaaS platform for the film and event industry.

create Secret Source company

kind (empty) → company

name (empty) → Secret Source

slug (empty) → secret-source

attrs (empty) → {"industry" => "software consulting", "location" => "Gran Canaria"}

description (empty) → Software company with an office in Gran Canaria. Miron Marczuk works at Apply4 through Secret Source.

short_description (empty) → Software company based in Gran Canaria.

create Amazon Route 53 tool

kind (empty) → tool

name (empty) → Amazon Route 53

slug (empty) → amazon-route-53

attrs (empty) → {"category" => "service"}

description (empty) → AWS managed DNS service. Used in Apply4's multi-region migration for geolocation-based routing: the DNS rule resolves...

short_description (empty) → AWS managed DNS service with geolocation routing.

create AWS Elastic Load Balancer tool

kind (empty) → tool

name (empty) → AWS Elastic Load Balancer

slug (empty) → aws-elastic-load-balancer

attrs (empty) → {"category" => "service"}

description (empty) → AWS load balancer used in Apply4's multi-region setup. Configured with path-pattern rules that match the country in t...

short_description (empty) → AWS load balancer with path-pattern redirect rules.

create AWS DataSync tool

kind (empty) → tool

name (empty) → AWS DataSync

slug (empty) → aws-datasync

attrs (empty) → {"category" => "service"}

description (empty) → AWS managed data-transfer service. Recommended by Miron Marczuk for migrating large amounts of files between storage ...

short_description (empty) → AWS managed data-transfer service for files.

create Bucketing concept

kind (empty) → concept

name (empty) → Bucketing

slug (empty) → bucketing

attrs (empty) → {"category" => "pattern"}

description (empty) → Pattern Apply4 used to split a single-region multi-tenant database into per-region databases. An integer 'bucket' col...

short_description (empty) → Tagging each database record with a target region before physically separating tables.

create Default scope for region preview concept

kind (empty) → concept

name (empty) → Default scope for region preview

slug (empty) → default-scope-for-region-preview

attrs (empty) → {"category" => "practice"}

description (empty) → Despite default_scope being widely considered a Rails anti-pattern, Miron recommends it for previewing how each regio...

short_description (empty) → Using Rails default_scope to preview what per-region data will look like.

create Top-down bucketing from Authority concept

kind (empty) → concept

name (empty) → Top-down bucketing from Authority

slug (empty) → top-down-bucketing-from-authority

attrs (empty) → {"category" => "practice"}

description (empty) → Apply4 domain model rooted on an Authority (has a country attribute → region). Bucket assignment starts at each Autho...

short_description (empty) → Assign region buckets starting from the Authority root and walking associations down.

create Table swap via empty copy concept

kind (empty) → concept

name (empty) → Table swap via empty copy

slug (empty) → table-swap-via-empty-copy

attrs (empty) → {"category" => "practice"}

description (empty) → Data-split technique from Apply4: create an empty copy of the source table, insert only the records that should remai...

short_description (empty) → Replace a table by copying wanted rows into an empty clone and renaming.

create Region-aware file paths concept

kind (empty) → concept

name (empty) → Region-aware file paths

slug (empty) → region-aware-file-paths

attrs (empty) → {"category" => "practice"}

description (empty) → File-system split strategy used by Apply4: without changing files themselves, prepend a region-denoting parent folder...

short_description (empty) → Add a region-denoting parent folder to file paths so whole folders can be migrated at once.

create DNS geolocation routing concept

kind (empty) → concept

name (empty) → DNS geolocation routing

slug (empty) → dns-geolocation-routing

attrs (empty) → {"category" => "pattern"}

description (empty) → DNS feature where the resolved IP for a hostname depends on the geographic origin of the requesting resolver. Route 5...

short_description (empty) → DNS returning region-specific IPs based on the requester's origin.

create Gradual migration via steps takeaway

kind (empty) → takeaway

name (empty) → Gradual migration via steps

slug (empty) → gradual-migration-via-steps

attrs (empty) → {"type" => "recommendation"}

description (empty) → Miron's first and most emphasized tip: instead of a single 'leap of faith' deployment that changes everything at once...

short_description (empty) → Break big multi-region migrations into small, deployable stages instead of one leap.

create Use 302 not 301 for region redirects takeaway

kind (empty) → takeaway

name (empty) → Use 302 not 301 for region redirects

slug (empty) → use-302-not-301-for-region-redirects

attrs (empty) → {"type" => "lesson-learned"}

description (empty) → When redirecting users from a region-agnostic URL to a region-specific URL on a load balancer, Apply4 originally used...

short_description (empty) → Chrome caches 301 redirects too aggressively — use 302 for region routing.

create Add SEO alternate links across regions takeaway

kind (empty) → takeaway

name (empty) → Add SEO alternate links across regions

slug (empty) → add-seo-alternate-links-across-regions

attrs (empty) → {"type" => "recommendation"}

description (empty) → Don't forget SEO when splitting a single application into multiple per-region siblings: add the rel=alternate link ta...

short_description (empty) → When splitting an app into regional siblings, add alternate-link tags in the header.

create Three options for multi-region multi-tenant concept

kind (empty) → concept

name (empty) → Three options for multi-region multi-tenant

slug (empty) → three-options-for-multi-region-multi-tenant

attrs (empty) → {"category" => "architecture"}

description (empty) → Framework Miron presents for picking a multi-region architecture: (1) one application, separated data layer — puts al...

short_description (empty) → Separate data only, separate apps fully, or hybrid with shared middle.

create Top-down beats bottom-up for bucketing takeaway

kind (empty) → takeaway

name (empty) → Top-down beats bottom-up for bucketing

slug (empty) → top-down-beats-bottom-up-for-bucketing

attrs (empty) → {"type" => "lesson-learned"}

description (empty) → When assigning region buckets to every record in a tree-like domain, walking top-down from the region-bearing root (A...

short_description (empty) → Starting from the domain root and walking down is simpler and faster than leaf-up.

create Table swap faster than deletion takeaway

kind (empty) → takeaway

name (empty) → Table swap faster than deletion

slug (empty) → table-swap-faster-than-deletion

attrs (empty) → {"type" => "lesson-learned"}

description (empty) → Q&A lesson: copying only the in-region records into an empty clone and renaming tables was measurably faster in the t...

short_description (empty) → Copy wanted rows into an empty clone and rename — faster than deleting unwanted rows.

create Rehearse the go-live takeaway

kind (empty) → takeaway

name (empty) → Rehearse the go-live

slug (empty) → rehearse-the-go-live

attrs (empty) → {"type" => "recommendation"}

description (empty) → Rehearse the entire go-live procedure on staging and locally as many times as possible, including file splits and all...

short_description (empty) → Run the full migration procedure repeatedly on staging/local before touching production.

create Write an explicit go-live runbook takeaway

kind (empty) → takeaway

name (empty) → Write an explicit go-live runbook

slug (empty) → write-an-explicit-go-live-runbook

attrs (empty) → {"type" => "recommendation"}

description (empty) → Go-live advice: inform clients, find a low-usage time (e.g. Saturday 5am), schedule a maintenance window in advance, ...

short_description (empty) → Define exact steps, commands, checks and owners before the maintenance window.

create Cross-region business reporting aggregation question

kind (empty) → question

name (empty) → Cross-region business reporting aggregation

slug (empty) → cross-region-business-reporting-aggregation

attrs (empty) → {"answer_summary" => "Logging is deployed per-region so logs stay local. Cross-region business-report aggregation is ...

description (empty) → Audience asked how Apply4 handles monitoring/logging and business-report aggregation across regions given the promise...

short_description (empty) → How to aggregate business reports across multiple regions without violating data residency.

create Why table swap instead of deletion? question

kind (empty) → question

name (empty) → Why table swap instead of deletion?

slug (empty) → why-table-swap-instead-of-deletion

attrs (empty) → {"answer_summary" => "Both approaches require the same end state, but in Apply4's tests inserting the correct rows in...

description (empty) → Audience asked why Apply4 creates an empty copy of a table, inserts only the in-region rows, and renames, rather than...

short_description (empty) → Why create a fresh table and copy in the wanted rows instead of deleting unwanted rows in place?

Edges (44)

update Miron Marczuk → authored → Multi-region data governance in Rails application

context (empty) → Miron delivered this talk at wroclove.rb 2023 — his first-ever public tech conference talk.

update Multi-region data governance in Rails application → presented_at → wroclove.rb 2023

context (empty) → Talk presented at wroclove.rb 2023 in Wrocław.

create Miron Marczuk → works_at → Apply4

attrs (empty) → {"role" => "developer"}

context (empty) → Works at Apply4 on the permitting SaaS platform, through Secret Source.

relation (empty) → works_at

source_node_id (empty) → e3f3936c-e740-43fc-b9f1-51ccefa2c8a7

target_node_id (empty) → 4f28f943-492c-4ad1-a7ad-8566eb7f4c21

create Miron Marczuk → works_at → Secret Source

context (empty) → Works at Apply4 through Secret Source, which has an office in Gran Canaria.

relation (empty) → works_at

source_node_id (empty) → e3f3936c-e740-43fc-b9f1-51ccefa2c8a7

target_node_id (empty) → 75cd1dcb-0313-486a-8b03-c2d6efed2172

create Miron Marczuk → uses → Ruby on Rails

context (empty) → Apply4's multi-tenant SaaS is a Ruby on Rails application.

relation (empty) → uses

source_node_id (empty) → e3f3936c-e740-43fc-b9f1-51ccefa2c8a7

target_node_id (empty) → 7aac705a-0987-49f2-b665-9d4e08a6acee

create Miron Marczuk → uses → Amazon Web Services

context (empty) → Apply4's infrastructure runs on AWS (ECS/EC2, Route 53, load balancers, DataSync).

relation (empty) → uses

source_node_id (empty) → e3f3936c-e740-43fc-b9f1-51ccefa2c8a7

target_node_id (empty) → 5b5f6a0e-b6dd-4a52-90a2-9b1547841cf8

create Apply4 → uses → Ruby on Rails

context (empty) → Apply4's permitting SaaS is a Ruby on Rails application deployed in containers on AWS ECS.

relation (empty) → uses

source_node_id (empty) → 4f28f943-492c-4ad1-a7ad-8566eb7f4c21

target_node_id (empty) → 7aac705a-0987-49f2-b665-9d4e08a6acee

create Apply4 → uses → Amazon ECS

context (empty) → Rails application is deployed as a container on AWS ECS (running on EC2).

relation (empty) → uses

source_node_id (empty) → 4f28f943-492c-4ad1-a7ad-8566eb7f4c21

target_node_id (empty) → 314fb680-983d-4973-a89a-700ffa38db4e

create Apply4 → uses → Amazon Route 53

context (empty) → Uses Route 53 geolocation DNS to resolve the region-agnostic URL to the correct regional load balancer.

relation (empty) → uses

source_node_id (empty) → 4f28f943-492c-4ad1-a7ad-8566eb7f4c21

target_node_id (empty) → cf57ef79-15a6-43af-97c8-59843f756395

create Apply4 → uses → AWS Elastic Load Balancer

context (empty) → Uses AWS load balancers with path-pattern rules to redirect requests to the correct region-specific application.

relation (empty) → uses

source_node_id (empty) → 4f28f943-492c-4ad1-a7ad-8566eb7f4c21

target_node_id (empty) → b89ac77b-e07c-4c12-8884-6b0da95a3908

create Apply4 → uses → AWS DataSync

context (empty) → Used AWS DataSync to efficiently copy large batches of files between regions when splitting the file system.

relation (empty) → uses

source_node_id (empty) → 4f28f943-492c-4ad1-a7ad-8566eb7f4c21

target_node_id (empty) → cacf93e4-5752-4f66-9cfd-e1316cf723ff

create Apply4 → uses → Redis

context (empty) → Redis is part of Apply4's persistence layer alongside the database and file system.

relation (empty) → uses

source_node_id (empty) → 4f28f943-492c-4ad1-a7ad-8566eb7f4c21

target_node_id (empty) → 4651221d-1a5e-4989-bac2-017a8b614da1

create Multi-region data governance in Rails application → about → Multi-Tenancy

context (empty) → Starts from a multi-tenant Rails SaaS and extends it to multi-region multi-tenant.

relation (empty) → about