Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21200

About 10x less insert performance with Galera cluster

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.3.18
    • Fix Version/s: 10.3.21
    • Component/s: Galera
    • Labels:
      None

      Description

      I am running an application which inserts a lot of rows and we were experiencing some low performance. So i started benchmarking the Galera Cluster with sysbench and oltp_insert.lua. The performance of the cluster is really bad.
      With the same test:
      As a standalone DB i can perform about18000 tps
      With Galera the performance is: 1000 tps
      I try to decrease cluster size to 1, but the result is still bad.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stepan.patryshev Stepan Patryshev
              Reporter:
              yz s
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: