So I'm currently testing a new DB topology before moving it into a production environment, and I've run into a rather odd problem. The current setup is as follows: 5 server instances. 2 are MySQL DBs in Master/Master . 2 are slaves that point to a virtual IP(VIP), which currently points to one of those masters. The 5th server is load balancing between the slaves using MySQL proxy.
So the idea is to have all reads done on the slaves, and all writes occur on the Master. Everything is working almost fine - anything wrote to the Master that the VIP is pointing to is propagated to the slaves, and the Masters are mirroring each other.
The problem is that when I write to the Master that is NOT currently pointed to by the VIP, it propagates over to the other Master, but that change is not propagated over to the slaves.
I know that this is a convoluted problem/question. If anyone has any ideas I would certainly appreciate a point in the right direction.