gordonb.7utfk@burditt.org (Gordon Burditt) wrote:
>>How much traffic does a master/slave configuration produce beyond
>>the inserted/updated data?
>
> Essentially, it seems to be the queries that changed something
> sent from the master to the slave. The size of the binary
> logs on the master is a good indication of this.

In fact the content of the binary log is exactly what's going over
the wire (modulo compressed/tunneled connection).

You can look at the contents of the binary log with the mysqlbinlog
utility. In it's output it shows the corresponding binlog position of
each log entry. So you can estimate the overhead yourself.


XL