Currently ProxySQL is configured with a single user (msandbox) for all traffic. For proper read/write split testing, configure:
msandbox_rw (R_READ_WRITE role) as the proxy user for write hostgroup (HG 0)msandbox_ro (R_READ_ONLY role) as the proxy user for read hostgroup (HG 1)
These users already exist in the MySQL sandbox grants (grants8x.gotxt creates them). They just need to be added to ProxySQL's mysql_users config with the correct default_hostgroup.
Currently ProxySQL is configured with a single user (
msandbox) for all traffic. For proper read/write split testing, configure:msandbox_rw(R_READ_WRITE role) as the proxy user for write hostgroup (HG 0)msandbox_ro(R_READ_ONLY role) as the proxy user for read hostgroup (HG 1)These users already exist in the MySQL sandbox grants (grants8x.gotxt creates them). They just need to be added to ProxySQL's
mysql_usersconfig with the correctdefault_hostgroup.