wangxuemei1121 2016-08-18 06:03 采纳率: 0%
浏览 3136

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

  • 普通网友 2016-10-03 16:41
    关注

    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

    评论

报告相同问题?

悬赏问题

  • ¥15 深度学习根据CNN网络模型,搭建BP模型并训练MNIST数据集
  • ¥15 lammps拉伸应力应变曲线分析
  • ¥15 C++ 头文件/宏冲突问题解决
  • ¥15 用comsol模拟大气湍流通过底部加热(温度不同)的腔体
  • ¥50 安卓adb backup备份子用户应用数据失败
  • ¥20 有人能用聚类分析帮我分析一下文本内容嘛
  • ¥15 请问Lammps做复合材料拉伸模拟,应力应变曲线问题
  • ¥30 python代码,帮调试,帮帮忙吧
  • ¥15 #MATLAB仿真#车辆换道路径规划
  • ¥15 java 操作 elasticsearch 8.1 实现 索引的重建