Announcement

Announcement Module
Collapse
No announcement yet.

Slow replication between nodes

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

  • Slow replication between nodes

    Hi, i have a problem with replication.
    Inserting the individual nodes not in the order in which the records inserted. These are a few messages (chat) at the same moment. Problem is characterized by the "enter a room," a member greets me before my entrance into the room.
    How to solve this problem?
    Nodes arent same but isnt overloaded, each of nodes have 2gbit (2x 1gbit with bonding) ethernet and enough memory

    Config is


    root@web1:~# cat /etc/mysql/my.cnf
    [client]
    port = 3306
    #socket = @MYSQL_UNIX_ADDR@

    [mysqld]
    #skip-name-resolve
    datadir=/var/lib/mysql
    user=mysql
    port = 3306

    wsrep_provider = /usr/lib/libgalera_smm.so
    wsrep_provider_options = "gcache.dir=/var/tmp;gcache.size=20G;gcache.page_size=1G;gcs.fc_lim it=512;gcs.fc_master_slave=YES;evs.user_send_windo w=512;evs.send_window=1024"
    wsrep_cluster_address = gcomm://10.100.0.1,10.100.0.2,10.100.0.3
    #wsrep_cluster_address = gcomm://10.100.0.1
    binlog_format = ROW
    default_storage_engine = InnoDB
    innodb_locks_unsafe_for_binlog = 1
    innodb_autoinc_lock_mode = 2
    wsrep_node_address = 10.100.0.2
    wsrep_node_name = web1
    wsrep_sst_method = xtrabackup-v2
    #wsrep_sst_donor =
    wsrep_cluster_name = sql1
    wsrep_sst_auth = "userass"
    wsrep_on = ON
    wsrep_retry_autocommit = 2
    wsrep_slave_threads = 32
    wsrep_log_conflicts = ON
    wsrep_debug = ON
    #wsrep_drupal_282555_workaround = ON
    #wsrep_notify_cmd = /usr/bin/galeranotify.py




    [mysqldump]
    quick
    max_allowed_packet = 16M

    [mysql]
    no-auto-rehash

    [myisamchk]
    key_buffer_size = 512M
    sort_buffer_size = 512M
    read_buffer = 8M
    write_buffer = 8M

    [mysqlhotcopy]
    interactive-timeout

    [mysqld_safe]
    open-files-limit = 8192

    [mysqld]
    explicit_defaults_for_timestamp
    innodb_use_native_aio=0
    datadir = /var/lib/mysql
    pid-file = /var/run/mysqld/mysqld.pid
    key-buffer-size = 32M
    myisam-recover = FORCE,BACKUP
    max-allowed-packet = 16M
    max-connect-errors = 1000000
    innodb = FORCE
    tmp-table-size = 32M
    max-heap-table-size = 32M
    max-connections = 500
    thread-cache-size = 50
    open-files-limit = 65535
    table-definition-cache = 1024
    table-open-cache = 2048
    log-error = /var/log/mysql/error.log
    log-queries-not-using-indexes = 0
    slow-query-log = 0
    slow-query-log-file = /var/log/mysql/slow.log

    # CACHES AND LIMITS #
    #table_cache = 16000
    tmp-table-size = 256M
    max-heap-table-size = 256M
    query-cache-type = 1
    query-cache-size = 2048M
    #query-cache-type = 0
    #query-cache-size = 0
    max-connections = 2000
    thread-cache-size = 50
    open-files-limit = 65535
    table-definition-cache = 8000
    table-open-cache = 8000
    key_buffer_size = 256M
    join_buffer_size = 512k
    thread_cache_size = 15000
    table_definition_cache = 16384
    table_open_cache = 16384
    innodb_write_io_threads = 16
    innodb_read_io_threads = 16
    back_log = 2048


    # INNODB #
    innodb_lock_wait_timeout = 60
    innodb_buffer_pool_instances = 8
    innodb_rollback_on_timeout = 0
    innodb-flush-method = O_DIRECT
    innodb-log-files-in-group = 2
    innodb-log-file-size = 128M
    #innodb-flush-log-at-trx-commit = 1
    innodb-file-per-table = 1
    innodb-buffer-pool-size = 4096M
    innodb-flush-log-at-trx-commit = 0

    [sst]
    streamfmt=xbstream

Working...
X