Proxysql mirrors queries in-order or out of order ?

[TUSHAR SINHA]

Hello Proxysql Community members,

I want to know if the order of the queries mirrored to the mirror hostgroup while using proxysql mirroring feature is preserved or not ? 

I found an old percona blog from 2017 which states that the order of the queries is not preserved.

I couldn't find anything regarding this in the proxysql documentation.

Looking forward to help from proxysql community on this.

Regards

Tushar

[René Cannaò]

Hi Tushar,

The order is not preserved.

To preserve the order, queries must be serialized in the way they are ordered in the backend .

ProxySQL cannot know how in which order they are executed in the backend.

Thus, to ensure that nobody would even try to use ProxySQL mirroring as an alternative to replication (because it cannot work!) , not only the order is not preserved: the order in which queries are executed is chosen randomly.

Thanks,

René

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/ec3cf9c6-57b2-4e68-8293-83ebce90251en%40googlegroups.com.