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
Hi,
I have experience in InnoDB-mysql-cluster-with-load-balancing proxy and a heartbeat.I will configure load balancer with 3 and 5 nodes of MYSL server so that site will be up and give maximum time response.
Thank you
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