How Servers Evaluate Replication Filtering Rules
1485
• Yes.
Continue to step 2.
• No.
Execute the statement and exit.
2. Are there any
--replicate-do-table
[1458]
options?
• Yes.
Does the table match any of them?
• Yes.
Execute the statement and exit.
• No.
Continue to step 3.
• No.
Continue to step 3.
3. Are there any
--replicate-ignore-table
[1458]
options?
• Yes.
Does the table match any of them?
• Yes.
Ignore the statement and exit.
• No.
Continue to step 4.
• No.
Continue to step 4.
4. Are there any
--replicate-wild-do-table
[1459]
options?
• Yes.
Does the table match any of them?
• Yes.
Execute the statement and exit.
• No.
Continue to step 5.
• No.
Continue to step 5.
5. Are there any
--replicate-wild-ignore-table
[1460]
options?
• Yes.
Does the table match any of them?
• Yes.
Ignore the statement and exit.
• No.
Continue to step 6.
• No.
Continue to step 6.
6. Are there any
--replicate-do-table
[1458]
or
--replicate-wild-do-table
[1459]
options?
• Yes.
Ignore the statement and exit.
• No.
Execute the statement and exit.
16.2.3.3. Replication Rule Application
This section provides additional explanation and examples of usage for different combinations of
replication filtering options.
Some typical combinations of replication filter rule types are given in the following table:
Condition (Types of Options)
Outcome
No
--replicate-*
options at all:
The slave executes all events that it receives from the
master.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...