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

       

        1. completed-test-suite-results.txt
          352 kB
        2. successfull-crdb-test-results.txt
          246 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

            Assignee:
            Nikola Koevski
            Reporter:
            Andre
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: