[MDEV-9345] Replication to enable filtering on master Created: 2015-12-30 Updated: 2023-10-05 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | VAROQUI Stephane | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
This task enable replication source to fetch only binlog events specifics to a set of tables without any modification of the application code and to fetch part of the schema without being force to copy all the binlogs. Today It is preferable that filters can be loaded into the master connections thread and filtering take place inside the master. |
| Comments |
| Comment by VAROQUI Stephane [ 2017-05-29 ] |
|
I don't agree with priority of this MDEV. This requirement is every where. replication filtering is very used and sending all binlogs for just a a table or ignoring some big logs table on the master is a must do such events should not transit the network Do you have something in mind that can enable like one time @ the biggest web shop in France to move a 100T DB that stop replicating when provisioning a new slave for changing a SAN? We used multi source for each independent domain and fetch them in different replicated stream this enable to catch up after provisioning without blocking what is already replicated , but such solution is limited by the number of source as it will duplicate the network traffic for each source |
| Comment by Oli Sennhauser [ 2023-10-05 ] |
|
If I understand Stephane correctly he wants to have binlog filtering on the binlog dump thread instead of the binary log writer thread. This request has some significant advantages:
|