From: Date: October 30 2006 11:08am Subject: RE: relay log one table List-Archive: http://lists.mysql.com/replication/606 Message-Id: <66EB4C0B3B4C93478593701A9AEC12EF01E53B43@euexch01.EU.PHOTOMASK.COM> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hi, No it is not a bug. Since the Master server never knows what the slave wants it always transmits everything. The slave then decides if it will execute the statement or not (depending on the setup).=20 If you want to reduce the traffic costs you can either do it with a scheduler calling LOAD TABLE FROM MASTER (http://dev.mysql.com/doc/refman/4.1/en/load-table-from-master.html). This will only load the data from the specified table. Or you can upgrade your servers to 5.1 (once it becomes past the Beta stage). In the new version MySQL changed the replication format from simple statement based replication to row based replication. This should reduce the traffic quite a bit. Peter -----Original Message----- From: sekes [mailto:gexlie@stripped]=20 Sent: Montag, 30. Oktober 2006 10:51 To: replication@stripped Subject: relay log one table i have two hosts with mysql 4.1.21 on different machines. i have a task to replicate two tables from the master's database called 'masterdb' which consists of several tens of tables. so i configured master and slave servers according to Mysql Documentation. i've set the following options to my.cnf on slave: server-id =3D 2 #replicate-do-db=3Dasterisk replicate-do-table=3Dasterisk.test_area_price replicate-do-table=3Dasterisk.non_area replicate-rewrite-db=3Dmasterdb >asterisk everything just works fine. these two tables is replicating as i wish. but several days before i examined slave-relay-bin.XXXXXX on my slave server and i have found that the slave server made requests to all statements in whole database 'masterdb' from master server even on that tables which i do not want to be replicated. every request on every table from master database was downloaded by the slave to its relay-bin-log. is it bug? here i have very high costs of traffic between these two machines. so its very expensive to download all database-requests and statements from master-server to slave I/O thread and slave relay-bin-log. So i need to find some options which i can pass to the slave server to download only that requests which are relate to my replicated tables. is it possible? thanks in advance.