- managed MySQL/MariaDB in solo and cluster configurations, played with Percona back in the day
- have my own Postgres and MariaDB distributions source-compiled for x86v3
What I did
- Designed and developed a system for tracking visits, clicks and leads for affiliate programs
- Zero-effort integration: any e-commerce site could gain affiliate functionality with a couple of hooks
What I achieved
- Besides project completion, I made an algorithm that coarsens data depending on the server load
- The bigger your site is, the coarser the data (up to a limit), so response time and resource consumption stayed near-constant
- We successfully processed statistics with mixed precision after collection
- Data scientists probably do it every day now, but in the early 2010s they hadn’t been invented yet
- The idea was inspired by time dilation in EVE Online
What I learned
- How to respond fast
- Data structures are not holy artifacts
- Dirty data is better than no data at all