|
|
MySQL 5.1 introduces row based replication, a way of replicating data that fixes many inconsistencies of the statement based replication, the standard method used by MySQL so far. |
The good: row based replication solves some problems when
replicating the result of non deterministic functions, such as
UUID() or NOW().
The bad: row-based replication may break existing
applications, where you count on the quirks of statement based
replication to execute conditionally (updates base on
@@server_id, for example), and may perform badly on
updates applied to very large tables.
…