Project

General

Profile

Actions

Feature #1091

open

[infra] Research supabase realtime scaling

Added by Phước Ngọc Trần 10 days ago. Updated 10 days ago.

Status:
Resolved - Dev
Priority:
Normal
Category:
-
Start date:
09/07/2024
Due date:
09/09/2024 (11 days late)
% Done:

100%

Estimated time:
5:00 h
Spent time:

Description

- Sử dụng Docker Swarm để scaling Database và Realtime
Đã research và document tại đây
https://github.com/ChatGPT-AINNATE/infra-kubernetes/tree/develop/supabase

Đã setup test trên domain:
- https://realtime-test.ttsopenai.com
- https://supabase-traefik-test.ttsopenai.com/dashboard/

Actions #1

Updated by Phước Ngọc Trần 10 days ago

Future architecture

Master swarm:
1 Traefik (Load balancer)
1 Kong
1 PostgREST Writer
1 DB Writer
1 Realtime

Master swarm
1 Traefik (Load balancer)
1 Kong
1 PostgREST Reader
1 DB Replica
1 Realtime

Worker swarm
1 Kong
1 PostgREST Reader
1 DB Replica
1 Realtime

=> 1 Database Endpoint Writer (use for backend)
- 1 Realtime Endpoint (use for client)
=> 1 Database Endpoint Reader (use for client)
- 1 Realtime Endpoint (use for client)

Actions #2

Updated by Phước Ngọc Trần 10 days ago

  • % Done changed from 10 to 100
Actions #3

Updated by Phước Ngọc Trần 10 days ago

  • Status changed from In Progress to Resolved - Dev
Actions

Also available in: Atom PDF