Canva’s mission is to make design accessible to everyone. The Canva Creators program has seen doubled usage in the past three years, leading to billions of content usages each month that require payment to creators. The challenge lies in accurately tracking this data while ensuring scalability and operability. By moving from OLTP to OLAP databases and implementing an ELT pipeline, Canva has improved accuracy, scalability, and operability. The new architecture has reduced incidents, simplified the codebase, and improved troubleshooting and recovery. The journey to this solution involved learning important lessons about simplicity, scalability, and observation from day one.
https://www.canva.dev/blog/engineering/scaling-to-count-billions/