Announcement

Announcement Module
Collapse
No announcement yet.

XtraDB Cluster tuning

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • XtraDB Cluster tuning

    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

  • #2
    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.

    Comment

    Working...
    X