Before starting the node ensure that the auto.cnf file in the base directory is removed.
rm /var/lib/mysql/auto.cnfTo start the joiner node just start the MariaDB service.
In the message log the Starting MariaDB and Started MariaDB should be shown.
Jun 7 06:20:34 DB-10 systemd[1]: Starting MariaDB 10.5.10 database server...
Jun 7 06:20:48 DB-10 sh[9710]: WSREP: Recovered position 13159679-bdfa-11eb-9896-1b0ee5d3b1cc:3454031
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.10-MariaDB) starting as process 9902 ...
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 178127)
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Warning] Changed limits: max_open_files: 32768 max_connections: 29538 (was 50000) table_cache: 200 (was 8000)
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 13159679-bdfa-11eb-9896-1b0ee5d3b1cc:3454031
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so'
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Note] WSREP: wsrep_load(): Galera 26.4.8(r902dd268) by Codership Oy <info@codership.com> loaded successfully.
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Note] WSREP: Found saved state: 13159679-bdfa-11eb-9896-1b0ee5d3b1cc:-1, safe_to_bootstrap: 1
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Note] WSREP: GCache DEBUG: opened preamble:
..........................................................
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 13159679-bdfa-11eb-9896-1b0ee5d3b1cc, offset: -1
Jun 7 06:20:48 DB-10 mariadbd[9902]: 2021-06-07 6:20:48 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/107374182424 bytes) complete.
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (107374182424/107374182424 bytes) complete.
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 3442400-3454031
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/107357628840 bytes) complete.
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (107357628840/107357628840 bytes) complete.
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 3/11635 locked buffers
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 16554120/107374182400
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.21.227.40; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 102400M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: Service thread queue flushed.
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: ####### Assign initial position for certification: 13159679-bdfa-11eb-9896-1b0ee5d3b1cc:3454031, protocol version: -1
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: Start replication
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: Connecting with bootstrap option: 0
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: Setting GCS initial position to 13159679-bdfa-11eb-9896-1b0ee5d3b1cc:3454031
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: protonet asio version 0
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: Using CRC-32C for message checksums.
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: backend: asio
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: restore pc from disk successfully
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: GMCast version 0
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: (dc9112fb-b987, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: (dc9112fb-b987, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: EVS version 1
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: gcomm: connecting to group 'galera_cluster', peer '10.21.227.40:,10.21.227.39:'
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: (dc9112fb-b987, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://10.21.227.40:4567
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: (dc9112fb-b987, 'tcp://0.0.0.0:4567') connection established to dc9112fb-b986 tcp://10.21.227.39:4567
Jun 7 06:20:51 DB-10 mariadbd[9902]: 2021-06-07 6:20:51 0 [Note] WSREP: (dc9112fb-b987, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: EVS version upgrade 0 -> 1
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: (dc9112fb-b987, 'tcp://0.0.0.0:4567') turning message relay requesting off
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: PC protocol upgrade 0 -> 1
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Warning] WSREP: no nodes coming from prim view, prim not possible
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: view(view_id(NON_PRIM,dc9112fb-b987,5) memb {
Jun 7 06:20:54 DB-10 mariadbd[9902]: #011dc9112fb-b987,0
Jun 7 06:20:54 DB-10 mariadbd[9902]: } joined {
Jun 7 06:20:54 DB-10 mariadbd[9902]: } left {
Jun 7 06:20:54 DB-10 mariadbd[9902]: } partitioned {
Jun 7 06:20:54 DB-10 mariadbd[9902]: })
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: promote to primary component
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: view(view_id(PRIM,dc9112fb-b987,5) memb {
Jun 7 06:20:54 DB-10 mariadbd[9902]: #011dc9112fb-b987,0
Jun 7 06:20:54 DB-10 mariadbd[9902]: } joined {
Jun 7 06:20:54 DB-10 mariadbd[9902]: } left {
Jun 7 06:20:54 DB-10 mariadbd[9902]: } partitioned {
Jun 7 06:20:54 DB-10 mariadbd[9902]: })
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: save pc into disk
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: tcp://10.21.227.39:4567
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: forgetting dc9112fb-b986 (tcp://10.21.227.39:4567)
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: clear restored view
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: gcomm: connected
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: Opened channel 'galera_cluster'
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: Deferred close timer handle_wait Operation aborted. for 0x56350b000150
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: Flow-control interval: [16, 16]
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: Received NON-PRIMARY.
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: Deferred close timer destruct
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = yes, my_idx = 0, memb_num = 1
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 302900c7-c793-11eb-9245-da2c0118dfd8
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 302900c7-c793-11eb-9245-da2c0118dfd8
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Note] WSREP: STATE EXCHANGE: got state msg: 302900c7-c793-11eb-9245-da2c0118dfd8 from 0 (DB-02)
Jun 7 06:20:54 DB-10 mariadbd[9902]: 2021-06-07 6:20:54 0 [Warning] WSREP: Quorum: No node with complete state:
....................................
Jun 7 06:20:57 DB-10 mariadbd[9902]: 2021-06-07 6:20:57 0 [Note] WSREP: cleaning up dc9112fb-b986 (tcp://10.21.227.39:4567)
Jun 7 06:20:58 DB-10 mariadbd[9902]: 2021-06-07 6:20:58 0 [Note] WSREP: (dc9112fb-b987, 'tcp://0.0.0.0:4567') connection established to dc9112fb-b986 tcp://10.21.227.39:4567
Jun 7 06:20:58 DB-10 mariadbd[9902]: 2021-06-07 6:20:58 0 [Note] WSREP: (dc9112fb-b987, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
Jun 7 06:21:02 DB-10 mariadbd[9902]: 2021-06-07 6:21:02 0 [Note] WSREP: (dc9112fb-b987, 'tcp://0.0.0.0:4567') turning message relay requesting off
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] InnoDB: Completed initialization of buffer pool
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] InnoDB: 128 rollback segments are active.
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] InnoDB: 10.5.10 started; log sequence number 17400206932221; transaction id 121091564
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] Server socket created on IP: '0.0.0.0'.
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] WSREP: Server initialized
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] WSREP: Server status change initializing -> initialized
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] Reading of all Master_info entries succeeded
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] Added new Master_info '' to hash table
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 0 [Note] /usr/sbin/mariadbd: ready for connections.
Jun 7 06:21:03 DB-10 mariadbd[9902]: Version: '10.5.10-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 4 [Note] WSREP: Recovered cluster id 13159679-bdfa-11eb-9896-1b0ee5d3b1cc
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 2 [Note] WSREP: Server status change initialized -> joined
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 2 [Note] WSREP: Lowest cert index boundary for CC from group: 3454032
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 2 [Note] WSREP: Min available from gcache for CC from group: 3442400
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 2 [Note] WSREP: Server DB-02 synced with group
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 2 [Note] WSREP: Server status change joined -> synced
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 2 [Note] WSREP: Synchronized with group, ready for connections
Jun 7 06:21:03 DB-10 mariadbd[9902]: 2021-06-07 6:21:03 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Jun 7 06:21:03 DB-10 systemd[1]: Started MariaDB 10.5.10 database server.