Filtered Replicator

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.

Loading

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.

Configuration

These command line options configure the plugin when drizzled is started. See Command Line Options for more information about specifying command line options.

--filtered-replicator.filteredschemas ARG
Default:

Variable:

filtered_replicator_filteredschemas

Comma-separated list of schemas to exclude from replication.

--filtered-replicator.filteredtables ARG
Default:

Variable:

filtered_replicator_filteredtables

Comma-separated list of tables to exclude from replication.

--filtered-replicator.schemaregex ARG
Default:

Variable:

filtered_replicator_schemaregex

Regular expression to apply to schemas to exclude from replication.

--filtered-replicator.tableregex ARG
Default:

Variable:

filtered_replicator_tableregex

Regular expression to apply to tables to exclude from replication.

Variables

These variables show the running configuration of the plugin. See variables for more information about querying and setting variables.

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

Examples

Sorry, there are no examples for this plugin.

Authors

Padraig O Sullivan

Version

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'

Chagnelog

v0.2

  • First release.