why use mixed-based replication for mysql
Does any one use mixed?
I bet many people have used Mixed-mode replication, since this was the default for a long time according to the MySQL Reference Manual:
From MySQL 5.1.12 to MySQL 5.1.28, mixed format is the default. Beginning with MySQL 5.1.29, statement-based format is the default.
The MySQL Performance Blog talks about different problems with the different replication methods.
So, it seems that MySQL has been trying to switch between mixed-mode, statement-based and row-based replication within the 5.1.x series, and that is unnerving.
I'm currently reading High Performance MySQL, Second Edition from O'Reilly. It has a great chapter on replication, and is well worth the read. Many of my questions have been answered with an hour of reading. You can read some of the chapter in Chapter 8. Replication > Replication Under the Hood - Pg. 357:
Because neither format is perfect for every situation, MySQL 5.1 switches between statement-based and row-based replication dynamically. By default, it uses statement-based replication, but when it detects an event that cannot be replicated correctly with a statement, it switches to row-based replication. You can also control the format as needed by setting the binlog_format session variable.