# 2 Node Cluster Very slow

**URL:** <https://forums.percona.com/t/2-node-cluster-very-slow/7419>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 10, 2020, 3:25pm UTC](https://forums.percona.com/t/2-node-cluster-very-slow/7419 "2020-02-10T15:25:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![meyerder](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/meyerder/32/16994_2.png) [@meyerder](https://forums.percona.com/u/meyerder)\
**Post date:** [February 10, 2020, 3:25pm UTC](https://forums.percona.com/t/2-node-cluster-very-slow/7419/1 "2020-02-10T15:25:24Z")

</div>

I am new to clusters in general and expect them to be a bit slower than a stand alone system… but I am QUITE a bit slower…

Existing prod is a 4 node 32 gig system with the following settings  
innodb\_flush\_log\_at\_timeout=1800  
innodb\_flush\_method=O\_DIRECT  
innodb-log-files-in-group = 2  
innodb-log-file-size = 1024M  
innodb-file-per-table = 1  
innodb-buffer-pool-size = 22G  
innodb\_stats\_on\_metadata=0  
innodb\_lock\_wait\_timeout=19000  
innodb\_io\_capacity\_max=1000  
innodb-doublewrite=0  
innodb-flush-log-at-trx\_commit=2  
innodb\_log\_buffer\_size=4M  
innodb\_change\_buffer\_max\_size=50  
innodb\_support\_xa = 0

mysqlslap results in the following which is pretty good…

mysqlslap --user=xxxx --password=xxxx --host=localhost --create-schema=“test” --concurrency=30 --query=“insert into t1(name) values(‘111’)” --number-of-queries=100000 --iterations=1  
mysqlslap: [Warning] Using a password on the command line interface can be insecure.  
Benchmark  
Average number of seconds to run all queries: 3.669 seconds  
Minimum number of seconds to run all queries: 3.669 seconds  
Maximum number of seconds to run all queries: 3.669 seconds  
Number of clients running queries: 30  
Average number of queries per client: 3333

The same on the cluster results in which is huge (using the same innodb settings and going to SSD storage… no spike on the systems while running the tests)  
The clusters are on the same vlan with a 0.31 ms response time and 10 gig interfaces between them (inside the same enclosure) so network is not a issue  
It does not change if I modify the slave threads The new clusters are 32 gig 16 core units

wsrep\_slave\_threads=6  
wsrep\_provider\_options=“gcache.size=4G”

mysqlslap: [Warning] Using a password on the command line interface can be insecure.  
Benchmark  
Average number of seconds to run all queries: 112.825 seconds  
Minimum number of seconds to run all queries: 97.198 seconds  
Maximum number of seconds to run all queries: 124.199 seconds  
Number of clients running queries: 30  
Average number of queries per client: 3333

What am I missing?

\*\*Note I know to run a 3 node cluster but just testing items right now
