MariaDB galera cluster not starting.

[Musbbar Variance]

Hello All,

I have setup 3 node and installing MariaDB 10.5.5 and setup galera cluster.

when i start first node with this command "galera_new_cluster" than MariaDB is start but when i going in second and third node and run this command "systemctl start mariadb" than MariaDB not started and its give me this error.

------------------------------------------------------------------------------------------------------------------------------------------------------------------

ERROR

● mariadb.service - MariaDB 10.5.5 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Fri 2020-09-18 08:58:30 UTC; 10s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 17611 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 17609 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 18028 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 17758 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environme
  Process: 17756 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 17745 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 18028 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 mariadbd[18028]: 2020-09-18  8:58:30 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary vie
Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 mariadbd[18028]:          at gcomm/src/pc.cpp:connect():160
Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 mariadbd[18028]: 2020-09-18  8:58:30 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():220: Failed to open backend connecti
Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 mariadbd[18028]: 2020-09-18  8:58:30 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1632: Failed to open channel 'db_cluster' at '
Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 mariadbd[18028]: 2020-09-18  8:58:30 0 [ERROR] WSREP: gcs connect failed: Connection timed out
Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 mariadbd[18028]: 2020-09-18  8:58:30 0 [ERROR] WSREP: wsrep::connect(gcomm://128.199.x.x,165.22.x.x,159.89.x.x) faile
Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 mariadbd[18028]: 2020-09-18  8:58:30 0 [ERROR] Aborting
Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 18 08:58:30 ubuntu-s-slave1-1vcpu-1gb-blr1-01 systemd[1]: Failed to start MariaDB 10.5.5 database server.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I have create galera file in : /etc/mysql/conf.d/galera.cnf.

In that file i have set this.

[mariadb]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so

# Galera Cluster Configuration
wsrep_cluster_name="db_cluster"
wsrep_cluster_address="gcomm://128.199.x.x,165.22.x.x,159.89.x.x"

# Galera Synchronization Configuration
wsrep_sst_method=rsync

# Galera Node Configuration
wsrep_node_address="159.89.x.x"
wsrep_node_name="Node3"

[micah milano]

The full log is not there, but it appears to fail to connect to the ips that you have set in the gcomm:// check that you can connect to those ips and the galera ports that should be open on your firewall