We need a High-availability-InnoDB-mysql-cluster-with-load-balancing proxy and a heartbeat
Structure will be 3 or 5 servers.
All servers sill have heartbeat, proxy and SQL on them for redundancy.
The database will be acessable from a single WAN IP
3x MySQL server one router R/W, R/O, R/O
or 4x MySQL one router R/W, R/W, R/O, R/O
Or more complex with 2 routers for failover
Hoster will be hetzner so we ill be able to do WAN, LAN and Floating IP as required
5 freelancer đang chào giá trung bình $10/giờ cho công việc này
Hi, I am a Linux expert and I can do this using proxysql. It will take around 100 hours please get in touch to discuss it further in chat. Thankyou Antima Mishra