There are scenarios where we have to provide the high ability to MySQL database instances and we use the Master and Slave replication method of MySQL database.
In the same case to segregate the Read and Write database traffic. We widly use HA- Proxy. It is a feature rich open source Load blancing tool with many unique features like reverse proxy but in out case we are going to use it only for Hight aviliblity purpose.
root@haproxy01:~# haproxy -v
HA-Proxy version 2.0.13-2ubuntu0.3 2021/08/27 - https://haproxy.org/
How to Install it?
You simply use yum or apt commands to install it
sudo apt install -y haproxy