Technical posts/MySQL

[Preparing DBMS Benchmark] Install Mariadb 10.1.17 on CentOS 7.2

ODB 2017. 8. 4. 15:28

[Preparing DBMS Benchmark] Install Mariadb 10.1.17 on CentOS 7.2


자! 4번째


마리아디비를 해보도록 하겠다


https://mariadb.com/download_file/mariadb/rhel/10.2.7/8279ca5e06351f8b77b538007ea2e001


요기서 다운받고


https://mariadb.com/kb/en/mariadb/installing-mariadb-with-the-rpm-tool/


요기처럼 설치하겠다




Step 1. 압축을 푼다

[root@localhost preinst]# tar -xvf *

mariadb-10.2.7-rhel-7-x86_64-rpms/

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-cracklib-password-check.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-aws-key-management.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-backup.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-client.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-common.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-compat.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-connect-engine.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-gssapi-server.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-devel.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-oqgraph-engine.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-rocksdb-engine.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-server.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-shared.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/MariaDB-10.2.7-centos7-x86_64-tokudb-engine.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/galera-25.3.20-1.rhel7.el7.centos.x86_64.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/jemalloc-3.6.0-1.el7.x86_64.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/jemalloc-devel-3.6.0-1.el7.x86_64.rpm

mariadb-10.2.7-rhel-7-x86_64-rpms/repodata/

mariadb-10.2.7-rhel-7-x86_64-rpms/repodata/4b0e8ee4d690f8f93cd9de19ef379591f88e55334cdb267e4a10dc08108e805a-primary.xml.gz

mariadb-10.2.7-rhel-7-x86_64-rpms/repodata/a2a465d5d14e8f7b115199c6b37914b6e0a6b56b12af73a1a403097ef73d2642-filelists.xml.gz

mariadb-10.2.7-rhel-7-x86_64-rpms/repodata/4237e6672ed8ea12fc140e80bfa8f6fc02b27e3c9157356eba979c55a91a1e4d-other.xml.gz

mariadb-10.2.7-rhel-7-x86_64-rpms/repodata/repomd.xml

mariadb-10.2.7-rhel-7-x86_64-rpms/repodata/be9830060c0625770454984708cf5639fcf4c64558477762ae59b58c9314e9f3-other.sqlite.bz2

mariadb-10.2.7-rhel-7-x86_64-rpms/repodata/6ddc68237c22304b3343ad7c439b3ab1de8ab00674058c91043c4dc9cbf2e507-filelists.sqlite.bz2

mariadb-10.2.7-rhel-7-x86_64-rpms/repodata/930728120c8db3d4630f63bd70131944b6b53d4290c633082153402888489131-primary.sqlite.bz2

mariadb-10.2.7-rhel-7-x86_64-rpms/README

mariadb-10.2.7-rhel-7-x86_64-rpms/setup_repository

[root@localhost preinst]# ls

mariadb-10.2.7-rhel-7-x86_64-rpms  mariadb-10.2.7-rhel-7-x86_64-rpms.tar

[root@localhost preinst]# cd mariadb-10.2.7-rhel-7-x86_64-rpms

