search

NASA-PDS / planetary-data-cloud

PDS Cloud Migration documentation, issue, tracking and simple tools for assisting in the PDS hybrid cloud study and migration efforts.
Apache License 2.0
0 stars 0 forks source link

Costing for Small Bodies - PostgreSQL Architecture in MCP #96

Open sjoshi-jpl opened 6 months ago

sjoshi-jpl commented 6 months ago

💡 Description

Option 1: Cost high-availability PostgresSQL DB option (260 GB right now): https://docs.aws.amazon.com/prescriptive-guidance/latest/saas-multitenant-managed-postgresql/availability.html

Option 2: ◦ Sync secondary DB using logical replication. ◦ Develop new logical replication replicator app to export/import the appropriate subscriber states

Clients connecting into primary : ~20 clients Download (Egress) : 500GB / month Logical replication

Basic design : On-prem primary node --> Route53 failover into Cloud --> Multi AZDB PostgresSQL setup with logical replication

⚔️ Parent Epic / Related Tickets

No response