Mysql replication Ignore specific table

Question

I want to exclude some table for replication in slave db. How i can do it. what steps needs to be implement on master server or slave server?
I dont want anymore some tables in slave server. is there any way to add wild card in my.cnf file or any query which i have to use to stop it.

Answer 1

• On Primary: binlog_... prevents sending updates for specified databases to Replicas.
• On Replica: replicate_ignore_table_... ignores updates for specified tables
• The tables that are already on the Replica are not DROPped; you must do that manually (on the Replica).

The settings changes should go into my.cnf; such changes won't take effect until you restart the server.