Need a way to permanently filter certain schemas from the replication stream
Bug #716502 reported by
David Shrewsbury
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Drizzle |
Fix Released
|
High
|
Brian Aker | ||
| 7.0 |
Fix Released
|
High
|
Brian Aker | ||
Bug Description
We need a way, other than using filtered_replicator plugin, to permanently block actions on certain schema from going through the replication stream. For instance, work being done for bug 711068 requires us to block modifications on a new table in D_D linking to the innodb transaction log.
This is also needed for this blueprint: https:/
The slave plugin stores its state information in it's own schema and tables, and these should never be replicated.
Related branches
lp://qastaging/~dshrews/drizzle/bug716502_perm_schema_filter
- Drizzle Developers: Pending requested
-
Diff: 188 lines (+77/-8)2 files modifieddrizzled/transaction_services.cc (+62/-8)
drizzled/transaction_services.h (+15/-0)
lp://qastaging/~linuxjedi/drizzle/trunk-repication-log-nolog
- Drizzle Developers: Pending requested
-
Diff: 11 lines (+1/-0)1 file modifiedplugin/innobase/dict/create_replication.cc (+1/-0)
lp://qastaging/~brianaker/drizzle/replication-ddl
- Drizzle Developers: Pending requested
-
Diff: 1442 lines (+301/-116)49 files modifieddrizzled/message/include.am (+6/-0)
drizzled/message/replication_options.proto (+12/-0)
drizzled/message/schema.h (+1/-0)
drizzled/message/schema.proto (+5/-0)
drizzled/message/statement_transform.cc (+9/-6)
drizzled/message/table.h (+1/-0)
drizzled/message/table.proto (+4/-0)
drizzled/parser.cc (+23/-0)
drizzled/parser.h (+2/-0)
drizzled/plugin/schema_engine.cc (+13/-4)
drizzled/plugin/storage_engine.h (+3/-1)
drizzled/plugin/table_function.cc (+2/-0)
drizzled/schema.cc (+3/-2)
drizzled/sql_insert.cc (+1/-0)
drizzled/sql_table.cc (+24/-8)
drizzled/sql_yacc.yy (+28/-31)
drizzled/symbol_hash.gperf (+1/-0)
drizzled/table/instance/base.h (+5/-0)
drizzled/table/instance/shared.h (+8/-0)
drizzled/transaction_services.cc (+41/-10)
drizzled/transaction_services.h (+5/-2)
drizzled/util/string.h (+1/-0)
plugin/collation_dictionary/tests/r/data_dictionary.result (+2/-2)
plugin/function_engine/function.cc (+3/-1)
plugin/information_schema_dictionary/tests/r/show_create_table.result (+20/-20)
plugin/innobase/tests/r/innodb_cmp.result (+1/-1)
plugin/innobase/tests/r/innodb_cmp_reset.result (+1/-1)
plugin/innobase/tests/r/innodb_cmpmem.result (+1/-1)
plugin/innobase/tests/r/innodb_cmpmem_reset.result (+1/-1)
plugin/innobase/tests/r/innodb_lock_waits.result (+1/-1)
plugin/innobase/tests/r/innodb_locks.result (+1/-1)
plugin/innobase/tests/r/innodb_replication_log.result (+1/-1)
plugin/innobase/tests/r/innodb_status.result (+1/-1)
plugin/innobase/tests/r/innodb_trx.result (+1/-1)
plugin/logging_stats/tests/r/command.result (+1/-1)
plugin/logging_stats/tests/r/max_user.result (+1/-1)
plugin/registry_dictionary/tests/r/data_dictionary.result (+2/-2)
plugin/replication_dictionary/tests/r/data_dictionary.result (+1/-1)
plugin/schema_dictionary/tests/r/data_dictionary.result (+6/-6)
plugin/session_dictionary/tests/r/data_dictionary.result (+1/-1)
plugin/show_dictionary/show_create_schema.cc (+9/-0)
plugin/status_dictionary/tests/r/data_dictionary.result (+4/-4)
plugin/table_cache_dictionary/tests/r/table_cache.result (+1/-1)
plugin/table_cache_dictionary/tests/r/table_definition_cache.result (+1/-1)
tests/r/create.result (+2/-2)
tests/r/replication_schema_ddl.result (+10/-0)
tests/r/replication_table_ddl.result (+16/-0)
tests/t/replication_schema_ddl.test (+7/-0)
tests/t/replication_table_ddl.test (+7/-0)
Revision history for this message
| David Shrewsbury (dshrews) wrote | #1 |
Revision history for this message
| Andrew Hutchings (linuxjedi) wrote | #2 |
To post a comment you must log in.
Assigning to Brian. He has a better solution.