hi,
when PXC 8.0.19 is working with latest ProxySQL V2.x, how proxySQL distribute the SQL query request between PXC nodes?
load balancing by default ? round robin ? anyway to control this behavior ?
ProxySQL must be configured before you can use it. Nothing is automatic. You need to configure ProxySQL with your hosts, users, and you need to set up query rules to route queries.
“and you need to set up query rules to route queries.”
query rules is the ONLY configuration for it?
it just say for read only operation we go those nodes and for write we go to other nodes, but how about the access pattern of a hostgroup for read only for example?
they are not going to read in PARALLEL but just round robin?
will proxySQL configure with multi write master and write to many nodes at the SAME time ? it is not safe however for ACID !
BTW, what is the way to tune ProxySQL for PXC ? any URL for me to read ?
query rules is the ONLY configuration for it?
No. You must configure servers, hostgroups, and users in addition to query rules.
Yes, round robin behavior based on WEIGHT.
will proxySQL configure with multi write master
The default is single-writer mode.
it is not safe however for ACID !
Yes, multi-node writers are 100% ACID safe. You need to learn more about what PXC is and how it works internally. You also need to learn more about how InnoDB works.
BTW, what is the way to tune ProxySQL for PXC ? any URL for me to read ?