Good day to all. I want to run Percona XtraDb Cluster for testing purposes on ubuntu 14.04. Based on these two articles

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

I got to the place

And finally, restart the daemon:

And it does not start with me

$ 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!

There are several errors in the logs. Error number one:

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

Naturally 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 number 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

Everyone is advised to remove everything from the /var/lib/mysql folder and supposedly starts working. But I deleted and earned nothing.

My config 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 run? If anyone has a working configuration, please share.

    0