[MDEV-21200] About 10x less insert performance with Galera cluster Created: 2019-12-03  Updated: 2019-12-09  Resolved: 2019-12-09

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.3.18
Fix Version/s: 10.3.21

Type: Bug Priority: Minor
Reporter: s Assignee: Stepan Patryshev (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None

Attachments: File galera.cnf     Text File galera_status.txt    
Issue Links:
Relates
relates to MDEV-20646 10.3.18 is slower than 10.3.17 Closed

 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.

 Comments   
Comment by s [ 2019-12-04 ]

When i set up pxc on docker, find the performance is good,. Tps about 6500!!! What puzzled me was that the performance of MariaDB cluster using Galera was so bad

Comment by s [ 2019-12-05 ]

When I use 10.4.10 MariaDB with same cnf to sysbench, I get a good result, about 8000tps

Comment by Stepan Patryshev (Inactive) [ 2019-12-05 ]

Please, see below my performance test results in TPS on the latest 10.4 (ae72205e31e7665238c1757ede352d9ca53d5327) and 10.3 (d759f764f6b115ca7ad7644ae3ee2e19c71c6138):

Ver. Standalone 3 nodes 1 Galera node
10.3.21 133 57 76
10.4.11 131 89 90

I can confirm the difference for 10.3 between using Galera and without it in 2 times, but not in 10!
Maybe, there was anything else special in original tests. I run oltp_insert.lua for 10 mins on the table with already 1M rows. But do not think that it matters here.

But I run it on HyperV VM, not on the real one.

Comment by s [ 2019-12-06 ]

I solve the problem by upgrading mariadb from 10.3.18 to 10.4.10.

Comment by s [ 2019-12-06 ]

I think that the problem may be solved in 10.3.19 or later.

Comment by Stepan Patryshev (Inactive) [ 2019-12-06 ]

I've tested it on 10.3.18 (604f80e77c054758aa449064cdc29dfa13a71922) also. See below my results:

Ver. Standalone 3 nodes 1 Galera node
10.3.18 133 58 76
10.3.21 133 57 76
10.4.11 131 89 90

Practically, do not see any difference between 10.3.18 and the latest 10.3 (10.3.21).

Btw, found also performance related issue MDEV-20646 (10.3.18 is slower than 10.3.17). But there is nothing about Galera.

Comment by s [ 2019-12-09 ]

Maybe it's not the reason for Galera. Anyway, thanks for your help, I've decided to use the latest version of MariaDB Galera cluster

Comment by Stepan Patryshev (Inactive) [ 2019-12-09 ]

Closing it as not reproduced.

Generated at Thu Feb 08 09:05:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.