IOTN :: Work Book :: MySQL

ȸ¿ø°¡ÀÔ

MariaDB default datadir º¯°æ [ datafile À§Ä¡ º¯°æ ] test version 10.4

ÃÖ±æÈ£ [LIST]   2020-05-29 18:04:39, Á¶È¸ : 269 MariaDB [(none)]> select @@datadir; +-----------------+ | @@datadir       | +-----------------+ | /var/lib/mysql/ | +-----------------+ 1 row in set (0.000 sec) root# systemctl stop mariadb systemctl status mariadb mkdir /data rsync -av /var/lib/mysql /data/ mv /var/lib/mysql /var/lib/mysql.bak vi /etc/my.cnf [client-server] socket=/data/mysql/mysql.sock [mysqld] datadir=/data/mysql ## ±âÁ¸ Á¤º¸ !includedir /etc/my.cnf.d semanage fcontext -a -t mysqld_db_t "/data/mysql(/.*)?" restorecon -R /data/mysql systemctl start mariadb MariaDB [(none)]> select @@datadir; +--------------+ | @@datadir    | +--------------+ | /data/mysql/ | +--------------+ 1 row in set (0.000 sec) MariaDB [(none)]> Ãâó: https://www.tecmint.com/change-default-mysql-mariadb-data-directory-in-linux/ À§ Á¤º¸ ´Ù½Ã º¸°í ÇÏ¸é ¿¡·¯ ¾È³¯µí. [root@node1 mysql]# systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. [root@node1 mysql]# systemctl status mariadb.service ● mariadb.service - MariaDB 10.4.13 database server    Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)   Drop-In: /etc/systemd/system/mariadb.service.d            ⡱¡±â¡±¢æmigrated-from-my.cnf-settings.conf    Active: failed (Result: exit-code) since Fri 2020-05-29 04:48:28 EDT; 8s ago      Docs: man:mysqld(8)            https://mariadb.com/kb/en/library/systemd/   Process: 2943 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)   Process: 5053 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)   Process: 5034 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)   Process: 5031 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Main PID: 5053 (code=exited, status=1/FAILURE)    Status: "MariaDB server is down" May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Plugin 'InnoDB' init function returned error. May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [Note] Plugin 'FEEDBACK' is disabled. May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Failed to initialize plugins. May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Aborting May 29 04:48:28 node1 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE May 29 04:48:28 node1 systemd[1]: Failed to start MariaDB 10.4.13 database server. May 29 04:48:28 node1 systemd[1]: Unit mariadb.service entered failed state. May 29 04:48:28 node1 systemd[1]: mariadb.service failed. Hint: Some lines were ellipsized, use -l to show in full. [root@node1 mysql]#

LIST

Copyright 1999-2022 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)