# XtraDB Cluster tuning

**URL:** <https://forums.percona.com/t/xtradb-cluster-tuning/2849>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [July 29, 2013, 9:28am UTC](https://forums.percona.com/t/xtradb-cluster-tuning/2849 "2013-07-29T09:28:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gkontos](https://avatars.discourse-cdn.com/v4/letter/g/f04885/32.png) [@gkontos](https://forums.percona.com/u/gkontos)\
**Post date:** [July 29, 2013, 9:28am UTC](https://forums.percona.com/t/xtradb-cluster-tuning/2849/1 "2013-07-29T09:28:20Z")

</div>

Hallo,

I have just set up a cluster with 3 nodes in vmware and I am very amazed so far on how easy this process is!

Before putting this to production, I was wondering what options are available for tuning compared to the simple percona extradb server or mysql55 server.Would something like the following be implemented ?

[mysqld]

# GENERAL

user = mysql  
default\_storage\_engine = InnoDB  
socket = /var/lib/mysql/data/mysql.sock  
pid\_file = /var/lib/mysql/data/mysql.pid

# MyISAM

key\_buffer\_size = 32M  
myisam\_recover = FORCE,BACKUP

# SAFETY

max\_allowed\_packet = 16M  
max\_connect\_errors = 1000000

# DATA STORAGE

datadir = /var/lib/mysql/data/

# BINARY LOGGING

log\_bin = /var/lib/mysql/data/mysql-bin  
expire\_logs\_days = 14  
sync\_binlog = 1

# CACHES AND LIMITS

tmp\_table\_size = 32M  
max\_heap\_table\_size = 32M  
query\_cache\_type = 0  
query\_cache\_size = 0  
max\_connections = 500  
thread\_cache\_size = 50  
open\_files\_limit = 65535  
table\_definition\_cache = 1024  
table\_open\_cache = 2048

# INNODB

innodb\_flush\_method = O\_DIRECT  
innodb\_log\_files\_in\_group = 2  
innodb\_log\_file\_size = 256M  
innodb\_flush\_log\_at\_trx\_commit = 1  
innodb\_file\_per\_table = 1  
innodb\_buffer\_pool\_size = 12G

Thanks,

George

---

<div class="post-metadata">

**Author:** ![cetanhota](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@cetanhota](https://forums.percona.com/u/cetanhota)\
**Post date:** [July 31, 2013, 5:54pm UTC](https://forums.percona.com/t/xtradb-cluster-tuning/2849/2 "2013-07-31T17:54:44Z")

</div>

I have tuned my PXC nodes much the same way I tuned my stand alone servers. Just keep an eye on your memory usage. Since the galera engine will take up some overhead. So far our results have been good.