Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3727 Table data compare and sync
  3. MXS-4395

Outline approaches for showing the diff and generate sync script

    XMLWordPrintable

Details

    • Sub-Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • N/A
    • N/A
    • None
    • 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.

      Attachments

        Activity

          People

            thien.ly Duong Thien Ly
            thien.ly Duong Thien Ly
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.