[root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# ls

galera-25.3.20-1.rhel7.el7.centos.x86_64.rpm          MariaDB-10.2.7-centos7-x86_64-client.rpm                   MariaDB-10.2.7-centos7-x86_64-devel.rpm           MariaDB-10.2.7-centos7-x86_64-shared.rpm

jemalloc-3.6.0-1.el7.x86_64.rpm                       MariaDB-10.2.7-centos7-x86_64-common.rpm                   MariaDB-10.2.7-centos7-x86_64-gssapi-server.rpm   MariaDB-10.2.7-centos7-x86_64-tokudb-engine.rpm

jemalloc-devel-3.6.0-1.el7.x86_64.rpm                 MariaDB-10.2.7-centos7-x86_64-compat.rpm                   MariaDB-10.2.7-centos7-x86_64-oqgraph-engine.rpm  README

MariaDB-10.2.7-centos7-x86_64-aws-key-management.rpm  MariaDB-10.2.7-centos7-x86_64-connect-engine.rpm           MariaDB-10.2.7-centos7-x86_64-rocksdb-engine.rpm  repodata

MariaDB-10.2.7-centos7-x86_64-backup.rpm              MariaDB-10.2.7-centos7-x86_64-cracklib-password-check.rpm  MariaDB-10.2.7-centos7-x86_64-server.rpm          setup_repository

[root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# 


Step 2. rpm --checksig $(find . -name '*.rpm')

 [root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# rpm --checksig $(find . -name '*.rpm')

./MariaDB-10.2.7-centos7-x86_64-cracklib-password-check.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-aws-key-management.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-backup.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-client.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-common.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-compat.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-connect-engine.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-gssapi-server.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-devel.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-oqgraph-engine.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-rocksdb-engine.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-server.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-shared.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./MariaDB-10.2.7-centos7-x86_64-tokudb-engine.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./galera-25.3.20-1.rhel7.el7.centos.x86_64.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./jemalloc-3.6.0-1.el7.x86_64.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

./jemalloc-devel-3.6.0-1.el7.x86_64.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#1bb943db) 

걍 진행한다


Step 3. rpm -qa 'mysql*' //혹시나 겹칠수 있는 패키지를 제거한다


 [root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# rpm -qa 'mysql*'

..

...

무반응...



Step 4. ./setup_repository // 그냥 yum을 쓰자!


[root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# ./setup_repository 

Repository file successfully created! Please install MariaDB Server with this command:


   yum install MariaDB-server


[root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]#



Step 5. yum install MariaDB-server


[root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# yum install MariaDB-server

Loaded plugins: fastestmirror


MariaDB                                                                        | 2.9 kB  00:00:00     


base                                                                             | 3.6 kB  00:00:00     


extras                                                                           | 3.4 kB  00:00:00     


updates                                                                        | 3.4 kB  00:00:00     


MariaDB/primary_db                                                       |  17 kB  00:00:00     

Loading mirror speeds from cached hostfile

 * base: mirror.xnet.co.nz

 * extras: mirror.xnet.co.nz

 * updates: mirror.xnet.co.nz

Resolving Dependencies

--> Running transaction check

---> Package MariaDB-server.x86_64 0:10.2.7-1.el7.centos will be installed

--> Processing Dependency: MariaDB-client for package: MariaDB-server-10.2.7-1.el7.centos.x86_64

--> Processing Dependency: perl(DBI) for package: MariaDB-server-10.2.7-1.el7.centos.x86_64

--> Processing Dependency: perl(strict) for package: MariaDB-server-10.2.7-1.el7.centos.x86_64

--> Processing Dependency: galera for package: Ma

...

...

Installed:

  MariaDB-compat.x86_64 0:10.2.7-1.el7.centos                                                                          MariaDB-server.x86_64 0:10.2.7-1.el7.centos                                                                         


Dependency Installed:

  MariaDB-client.x86_64 0:10.2.7-1.el7.centos    MariaDB-common.x86_64 0:10.2.7-1.el7.centos     boost-program-options.x86_64 0:1.53.0-26.el7    galera.x86_64 0:25.3.20-1.rhel7.el7.centos     lsof.x86_64 0:4.87-4.el7                   

  perl.x86_64 4:5.16.3-291.el7                   perl-Carp.noarch 0:1.26-244.el7                 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7    perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7    perl-DBI.x86_64 0:1.627-4.el7              

  perl-Data-Dumper.x86_64 0:2.145-3.el7          perl-Encode.x86_64 0:2.51-7.el7                 perl-Exporter.noarch 0:5.68-3.el7               perl-File-Path.noarch 0:2.09-2.el7             perl-File-Temp.noarch 0:0.23.01-3.el7      

  perl-Filter.x86_64 0:1.49-3.el7                perl-Getopt-Long.noarch 0:2.40-2.el7            perl-HTTP-Tiny.noarch 0:0.033-3.el7             perl-IO-Compress.noarch 0:2.061-2.el7          perl-Net-Daemon.noarch 0:0.48-5.el7        

  perl-PathTools.x86_64 0:3.40-5.el7             perl-PlRPC.noarch 0:0.2020-14.el7               perl-Pod-Escapes.noarch 1:1.04-291.el7          perl-Pod-Perldoc.noarch 0:3.20-4.el7           perl-Pod-Simple.noarch 1:3.28-4.el7        

  perl-Pod-Usage.noarch 0:1.63-3.el7             perl-Scalar-List-Utils.x86_64 0:1.27-248.el7    perl-Socket.x86_64 0:2.010-4.el7                perl-Storable.x86_64 0:2.45-3.el7              perl-Text-ParseWords.noarch 0:3.29-4.el7   

  perl-Time-HiRes.x86_64 4:1.9725-3.el7          perl-Time-Local.noarch 0:1.2300-2.el7           perl-constant.noarch 0:1.27-2.el7               perl-libs.x86_64 4:5.16.3-291.el7              perl-macros.x86_64 4:5.16.3-291.el7        

  perl-parent.noarch 1:0.225-244.el7             perl-podlators.noarch 0:2.5.1-3.el7             perl-threads.x86_64 0:1.87-4.el7                perl-threads-shared.x86_64 0:1.43-6.el7        rsync.x86_64 0:3.0.9-17.el7                


Replaced:

  mariadb-libs.x86_64 1:5.5.52-1.el7                                                                                                                                                                                                        


Complete! 

yum은 최고다...


Step 6. root 패스워드 지정


[root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# /usr/bin/mysqladmin -u root password '**************' 

[root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# systemctl start mysqld

[root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# ps -ef |grep mysql

mysql     2617     1  0 19:27 ?        00:00:00 /usr/sbin/mysqld

root      2682  2247  0 19:29 pts/0    00:00:00 grep --color=auto mysql

[root@localhost mariadb-10.2.7-rhel-7-x86_64-rpms]# mysql -uroot -p

Enter password: 

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 9

Server version: 10.2.7-MariaDB MariaDB Server


Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| test               |

+--------------------+

4 rows in set (0.01 sec)




Step 7. 유저생성 및 권한부여


MariaDB [(none)]> create user 'test_maria'@'%' identified by 'Testtest1!';

Query OK, 0 rows affected (0.01 sec)


MariaDB [(none)]> grant all privileges on *.* to 'test_maria'@'%';

Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> select user,host from mysql.user;

+------------+-----------------------+

| user       | host                  |

+------------+-----------------------+

| test_maria | %                     |

| root       | 127.0.0.1             |

| root       | ::1                   |

| root       | localhost             |

| root       | localhost.localdomain |

+------------+-----------------------+

7 rows in set (0.00 sec)


MariaDB [(none)]> 


MariaDB도 끝..

"이 포스팅은 쿠팡 파트너스 활동의 일환으로, 이에 따른 일정액의 수수료를 제공받습니다."