[MXS-3727] Table data compare and sync Created: 2021-08-12  Updated: 2024-01-02

Status: Stalled
Project: MariaDB MaxScale
Component/s: maxgui, REST-API
Affects Version/s: None
Fix Version/s: 24.02

Type: New Feature Priority: Major
Reporter: Manjot Singh (Inactive) Assignee: Duong Thien Ly
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
Blocks
blocks MXS-4386 DDL compare and sync Open
Duplicate
duplicates MXS-4076 Query Editor: Data Comparison Feature... Closed
Issue split
split to MXS-4386 DDL compare and sync Open
Relates
relates to MXS-2709 ETL / Data Migration Service Closed
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
MXS-4394 Redesign Query Editor UX Sub-Task Closed Duong Thien Ly  
MXS-4395 Outline approaches for showing the di... Sub-Task Closed Duong Thien Ly  
MXS-4408 Add PRD Sub-Task Closed Duong Thien Ly  
MXS-4884 Extend /sql interface to have sub-end... Sub-Task Open markus makela  
Sprint: MXS-SPRINT-169, MXS-SPRINT-170, MXS-SPRINT-171

 Description   

Maxscale should have the ability to compare tables within a server and across servers/topologies. After comparison, it should provide a diff and have the ability to use that diff to sync the tables.

This should also be made available in the IDE.

(The scope of this ticket will be for data comparison and sync.)

 Comments   
Comment by Naresh Chandra [ 2022-10-25 ]

Hi @Duong

Can we implement for both data compare and structure compare features would be good. I mean it should compare both data and compare all the schema objects (Schema/Table/Procs/Triggers/Any) from source to destination.

Comment by Naresh Chandra [ 2022-11-09 ]

Hi Duong,

Can we add compare/sync option to external servers as well? I mean if we don't add servers in the maxscale conf file, but we want to compare the data and table structures or sync data and structures for external servers would be a good feature for us.

EX: User should be able to add temporary source/destination db server's details in the GUI and then compare external database data/structures from source to destination in the GUI.

Comment by Naresh Chandra [ 2022-11-11 ]

Hi Duong,

Can you please include above external feature as well?

Comment by Naresh Chandra [ 2022-11-21 ]

Hi Duong,

Just a thought, can we implement to compare data between different database technologies, it can be a MariaDB, Postgres, MongoDB or any other technologies?

Comment by Kathryn Sizemore [ 2023-06-14 ]

naresh.chandra@copart.com
I believe the above can be split into different tickets, but the scope for this ticket is compare and sync for data.
MXS-4386 is for DDL

Comment by Naresh Chandra [ 2023-08-11 ]

Kathryn Sizemore Sure, thanks for the update.

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