Skip to content

Instantly share code, notes, and snippets.

@xiangchu0
Created August 12, 2017 08:54
Show Gist options
  • Select an option

  • Save xiangchu0/8134cd163f44939f7da4323ab412f292 to your computer and use it in GitHub Desktop.

Select an option

Save xiangchu0/8134cd163f44939f7da4323ab412f292 to your computer and use it in GitHub Desktop.
pxc onenode install for debug
[client]
socket=/go/pxc/data1/mysql.sock
user=root
password=Cde!@#123
[mysqld]
user=mysql
datadir=/go/pxc/data1
socket=/go/pxc/data1/mysql.sock
pid-file=/go/pxc/data1/mysql-node1.pid
port=3316
character_set_server = utf8
symbolic-links=0
wsrep_provider=/go/pxc/lib/libgalera_smm.so
wsrep_cluster_address=gcomm://127.0.0.1:4577,127.0.0.1:4587,127.0.0.1:4597
wsrep_provider_options = "base_port=4577;"
binlog_format=ROW
default_storage_engine=InnoDB
wsrep_slave_threads= 8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_cluster_name=standalone
wsrep_node_name=node1
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth="root:Cde!@#123"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment