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

求解: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 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像,如何解决?
  • ¥15 求daily translation(DT)偏差订正方法的代码
  • ¥15 js调用html页面需要隐藏某个按钮
  • ¥15 ads仿真结果在圆图上是怎么读数的
  • ¥20 Cotex M3的调试和程序执行方式是什么样的?
  • ¥20 java项目连接sqlserver时报ssl相关错误
  • ¥15 一道python难题3
  • ¥15 牛顿斯科特系数表表示
  • ¥15 arduino 步进电机
  • ¥20 程序进入HardFault_Handler