mariadb相关说明，更改数据路径##mk

mariadb相关说明，更改数据路径##mk

安装

##
yum install mariadb mariadb-server

##
service  mariadb  start

MariaDB/MySQL的默认设置性能非常差，仅仅起一个功能测试的作用，不能用在生产环境中，因此要对一些参数进行调整优化。

更改数据路径

##
 mkdir /data/mysql

###
service mariadb stop

## 
cd /data/mysql
mv /var/lib/mysql/* .
chown -R mysql:mysql /data/mysql/

### vim /etc/my.cnf,将文件mv过去然后重启即可
[mysqld]
datadir=/data/mysql
socket=/var/lib/mysql/mysql.sock

验证

$service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2022-07-22 11:50:20 CST; 2s ago
  Process: 81753 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 81717 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 81752 (mysqld_safe)
   CGroup: /system.slice/mariadb.service
           ├─81752 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─81917 /usr/libexec/mysqld --basedir=/usr --datadir=/data/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var...

Jul 22 11:50:18 szcxg-base-zabbix-01 systemd[1]: Starting MariaDB database server...