Traffic for Master/Slave

Hi!

How much traffic does a master/slave configuration produce beyond
the inserted/updated data?

As to say: How much "meta"-traffic is to be expected?

It's a very small database with around 20 tables, each around
5 - 10 fields, evenly spread varchars and numerics.

There are about 10 inserts and 50 updates a day.

--
Marco Dieckhoff
icq# 22243433
GPG Key 0x1A6C95BA -- http://www.frankonia-brunonia.de/keys

>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. If, for example,
you increment a field in *EVERY* row, it sends the query (which is
likely much smaller), not a copy of every row.

>As to say: How much "meta"-traffic is to be expected?

There's the usual TCP overhead. And the slave does have to log in
on the master.

>It's a very small database with around 20 tables, each around
>5 - 10 fields, evenly spread varchars and numerics.
>
>There are about 10 inserts and 50 updates a day.

It sounds like you are dealing with traffic that could easily be
handled over a 300 bps (that is, really ancient and very slow)
modem. At about 100 characters per query, and double it for overhead,
that's about 1.1 bits per second (not bytes, not kilobits, not
megabits, just *bits*). It sounds like this could easily be handled
with carrier pigeons or mailed floppy disks.

Gordon L. Burditt

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

"Marco Dieckhoff" <dieck@gmx.de> schreef in bericht
news:n59s13-6p6.ln1@hamlet.frbr.etc.tu-bs.de...
> Hi!
>
> How much traffic does a master/slave configuration produce beyond
> the inserted/updated data?
>
> As to say: How much "meta"-traffic is to be expected?
>
> It's a very small database with around 20 tables, each around
> 5 - 10 fields, evenly spread varchars and numerics.
>
> There are about 10 inserts and 50 updates a day.
>
> --
> Marco Dieckhoff
> icq# 22243433
> GPG Key 0x1A6C95BA -- http://www.frankonia-brunonia.de/keys