Installation

Install on CentOS 7 
 URL: https://downloads.mariadb.org/mariadb/repositories/#mirror=mephi&distro=CentOS&distro_release=centos7-amd64--centos7   
 /etc/yum.repos.d/MariaDB.repo 
 # MariaDB 10.5 CentOS repository list - created 2021-05-08 02:51 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1 
 安裝開始 
 yum install MariaDB-server MariaDB-client 
 Starting MariaDB 
 systemctl start mariadb.service
systemctl enable mariadb.service
systemctl status mariadb.service 
 Securing MariaDB 
 mysql_secure_installation 
 OS Optimization 
 Linux Kernel Settings – IO Scheduler 
 # A temporary change can be done by issuing the following command
echo noop > /sys/block/sda/queue/scheduler

# To make it persistent, you’ll need to configure it in GRUB’s configuration 
# file as shown below in /etc/default/grub , rebuild GRUB, and reboot the system.
GRUB_CMDLINE_LINUX_DEFAULT="quiet splash elevator=noop" 
 Resource Limits – Open Files Limit, Core File Size 
 # /etc/security/limits.conf
mysql soft nofile 65535 
mysql hard nofile 65535
mysql soft core unlimited
mysql hard core unlimited 
 Configure Swappiness 
 # /etc/sysctl.conf
vm.swappiness = 1 
 Filesystem Optimizations 
 # /etc/fstab
/dev/sdb /var/lib/mysql ext4 defaults,noatime 0 0 
 DB Optimization