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 = 2
#replicate-do-db=asterisk
replicate-do-table=asterisk.test_area_price
replicate-do-table=asterisk.non_area
replicate-rewrite-db=masterdb >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.
