Professional Web Applications Themes

Traffic for Master/Slave - MySQL

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 -- [url]http://www.frankonia-brunonia.de/keys[/url]...

  1. #1

    Default 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 -- [url]http://www.frankonia-brunonia.de/keys[/url]
    Marco Dieckhoff Guest

  2. #2

    Default Re: Traffic for Master/Slave

    >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
    Gordon Burditt Guest

  3. #3

    Default Re: Traffic for Master/Slave

    [email]gordonb.7utfkburditt.org[/email] (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
    Axel Schwenke Guest

  4. #4

    Default Re: Traffic for Master/Slave


    "Marco Dieckhoff" <dieckgmx.de> schreef in bericht
    news:n59s13-6p6.ln1hamlet.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 -- [url]http://www.frankonia-brunonia.de/keys[/url]

    nico rijsmus Guest

Similar Threads

  1. #39052 [NEW]: pdo::query with "show slave/master status"
    By xing at mac dot com in forum PHP Bugs
    Replies: 4
    Last Post: October 6th, 12:21 PM
  2. Replies: 0
    Last Post: October 5th, 07:36 PM
  3. Linking to pages that are based on a master flows text to master?
    By William_Brownville@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 8
    Last Post: August 23rd, 03:53 PM
  4. slave buttons that refer to master button actions
    By conspiracytheorist in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: February 17th, 09:42 PM
  5. HELP! WINXP PRO, Converting slave to master Drive
    By sqr in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 18th, 03:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139