Skip to content

ureyni/percona_replicationtest

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

we use percona mysql cluster 5.5, 5.6 , 5.7

test table CREATE TABLE test.ondisk (c1 int(11) NOT NULL,c2 varchar(32) DEFAULT NULL,PRIMARY KEY (c1)) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Environment :
Node Configuration :
OS : CentOS Linux release 7.3.1611 (Core)
Hardware : virtual machine with 2 core , 4GB ram , 10G/s eth speed
Percona : Percona XtraDB Cluster (GPL), Release rel18, Revision 4a4da7e, WSREP version 29.24, wsrep_29.24
version 5.7.20-18-57-log , innodb_version 5.7.20-18 , protocol_version 10
Nodes : 10.145.172.61,62,63
proxysql : 10.145.172.60

wsrep.conf : 
wsrep_sync_wait=1
wsrep_causal_reads=ON

sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

max_connections=10000
open_files_limit=32768
wsrep_provider_options="pc.ignore_quorum=true;pc.ignore_sb=true;gcache.size=2G; gcache.page_size=1G;gcs.fc_limit = 256; gcs.fc_factor = 0.99;"
wsrep_slave_threads=32

[sst]
inno-apply-opts="--use-memory=8G"
compressor="pigz"
decompressor="pigz -d"

About

No description or website provided.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages