I recently installed a 3 full master node cluster based on Percona Xtradb (very easy install). But now i need to make some tuning to increase INSERT/UPDATE requests. Actually, i made around 100 insertions every 5 minutes, but also made around 400 update in the same time. All this operation take less than 3 minutes when i was on a single server architecture. And now, with 3 node server, it takes more than 5 minutes ...
Is there any tuning i can do to speed up this operations ? Here is my actual cnf configuration :
[mysqld] datadir=/var/lib/mysql user=mysql wsrep_provider=/usr/lib/libgalera_smm.so wsrep_cluster_address=gcomm://dbnode01,dbnode02,dbnode03 binlog_format=ROW default_storage_engine=InnoDB innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 wsrep_node_address=18.104.22.168 wsrep_cluster_name=my_cluster wsrep_sst_method=xtrabackup wsrep_sst_auth="user:password"
Here are the 3-server hard config :
CPU: Single Processor Quad Core Xeon 3470 - 2.93Ghz (Lynnfield) - 1 x 8MB cache w/HT RAM: 8 GB DDR3 Registered 1333 HDD: 500GB SATA II
CPU: Single Processor Quad Core Xeon 1270 V2 - 3.50GHz (Ivy Bridge) - 1 x 8MB cache w/HT RAM: 4 GB DDR3 1333 HDD: 1.00TB SATA II
CPU: Intel(R) Xeon(R) CPU E3-1245 V2 @ 3.40GHz (4-Cores) RAM: 32G HDD: 2T
Actualy there's around 2.4M records (24 fields each) in the table concerned by the INSERT/UPDATE statements (6 fields indexed).