why use mixed-based replication for mysql
- by Alistair Prestidge
I am in the process of configuring MySQL replication and am intending to use row-based-replication but I was also reading up about mixed-based replication.
This is where statement-based is the default and then for certain circumstances (http://dev.mysql.com/doc/refman/5.1/en/binary-log-mixed.html) MySQL will switch to row-based.
The list is quit vast on when it will switch to row-based.
My questions are:
Does any one use mixed?
If yes why did you chose this over just using one or the other?
Thanks in advance