Re: Use Case: Distribute INSERTS/UPDATES to several masters

[Thamabara Basavaiah]

Hi Jan,
The idea is actually good.But if one master goes down how do you figure out which bin log file and position to set on all the slaves.If we have same configuration for
both the masters will the binlog files will exactly be same?If that is the case then
no wories the down time will be not even 10 mins.

Hi Patric,
The option you gave will have some pitfalls.Consider suppose two transactions are happening t1 and t2,t1 is sent to M1 ,t2 is sent to M2(which is master to the slaves).The moment after proxy sent the queries M2 crashed without executing the t2.proxy doesn't know anything,but t2 update is gone.In your case also downtime will
be there.The only thing is if M1 fails,then there will not be any down time but this is not our requirement.The purpose of M1 itself is backup for M2.


Thanks
Basu