ProxySql with mysql replication slave

Is it possible to redirect some heavy “reads” on mysql replica by proxysql, also is it possible to monitor slave status/replica lag by proxy sql?
General architecture : 3 mysql nodes + 1 mysql replication slave+ 2 proxysql nodes.
In mysql_servers table already added 3 mysql nodes but how about replication slave node ?

Hello, yes it is possible. Check out this topic for more info How to split reads/writes with ProxySQL

1 Like