Transparen Corporation can assist teams of system administrators in implementing high availability systems using MySQL replication. The most popular replication style in MySQL is the log-shipping enabled through binlogs, but MySQL is also capable of row-based replication and mixed modes of replication.
Each style of replication has advantages and disadvantages. For instance, row-based replication can create large log files if updates touch many rows. On the other hand statement-based replication can require more CPU power from the secondary server than may be available.
Advantages of Statement-Based Replication
More concise. Less bandwidth required - sometimes the bandwidth between servers can be an issue in high performance networks.
Advantages of Row-Based Replication
More thorough. More exact. For instance, time-stamps are replicated exactly, versus being shifted slightly by a replication process.
