I have a 2-node fresh Galera Cluster in 2 DCs. I Import a 3GB dump into one node and the other starts to sync. After importing dump, I check the size and rows on both nodes and they are not equal. This is my galera.cnf ( Customized for WAN env )
[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
# Galera Cluster Configuration
wsrep_cluster_name="my-company"
wsrep_cluster_address="gcomm://XXXX,YYYY"
# Galera Synchronization Configuration
wsrep_sst_method=rsync
# Galera Node Configuration
wsrep_node_address="XXXX"
wsrep_node_name="Node-1"
# Galera Custome setting for WAN
wsrep_provider_options="evs.suspect_timeout=PT1M"
wsrep_provider_options="evs.inactive_timeout=PT1M"
wsrep_provider_options="evs.send_window=512"
wsrep_provider_options="evs.user_send_window=512"
wsrep_provider_options="evs.inactive_check_period=PT30S"
wsrep_provider_options="gcs.fc_factor=1"
wsrep_provider_options="gcs.fc_limit=260"
wsrep_provider_options="gcs.max_packet_size=2097152"
This is Databases size after import dump:
Node1: 27329.4 MB
Node2: 17570.1 MB
This is bandwidth usage on the node that I imported dump:
Why many record did't insert? It's about mysql tuning or something else?
Ubuntu 18.0.4
mysql-wsrep-server-5.7
8 Core cpu, 16GB Ram
I hope someone can help, Thanks a lot.
mysqldump
? Did it give any errors?