CentOS 7 에 MariaDB 10 업데이트

CentOS 7 에 MariaDB 10 업데이트

MariaDB [(none)]> SET GLOBAL innodb_fast_shutdown=0;
Query OK, 0 rows affected (0.022 sec)

MariaDB [(none)]> \q
Bye

#MariaDB 중지
[root@ggcdev ~]# sudo systemctl stop mariadb.service
[root@ggcdev ~]#


#MariaDB 패키지 제거
[root@ggcdev ~]# yum remove mariadb-server

Removed:
  MariaDB-server.x86_64 0:10.3.37-1.el7.centos

Complete!


#yum repository 추가
[root@ggcdev ~]# vi /etc/yum.repos.d/MariaDB.repo

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.10/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

#yum update 및 upgrade하기
[root@ggcdev ~]# sudo yum update
[root@ggcdev ~]# sudo yum upgrade


#MariaDB 설치 재확인
[root@ggcdev ~]# rpm -qa | grep -i mariadb
#MariaDB 설치
[root@ggcdev ~]# sudo yum -y install mariadb-server

#MariaDB 시작
[root@ggcdev ~]# sudo systemctl start mariadb.service
[root@ggcdev ~]#


#기존 DB 업그레이드
[root@ggcdev ~]# sudo mysql_upgrade --user=root --password

 

 

[root@ggcdev /]# mysql --help | grep my.cnf
/etc/my.cnf ~/.my.cnf 

vi ./etc/my.cnf

[mysqld]
innodb_buffer_pool_size=4077M
innodb_strict_mode = 0
innodb_log_file_size = 512M