[MXS-4294] Replace CDC protocol for avrorouter Created: 2022-09-14  Updated: 2023-07-01  Resolved: 2023-06-30

Status: Closed
Project: MariaDB MaxScale
Component/s: avrorouter, cdc
Affects Version/s: 22.08
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: markus makela Assignee: Niclas Antti
Resolution: Won't Do Votes: 0
Labels: None

Sprint: MXS-SPRINT-184, MXS-SPRINT-185, MXS-SPRINT-186

 Description   

The CDC protocol is not very secure and it is not that good in general. Find a way to replace it with something so that we can drop it and forget that it ever existed.

One candidate is to simply use the MariaDB protocol and rewrite the client side of things to use normal connectors and add rudimentary SQL parsing to the avrorouter (similar to what the binlogrouter does).



 Comments   
Comment by markus makela [ 2023-06-19 ]

One idea that I discussed with nantti was to replace the whole Avrorouter with a filter that converts the binlog stream from the binlogrouter into a JSON CDC stream. This would reuse existing code and provide all the features that the binlogrouter has (encryption) or can have (external storage via S3).

Comment by Niclas Antti [ 2023-06-30 ]

No commerical need at the moment.

Generated at Thu Feb 08 04:27:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.