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 r…

ProxySql with mysql replication slave

Ivan_Groenewold November 8, 2022, 4:00pm 2

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

Topic		Replies	Views
Mysql Replication with write forwarding? Other MySQL® Questions	3	727	November 27, 2007
Mysql replication read / write splitting: Mysql proxy or in software? Other MySQL® Questions	1	735	October 26, 2008
How to split reads/writes with ProxySQL Percona Operator for MySQL mysql , percona	6	3704	May 6, 2022
ProxySQL Setting rules to filter to some certain selects MySQL & MariaDB	1	636	October 28, 2022
ProxySQL: fire & forget slaves Other Tools	5	1966	December 2, 2018