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. 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

            [CAM-12071] Official support for CockroachDB

            Vy Ton added a comment -

            Product manager at Cockroach Labs here. It's awesome to see interest in adding official support for CockroachDB. Let me know if there are any questions our team can help answer

            Vy Ton added a comment - Product manager at Cockroach Labs here. It's awesome to see interest in adding official support for CockroachDB. Let me know if there are any questions our team can help answer

            Thorben Lindhauer added a comment -

            Hi vy-ton,

            Thanks for checking in. I recently posted a question on the CRDB forum that we would like to get an answer to: https://forum.cockroachlabs.com/t/understanding-a-transactionretryerror-with-a-foreign-key/3895. If you could bring to the right people's attention, that would be great.

            Cheers,
            Thorben

            Thorben Lindhauer added a comment - Hi vy-ton , Thanks for checking in. I recently posted a question on the CRDB forum that we would like to get an answer to: https://forum.cockroachlabs.com/t/understanding-a-transactionretryerror-with-a-foreign-key/3895 . If you could bring to the right people's attention, that would be great. Cheers, Thorben

            Vy Ton added a comment -

            Excited to see the resolved status on this issue. Do you know which Camunda release will have CockroachDB support?

            Vy Ton added a comment - Excited to see the resolved status on this issue. Do you know which Camunda release will have CockroachDB support?

            Nikola Koevski added a comment -

            Hi vy-ton,

            CockroachDB support will arrive with Camunda 7.14.0, due to be released on October 13th, 2020.

            Best,
            Nikola

            Nikola Koevski added a comment - Hi vy-ton , CockroachDB support will arrive with Camunda 7.14.0, due to be released on October 13th, 2020. Best, Nikola

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

                Created:
                Updated:
                Resolved: