Problem with MariaDB

Hello! Did a fresh install in Alma and somehow MariaDB did not installed?
I get Unit mariadb.service could not be found. How can i reinstall MariaDB?


Please fill in any relevant information that applies to you:

• CentOS Version: AlmaLinux OS 9.4 Minimal
• Centmin Mod Version Installed: 131.00stable.b058
• Nginx Version Installed: nginx/1.27.2 (061124-011312-almalinux9-kvm-4a3b366)
• PHP Version Installed: PHP 8.3.13 (cli) (built: Nov 6 2024 01:35:41) (NTS)
• MariaDB MySQL Version Installed:
  mysqladmin: connect to server at 'localhost' failed
  error: 'Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)'
  Check that mariadbd is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
• When was last time updated Centmin Mod code base ? : Already up to date.
• Persistent Config: LETSENCRYPT_DETECT='y'

---

 

i guess i've messed up with Initial Centmin Mod installation needs to be done as full root user rather than as sudo user and centmin.sh shell based menu needs to be run as full root user., as i've installed cmm with sudo.

 

Well, tried on a fresh install with root — same thing. MariaDB is not here.

 

Thanks ! I've checked logs and found a problem - script tries to install MariaDB from .ua Mirrors, which are blocked in my country. Is there any workaround?

 

Snippet of installer log with MariaDB errors. Strange that install failed, but installer keeps on going.

Spoiler

