Role in the Platform
MySQL 8 stores all persistent platform data: instrument master, watchlists, trade history, configuration, and audit logs. AWS RDS provides managed backups, Multi-AZ failover, and automated patching.
Implementation Highlights
Normalized schema for instruments and trades
Stored procedures for complex calculations
JSON columns for flexible configuration storage
Automated daily backups via AWS RDS
Read replicas for analytics workloads
Platform Components
ccl-sql - Schema definitions and migrations
All services - Instrument lookups, trade logging
ccl_ui - User sessions, watchlist storage
ccl_rms - Risk configuration parameters