Phase 1: Partition the 6 biggest CI/CD database tables
1. Create partitioned schemas for all 6 database tables. 1. Design a way to cascade partition_id to all partitioned resources. 1. Implement initial query analyzers validating that we target routing tables. 1. Attach zero partitions to the partitioned database tables. 1. Update the application to target routing tables and partitioned tables. 1. Manually create second partitions and start to use them. 1. Measure the performance and efficiency of this solution.
epic