Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Replicate only specific databases (on replica) CHANGE REPLICATION FILTER REPLICATE_DO_DB = (orders, inventory); -- Ignore specific tables CHANGE REPLICATION FILTER REPLICATE_IGNORE_TABLE = (mydb.sessions, mydb.logs); -- my.cnf alternatives: -- replicate-do-db = mydb -- replicate-ignore-table = mydb.cache_entries -- View current filters SELECT * FROM performance_schema.replication_applier_filters;
Result
Open