![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961501.webp)
How Servers Evaluate Replication Filtering Rules
1481
database name that matches the name given for
--replicate-do-db
[1457]
. Suppose a replication
slave is started with
--replicate-do-db=dbx
[1457]
--replicate-wild-do-table=db
%.t1
[1459]
. Then, suppose that on the master, you issue the statement
CREATE DATABASE dbx
.
Although you might expect it, this statement is not replicated because it does not reference a table
named
t1
.
If any
--replicate-rewrite-db
[1458]
options were specified, they are applied before the
--
replicate-*
filtering rules are tested.
Note
In MySQL 5.0, database-level filtering options are case-sensitive on platforms
supporting case sensitivity in filenames, whereas table-level filtering options
are not (regardless of platform). This is true regardless of the value of the
lower_case_table_names
[466]
system variable.
16.2.3.1. Evaluation of Database-Level Replication and Binary Logging Options
When evaluating replication options, the slave begins by checking to see whether there are any
--
replicate-do-db
[1457]
or
--replicate-ignore-db
[1457]
options that apply. When using
--
binlog-do-db
[1469]
or
--binlog-ignore-db
[1470]
, the process is similar, but the options are
checked on the master.
Checking of the database-level options proceeds as shown in the following diagram.
The steps involved are listed here:
1. Are there any
--replicate-do-db
[1457]
options?
• Yes.
Do any of them match the database?
• Yes.
Execute the statement and exit.
• No.
Continue to step 2.
• No.
Continue to step 2.
Содержание 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 ...