← Back to branch summary

~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

« back to all changes in this revision

Viewing changes to docs/plugins/filtered_replicator/index.rst

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2011-03-15 10:41:18 UTC
  • mfrom: (1.2.10 upstream)
  • Revision ID: james.westby@ubuntu.com-20110315104118-eaf0hvlytjdl4zrf
Tags: 2011.03.13-0ubuntu1
* New upstream release.
* Added slave plugin.
* Removed archive, blackhole and blitzdb plugins.
* Moved location of libdrizzle headers.
* Removed drizzleadmin manpage patch.
* Add drizzle_safe_write_string to symbols.

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/plugins/filtered_replicator/index.rst
 
1
*******************
 
2
Filtered Replicator
 
3
*******************
 
4
 
 
5
Description
 
6
###########
 
7
 
 
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.
 
12
 
 
13
To make the filtered replicator available, you must enable the plugin when the
 
14
server is started using the :option:`--plugin-add` option.
 
15
 
 
16
Configuration
 
17
#############
 
18
 
 
19
.. program:: drizzled
 
20
 
 
21
.. option:: --filtered-replicator.filteredschemas
 
22
 
 
23
   Comma-separated list of schema names to exclude from replication.
 
24
 
 
25
.. option:: --filtered-replicator.filteredtables
 
26
 
 
27
   Comma-separated list of table names to exclude from replication.
 
28
 
 
29
.. option:: --filtered-replicator.schemaregex
 
30
 
 
31
   Regular expression to apply to schemas to exclude from replication.
 
32
 
 
33
.. option:: --filtered-replicator.tableregex
 
34
 
 
35
   Regular expression to apply to tables to exclude from replication.
 
36
 
 
37
Examples
 
38
########
 
39
 
 
40
To prevent changes to the *foo* schema from being replicated::
 
41
 
 
42
  sbin/drizzled --plugin-add=filtered_replicator \
 
43
                --filtered-replicator.filteredschemas=foo
 
44
 
 
45
To prevent changes to any schema beginning with *test* from being replicated::
 
46
 
 
47
  sbin/drizzled --plugin-add=filtered_replicator \
 
48
                --filtered-replicator.schemaregex="test*"
 
49
 
 
50
To prevent changes to any table beginning with *junk* from being replicated::
 
51
 
 
52
  sbin/drizzled --plugin-add=filtered_replicator \
 
53
                --filtered-replicator.tableregex="junk*"