MariaDB 10.5.2をインストールしてみた。

先日リリースされたMariaDB 10.5.2をインストールしてみた。

現時点では、Do not use beta releases in production!と書かれており注意です。

参考にしたのはMariaDB公式サイト
悩むことなくインストールできました。
入れたOSは↓

# cat /etc/redhat-release
CentOS Linux release 8.1.1911 (Core)

それでは作業開始
.repoを作ります。

# vim /etc/yum.repos.d/MariaDB.repo
# MariaDB 10.5 CentOS repository list – created 2020-04-14 13:37 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos8-amd64
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

それではインストール

# dnf install MariaDB-server
CentOS-8 – AppStream 7.6 kB/s | 4.3 kB 00:00
CentOS-8 – Base 6.5 kB/s | 3.8 kB 00:00
CentOS-8 – Extras 3.9 kB/s | 1.5 kB 00:00
MariaDB 234 kB/s | 501 kB 00:02
Extra Packages for Enterprise Linux Modular 8 – 5.8 kB/s | 9.5 kB 00:01
Extra Packages for Enterprise Linux 8 – x86_64 9.4 kB/s | 6.7 kB 00:00
nginx stable repo 4.0 kB/s | 2.9 kB 00:00
Remi’s Modular repository for Enterprise Linux 3.3 kB/s | 3.5 kB 00:01
Safe Remi’s RPM repository for Enterprise Linux 2.6 kB/s | 3.0 kB 00:01
Safe Remi’s RPM repository for Enterprise Linux 373 kB/s | 1.5 MB 00:04
Dependencies resolved.
================================================================================
Package Arch Version Repo Size
================================================================================
Installing:
MariaDB-server x86_64 10.5.2-1.el8 mariadb 26 M
Installing dependencies:
boost-program-options
x86_64 1.66.0-6.el8 AppStream 143 k
perl-DBI x86_64 1.641-3.module_el8.1.0+199+8f0a6bbd AppStream 740 k
lsof x86_64 4.91-2.el8 BaseOS 253 k
perl-Math-BigInt noarch 1:1.9998.11-7.el8 BaseOS 196 k
perl-Math-Complex noarch 1.59-416.el8 BaseOS 108 k
rsync x86_64 3.1.3-6.el8 BaseOS 405 k
MariaDB-client x86_64 10.5.2-1.el8 mariadb 13 M
MariaDB-common x86_64 10.5.2-1.el8 mariadb 87 k
galera-4 x86_64 26.4.4-1.rhel8.0.el8 mariadb 13 M
Enabling module streams:
perl-DBI 1.641

Transaction Summary
================================================================================
Install 10 Packages

Total download size: 54 M
Installed size: 208 M
Is this ok [y/N]: y
Downloading Packages:
(1/10): boost-program-options-1.66.0-6.el8.x86_ 1.8 MB/s | 143 kB 00:00
(2/10): lsof-4.91-2.el8.x86_64.rpm 2.0 MB/s | 253 kB 00:00
(3/10): perl-DBI-1.641-3.module_el8.1.0+199+8f0 5.2 MB/s | 740 kB 00:00
(4/10): perl-Math-Complex-1.59-416.el8.noarch.r 3.9 MB/s | 108 kB 00:00
(5/10): perl-Math-BigInt-1.9998.11-7.el8.noarch 2.0 MB/s | 196 kB 00:00
(6/10): rsync-3.1.3-6.el8.x86_64.rpm 3.3 MB/s | 405 kB 00:00
(7/10): MariaDB-common-10.5.2-1.el8.x86_64.rpm 84 kB/s | 87 kB 00:01
(8/10): MariaDB-client-10.5.2-1.el8.x86_64.rpm 1.5 MB/s | 13 MB 00:08
(9/10): galera-4-26.4.4-1.rhel8.0.el8.x86_64.rp 1.6 MB/s | 13 MB 00:08
(10/10): MariaDB-server-10.5.2-1.el8.x86_64.rpm 1.5 MB/s | 26 MB 00:17
——————————————————————————–
Total 2.9 MB/s | 54 MB 00:18
warning: /var/cache/dnf/mariadb-43de5445dbb1892a/packages/MariaDB-client-10.5.2-1.el8.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
MariaDB 11 kB/s | 8.2 kB 00:00
Importing GPG key 0x1BB943DB:
Userid : “MariaDB Package Signing Key ”
Fingerprint: 1993 69E5 404B D5FC 7D2F E43B CBCB 082A 1BB9 43DB
From : https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Is this ok [y/N]: y
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: MariaDB-common-10.5.2-1.el8.x86_64 1/10
Installing : MariaDB-common-10.5.2-1.el8.x86_64 1/10
Running scriptlet: MariaDB-common-10.5.2-1.el8.x86_64 1/10
Running scriptlet: MariaDB-client-10.5.2-1.el8.x86_64 2/10
Installing : MariaDB-client-10.5.2-1.el8.x86_64 2/10
Running scriptlet: MariaDB-client-10.5.2-1.el8.x86_64 2/10
Installing : rsync-3.1.3-6.el8.x86_64 3/10
Installing : perl-Math-Complex-1.59-416.el8.noarch 4/10
Installing : perl-Math-BigInt-1:1.9998.11-7.el8.noarch 5/10
Installing : perl-DBI-1.641-3.module_el8.1.0+199+8f0a6bbd.x86_6 6/10
Installing : lsof-4.91-2.el8.x86_64 7/10
Installing : boost-program-options-1.66.0-6.el8.x86_64 8/10
Running scriptlet: boost-program-options-1.66.0-6.el8.x86_64 8/10
Running scriptlet: galera-4-26.4.4-1.rhel8.0.el8.x86_64 9/10
Installing : galera-4-26.4.4-1.rhel8.0.el8.x86_64 9/10
Running scriptlet: galera-4-26.4.4-1.rhel8.0.el8.x86_64 9/10
Running scriptlet: MariaDB-server-10.5.2-1.el8.x86_64 10/10
Installing : MariaDB-server-10.5.2-1.el8.x86_64 10/10
Running scriptlet: MariaDB-server-10.5.2-1.el8.x86_64 10/10

Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system ‘root’ user to connect. Use, for example, sudo mysql
The second is mysql@localhost, it has no password either, but
you need to be the system ‘mysql’ user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB’s strong and vibrant community:
　https://mariadb.org/get-involved/

