Unable to start/Bootstrap Galera cluster after installing and configuring

[shashikanth M]

Hi all,

I am getting below message when trying to bootstrap first node after installing Galera/mysql software and configuring mysql.conf

#Start mysql error

root@rootuser:/home/user# sudo systemctl start mysql

Job for mysql.service failed because the control process exited with error code.

See "systemctl status mysql.service" and "journalctl -xe" for details.

root@ rootuser  /home/user# mysqld_bootstrap

Job for mysql.service failed because the control process exited with error code.

See "systemctl status mysql.service" and "journalctl -xe" for details.

root@ rootuser  :/home/user#

# mysql status

root@ rootuser    /home/user# sudo systemctl status mysql

● mysql.service - MySQL Wsrep Server

   Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: enabled)

   Active: activating (start-pre) since Thu 2021-09-30 13:24:20 UTC; 1s ago

Cntrl PID: 27201 (mysql-systemd-s)

    Tasks: 13 (limit: 4915)

   CGroup: /system.slice/mysql.service

           ├─27201 /bin/bash /usr/share/mysql/mysql-systemd-start pre

           └─27238 /usr/sbin/mysqld --user=mysql --wsrep_recover --log-error=/var/lib/mysql-files/tmp.bGCBRJgne8.log

Error log #

root@ rootuser   :/home/user# tail -f /var/lib/mysql-files/tmp.bGCBRJgne8.log

2021-09-30T13:24:22.440826Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1321261

2021-09-30T13:24:22.442677Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-09-30T13:24:22.442692Z 0 [Note] Shutting down plugin 'MEMORY'

2021-09-30T13:24:22.442698Z 0 [Note] Shutting down plugin 'CSV'

2021-09-30T13:24:22.442704Z 0 [Note] Shutting down plugin 'sha256_password'

2021-09-30T13:24:22.442707Z 0 [Note] Shutting down plugin 'mysql_native_password'

2021-09-30T13:24:22.442710Z 0 [Note] Shutting down plugin 'wsrep'

2021-09-30T13:24:22.442840Z 0 [Note] Shutting down plugin 'binlog'

2021-09-30T13:24:22.443115Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

# mysql.conf details are below

[mysqld]

pid-file        = /var/run/mysqld/mysqld.pid

socket          = /var/run/mysqld/mysqld.sock

datadir         = /var/lib/mysql

log-error       = /var/log/mysql/error.log

#log-bin=mysql-bin.log

bind-address=0.0.0.0

user=mysql

default_storage_engine=InnoDB

innodb_autoinc_lock_mode=2

innodb_flush_log_at_trx_commit=0

innodb_buffer_pool_size=256M

binglog_format=ROW

wsrep_on=ON

wsrep_provider=/usr/lib/galera/libgalera_smm.so

wsrep_node_name='galera-node1'

wsrep_node_address="IP1"

wsrep_cluster_name='galera-cluster'

wsrep_cluster_address="gcomm://IP1,IP2,IP3"

wsrep_provide_options="gcache.size=500M;gcache.page_size=500M"

wsrep_slave_thread=4

wsrep_sst_method=rsync

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

###Kindly suggest how to get this resolved.

[Colin Charles]

Can you show us what your mysql error log looks like and also, if you disabled SELinux? And maybe the command you used to bootstrap your cluster. Thanks