Dynamic ProxySQL Query Rules - Shopify

What this post added

Introduced a tool for dynamically managing ProxySQL query rules across thousands of instances. Implemented a dry-run mode for query rules by leveraging the `active` and `log` fields in ProxySQL's `mysql_query_rules` table, allowing for safe previewing of rule effects. Developed a sidecar container that polls a key-value store for rule changes and applies them to ProxySQL, ensuring scalability and reducing manual effort during incidents. Incorporated exponential backoff for logging to prevent performance degradation from overly broad regex patterns.