4 ms·
this should work in a mixed setup, remember replication in MySQL is pretty much a replay of SQL statements.
by blantonl 14y ago
this should work in a mixed setup, remember replication in MySQL is pretty much a replay of SQL statements.
- toast0 14y agoI don't know how mixed mode decides to use row or query based for a given query; but if it chose query based, the queries would work, but you wouldn't be resynchronized. (In query based mode, I've done resynchs by iterating over each row, and setting a not super important column to a different value, and then back, including values for all the columns that need to be resynchronized. It's a lot more queries, but it's also easier to rate limit if your tables are big enough that doing it in two queries is going to back everything up)