How to skip table data for replication in MySQL?
Create a database.  Add binlog_ignore_database on the master to avoid even sending the data out (as opposed to sending it, then tossing on the slave, as with replicate_ignore_*)

Put all your not-to-be-replicated tables in that database.  Reference them via dbname.tblname.

Be aware of how replication filters:  In SBR, USE controls what to check for do/ignore filters.

There's a trick I did quite successfully:


Setup: RBR, extra db, binlog_ignore_db (as above)
Create tables in that db and load data into them
Processed those tables (only on the Master) -- normalization, cleansing, updating Summary Tables, etc
INSERT stuff from that db into replicated tables (in other dbs). -- This is the only step that was replicated.
And drop the tables in the ignored db.


The net effect was to do a lot of ETL stuff only on the Master, yet still get the end results onto the Slave.