Mysql replication Ignore specific table



  • 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.



    • 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.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2