Not the answer you need?
Register and ask your own question!

when PXC 8.0.19 is working with latest ProxySQL V2.x, how proxySQL distribute the workload

DBA100DBA100 Current User Role Patron
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 ?

Answers

  • matthewbmatthewb Senior [email protected] Percona Staff Role

    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.

  • DBA100DBA100 Current User Role Patron

    "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 ?

  • matthewbmatthewb Senior [email protected] Percona Staff Role

    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 ?

    https://proxysql.com/documentation/

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.