Not the answer you need?
Register and ask your own question!

Slow replication between nodes

lukyryslukyrys EntrantInactive User Role Beginner
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


[email protected]:~# cat /etc/mysql/my.cnf
[client]
port = 3306
#socket = @[email protected]

[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_limit=512;gcs.fc_master_slave=YES;evs.user_send_window=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 = "user:pass"
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
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.