求解:mysql-5.6,搭建galera 集群出现的问题。数据库添加集群相关参数后就起不来

报错:
2016-08-18 13:49:00 24069 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'wsrep_provider=/usr/lib64/libgalera_smm.so'
2016-08-18 13:49:00 24069 [ERROR] Aborting
配置:
[mysqld]
pid-file=/usr/local/mysql/mysql_db3.pid
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
query_cache_size=0
query_cache_type=0
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_name="my_wsrep_cluster"
wsrep_cluster_address="gcomm://192.168.0.15,192.168.0.16,192.168.0.17"
wsrep_node_name=17
wsrep_node_address=17
wsrep_slave_threads=4
wsrep_sst_method=rsync
wsrep_sst_auth=sst:bjyappam
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
innodb_buffer_pool_size = 5000M
thread_concurrency = 10
character_set_server=utf8
max_allowed_packet=256M
log-bin=mysql-bin
lower_case_table_names=1
basedir=/usr/local/mysql
datadir=/data1/data
binlog_format=row
server-id = 3
innodb_flush_log_at_trx_commit = 0

2个回答

sql-5.6,搭建galera 集群出现的问题。数据库添加集群相关参数后就起不来
报错:
2016-08-18 13:49:00 24069 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'wsrep_provider=/usr/lib64/libgalera_smm.so'
2016-08-18 13:49:00 24069 [ERROR] Aborting
配置:
[mysqld]
pid-file=/usr/local/mysql/mysql_db3.pid
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
query_cache_size=0
query_cache_type=0
wsrep_provider=/usr/lib64/libgalera_smm.s

/usr/lib64/libgalera_smm.s

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问