8
The Filtered Replicator plugin registers itself in the Drizzle kernel replication
9
stream process as a new replicator (see :ref:`replication_streams` for more
10
information). It provides a way to filter replication messages by schema name or
11
table name. Regular expressions can be used for the schema and table names.
13
To make the filtered replicator available, you must enable the plugin when the
14
server is started using the :option:`--plugin-add` option.
4
The Filtered Replicator plugin registers itself in the Drizzle kernel
5
replication stream process as a new replicator (see :ref:`replication_streams`
6
for more information). It provides a way to filter replication messages by
7
schema name or table name. Regular expressions can be used for the schema and
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:: :doc:`/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 :doc:`/configuration` for more information about specifying
19
33
.. program:: drizzled
21
.. option:: --filtered-replicator.filteredschemas
23
Comma-separated list of schema names to exclude from replication.
25
.. option:: --filtered-replicator.filteredtables
27
Comma-separated list of table names to exclude from replication.
29
.. option:: --filtered-replicator.schemaregex
31
Regular expression to apply to schemas to exclude from replication.
33
.. option:: --filtered-replicator.tableregex
35
Regular expression to apply to tables to exclude from replication.
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:
40
To prevent changes to the *foo* schema from being replicated::
42
sbin/drizzled --plugin-add=filtered_replicator \
43
--filtered-replicator.filteredschemas=foo
45
To prevent changes to any schema beginning with *test* from being replicated::
47
sbin/drizzled --plugin-add=filtered_replicator \
48
--filtered-replicator.schemaregex="test*"
50
To prevent changes to any table beginning with *junk* from being replicated::
52
sbin/drizzled --plugin-add=filtered_replicator \
53
--filtered-replicator.tableregex="junk*"
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'