My Oracle Support Banner

How does Filtering of Stored Procedures, Stored Functions, Events, Views, and Triggers Work with Replication Filters? (Doc ID 1335242.1)

Last updated on NOVEMBER 16, 2016

Applies to:

MySQL Server - Version 5.1 and later
Information in this document applies to any platform.

Goal

Learn how replication of stored procedures, stored functions, events (MySQL Server 5.1 and later), views, and triggers are affected by the replicate-do-table, replicate-ignore-table, replicate-wild-do-table, replicate-wild-ignore-table, replicate-do-db, and replicate-ignore-db replication filter options.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 How Does MySQL Save Stored Programs and Views?
 How Does the replicate-*-table Options Filter Statements Creating, Altering, or Dropping Stored Programs and Views
 How Does the replicate-*-db Options Filter Statements Creating, Altering, or Dropping Stored Programs and Views
 Statement Based Replication
 Row Based Replication
 Mixed Mode Replication
 Examples
 Example 1
 Replication Filters
 Statements
 Result
 Example 2
 Replication Filters
 Statements
 Result
 Example 3
 Replication Filters
 Statements
 Result
 Example 4
 Replication Filters
 Statements
 Result
 Example 5
 Replication Filters
 Statements
 Result
 Example 6
 Replication Filters
 Statements
 Result
 Summary
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.