When we first started capturing realtime analytics data for Kernl it was a simple affair: 1 table N columns (id, date, product_uuid, domain, product_version, php_version,….) This worked well for the first few weeks, but eventually we started to see serious performance degradation as the table size grew. The first step we took was to normalize… Continue reading Migrating Kernl Analytics from Batch-Driven to Realtime
Category: Typescript
Building & Scaling Kernl Analytics
Over the past 3 years I’ve often received requests from new and existing Kernl customers for some form of analytics on their plugin/theme. I avoided doing this for a long time because I wasn’t sure that I could do so economically at the scale Kernl operates at, but I eventually decided to give Kernl Analytics… Continue reading Building & Scaling Kernl Analytics