why use mixed-based replication for mysql

Posted by Alistair Prestidge on Server Fault See other posts from Server Fault or by Alistair Prestidge
Published on 2010-06-15T15:31:28Z Indexed on 2010/06/15 15:33 UTC
Read the original article Hit count: 269

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

© Server Fault or respective owner

Related posts about mysql

Related posts about replication