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 Thien Ly
            thien.ly 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.