The filtered replicator plugin, named filtered_replicator, filters replication events based on schema name or table name. Regular expressions can be used for the schema and table names.
To load this plugin, start drizzled with:
--plugin-add=filtered_replicator
Loading the plugin may not enable or configure it. See the plugin’s Configuration and Variables.
See also
Plugin Options for more information about adding and removing plugins.
These command line options configure the plugin when drizzled is started. See Command Line Options for more information about specifying command line options.
Default : | |
---|---|
Variable : | filtered_replicator_filteredschemas |
Comma-separated list of schemas to exclude from replication.
Default : | |
---|---|
Variable : | filtered_replicator_filteredtables |
Comma-separated list of tables to exclude from replication.
Default : | |
---|---|
Variable : | filtered_replicator_schemaregex |
Regular expression to apply to schemas to exclude from replication.
Default : | |
---|---|
Variable : | filtered_replicator_tableregex |
Regular expression to apply to tables to exclude from replication.
These variables show the running configuration of the plugin. See variables for more information about querying and setting variables.
filtered_replicator_filteredschemas
Scope: Global Dynamic: No Option: --filtered-replicator.filteredschemas Comma-separated list of schemas to exclude from replication.
filtered_replicator_filteredtables
Scope: Global Dynamic: No Option: --filtered-replicator.filteredtables Comma-separated list of tables to exclude from replication.
filtered_replicator_schemaregex
Scope: Global Dynamic: No Option: --filtered-replicator.schemaregex Regular expression to apply to schemas to exclude from replication.
filtered_replicator_tableregex
Scope: Global Dynamic: No Option: --filtered-replicator.tableregex Regular expression to apply to tables to exclude from replication.
Sorry, there are no examples for this plugin.
Padraig O Sullivan
This documentation applies to filtered_replicator 0.2.
To see which version of the plugin a Drizzle server is running, execute:
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='filtered_replicator'