Go로 PostgreSQL 프록시 만들기 (34) - Multi-Database Routing
단일 pgmux 인스턴스에서 여러 PostgreSQL 데이터베이스를 동시 프록시하는 Multi-Database Routing을 구현한다. DatabaseGroup 추상화, per-DB 풀/밸런서 격리, 캐시 키 혼합까지.
Tags
database (72)
proxy (63)
postgresql (61)
go (59)
performance (32)
spring (28)
security (25)
redis (20)
ci (18)
java (17)
spring boot (16)
ci/cd (15)
geeknews (14)
hacker news (14)
jpa (13)
kafka (13)
observability (13)
qa (13)
cache (12)
network (11)
kubernetes (10)
mysql (10)
connection pool (9)
devops (9)
microservices (9)
ai agent (8)
api (8)
bug fix (8)
concurrency (8)
http (8)
index (8)
jvm (8)
platform engineering (8)
resilience (8)
rest (8)
spring security (8)
ai coding (7)
architecture (7)
docker (7)
jwt (7)
oauth2 (7)
transaction (7)
caching (6)
ddd (6)
event-driven (6)
hot reload (6)
react (6)
면접 (6)
백엔드 (6)
backend operations (5)
circuit breaker (5)
developer productivity (5)
error handling (5)
graceful shutdown (5)
mcp (5)
metrics (5)
monitoring (5)
opentelemetry (5)
prometheus (5)
reactive (5)
reddit (5)
retry (5)
routing (5)
sharding (5)
slo (5)
tls (5)
agentic engineering (4)
async (4)
authentication (4)
b-tree (4)
backend (4)
backpressure (4)
caffeine (4)
configuration (4)
consumer group (4)
controlleradvice (4)
data race (4)
deployment (4)
distributed systems (4)
dns (4)
elk (4)
gc (4)
github actions (4)
governance (4)
graphql (4)
idempotency (4)
isolation (4)
jit (4)
lock (4)
memory (4)
optimization (4)
q&a (4)
refactoring (4)
reliability (4)
schema (4)
spec-driven development (4)
sql (4)
system design (4)
testing (4)
timeout (4)
admin api (3)
aggregate (3)
ai coding agent (3)
aop (3)
argocd (3)
authorization (3)
availability (3)
aws (3)
batch (3)
benchmark (3)
canary (3)
cap (3)
capacity planning (3)
cdc (3)
claude code (3)
cli (3)
code review (3)
consistency (3)
cost optimization (3)
dev productivity (3)
dlq (3)
elasticsearch (3)
entity (3)
exception handling (3)
explain (3)
grpc (3)
hibernate (3)
hooks (3)
linux (3)
load balancer (3)
logging (3)
memory leak (3)
n+1 (3)
offset (3)
oop (3)
replication (3)
rest api (3)
runtime governance (3)
saga (3)
spring mvc (3)
sre (3)
tcp (3)
validation (3)
vault (3)
wasm (3)
webflux (3)
wire protocol (3)
메시지큐 (3)
분산락 (3)
@transactional (2)
a2a (2)
acid (2)
admission control (2)
advice (2)
aggregation (2)
ai (2)
alerting (2)
api gateway (2)
apm (2)
arraylist (2)
ast (2)
auth (2)
automation (2)
autoresearch (2)
bean (2)
best practices (2)
bloat (2)
build (2)
cache aside (2)
cache invalidation (2)
cap theorem (2)
claude opus (2)
clean code (2)
collections (2)
connection pooling (2)
container (2)
context api (2)
cqrs (2)
cryptography (2)
cs (2)
data contract (2)
db (2)
debugging (2)
design patterns (2)
devex (2)
di (2)
disaster recovery (2)
dispatcherservlet (2)
distributed lock (2)
docker compose (2)
ebpf (2)
edge ai (2)
error response (2)
evals (2)
event sourcing (2)
factory (2)
feature flag (2)
filter chain (2)
finops (2)
firecracker (2)
firewall (2)
formal verification (2)
fsnotify (2)
full-text search (2)
g1gc (2)
globalexception (2)
gpt-5.4 (2)
grafana (2)
grapheneos (2)
handshake (2)
hash (2)
hashmap (2)
health check (2)
hexagonal (2)
hikaricp (2)
https (2)
integration test (2)
interceptor (2)
interview (2)
inverted index (2)
ioc (2)
jenkins (2)
join (2)
k8s (2)
kotlin (2)
latency (2)
llm (2)
llm gateway (2)
load shedding (2)
logs (2)
mdc (2)
metaspace (2)
micrometer (2)
migration (2)
mockito (2)
module (2)
moe (2)
mono (2)
multi-module (2)
multi-tenancy (2)
noisy neighbor (2)
openai (2)
optional (2)
ordering (2)
os (2)
partition (2)
pgbouncer (2)
phishing (2)
pointcut (2)
pprof (2)
prepared statement (2)
production safety (2)
project (2)
python (2)
query (2)
quic (2)
race condition (2)
rate limiting (2)
rbac (2)
reactor (2)
rebalance (2)
redux (2)
release (2)
repository (2)
resilience4j (2)
rollback (2)
runbook (2)
s3 (2)
saas (2)
sandbox (2)
sbom (2)
scalability (2)
scheduling (2)
schema registry (2)
search (2)
serverless (2)
service mesh (2)
social login (2)
spring boot actuator (2)
spring webflux (2)
state management (2)
stomp (2)
strangler (2)
strategy (2)
stream (2)
streams (2)
structured logging (2)
supply chain (2)
supply chain attack (2)
template method (2)
thread (2)
thread dump (2)
thread pool (2)
thundering herd (2)
token (2)
tracing (2)
value object (2)
vector db (2)
version control (2)
vibe coding (2)
virtual dom (2)
web (2)
websocket (2)
workflow orchestration (2)
zero downtime (2)
zustand (2)
낙관적락 (2)
동시성 (2)
보안 (2)
분산시스템 (2)
비관적락 (2)
비동기 (2)
성능 (2)
성능최적화 (2)
성능테스트 (2)
에러처리 (2)
예외처리 (2)
인증 (2)
캐싱 (2)
커뮤니케이션 (2)
테스트 (2)
트러블슈팅 (2)
2pc (1)
3m (1)
400b llm (1)
a/b test (1)
abac (1)
active-active (1)
adaptive concurrency (1)
ageless linux (1)
agent safehouse (1)
agentic commerce (1)
ai agents (1)
ai art royalties (1)
ai code (1)
ai code review (1)
ai engineering (1)
ai labor (1)
ai labor market (1)
ai platform (1)
ai research (1)
ai security (1)
ai slop (1)
alb (1)
allocation (1)
amazon ai outage (1)
android sideloading (1)
ann (1)
api security (1)
apple silicon (1)
applicationcontext (1)
approval workflow (1)
archive.today (1)
archunit (1)
arxiv (1)
association (1)
astral (1)
at-least-once (1)
attention residuals (1)
audit (1)
authorization code (1)
authorization server (1)
auto-remediation (1)
autoconfiguration (1)
autoscaling (1)
autovacuum (1)
aws fis (1)
aws lambda (1)
aws secrets manager (1)
azure (1)
backend architecture (1)
backend reliability (1)
backlog (1)
backoff (1)
backup (1)
backward compatibility (1)
barrier (1)
bean scope (1)
bean validation (1)
bff (1)
billing (1)
bitmap (1)
bitnet (1)
blast radius (1)
blocking (1)
bloom filter (1)
blue-green (1)
bluegreen (1)
botnet (1)
bounded context (1)
bram cohen (1)
bridge (1)
browser (1)
browser agent (1)
bulkhead (1)
c++26 (1)
cache stampede (1)
cancel request (1)
cancelrequest (1)
card table (1)
cassandra (1)
causal consistency (1)
cdn (1)
cell-based architecture (1)
certificate (1)
channels (1)
chaos engineering (1)
chatgpt (1)
checklist (1)
circuitbreaker (1)
classloader (1)
classpath (1)
claude code cost (1)
claude computer use (1)
clean architecture (1)
cloud (1)
cloud cost (1)
cloudflare (1)
cloudflare crawl (1)
code organization (1)
code quality (1)
codespeak (1)
codex security (1)
codex subagents (1)
cold start (1)
collection (1)
command (1)
commit (1)
compatibility (1)
completablefuture (1)
compliance (1)
component model (1)
computer use (1)
concurrency limit (1)
condition (1)
conditional request (1)
configmap (1)
configurationproperties (1)
congestion control (1)
connection limits (1)
connection management (1)
connection storm (1)
consensus (1)
consistent hashing (1)
constraint (1)
consumer lag (1)
contention (1)
context cancellation (1)
context engineering (1)
continuous profiling (1)
contract testing (1)
contracts (1)
copy protocol (1)
coroutines (1)
cors (1)
cosign (1)
cq (1)
crdt (1)
cron (1)
cross-model void convergence (1)
crud (1)
csrf (1)
cursor (1)
cutover (1)
cve (1)
dangling pointer (1)
data center (1)
data consistency (1)
data migration (1)
data retention (1)
database branching (1)
database internals (1)
database lock (1)
database migration (1)
database scaling (1)
dataloader (1)
datetime (1)
dead tuple (1)
deadlock (1)
debezium (1)
decoupling (1)
deduplication (1)
defi (1)
dependencies (1)
dependency injection (1)
design principles (1)
developer experience (1)
developer tools (1)
digital twin (1)
distributed tracing (1)
distributed transaction (1)
distributed transactions (1)
dlp (1)
dnssec (1)
dockerfile (1)
document db (1)
documentation (1)
doh (1)
drr (1)
dual write (1)
durable execution (1)
dx (1)
e2e (1)
ec2 (1)
embeddings (1)
entitygraph (1)
entitymanager (1)
epoll (1)
error (1)
error budget (1)
europol (1)
event-driven architecture (1)
eventloop (1)
events (1)
eventual consistency (1)
exactly once (1)
exception (1)
exceptionhandling (1)
executor (1)
expand-contract (1)
extended query (1)
failover (1)
fair scheduling (1)
fanout (1)
fault injection (1)
fault isolation (1)
fault tolerance (1)
federation (1)
fetch join (1)
fifo (1)
file upload (1)
filebeat (1)
filter (1)
firefox (1)
flaky test (1)
flash-moe (1)
flow control (1)
flush (1)
flux (1)
flyway (1)
foreignkey (1)
forge (1)
frontend (1)
fulltext (1)
functional programming (1)
gateway (1)
gatling (1)
gc logs (1)
generative ui (1)
geo (1)
ghcr (1)
ghostty (1)
git (1)
github (1)
glassworm (1)
go 1.26 (1)
golden path (1)
golden signals (1)
google (1)
goroutine (1)
goroutine leak (1)
gpt-5.2 (1)
graalvm (1)
gradle (1)
greenboost (1)
group by (1)
gsd (1)
gslb (1)
gstack (1)
han (1)
hashset (1)
having (1)
heap dump (1)
hedged request (1)
helm (1)
hermetic build (1)
high availability (1)
hnsw (1)
hot key (1)
http api (1)
http/3 (1)
http2 (1)
hybrid inference (1)
hyperloglog (1)
i/o (1)
i18n (1)
iac (1)
icml (1)
idempotent (1)
idl (1)
idp (1)
image (1)
immersion cooling (1)
incident response (1)
indie game dev (1)
indieweb (1)
infra (1)
innodb (1)
intellij (1)
interoperability (1)
io (1)
iphone 17 pro (1)
istio (1)
jaeger (1)
javascript (1)
jemalloc (1)
jmeter (1)
junior developer (1)
junit (1)
junit 5 (1)
k6 (1)
kakao (1)
karpathy (1)
kernel anti-cheat (1)
key (1)
key management (1)
key-value store (1)
kibana (1)
kimi k2.5 (1)
kitten tts (1)
kms (1)
kong (1)
labs (1)
lambda (1)
langchain skills (1)
layer duplication (1)
leader election (1)
leanstral (1)
ledger (1)
legacy (1)
lettuce (1)
lifecycle (1)
linearizability (1)
literate programming (1)
litmuschaos (1)
little's law (1)
llm agent (1)
llm architecture (1)
llm code quality (1)
llm coding (1)
llm emergent abilities (1)
llmops (1)
load balancing (1)
load test (1)
local llm (1)
locale (1)
log analysis (1)
logstash (1)
lru (1)
lsm-tree (1)
lsn (1)
lua (1)
maintainability (1)
maintenance (1)
mamba-3 (1)
manyana (1)
manytomany (1)
manytoone (1)
mat (1)
matrix (1)
maven (1)
memory allocator (1)
merge (1)
merge queue (1)
merge tooling (1)
message queue (1)
mfa bypass (1)
microsoft (1)
microvm (1)
milvus (1)
mirroring (1)
mistral ai (1)
modeling (1)
modularization (1)
mongodb (1)
monolith (1)
monorepo (1)
moonshot ai (1)
motorola (1)
mozilla ai (1)
msa (1)
mtls (1)
multi-agent (1)
multi-database (1)
multi-region (1)
multi-tenant (1)
multiplexing (1)
multitenancy (1)
mvc (1)
mvcc (1)
nacl (1)
nemoclaw (1)
net/http (1)
netty (1)
networking (1)
newsfeed (1)
nio (1)
nlb (1)
non-blocking (1)
nonblocking (1)
normalization (1)
nosql (1)
npm (1)
null safety (1)
nvidia (1)
o(n²) (1)
oauth (1)
object storage (1)
oidc (1)
on-call (1)
on-device ai (1)
onetomany (1)
online ddl (1)
open source (1)
open swe (1)
openapi (1)
openbsd (1)
opencode (1)
opengenerativeui (1)
operational safety (1)
operations (1)
ops (1)
optimizer (1)
organizational velocity (1)
orm (1)
osi 7 layer (1)
outbox (1)
overload (1)
owasp (1)
p99 (1)
pacelc (1)
package design (1)
pact (1)
pagination (1)
panic recovery (1)
partition key (1)
partitioning (1)
patterns (1)
paxos (1)
pel (1)
performance regression (1)
performance tuning (1)
persistence context (1)
pf (1)
pfas (1)
pinecone (1)
pipeline (1)
pkce (1)
pod (1)
policy engine (1)
polyfill (1)
ports and adapters (1)
posse (1)
postgresql jit (1)
posthog (1)
posts (1)
pr risk scoring (1)
practice (1)
preview environment (1)
priority queue (1)
process (1)
productivity (1)
profile (1)
profiling (1)
project nomad (1)
prompt cache (1)
prompt firewall (1)
prompt injection (1)
proofshot (1)
propagation (1)
protobuf (1)
protocol desync (1)
prototype (1)
provenance (1)
pub/sub (1)
publisher (1)
purge pipeline (1)
pypy (1)
python gil (1)
quality (1)
quality gate (1)
quartz (1)
query digest (1)
query methods (1)
query optimization (1)
query parser (1)
query plan (1)
querydsl (1)
queueing (1)
quota (1)
rabbitmq (1)
raft (1)
rag (1)
rate limit (1)
ratelimiter (1)
rds (1)
reactive programming (1)
read replica (1)
read-only (1)
real-time (1)
realtime (1)
rebac (1)
rebase (1)
reconciliation (1)
redis cluster (1)
redisson (1)
redos (1)
redox os no-llm (1)
regex (1)
release engineering (1)
remote cache (1)
repairability (1)
reprocessing (1)
reserved instance (1)
resharding (1)
resolv (1)
resolver (1)
resource server (1)
response (1)
rest docs (1)
restful (1)
revert (1)
review (1)
rls (1)
rocksdb (1)
rolldown (1)
rollingupdate (1)
row level security (1)
rpo (1)
rto (1)
ruff (1)
rust (1)
rust effects (1)
scaling (1)
schema migration (1)
scope functions (1)
scrapling (1)
sdlc (1)
sealed class (1)
secret management (1)
secret rotation (1)
secrets (1)
security group (1)
security headers (1)
server plugins (1)
service (1)
service split (1)
session (1)
session pinning (1)
shadow traffic (1)
shedlock (1)
shift left (1)
sighup (1)
signing (1)
sigstore (1)
simulation (1)
singleflight (1)
singleton (1)
sli (1)
sliding window (1)
slm (1)
slow query (1)
slsa (1)
snapstart (1)
snowflake (1)
soft delete (1)
software design (1)
solid (1)
sops (1)
specification (1)
spot (1)
spring batch (1)
spring cloud (1)
spring cloud config (1)
spring cloud gateway (1)
spring data (1)
spring data jpa (1)
sql parser (1)
sse (1)
ssl (1)
ssm (1)
sso (1)
stack overflow (1)
stateless (1)
storage (1)
storage engine (1)
streaming (1)
string (1)
subnet (1)
subquery (1)
subscriber (1)
supply chain security (1)
swagger (1)
swe-ci (1)
sync (1)
sync.map (1)
sync.pool (1)
sync.rwmutex (1)
tail latency (1)
tcp/ip (1)
tdd (1)
tech debt (1)
telemetry pipeline (1)
temporal (1)
terraform (1)
test (1)
test impact analysis (1)
testcontainers (1)
thread safety (1)
threadpool (1)
timber (1)
timeout budget (1)
timezone (1)
tlab (1)
tls ech (1)
token bucket (1)
tooling (1)
traffic management (1)
transactional outbox (1)
ttl (1)
tuning (1)
tycoon 2fa (1)
typescript (1)
ubuntu (1)
udp (1)
ui verification (1)
unicode (1)
url shortener (1)
usage metering (1)
uv (1)
vacuum (1)
versioning (1)
video editing (1)
virtualization (1)
visualvm (1)
vite 8 (1)
vm sandbox (1)
vpc (1)
vram (1)
vulnerability (1)
waitgroup (1)
walmart (1)
web performance (1)
webclient (1)
webgpu (1)
webhook (1)
webmcp (1)
wfq (1)
wikipedia (1)
window function (1)
windows 11 (1)
workflow (1)
write through (1)
writeheader (1)
xadd (1)
xbox one (1)
xclaim (1)
yaml (1)
zero copy (1)
zig (1)
zipkin (1)
개념 (1)
공간복잡도 (1)
기초 (1)
답변 (1)
데이터베이스 (1)
데이터시스템 (1)
로드맵 (1)
멀티스테이지 (1)
멀티테넌트 (1)
모니터링 (1)
벤치마크 (1)
분산트랜잭션 (1)
비교분석 (1)
빅오 (1)
시간복잡도 (1)
시스템설계 (1)
실전 (1)
아카이브 (1)
아키텍처 (1)
알고리즘 (1)
영속성컨텍스트 (1)
일관성 (1)
자료구조 (1)
전달보장 (1)
정리 (1)
중복처리 (1)
커리큘럼 (1)
쿼리최적화 (1)
튜닝 (1)
트레이드오프 (1)
파일업로드 (1)
페이징 (1)
프레임워크 (1)
프론트엔드 (1)
학습전략 (1)
전체 보기
Posts
Go로 PostgreSQL 프록시 만들기 (35) - Query Digest와 Top-N 쿼리 분석
Go로 PostgreSQL 프록시 만들기 (35) - Query Digest와 Top-N 쿼리 분석
🚀 pgmux
March 13, 2026
⏱ 5분
쿼리를 정규화하여 패턴별 실행 횟수, 평균/P50/P99 레이턴시를 집계하는 Query Digest 기능을 구현한다. pg_stat_statements의 프록시 버전.
Go로 PostgreSQL 프록시 만들기 (36) - Grafana Dashboard 템플릿
Go로 PostgreSQL 프록시 만들기 (36) - Grafana Dashboard 템플릿
🚀 pgmux
March 13, 2026
⏱ 4분
pgmux의 17개 Prometheus 메트릭을 한눈에 볼 수 있는 Grafana 대시보드 템플릿을 만들고, Helm Chart로 자동 배포하는 방법을 다룬다.
Go로 PostgreSQL 프록시 만들기 (37) - PgBouncer 대비 성능 벤치마크 및 최적화
Go로 PostgreSQL 프록시 만들기 (37) - PgBouncer 대비 성능 벤치마크 및 최적화
🚀 pgmux
March 13, 2026
⏱ 3분
pgbench로 Direct DB, pgmux, PgBouncer를 3자 비교하고, hot path 최적화로 SELECT-only 46%→83%로 개선한다.
Go로 PostgreSQL 프록시 만들기 (38) - pprof 기반 최적화와 투명 프록시의 경계
Go로 PostgreSQL 프록시 만들기 (38) - pprof 기반 최적화와 투명 프록시의 경계
🚀 pgmux
March 13, 2026
⏱ 8분
pprof CPU/alloc 프로파일링으로 병목을 찾고, atomic.Pointer·ReadMessageReuse·wire buffer 재사용을 적용한다. 그리고 응답 batching이 왜 '투명한 프록시'의 원칙을 깨는지 분석한다.
Go로 PostgreSQL 프록시 만들기 (39) - DISCARD ALL 최적화와 벤치마크 신뢰성
Go로 PostgreSQL 프록시 만들기 (39) - DISCARD ALL 최적화와 벤치마크 신뢰성
🚀 pgmux
March 13, 2026
⏱ 5분
세션 상태 추적으로 불필요한 DISCARD ALL을 건너뛰고, RouteWithTxState로 lock 횟수를 줄이고, 벤치마크 방법론을 개선한다.
2026 개발 트렌드: DB Branching + Preview Environment가 배포 리스크를 줄이는 방식
2026 개발 트렌드: DB Branching + Preview Environment가 배포 리스크를 줄이는 방식
March 12, 2026
⏱ 4분
코드 PR마다 앱+DB를 함께 검증하는 Preview Environment 운영이 왜 2026년 실무 표준으로 올라오는지, 도입 임계치와 운영 기준을 정리합니다.
Go로 PostgreSQL 프록시 만들기 (21) - Prepared Statement Multiplexing
Go로 PostgreSQL 프록시 만들기 (21) - Prepared Statement Multiplexing
🚀 pgmux
March 12, 2026
⏱ 5분
Transaction Pooling 환경에서 Prepared Statement를 사용할 수 없는 PgBouncer의 한계를 극복하기 위해, Parse/Bind 메시지를 인터셉트하여 Simple Query로 합성하는 Multiplexing 기능을 구현한다.
Go로 PostgreSQL 프록시 만들기 (22) - COPY 프로토콜 교착과 Map 메모리 누수
Go로 PostgreSQL 프록시 만들기 (22) - COPY 프로토콜 교착과 Map 메모리 누수
🚀 pgmux
March 12, 2026
⏱ 4분
pgmux에서 발견된 두 가지 CRITICAL 버그 — COPY 프로토콜 교착(Deadlock)과 Audit Logger의 무한 Map 메모리 누수 — 를 분석하고 수정한다.
Go로 PostgreSQL 프록시 만들기 (23) - 커넥션 풀 오염과 Panic 격리
Go로 PostgreSQL 프록시 만들기 (23) - 커넥션 풀 오염과 Panic 격리
🚀 pgmux
March 12, 2026
⏱ 4분
pgmux에서 발견된 두 가지 CRITICAL 버그 — 에러 시 오염된 커넥션이 풀에 반납되는 Protocol Desync와, 단일 panic이 전체 서버를 크래시시키는 Global Panic Vulnerability — 를 분석하고 수정한다.