Originally Posted by YbeddyJ
my Question is, Is it posible to exclude a particular table from the replication effort?
Yes, you can:
in my.cnf on slave server you put
replicate-ignore-table = dbname.tablename
This is very useful and often ignored. If you have logging table which you only do writes to but never read from, there is no real point to replicate that table to slave(s). This way you ignore specific tables.
Second option is to use wildcards:
And here are some more tips:
replicate-do-db = dbname (or) replicate-do-db = dbname1, dbname2, Ö, dbnameN
This option is used on slave server to tell the server to only replicate dbname db on this particular host. You would want to use this if you have a master which is replicating to multiple slaves and each slave may contain different database for read performance reasons.
replicate-do-table = dbname.tablename
This specifies a table from a database to be replicated.
Letís say you have database with multiple type of open source installations (phpbb, wordpress, drupal, etc), and you want to designate slave(s) to only be used for phpbb, you would do: