[Preparing DBMS Benchmark] Install Mariadb 10.1.17 on CentOS 7.2

[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도 끝..