[MDEV-26706] Enable per table gtid domain_id Created: 2021-09-28 Updated: 2021-09-28 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | VAROQUI Stephane | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
Replication filters have many issues and domain filtering works better to allow selective filtering on replicas such task would attach one or many domain per table definition enabling user define logical dataset to be filtered or apply on a replica. Today using extra domain is.an application layer task and is out of the scope of sysops dbops making such good feature a no go in most case. |
| Comments |
| Comment by Daniel Black [ 2021-09-28 ] |
|
This will get tricky if two table updates are in the same transaction. Which gtid will it get? |
| Comment by VAROQUI Stephane [ 2021-09-28 ] |
|
Yep in row based no issue but in statement could just works as in filters today so if stmt cross multi domains tables , all domains has to be store in binlog so that filetring can works as described today |
| Comment by VAROQUI Stephane [ 2021-09-28 ] |
|
For resolving the selective purge on master and store on replica a syntax ALTER TABLE ADD DOMAIN x FOR ALL|DELETE|UPDATE|REPLACE|INSERT can be introduce |