we are trying to setup mysql server with below configurations.
3 mysql pods with sharing same persistence volume and data should be available across all pods and any pods can execute read and write requests and a load balancer to route the traffic to different pods based on load.
Hope service will take care to route the traffic.
I tried master and salve method here master is only suitable for write and slave for read.
Can anyone explain which method is suitable to suite my requirements.