Using Ubuntu Server 14.04.1 and Percona XtraDB 5.6.20-68.0-56.
When the cluster is running with all three servers and we do a set of inserts (~800,000 of them) we see
a through put of around 150 inserts/second.
If I shut down servers two and three and now run the same transactions we see a through put of 6,000
to 12,000 inserts/second. It jumps around a bit.
It just seems wrong for the cluster to be that much slower. My my.cnf from the first server is below.
All three servers are the same, Intel Xeon E3-1270 @ 3.5Ghz, 32 Gb memory, and a single 256
Samsung SSD, dual gigabit nics bonded in balance-rr mode and all on the same gigabit switch.
Any thoughts are deeply appreciated
Larry
[mysqld]
datadir=/var/lib/mysql/
user=mysql
#Skip reverse DNS lookup of clients
skip-host-cache
skip-name-resolve
wsrep_provider=/usr/lib/libgalera_smm.so
#wsrep_cluster_address=gcomm://
wsrep_cluster_address=gcomm://192.168.90.140,192.168.90.141,192.168.90.142
max_connections=1000
max_connect_errors=100
max_allowed_packet= 32M
max-heap-table-size = 32M
tmp-table-size = 32M
thread_cache_size = 2000
open-files-limit = 65535
binlog_format=ROW
default_storage_engine=InnoDB
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=25G
innodb_log_file_size=512M
wsrep_node_address=192.168.90.140
wsrep_sst_method=xtrabackup
wsrep_cluster_name=prod
wsrep_sst_auth=user:hidden