Verifying : boost-program-options-1.66.0-6.el8.x86_64 1/10
Verifying : perl-DBI-1.641-3.module_el8.1.0+199+8f0a6bbd.x86_6 2/10
Verifying : lsof-4.91-2.el8.x86_64 3/10
Verifying : perl-Math-BigInt-1:1.9998.11-7.el8.noarch 4/10
Verifying : perl-Math-Complex-1.59-416.el8.noarch 5/10
Verifying : rsync-3.1.3-6.el8.x86_64 6/10
Verifying : MariaDB-client-10.5.2-1.el8.x86_64 7/10
Verifying : MariaDB-common-10.5.2-1.el8.x86_64 8/10
Verifying : MariaDB-server-10.5.2-1.el8.x86_64 9/10
Verifying : galera-4-26.4.4-1.rhel8.0.el8.x86_64 10/10

Installed:
MariaDB-server-10.5.2-1.el8.x86_64
boost-program-options-1.66.0-6.el8.x86_64
perl-DBI-1.641-3.module_el8.1.0+199+8f0a6bbd.x86_64
lsof-4.91-2.el8.x86_64
perl-Math-BigInt-1:1.9998.11-7.el8.noarch
perl-Math-Complex-1.59-416.el8.noarch
rsync-3.1.3-6.el8.x86_64
MariaDB-client-10.5.2-1.el8.x86_64
MariaDB-common-10.5.2-1.el8.x86_64
galera-4-26.4.4-1.rhel8.0.el8.x86_64

Complete!

すんなりインストール成功
起動とかその他を設定

# systemctl start mariadb
# systemctl status mariadb
● mariadb.service – MariaDB 10.5.2 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor pr>
Drop-In: /etc/systemd/system/mariadb.service.d
mqmigrated-from-my.cnf-settings.conf
Active: active (running) since Tue 2020-04-14 22:41:58 JST; 3s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 4545 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_STA>
Process: 4521 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VA>
Process: 4519 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_STAR>
Main PID: 4531 (mysqld)
Status: “Taking your SQL requests now…”
Tasks: 13 (limit: 12521)
Memory: 74.0M
CGroup: /system.slice/mariadb.service
mq4531 /usr/sbin/mysqld

Apr 14 22:41:58 www3.higherhope.net mysqld[4531]: 2020-04-14 22:41:58 0 [Note] >
Apr 14 22:41:58 www3.higherhope.net mysqld[4531]: 2020-04-14 22:41:58 0 [Note] >
Apr 14 22:41:58 www3.higherhope.net mysqld[4531]: 2020-04-14 22:41:58 0 [Note] >
Apr 14 22:41:58 www3.higherhope.net mysqld[4531]: 2020-04-14 22:41:58 0 [Note] >
Apr 14 22:41:58 www3.higherhope.net mysqld[4531]: 2020-04-14 22:41:58 0 [Note] >
Apr 14 22:41:58 www3.higherhope.net mysqld[4531]: 2020-04-14 22:41:58 0 [Note] >
Apr 14 22:41:58 www3.higherhope.net mysqld[4531]: 2020-04-14 22:41:58 0 [Note] >
Apr 14 22:41:58 www3.higherhope.net mysqld[4531]: 2020-04-14 22:41:58 0 [Note] >
Apr 14 22:41:58 www3.higherhope.net mysqld[4531]: Version: ‘10.5.2-MariaDB’ so>
Apr 14 22:41:58 www3.higherhope.net systemd[1]: Started MariaDB 10.5.2 database>

自動起動設定

# systemctl enable mariadb
Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.

バージョン確認

# mariadb -V
mariadb Ver 15.1 Distrib 10.5.2-MariaDB, for Linux (x86_64) using readline 5.1

取り合えずインストールは成功です。