wangxuemei1121
wangxuemei1121
2016-08-18 06:03

求解: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条回答

为你推荐