In this blog post, we’ll look at how ProxySQL and mirroring go
Let me be clear: I love ProxySQL, and I think it is a great
component for expanding architecture flexibility and high
availability. But not all that shines is gold! In this post,
I want to correctly set some expectations, and avoid selling
carbon for gold (carbon has it’s own uses, while gold has
First of all, we need to cover the basics of how ProxySQL
manages traffic dispatch (I don’t want to call it
mirroring, and I’ll explain further below).
ProxySQL receives a connection from the application, and through
it we can have a simple SELECT or a more complex transaction.
ProxySQL gets each query, passes them to the Query Processor,
processes them, identifies if a query is mirrored, duplicates the
whole MySQL session ProxySQL internal object and associates it to
a mirror queue (which refer to a …[Read more]