Low Cost Transactional and Analytics With MySQL and Clickhouse, Have Your Cake and Eat It Too!

Would you like MySQL Protocol Compatibility and near real time dashboard analytics with that? We are hoarding data in the hopes of making meaningful information out of them to make smart business decisions. But we also resort to inflating costs just to satisfy this need (or not). While there have been a number of open source roll your own options, it has been also operationally costly and sometimes stressful to maintain, not to mention the shortcomings of each. If you have been traditionally storing your data with MySQL and have been enduring running your queries from the same set of servers, fret no more – Clickhouse might just be what you need. In this presentation, we will discuss how to deploy, design, and maintain a Clickhouse analytics platform that continuously reads data from your MySQL servers in near real-time*. * Depends if you have transformations or complex schema.