Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-12071

Official support for CockroachDB

XMLWordPrintable

      User story

      As a user, I want to use CockroachDB with Camunda so that I can use a resilient, scalable, and consistent database.

      Background

      We want to provide official support for CockroachDB in 7.14. For this, we are starting a spike on June 29 with the goal to validate the technical feasibility of how we can support CockroachDB.

      What is it?

      CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.

       

      AC

      • CockroachDB is officially supported in 7.14
      • Documentation can be found on how to set up and run projects with CockroachDB

       

        This is the controller panel for Smart Panels app

          1. successfull-crdb-test-results.txt
            246 kB
          2. completed-test-suite-results.txt
            352 kB
          1.
          		 [BUG] CRDB Timestamp subtraction doesn't combine with EXTRACT Sub-task Closed Unassigned
          2.
          		 [BUG] CRDB concurrent transactions must be retried or reported to caller Sub-task Closed Nikola Koevski
          3.
          		 [BUG] Long-running CRDB transactions fail when commit deadline is exceeded Sub-task Closed Nikola Koevski
          4.
          		 [BUG] Union queries fail in CRDB due to a type mismatch Sub-task Closed Unassigned
          5.
          		 [BUG] Concurrent DbDeadlockTest blocks on CRDB Sub-task Closed Unassigned
          6.
          		 [BUG] CompetingMessageCorrelationTest test case blocks test suite execution Sub-task Closed Unassigned
          7.
          		 Document support for CockroachDB Sub-task Closed Nikola Koevski
          8.
          		 Disable pessmistic locks on CRDB and do retries instead Sub-task Closed Nikola Koevski
          9.
          		 Add CRDB-specific behavior tests Sub-task Closed Nikola Koevski
          10.
          		 Provide a clear approach on CRDB usage with external transaction management Sub-task Closed Nikola Koevski

              nikola.koevski Nikola Koevski
              andre.bappert Andre
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: