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

Dynamic horizontal scaling for Small to Medium-sized installations.

    XMLWordPrintable

Details

    Description

      This project solves horizontall scale problem to increase read-only QPS in real-time by adding more nodes.

      As of 23.02 MCS can't add read-only nodes sharing the same data between the nodes neither for S3, nor for distributed File Systems or block device technologies.

      The topology would consist of 3 major elements:

      • MaxScale proxy to Load Balance read-only requests between read-only nodes and route DML/DDL to the read-write node
      • Read-write node that "owns" dbroot/-s with data
      • Multiple read-only nodes that doesn't run WE or "own" dbroot/-s.

      The problems to solve:

      • add declarative description for a set of read-only nodes into Columnstore.xml
      • teach CMAPI how to add a node with read-only role into a cluster
      • handle read-only ownership in StorageManager for S3 installations

      Attachments

        Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. MCOL-6018 ASAN memory leaks and UBSAN in plugin

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5861 Read-only Columnstore node

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5962 Fix rollback in mcs cli and passing errors during broadcasting config.

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Task - A task that needs to be done. MCOL-5996 Cmapi+ Multinode Failover tests infrastructure

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MCOL-6160 Read replica with S3

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MCOL-6169 Support creating POSIX shared storage in columnstore-ansible-aws

          • Major - Major loss of function.
          • In Review
          mentioned on

          GitLab Commit - MCOL-5806: added ability to start node in read-only mode

          Activity

            People

              sergey.zefirov Sergey Zefirov
              allen.herrera Allen Herrera
              Votes:
              0 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.