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

Sync schema created mysql-bin.xxxxxx files for data replication. It should be for schema only

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.7
    • Icebox
    • installation
    • None
    • 2-node combo stack on AWS, using d2.8xlarge instance type
    • 2017-20

    Description

      Build tested: 1.0.7-1, on AWS

      I cpimported a 1TB dbt3 database, then insert..select all 8 tables to another database. There are mysql-bin files totaling 303 gb. This affects disk utilization and performance. We should setup replication for schema sync only.

      rw-rw--- 1 mariadb-user mariadb-user 10920 Feb 6 15:38 mysql-bin.000001
      rw-rw--- 1 mariadb-user mariadb-user 346 Feb 6 15:46 mysql-bin.000002
      rw-rw--- 1 mariadb-user mariadb-user 1465 Feb 6 15:46 mysql-bin.000003
      rw-rw--- 1 mariadb-user mariadb-user 8352 Feb 6 17:49 mysql-bin.000004
      rw-rw--- 1 mariadb-user mariadb-user 346 Feb 6 17:50 mysql-bin.000005
      rw-rw--- 1 mariadb-user mariadb-user 24669057129 Feb 6 21:33 mysql-bin.000006
      rw-rw--- 1 mariadb-user mariadb-user 154527553064 Feb 7 00:23 mysql-bin.000007
      rw-rw--- 1 mariadb-user mariadb-user 1437982903 Feb 7 00:24 mysql-bin.000008
      rw-rw--- 1 mariadb-user mariadb-user 118352065576 Feb 7 01:36 mysql-bin.000009
      rw-rw--- 1 mariadb-user mariadb-user 24508258169 Feb 7 02:02 mysql-bin.000010
      rw-rw--- 1 mariadb-user mariadb-user 510 Feb 7 15:54 mysql-bin.000011
      rw-rw--- 1 mariadb-user mariadb-user 346 Feb 7 15:56 mysql-bin.000012
      rw-rw--- 1 mariadb-user mariadb-user 1361 Feb 7 16:11 mysql-bin.000013

      Attachments

        Issue Links

          Activity

            People

              LinuxJedi Andrew Hutchings (Inactive)
              dleeyh Daniel Lee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              3 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.