Ubicloud Infrastructure Platform

1 Summary

Ubicloud provides PostgreSQL database hosting and cloud infrastructure services supporting ethicic-public data imports and Garden database operations. Currently in phaseout process as database services migrate to alternative cloud providers.

2 ⚠️ Legacy System Status

Phase-out Timeline: In progress Migration Target: Alternative PostgreSQL hosting platform Critical Dependencies: Garden database (dewey-db), ethicic-public imports Operational Impact: Limited new feature development, focus on stability

3 Support Channels

4 Current Infrastructure

4.1 Database Services

  • Garden Database: dewey-db.pgp92x5xnqyj7q1kkftgc93crz.postgres.ubicloud.com
    • Client portfolio data, investment records, operational analytics
    • Critical dependency for Garden application functionality
  • Ethicic-Public Imports: Data processing and content import workflows
    • Blog content import and processing pipelines
    • Content synchronization between systems

4.2 Technical Implementation

  • Platform: Managed PostgreSQL instances with automated backups
  • Access Control: SSL-enforced connections with certificate authentication
  • Monitoring: Built-in performance monitoring and alerting
  • Scaling: Managed scaling for database performance optimization
  • Backup Strategy: Automated daily backups with point-in-time recovery

5 Migration Planning

5.1 Critical Data Assessment

  • Garden Database Size: Estimate complete database size for migration planning
  • Query Patterns: Document current query performance and optimization requirements
  • Integration Points: Catalog all applications and services dependent on Ubicloud databases
  • Backup Validation: Regular verification of backup completeness and restoration procedures

5.2 Migration Strategy

  1. Alternative Provider Selection: Evaluate replacement PostgreSQL hosting options
  2. Migration Tool Preparation: Set up database migration tools and procedures
  3. Parallel Environment: Establish target environment for migration testing
  4. Data Synchronization: Implement real-time sync during transition period
  5. Cutover Planning: Coordinated switchover with minimal downtime

5.3 Risk Mitigation

  • Backup Frequency: Increased backup frequency during transition planning
  • Performance Monitoring: Enhanced monitoring to detect degradation during phaseout
  • Connection String Management: Centralized configuration for easy migration switchover
  • Rollback Procedures: Complete rollback plan in case migration issues occur

6 Current Operational Dependencies

6.1 Garden Application

  • Database Connection: Primary data store for Garden application functionality
  • Performance Requirements: Query response times critical for application performance
  • Data Integrity: ACID compliance required for financial data accuracy
  • Backup Recovery: Point-in-time recovery capability for data protection

6.2 Ethicic-Public Integration

  • Import Processes: Data import workflows for content management
  • Content Processing: Database-driven content transformation and publishing
  • Analytics: Performance data and content analytics storage

7 Phaseout Operational Procedures

7.1 Maintenance Mode

  • Configuration Freeze: No major configuration changes during phaseout period
  • Performance Optimization: Focus on stability rather than performance tuning
  • Monitoring: Maintain full monitoring with migration-focused alerting
  • Documentation: Complete documentation of current configuration for migration

7.2 Service Level Adjustments

  • Response Time: Standard response with migration timeline consideration
  • Feature Requests: No new feature implementation, essential fixes only
  • Capacity Planning: Maintain current capacity without expansion
  • Investment: Minimal investment in Ubicloud-specific optimizations

8 Emergency Response During Phaseout

8.1 Database Outage

  • Immediate Response: Standard incident response procedures
  • Recovery Priority: Focus on fastest restoration method available
  • Migration Consideration: Evaluate if outage accelerates migration timeline
  • Stakeholder Communication: Include migration status in incident communications

8.2 Data Corruption

  • Backup Restoration: Immediate restoration from most recent valid backup
  • Data Validation: Complete validation of restored data integrity
  • Migration Impact: Assess if corruption affects migration planning
  • Root Cause Analysis: Investigation with consideration for service transition

9 Migration Support Resources

9.1 Database Migration Tools

  • pg_dump/pg_restore: Standard PostgreSQL backup and restoration utilities
  • Database Replication: Streaming replication for minimal downtime migration
  • Migration Validation: Data consistency verification between source and target
  • Performance Testing: Query performance validation on target platform

9.2 Monitoring During Migration

  • Connection Monitoring: Track database connections during transition
  • Performance Baseline: Establish performance baselines for comparison
  • Error Rate Tracking: Monitor application error rates during migration
  • Rollback Metrics: Define success/failure criteria for migration completion

11 Post-Migration Cleanup

  • Service Termination: Formal service cancellation procedures
  • Data Destruction: Secure deletion of data from Ubicloud infrastructure
  • Configuration Cleanup: Remove Ubicloud-specific configurations from applications
  • Documentation Updates: Update all references to reflect new infrastructure
Owner: Ops: Infrastructure
Last reviewed: 2025-09-24
SLA: N/A
Controls: ?invalid meta type:ops_controls
Commit: 8f0c18729ae96125ef5caf6824600a75c4928c16