I am doing a production, high-availability deployment of Magento (ecommerce backend), Vuestorefront (Headless frontend) and Strapi (headless CMS), which includes the deployment of software such as Postgresql, MySQL, Redis, RabbitMQ, Elasticsearch, in addition to the apps themselves. I am familiar with the use of virtual IP, HAProxy open source, keepalived, VRRP to set up a HA, failover active/ passive setup. What I am not familiar with is using the same group of open source software to deploy an active/ active setup.

I know HAProxy Enterprise supports active / active. I’ve done some searching but haven’t found significant documentation on using HAProxy community or other open source software to set up active/ active. The goal is, if possible, to use e.g. the 2 standbys in a 3 node cluster as read replicas so they can help balance the load. Question, is it doable with only open source software? Can anyone point me to resources that can help me understand the set up?

Thanks.