1
.. _filtered_replicator:
6
The filtered replicator plugin, named ``filtered_replicator``, filters
7
replication events based on schema name or table name. Regular expressions
8
can be used for the schema and table names.
10
.. _filtered_replicator_loading:
15
To load this plugin, start :program:`drizzled` with::
17
--plugin-add=filtered_replicator
19
Loading the plugin may not enable or configure it. See the plugin's
20
:ref:`filtered_replicator_configuration` and :ref:`filtered_replicator_variables`.
22
.. seealso:: :ref:`drizzled_plugin_options` for more information about adding and removing plugins.
24
.. _filtered_replicator_configuration:
29
These command line options configure the plugin when :program:`drizzled`
30
is started. See :ref:`command_line_options` for more information about
31
specifying command line options.
35
.. option:: --filtered-replicator.filteredschemas ARG
38
:Variable: :ref:`filtered_replicator_filteredschemas <filtered_replicator_filteredschemas>`
40
Comma-separated list of schemas to exclude from replication.
42
.. option:: --filtered-replicator.filteredtables ARG
45
:Variable: :ref:`filtered_replicator_filteredtables <filtered_replicator_filteredtables>`
47
Comma-separated list of tables to exclude from replication.
49
.. option:: --filtered-replicator.schemaregex ARG
52
:Variable: :ref:`filtered_replicator_schemaregex <filtered_replicator_schemaregex>`
54
Regular expression to apply to schemas to exclude from replication.
56
.. option:: --filtered-replicator.tableregex ARG
59
:Variable: :ref:`filtered_replicator_tableregex <filtered_replicator_tableregex>`
61
Regular expression to apply to tables to exclude from replication.
63
.. _filtered_replicator_variables:
68
These variables show the running configuration of the plugin.
69
See `variables` for more information about querying and setting variables.
71
.. _filtered_replicator_filteredschemas:
73
* ``filtered_replicator_filteredschemas``
77
:Option: :option:`--filtered-replicator.filteredschemas`
79
Comma-separated list of schemas to exclude from replication.
81
.. _filtered_replicator_filteredtables:
83
* ``filtered_replicator_filteredtables``
87
:Option: :option:`--filtered-replicator.filteredtables`
89
Comma-separated list of tables to exclude from replication.
91
.. _filtered_replicator_schemaregex:
93
* ``filtered_replicator_schemaregex``
97
:Option: :option:`--filtered-replicator.schemaregex`
99
Regular expression to apply to schemas to exclude from replication.
101
.. _filtered_replicator_tableregex:
103
* ``filtered_replicator_tableregex``
107
:Option: :option:`--filtered-replicator.tableregex`
109
Regular expression to apply to tables to exclude from replication.
111
.. _filtered_replicator_examples:
116
Sorry, there are no examples for this plugin.
118
.. _filtered_replicator_authors:
125
.. _filtered_replicator_version:
130
This documentation applies to **filtered_replicator 0.2**.
132
To see which version of the plugin a Drizzle server is running, execute:
134
.. code-block:: mysql
136
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='filtered_replicator'