2

All the good days. I want to run for test purposes Percona XtraDb Cluster on ubuntu 14.04. The basis here took these two articles

  1. https://habrahabr.ru/post/152969/
  2. https://www.percona.com/doc/percona-xtradb-cluster/5.6/manual/bootstrap.html

I came instead

Ну и в завершение, перезапускаем демона:

The daemon does not start

$ sudo /etc/init.d/mysql start  
 * Starting MySQL (Percona XtraDB Cluster) database server mysqld 
 * The server quit without updating PID file (/var/lib/mysql/vagrant-ubuntu-trusty-64.pid).
   ...fail!

The logs several errors. Error one:

[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

Sure I ran mysql_upgrade, but it does not work

$ sudo mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed

Error two:

160502 14:56:26 [ERROR] Plugin 'InnoDB' init function returned error. 160502 14:56:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 160502 14:56:26 [ERROR] Unknown/unsupported storage engine: InnoDB 160502 14:56:26 [ERROR] Aborting

All are advised to remove all of the folders / var / lib / mysql and supposedly starts. But I deleted and nothing worked.

My file my.cnf

[mysqld_safe]
# wsrep_urls=gcomm://192.168.33.101:3400,gcomm://192.168.33.102:3400,gcomm://
#wsrep_urls=gcomm://192.168.33.101:3400,gcomm://

[mysqld]
innodb_log_file_size=256M
wsrep_cluster_address=gcomm://192.168.33.101
port=3306
socket=/var/run/mysqld/mysqld.sock
datadir=/var/lib/mysql
basedir=/usr
user=mysql
log_error=/var/log/mysql.err
binlog_format=ROW
default_storage_engine=InnoDB
wsrep_provider=/usr/lib/libgalera_smm.so
wsrep_sst_receive_address=192.168.33.101:3500
wsrep_node_incoming_address=192.168.33.101
wsrep_slave_threads=2
wsrep_cluster_name=cluster0
wsrep_provider_options="gmcast.listen_addr=tcp://192.168.33.101:3400;"
wsrep_sst_method=xtrabackup
wsrep_sst_auth=backup:password
wsrep_node_name=node0
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_buffer_pool_size=5000M
innodb_log_file_size=256M
innodb_log_buffer_size=4M

[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

Actually the question: how to start? If there is anyone working configuration, then please share.

dlarchikov
  • 121
  • 4

1 Answers1

0

I think the path to galera library causes the "error two". You should try this: wsrep_provider=/usr/lib/galera3/libgalera_smm.so

pinGu
  • 140
  • 1
  • 1
  • 7