Table data compare and sync (MXS-3727)

[MXS-4395] Outline approaches for showing the diff and generate sync script Created: 2022-11-14  Updated: 2022-11-24  Resolved: 2022-11-24

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: Sub-Task Priority: Major
Reporter: Duong Thien Ly Assignee: Duong Thien Ly
Resolution: Fixed Votes: 0
Labels: None

Sprint: MXS-SPRINT-169, MXS-SPRINT-170, MXS-SPRINT-171

 Description   

To check if the tables are out of sync, `CHECKSUM TABLE` could be used for that.
Showing the diff may be challenging. A preliminary thought is to use the column key and `LIMIT` to navigate through the table. This approach may be slower and not user-friendly to see the diff but this will prevent MaxScale and the query editor from running out of memory.

 Comments   
Comment by Duong Thien Ly [ 2022-11-24 ]

https://docs.google.com/document/d/10r5NRlwCeLjXrQjtFwbl4wL-CmqINdC4n2Aa1ofIEN0/edit?usp=sharing

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