asxpio/db/migrations
Sergei Poljanski 0cc3e1dece
All checks were successful
Build and Deploy to Production / test (push) Successful in 26s
Build and Deploy to Production / build (push) Successful in 1m11s
Build and Deploy to Production / deploy (push) Successful in 37s
bingo: add a reachability monitor for the status page
datacenterbingo gets a public page showing whether each datacenter's
network answers. The probing lives here, next to the schema and the
admin, since the public site only has a read-only role.

bin/monitor runs as a second container from the same image. Once a
minute it opens one TCP connection to every active target (a handshake
or a refusal both count as answered) and folds the results into
5-minute rows per datacenter, plus a per-bucket row for control hosts in
Russia, so a lost vantage point isn't mistaken for dark sites. Rows are
kept 30 days. Targets are managed at /admin/bingo/monitor; only hosts a
public source ties to that one site belong there.

Migration 017 also grants the new tables to the bingo role, so the
public site can read them without a storage redeploy.

Assisted-by: Claude:opus-5-5
2026-10-18 10:31:00 +04:00
..
001_invoices.rb db: connection helper and invoices migration 2026-05-26 17:43:18 +03:00
002_invoice_ltc.rb ltc payments 2026-06-08 18:43:01 +03:00
003_invoice_crypto.rb invoices: multi-crypto payment support 2026-07-03 02:01:57 +04:00
004_bingo.rb bingo: serve datacenter bingo on bingo.asxp.io 2026-10-10 04:51:26 +04:00
005_bingo_photo_variants.rb bingo: SEO pass and resized photos 2026-10-10 06:26:03 +04:00
006_bingo_mw_type.rb bingo: planned status and capacity type 2026-10-10 06:59:04 +04:00
007_users.rb admin: user accounts and session login 2026-10-10 08:25:46 +04:00
008_user_tokens_audit.rb admin: user management, invites, password reset, audit log 2026-10-10 08:31:42 +04:00
009_invoice_cancel_hide.rb invoices: cancel with stamped PDF, superuser-only hiding 2026-10-10 08:35:01 +04:00
010_payout_addresses.rb invoices: payout addresses in the database 2026-10-10 08:36:32 +04:00
011_users_choose_username.rb admin: invite links without a username 2026-10-10 09:12:21 +04:00
012_payout_addresses_rework.rb invoices: self-contained payout addresses 2026-10-10 09:17:09 +04:00
013_bingo_photo_og.rb bingo: 1200x630 JPEG for og:image 2026-10-10 09:28:57 +04:00
014_bingo_updated_at.rb bingo: lastmod from the last edit, not the last insert 2026-10-10 09:30:37 +04:00
015_bingo_about.rb bingo: optional prose per datacenter page 2026-10-10 09:41:11 +04:00
016_bingo_provider.rb bingo: build the card from chosen providers 2026-10-11 21:12:47 +04:00
017_bingo_monitor.rb bingo: add a reachability monitor for the status page 2026-10-18 10:31:00 +04:00