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_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