Hello Artem,
thanks for your answer.
For selective replication I would check startup options --replicate-do-* and --replicate-wild-*.I'm using replicate-do-db on the client but the problem is, that the master sends the sql-statements of ALL databases to the repl-client and the replicate-do-db-command only tells the client which sql-statements it should carry out and which statements it should drop without notice. In the actual case only 5% of the traffic is caused by the database which needs to be replicated so we would have to pay for 95% useless traffic if we wouldn't use daisy-chain Replication to filter the traffic.
.
Also you may need log-slave-update option on if you have daisy-chain replication.I'm using this option too but it seems to have no effect doing a "load table ... from master".
Greetings from Germany
Lutz
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
