I didn't know how to describe it so I am calling it semi circle. Here's what I am doing.
Server B = This is slave of Server A
Server C = This is slave of Server B
When I update something on Server A then it is reflected on Server B. But the same change is not reflected on Server C.
Only when I update something on Server B then change is reflected on Server C.
How do I make it so any changes done on Server A will come to Server B (which is already working) and then it goes to Server C?
Upon investigation I found out that when I make some change on Server A then its log file position changes. But when those changes are reflected on Server B then Server B log file position doesn't change. It is because of this reason Server C doesn't know if there has been any change on Server B unless I explicitly change something (insert,update,delete) on Server B.
So is there a way to tell MySQL to increment log file position when Slave is receiving updates from Master?