How to setup Keepalived HA for MySQL cluster?

Question

PHP

Introductory: 1. Three servers
with MySQL (Percona XtraDB Cluster) Ubuntu 12.04 2. IP
addresses 10.10.1.121-123 and balancer
.120 IP .120 and ports 3307 and 3308 3307 refers to the entire real_server pool 3306, DR routing (lb_kind) 3308 refers only to the current node on 3306, NAT routing Connection to .120:3308 works fine, local MySQL always answers when moving .120:3307 does not work (falls off by timeout). Judging by tcpdump port 3306, the packets go normally, but the processing server does not accept them (MySQL responses come from the src ip of the node)



The real question is what can be done?

Answer 1

Problem solved.
The solution came from the side of the manual and consisted in the fact that with DR on IPVS you cannot map ports.
A little later there will be a manual for assembling such a config.

Answer 2

Set up query splitting via mysqlproxy