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 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?