Cannot cluster MySQL Database when try to make my stack highly available

asked 2017-07-16 19:02:33 -0500

rcgelber gravatar image

So I'm trying to make my openstack configuration at our data center highly available. When I follow the openstack HA guide I get stuck on making the stack on service mysql start --wsrep-new-cluster and i get the following error.

Any Ideas on how to solve this???

Error:

journalctl -xe

Jul 16 16:51:08 rno-a1-r2-u41 mysqld[31763]: 170716 16:51:08 [Note] InnoDB: Starting shutdown... Jul 16 16:51:09 rno-a1-r2-u41 mysqld[31763]: 170716 16:51:09 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool Jul 16 16:51:10 rno-a1-r2-u41 mysqld[31763]: 170716 16:51:10 [Note] InnoDB: Shutdown completed; log sequence number 1616787 Jul 16 16:51:10 rno-a1-r2-u41 mysqld[31763]: 170716 16:51:10 [Note] /usr/sbin/mysqld: Shutdown complete Jul 16 16:51:10 rno-a1-r2-u41 mysqld[31763]: Jul 16 16:51:10 rno-a1-r2-u41 mysqld_safe[31815]: mysqld from pid file /var/run/mysqld/mysqld.pid ended Jul 16 16:51:38 rno-a1-r2-u41 /etc/init.d/mysql[32073]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jul 16 16:51:38 rno-a1-r2-u41 /etc/init.d/mysql[32073]: [61B blob data] Jul 16 16:51:38 rno-a1-r2-u41 /etc/init.d/mysql[32073]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")' Jul 16 16:51:38 rno-a1-r2-u41 /etc/init.d/mysql[32073]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Jul 16 16:51:38 rno-a1-r2-u41 mysql[31539]: ...fail! Jul 16 16:51:38 rno-a1-r2-u41 /etc/init.d/mysql[32073]: Jul 16 16:51:38 rno-a1-r2-u41 systemd[1]: mysql.service: Control process exited, code=exited status=1 Jul 16 16:51:38 rno-a1-r2-u41 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon. Jul 16 16:51:38 rno-a1-r2-u41 systemd[1]: mysql.service: Unit entered failed state. Jul 16 16:51:38 rno-a1-r2-u41 systemd[1]: mysql.service: Failed with result 'exit-code'.

Config: /etc/mysql/conf.d/galera.cnf

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql binlog_format=ROW bind-address=10.11.2.3

InnoDB Configuration default_storage_engine=innodb innodb_autoinc_lock_mode=2 innodb_flush_log_at_trx_commit=0 innodb_buffer_pool_size=122M

Galera Cluster Configuration wsrep_provider=/usr/lib/libgalera_smm.so wsrep_provider_options='pc.recovery=TRUE;gcache.size=300M' wsrep_cluster_name='rno-sql' wsrep_cluster_address='gcomm://192.168.10.1,192.168.10.2' wsrep_sst_method=rsync

Galera Node Configuration wsrep_node_address=192.168.1.1 wsrep_node_name=rno-a1-r2-u41

Hosts

localhost 127.0.0.1 localhost rno-a1-r2-u41

Openstack Host File 10.11.2.2 controller 10.11.2.3 controller-u41 10.11.2.4 controller-u38 10.11.2.5 compute-u36 10.11.2.6 compute-u34 10.11.2.7 compute-u32 10.11.2.8 compute-u30 10.11.2.9 compute-u19 10.11.2.10 compute-u17 10.11.2.11 compute-u15 10.11.2.12 compute-u13 10.11.2.13 compute-u11

edit retag flag offensive close merge delete