MySQL Performance Blog - Wed, 07/11/2007 - 12:40pm
To get this straight - I’m not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) - there is enough gotchas with replication itself and getting things right with filtering can get quite bumpy road. In some applications however it is very helpful so lets see what one should do or should not do to make it work.
Experience shared here mainly applies to logical level replication. MySQL 5.1 can use row level replication which elevates some of these issues but I guess it will still take some time before it becomes massively used.