XtraDB Cluster tuning

gkontosgkontos EntrantActive Member Participant
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

Comments

  • cetanhotacetanhota Contributor Advisor
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.