Code (Text):

         __  __               _         ____   ____    _   ___     __  
        |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   / /_
        | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | | | '_ \
        | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_| (_) |
        |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)\___/
                                                                       
          __   __                   ___              _          _  _
          \ \ / /_   _  _ __ ___   |_ _| _ __   ___ | |_  __ _ | || |
           \ V /| | | || '_ ` _ \   | | | '_ \ / __|| __|/ _` || || |
            | | | |_| || | | | | |  | | | | | |\__ \| |_| (_| || || |
            |_|  \__,_||_| |_| |_| |___||_| |_||___/ \__|\__,_||_||_|
                                                                   
MariaDB 10.6 YUM install...
                                ____         _  
                               / ___|   ___ | |_
                               \___ \  / _ \| __|
                                ___) ||  __/| |_
                               |____/  \___| \__|
                                               
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|
                                             |___/                    

Copying MariaDB my-mdb10.cnf file to /etc/my.cnf

Dependencies resolved.
================================================================================
 Package             Arch        Version                  Repository       Size
================================================================================
Removing:
 mytop               noarch      1.7-24.b737f60.el9       @epel            67 k
Removing unused dependencies:
 perl-DBD-MySQL      x86_64      4.050-13.el9             @appstream      364 k
 perl-DBI            x86_64      1.643-9.el9              @appstream      1.9 M

Transaction Summary
================================================================================
Remove  3 Packages

Freed space: 2.3 M
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                        1/1
  Erasing          : mytop-1.7-24.b737f60.el9.noarch                        1/3
  Erasing          : perl-DBD-MySQL-4.050-13.el9.x86_64                     2/3
  Erasing          : perl-DBI-1.643-9.el9.x86_64                            3/3
  Running scriptlet: perl-DBI-1.643-9.el9.x86_64                            3/3
  Verifying        : mytop-1.7-24.b737f60.el9.noarch                        1/3
  Verifying        : perl-DBD-MySQL-4.050-13.el9.x86_64                     2/3
  Verifying        : perl-DBI-1.643-9.el9.x86_64                            3/3

Removed:
  mytop-1.7-24.b737f60.el9.noarch       perl-DBD-MySQL-4.050-13.el9.x86_64    
  perl-DBI-1.643-9.el9.x86_64        

Complete!
time yum -q -y install perl-DBI

Installed:
  perl-DBI-1.643-9.el9.x86_64                                                  


real    0m23.752s
user    0m4.307s
sys    0m0.722s

[1;32;40mMariaDB 10.6.x YUM install...
[m[1;32;40myum -q -y install MariaDB-client MariaDB-common MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel

Last metadata expiration check: 0:00:19 ago on Wed 06 Nov 2024 01:09:30 AM EST.
Dependencies resolved.
================================================================================
 Package              Arch      Version                Repository          Size
================================================================================
Installing:
 MariaDB-client       x86_64    10.6.20-1.el9          mariadb            8.5 M
 MariaDB-common       x86_64    10.6.20-1.el9          mariadb             88 k
 MariaDB-devel        x86_64    10.6.20-1.el9          mariadb            7.9 M
 MariaDB-server       x86_64    10.6.20-1.el9          mariadb             18 M
 MariaDB-shared       x86_64    10.6.20-1.el9          mariadb            131 k
     replacing  mariadb-connector-c.x86_64 3.2.6-1.el9_0
     replacing  mariadb-connector-c-config.noarch 3.2.6-1.el9_0
Installing dependencies:
 galera-4             x86_64    26.4.20-1.el9          mariadb            1.4 M
 perl-Sys-Hostname    x86_64    1.23-481.el9           appstream           16 k
 rsync                x86_64    3.3.0-1.el9            backports-rsync    413 k
Installing weak dependencies:
 socat                x86_64    1.7.4.1-5.el9_4.2      appstream          299 k

Transaction Summary
================================================================================
Install  9 Packages

Total download size: 36 M
Downloading Packages:
(1/9): perl-Sys-Hostname-1.23-481.el9.x86_64.rp 513 kB/s |  16 kB     00:00  
(2/9): socat-1.7.4.1-5.el9_4.2.x86_64.rpm       4.8 MB/s | 299 kB     00:00  
(3/9): rsync-3.3.0-1.el9.x86_64.rpm             1.3 MB/s | 413 kB     00:00  
(4/9): MariaDB-common-10.6.20-1.el9.x86_64.rpm   81 kB/s |  88 kB     00:01  
(5/9): MariaDB-client-10.6.20-1.el9.x86_64.rpm  5.1 MB/s | 8.5 MB     00:01  
(6/9): MariaDB-server-10.6.20-1.el9.x86_64.rpm   20 MB/s |  18 MB     00:00  
(7/9): MariaDB-shared-10.6.20-1.el9.x86_64.rpm  381 kB/s | 131 kB     00:00  
(8/9): galera-4-26.4.20-1.el9.x86_64.rpm        6.3 MB/s | 1.4 MB     00:00  
[MIRROR] MariaDB-devel-10.6.20-1.el9.x86_64.rpm: Curl error (28): Timeout was reached for https://fastmirror.pp.ua/mariadb/mariadb-10.6.20/yum/rhel/9/x86_64/rpms/MariaDB-devel-10.6.20-1.el9.x86_64.rpm [Failed to connect to fastmirror.pp.ua port 443: Connection timed out]
[MIRROR] MariaDB-devel-10.6.20-1.el9.x86_64.rpm: Curl error (28): Timeout was reached for https://fastmirror.pp.ua/mariadb/mariadb-10.6.20/yum/rhel/9/x86_64/rpms/MariaDB-devel-10.6.20-1.el9.x86_64.rpm [Failed to connect to fastmirror.pp.ua port 443: Connection timed out]
[MIRROR] MariaDB-devel-10.6.20-1.el9.x86_64.rpm: Curl error (28): Timeout was reached for https://fastmirror.pp.ua/mariadb/mariadb-10.6.20/yum/rhel/9/x86_64/rpms/MariaDB-devel-10.6.20-1.el9.x86_64.rpm [Failed to connect to fastmirror.pp.ua port 443: Connection timed out]
[MIRROR] MariaDB-devel-10.6.20-1.el9.x86_64.rpm: Curl error (28): Timeout was reached for https://fastmirror.pp.ua/mariadb/mariadb-10.6.20/yum/rhel/9/x86_64/rpms/MariaDB-devel-10.6.20-1.el9.x86_64.rpm [Failed to connect to fastmirror.pp.ua port 443: Connection timed out]
[FAILED] MariaDB-devel-10.6.20-1.el9.x86_64.rpm: No more mirrors to try - All mirrors were already tried without success

The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing 'yum clean packages'.
Error: Error downloading packages:
  MariaDB-devel-10.6.20-1.el9.x86_64: Cannot download, all mirrors were already tried without success

real    1m3.417s
user    0m1.663s
sys    0m0.320s
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|
                                             |___/                    
                                      _           _                  _        
  ___  ___   _ __ ___   _ __    __ _ | |_    ___ | |__    ___   ___ | | __ ___
 / __|/ _ \ | '_ ` _ \ | '_ \  / _` || __|  / __|| '_ \  / _ \ / __|| |/ // __|
