Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4936

Disable bingloging for MCS tables running DML/bulk insertion(LDIF)

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 6.2.1
    • 6.3.1
    • MDB Plugin
    • None
    • 2021-16, 2021-17

    Description

      LOAD DATA IN FILE and DML are the only ways to ingest data into MCS tables in the cloud. Both LDIF and DML produces binlog entries for MCS tables. The binlogs themselves doesn't make any sense in MCS cluster b/c of its distributed storage and also binlogs can take a lot of disk space in case of LDIF. The immediate solution is to disable binlogs for DML/bulk insertion for MCS tables.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4960 Allow a user to enable DML binlog replication when performing DML statements on a ColumnStore table

          • Major - Major loss of function.
          • Open

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.