If my MySQL master has heavy writes, my read replicas will in-turn gets bogged down by the replication logs & executing them. Then could it serve the reads?
Assume MYSQL master is executing at 100% CPU and disk utilization, now these needs to be executed in the read replicas too. So in turn read replicas would also incur 100% CPU and disk utilization. Then how could it serve the read requests?
Note: Assume the MYSQL master write is just updating a field Ex: UPDATE where ID = <>. No more complex queries so there is no possibility of optimizing in read replicas too.