| (__| (_) || | | | | || |_) || (_| || |_  | (__ | | | ||  __/| (__ |   < \__ \
 \___|\___/ |_| |_| |_|| .__/  \__,_| \__|  \___||_| |_| \___| \___||_|\_\|___/
                       |_|                                                    

         __  __               _         ____   ____    _   ___     __  
        |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   / /_
        | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | | | '_ \
        | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_| (_) |
        |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)\___/
                                                                       
                   ____                      _   __  _      
                  / ___|  _ __    ___   ___ (_) / _|(_)  ___
                  \___ \ | '_ \  / _ \ / __|| || |_ | | / __|
                   ___) || |_) ||  __/| (__ | ||  _|| || (__
                  |____/ | .__/  \___| \___||_||_|  |_| \___|
                         |_|                                
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|
                                             |___/                    

                                  _   _                          _  _      
    _ __ ___   _   _  ___   __ _ | | | |_  _ __ ___   _ __    __| |(_) _ __
   | '_ ` _ \ | | | |/ __| / _` || | | __|| '_ ` _ \ | '_ \  / _` || || '__|
   | | | | | || |_| |\__ \| (_| || | | |_ | | | | | || |_) || (_| || || |  
   |_| |_| |_| \__, ||___/ \__, ||_|  \__||_| |_| |_|| .__/  \__,_||_||_|  
               |___/          |_|                    |_|                  
                                     _                
                          ___   ___ | |_  _   _  _ __
                         / __| / _ \| __|| | | || '_ \
                         \__ \|  __/| |_ | |_| || |_) |
                         |___/ \___| \__| \__,_|| .__/
                                                |_|  
setup /var/log/mysqld.log
chown: invalid user: ‘mysql:mysql’
-rw------- 1 root root 0 Nov  6 01:10 /var/log/mysqld.log

systemctl restart mariadb.service
Failed to restart mariadb.service: Unit mariadb.service not found.

NotifyAccess=none
ManagedOOMSwap=auto
ManagedOOMMemoryPressure=auto
ManagedOOMMemoryPressureLimit=0
ManagedOOMPreference=none
LimitNOFILE=1073741816
LimitNOFILESoft=1073741816
OOMScoreAdjust=0

             __  __               _         ____   ____    _   ___
            |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \
            | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |
            | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |
            |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/
                                                                   
                     ____   _                _            
                    |  _ \ | | _   _   __ _ (_) _ __   ___
                    | |_) || || | | | / _` || || '_ \ / __|
                    |  __/ | || |_| || (_| || || | | |\__ \
                    |_|    |_| \__,_| \__, ||_||_| |_||___/
                                      |___/              
------------------------------------------------
Installing MariaDB 10 plugins
------------------------------------------------
mysql -e "INSTALL SONAME 'metadata_lock_info';"
/usr/local/src/centminmod/inc/mariadb_install106.inc: line 1181: mysql: command not found
mysql -e "INSTALL SONAME 'query_cache_info';"
/usr/local/src/centminmod/inc/mariadb_install106.inc: line 1183: mysql: command not found
mysql -e "INSTALL SONAME 'query_response_time';"
/usr/local/src/centminmod/inc/mariadb_install106.inc: line 1185: mysql: command not found
mysql -t -e "SELECT * FROM mysql.plugin;"
/usr/local/src/centminmod/inc/mariadb_install106.inc: line 1192: mysql: command not found
mysql -t -e "SHOW PLUGINS;"
/usr/local/src/centminmod/inc/mariadb_install106.inc: line 1194: mysql: command not found
mysql -t -e "SHOW ENGINES;"
/usr/local/src/centminmod/inc/mariadb_install106.inc: line 1196: mysql: command not found


Installed:
  perl-DBD-MySQL-4.050-13.el9.x86_64                                          

Last metadata expiration check: 0:00:04 ago on Wed 06 Nov 2024 01:10:54 AM EST.
Dependencies resolved.
================================================================================
 Package         Architecture   Version                 Repository         Size
================================================================================
Installing:
 postfix         x86_64         2:3.5.9-24.el9          appstream         1.4 M

Transaction Summary
================================================================================
Install  1 Package

Total download size: 1.4 M
Installed size: 4.4 M
Downloading Packages:
postfix-3.5.9-24.el9.x86_64.rpm                  11 MB/s | 1.4 MB     00:00  
--------------------------------------------------------------------------------
Total                                           2.1 MB/s | 1.4 MB     00:00    
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                        1/1
  Running scriptlet: postfix-2:3.5.9-24.el9.x86_64                          1/1
  Installing       : postfix-2:3.5.9-24.el9.x86_64                          1/1
  Running scriptlet: postfix-2:3.5.9-24.el9.x86_64                          1/1
  Verifying        : postfix-2:3.5.9-24.el9.x86_64                          1/1

Installed:
  postfix-2:3.5.9-24.el9.x86_64                                                

Complete!

real    0m9.887s
user    0m6.675s
sys    0m1.395s
Last metadata expiration check: 0:00:14 ago on Wed 06 Nov 2024 01:10:54 AM EST.
Dependencies resolved.
================================================================================
 Package                 Architecture Version             Repository       Size
================================================================================
Installing:
 MariaDB-client          x86_64       10.6.20-1.el9       mariadb         8.5 M
Installing dependencies:
 MariaDB-common          x86_64       10.6.20-1.el9       mariadb          88 k
 MariaDB-shared          x86_64       10.6.20-1.el9       mariadb         131 k
     replacing  mariadb-connector-c.x86_64 3.2.6-1.el9_0
     replacing  mariadb-connector-c-config.noarch 3.2.6-1.el9_0
 perl-Sys-Hostname       x86_64       1.23-481.el9        appstream        16 k

Transaction Summary
================================================================================
Install  4 Packages

Total download size: 8.7 M
Downloading Packages:
(1/4): perl-Sys-Hostname-1.23-481.el9.x86_64.rp 507 kB/s |  16 kB     00:00  
(2/4): MariaDB-common-10.6.20-1.el9.x86_64.rpm   81 kB/s |  88 kB     00:01  
(3/4): MariaDB-client-10.6.20-1.el9.x86_64.rpm  5.1 MB/s | 8.5 MB     00:01  
[MIRROR] MariaDB-shared-10.6.20-1.el9.x86_64.rpm: Curl error (28): Timeout was reached for https://fastmirror.pp.ua/mariadb/mariadb-10.6.20/yum/rhel/9/x86_64/rpms/MariaDB-shared-10.6.20-1.el9.x86_64.rpm [Failed to connect to fastmirror.pp.ua port 443: Connection timed out]
(4/4): MariaDB-shared-10.6.20-1.el9.x86_64.rpm  8.2 kB/s | 131 kB     00:15  
--------------------------------------------------------------------------------
Total                                           542 kB/s | 8.7 MB     00:16    
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                        1/1
  Installing       : MariaDB-shared-10.6.20-1.el9.x86_64                    1/6
  Running scriptlet: MariaDB-shared-10.6.20-1.el9.x86_64                    1/6
  Installing       : MariaDB-common-10.6.20-1.el9.x86_64                    2/6
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew

  Installing       : perl-Sys-Hostname-1.23-481.el9.x86_64                  3/6
  Installing       : MariaDB-client-10.6.20-1.el9.x86_64                    4/6
  Obsoleting       : mariadb-connector-c-3.2.6-1.el9_0.x86_64               5/6
  Obsoleting       : mariadb-connector-c-config-3.2.6-1.el9_0.noarch        6/6
  Running scriptlet: mariadb-connector-c-config-3.2.6-1.el9_0.noarch        6/6
  Verifying        : perl-Sys-Hostname-1.23-481.el9.x86_64                  1/6
  Verifying        : MariaDB-client-10.6.20-1.el9.x86_64                    2/6
  Verifying        : MariaDB-common-10.6.20-1.el9.x86_64                    3/6
  Verifying        : MariaDB-shared-10.6.20-1.el9.x86_64                    4/6
  Verifying        : mariadb-connector-c-3.2.6-1.el9_0.x86_64               5/6
  Verifying        : mariadb-connector-c-config-3.2.6-1.el9_0.noarch        6/6

Installed:
  MariaDB-client-10.6.20-1.el9.x86_64   MariaDB-common-10.6.20-1.el9.x86_64  
  MariaDB-shared-10.6.20-1.el9.x86_64   perl-Sys-Hostname-1.23-481.el9.x86_64

Complete!
----------------------------------------------
Creating /etc/logrotate.d/mysql file
----------------------------------------------
......
----------------------------------------------
Creating /etc/logrotate.d/mysql-slowlog file
----------------------------------------------
......
----------------------------------------------------------------------------
/var/log/mysqld.log {
  create 600 mysql mysql
  dateext
  notifempty
  daily
  rotate 8
  missingok
  compress
  sharedscripts
  postrotate
  if test -x /usr/bin/mysqladmin && /usr/bin/mysqladmin ping &>/dev/null      
  then
    env HOME=/root/ /usr/bin/mysql -e 'select @@global.long_query_time into @lqt_save; set global long_query_time=2000; select sleep(2); FLUSH LOGS; select sleep(2); set global long_query_time=@lqt_save;'
  fi
  endscript
}
----------------------------------------------------------------------------
/var/lib/mysql/slowq.log {
  create 600 mysql mysql
  dateext
  notifempty
  daily
  rotate 8
  missingok
  compress
  sharedscripts
  postrotate
  # just if mysqld is really running
  if test -x /usr/bin/mysqladmin &&
    /usr/bin/mysqladmin ping &>/dev/null      
  then
    env HOME=/root/ /usr/bin/mysql -e 'select @@global.long_query_time into @lqt_save; set global long_query_time=2000; set global slow_query_log = 0; select sleep(2); FLUSH LOGS; select sleep(2); set global long_query_time=@lqt_save; set global slow_query_log = 1;' > /var/log/mysqladmin.flush-logs 2>&1
  fi  
  endscript
}
----------------------------------------------------------------------------
---------------------------------------------------------------------------
Current mysql log directories:
---------------------------------------------------------------------------
ls -lh /var/log/ | egrep 'mysql|mysql-slowlog'
-rw-------  1 root   root      0 Nov  6 01:10 mysqld.log
---------------------------------------------------------------------------
---------------------------------------------------------------------------

----------------------------------------------------------------------------
mysql logrotation /etc/logrotate.d/mysql & /etc/logrotate.d/mysql-slowlog setup completed
----------------------------------------------------------------------------
            _   _                   ___         _  _    _         _
           | \ | |  ___ __      __ |_ _| _ __  (_)| |_ (_)  __ _ | |
           |  \| | / _ \\ \ /\ / /  | | | '_ \ | || __|| | / _` || |
           | |\  ||  __/ \ V  V /   | | | | | || || |_ | || (_| || |
           |_| \_| \___|  \_/\_/   |___||_| |_||_| \__||_| \__,_||_|
                                                                   
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|
                                             |___/                    
new initial /etc/my.cnf
=================================================
[client]
socket=/var/lib/mysql/mysql.sock

[mysql]
max_allowed_packet = 48M

[mysqld]
local-infile=0
ignore_db_dirs=lost+found
character-set-server=utf8mb4
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

#bind-address=127.0.0.1
# optimized my.cnf for MariaDB 5.5.x
# by eva2000
# centminmod.com

tmpdir=/home/mysqltmp

innodb=ON
#skip-federated
##skip-pbxt
##skip-pbxt_statistics
#skip-archive
#skip-name-resolve
#old_passwords
back_log = 200
max_connections = 200
key_buffer_size = 32M
myisam_sort_buffer_size = 64M
myisam_max_sort_file_size = 2048M
join_buffer_size = 128K
read_buffer_size = 128K
sort_buffer_size = 256K
table_definition_cache = 8192
table_open_cache = 4096
thread_cache_size = 128
wait_timeout = 1800
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 48M
#max_seeks_for_key = 4294967295
#group_concat_max_len = 1024
max_length_for_sort_data = 1024
net_buffer_length = 8192
max_connect_errors = 100000
concurrent_insert = 2
read_rnd_buffer_size = 256K
bulk_insert_buffer_size = 8M
# query_cache boost for MariaDB >10.1.2+
# https://community.centminmod.com/posts/30811/
query_cache_limit = 1024K
query_cache_size = 64M
query_cache_type = 1
query_cache_min_res_unit = 2K
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = InnoDB

log_warnings=1
slow_query_log=0
long_query_time=1
slow_query_log_file=/var/lib/mysql/slowq.log
log-error=/var/log/mysqld.log

# innodb settings
innodb_purge_threads=1
innodb_file_per_table = 1
innodb_open_files = 4000
innodb_data_file_path= ibdata1:10M:autoextend
innodb_buffer_pool_size = 192M

## https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#innodb_buffer_pool_instances
#innodb_buffer_pool_instances=1

innodb_log_file_size = 128M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout=50
innodb_flush_method = O_DIRECT

# 200 * # DISKS
innodb_io_capacity = 200
innodb_io_capacity_max = 2000
innodb_read_io_threads = 2
innodb_write_io_threads = 2
innodb_flush_neighbors = 1

# mariadb settings
[mariadb]
#thread-handling = pool-of-threads
#thread-pool-size= 20
#mysql --port=3307 --protocol=tcp
#extra-port=3307
#extra-max-connections=1

userstat = 0
key_cache_segments = 1
aria_group_commit = none
aria_group_commit_interval = 0
aria_log_file_size = 32M
aria_log_purge_type = immediate
aria_pagecache_buffer_size = 32M
aria_sort_buffer_size = 32M

[mariadb-5.5]
innodb_file_per_table = 1

#ignore_db_dirs=
query_cache_strip_comments=0

innodb_read_ahead = linear
innodb_adaptive_flushing_method = estimate
innodb_flush_neighbor_pages = 1
innodb_stats_update_need_lock = 0
innodb_log_block_size = 512

log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

[mysqld_safe]
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
#nice = -5
open-files-limit = 8192

[mysqldump]
default-character-set=utf8mb4
quick
max_allowed_packet = 48M

[myisamchk]
tmpdir=/home/mysqltmp
key_buffer = 32M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

[mariadb-10.0]
innodb_file_per_table = 1

# 2 variables needed to switch from XtraDB to InnoDB plugins
#plugin-load=ha_innodb
#ignore_builtin_innodb

## MariaDB 10 only save and restore buffer pool pages
## warm up InnoDB buffer pool on server restarts
#innodb_buffer_pool_dump_at_shutdown=1
#innodb_buffer_pool_load_at_startup=1
innodb_buffer_pool_populate=0
## Disabled settings
performance_schema=OFF
innodb_stats_on_metadata=OFF
innodb_sort_buffer_size=2M
innodb_online_alter_log_max_size=128M
query_cache_strip_comments=0
log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

[mariadb-10.6]
#innodb_file_format = Barracuda
innodb_default_row_format = dynamic
innodb_file_per_table = 1

# performance regressions
# https://jira.mariadb.org/browse/MDEV-16337
# https://jira.mariadb.org/browse/MDEV-20697
#join_cache_level=0
optimizer_use_condition_selectivity=1

## wsrep specific
# wsrep_on=OFF
# wsrep_provider
# wsrep_cluster_address
# binlog_format=ROW
# default_storage_engine=InnoDB
# innodb_autoinc_lock_mode=2
# innodb_doublewrite=1
# query_cache_size=0

# 2 variables needed to switch from XtraDB to InnoDB plugins
#plugin-load=ha_innodb
#ignore_builtin_innodb

## MariaDB 10 only save and restore buffer pool pages
## warm up InnoDB buffer pool on server restarts
innodb_buffer_pool_dump_at_shutdown=1
innodb_buffer_pool_load_at_startup=1
## Disabled settings
performance_schema=OFF
innodb_stats_on_metadata=OFF
innodb_sort_buffer_size=2M
innodb_online_alter_log_max_size=128M
query_cache_strip_comments=0
log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

# Defragmenting unused space on InnoDB tablespace
innodb_defragment=1
innodb_defragment_n_pages=7
innodb_defragment_stats_accuracy=0
innodb_defragment_fill_factor_n_recs=20
innodb_defragment_fill_factor=0.9
innodb_defragment_frequency=40

# page compression
# 10.1+ https://mariadb.com/kb/en/mariadb/compression/
#innodb_compression_algorithm=zlib
#innodb_use_fallocate=0
#innodb_use_mtflush=0
#innodb_mtflush_threads=4
=================================================

[1;32;40mexclude line exists... adding exclude line for mysql*
[1;32;40m* Starting MariaDB Secure Installation
/usr/local/src/centminmod/inc/mariadb_install106.inc: line 1471: mysql_upgrade: command not found
systemctl restart mariadb.service
Failed to restart mariadb.service: Unit mariadb.service not found.
Failed to stop mariadb.service: Unit mariadb.service not loaded.
Failed to start mariadb.service: Unit mariadb.service not found.
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mariadbd is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mariadbd is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Installed:
  fio-3.35-1.el9.x86_64                   fio-engine-http-3.35-1.el9.x86_64  
  fio-engine-libaio-3.35-1.el9.x86_64     fio-engine-nbd-3.35-1.el9.x86_64    
  fio-engine-rados-3.35-1.el9.x86_64      fio-engine-rbd-3.35-1.el9.x86_64    
  fio-engine-rdma-3.35-1.el9.x86_64       libnbd-1.18.1-4.el9_4.x86_64        
  librados2-2:16.2.4-5.el9.x86_64         librbd1-2:16.2.4-5.el9.x86_64      
  librdmacm-48.0-1.el9.x86_64          

Failed to start mariadb.service: Unit mariadb.service not found.
ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)
Full Reads: 24165
Full Writes: 19931
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mariadbd is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mariadbd is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
innodb_io_capacity = 1000

+------------------------+-------+
/etc/my.cnf adjustment
+------------------------+-------+
existing value:
ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)
new value:
ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)

+------------------------+-------+
innodb io threads adjustment
+------------------------+-------+
existing value:
+------------------------+-------+
innodb_read_io_threads = 2
innodb_write_io_threads = 2
+------------------------+-------+
new value:
+------------------------+-------+
innodb_read_io_threads = 2
innodb_write_io_threads = 2
+------------------------+-------+

Restart MySQL server for io thread changes

ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)
[1;32;40m* MariaDB installed
After MariaDB installation
Wed Nov  6 01:11:56 AM EST 2024
Failed to stop mariadb.service: Unit mariadb.service not loaded.
Failed to start mariadb.service: Unit mariadb.service not found.
Failed to enable unit: Unit file mariadb.service does not exist.
Failed to start mariadb.service: Unit mariadb.service not found.
ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)

[1;33;40m-------------------------------------------------------
[m[1;32;40mMySQL root user password set
[m[1;32;40mMySQL root user added to /root/.my.cnf
[m[1;33;40m-------------------------------------------------------
[m[1;32;40mMySQL root password:
[m[1;33;40m-------------------------------------------------------
[1;32;40m* Installing PHP
PHP VERSION ID: 80313
Initial Install PHPMVER: 8.3
buildconf: Checking installation
buildconf: autoconf version 2.69 (ok)
buildconf: Forcing buildconf. The configure files will be regenerated.
buildconf: Cleaning cache and configure files
buildconf: Rebuilding configure
buildconf: Rebuilding main/php_config.h.in
buildconf: Run ./configure to proceed with customizing the PHP build.
PHP configure stage

 

Code (Text):

[mariadb]
name = MariaDB
baseurl = https://yum.mariadb.org/10.6/rhel9-amd64
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
exclude=MariaDB-Galera-server

I've executed manually

Code (Text):

yum install mariadb-server

and server installed, somehow. However i don't quite sure that it installed properly. WP via command 22 installed and working too.