MariaDB 10.2 Installation Procedure on Oracle Linux 7－DanBrother的部落格

MariaDB 10.2 Installation Procedure on Oracle Linux 7

#####################################
# Creatiing the MariaDB YUM repository
#####################################
vi /etc/yum.repos.d/MariaDB.repo
>>
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2.12/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

################################
# Installing MariaDB with YUM
################################

# yum --disablerepo="*" --enablerepo="mariadb" list MariaDB-server MariaDB-client

Loaded plugins: langpacks, ulninfo
Available Packages
MariaDB-client.x86_64 10.2.12-1.el7.centos mariadb
MariaDB-server.x86_64 10.2.12-1.el7.centos mariadb

# yum --disablerepo="*" --enablerepo="mariadb" install MariaDB-server MariaDB-client

Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.2.12-1.el7.centos will be installed
--> Processing Dependency: MariaDB-common for package: MariaDB-client-10.2.12-1.el7.centos.x86_64
---> Package MariaDB-server.x86_64 0:10.2.12-1.el7.centos will be installed
--> Processing Dependency: galera for package: MariaDB-server-10.2.12-1.el7.centos.x86_64
--> Running transaction check
---> Package MariaDB-common.x86_64 0:10.2.12-1.el7.centos will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.2.12-1.el7.centos.x86_64
---> Package galera.x86_64 0:25.3.22-1.rhel7.el7.centos will be installed
--> Running transaction check
---> Package MariaDB-compat.x86_64 0:10.2.12-1.el7.centos will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================================================================================================================
Package Arch Version Repository Size
===================================================================================================================================================================================================
Installing:
MariaDB-client x86_64 10.2.12-1.el7.centos mariadb 48 M
MariaDB-server x86_64 10.2.12-1.el7.centos mariadb 110 M
Installing for dependencies:
MariaDB-common x86_64 10.2.12-1.el7.centos mariadb 154 k
MariaDB-compat x86_64 10.2.12-1.el7.centos mariadb 2.8 M
galera x86_64 25.3.22-1.rhel7.el7.centos mariadb 8.0 M

Transaction Summary
===================================================================================================================================================================================================
Install 2 Packages (+3 Dependent packages)

Total download size: 168 M
Installed size: 718 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7Server/mariadb/packages/MariaDB-10.2.12-centos7-x86_64-common.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY ] 144 kB/s | 207 kB 00:19:51 ETA
Public key for MariaDB-10.2.12-centos7-x86_64-common.rpm is not installed
(1/5): MariaDB-10.2.12-centos7-x86_64-common.rpm | 154 kB 00:00:01
(2/5): MariaDB-10.2.12-centos7-x86_64-compat.rpm | 2.8 MB 00:00:04
(3/5): MariaDB-10.2.12-centos7-x86_64-client.rpm | 48 MB 00:00:10
(4/5): galera-25.3.22-1.rhel7.el7.centos.x86_64.rpm | 8.0 MB 00:00:01
MariaDB-10.2.12-centos7-x86_64 FAILED 92% [=================================================================== ] 3.5 kB/s | 155 MB 01:03:30 ETA
http://yum.mariadb.org/10.2.12/centos7-amd64/rpms/MariaDB-10.2.12-centos7-x86_64-server.rpm: [Errno 12] Timeout on http://yum.mariadb.org/10.2.12/centos7-amd64/rpms/MariaDB-10.2.12-centos7-x86_64-server.rpm: (28, 'Operation too slow. Less than 1000 bytes/sec transferred the last 30 seconds')
Trying other mirror.
(5/5): MariaDB-10.2.12-centos7-x86_64-server.rpm | 110 MB 00:00:06
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 2.6 MB/s | 168 MB 00:01:04
Retrieving key from https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Importing GPG key 0x1BB943DB:
Userid : "MariaDB Package Signing Key <package-signing-key@mariadb.org>"
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
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
perl-DBD-MySQL-4.023-5.0.1.el7.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
perl-DBD-MySQL-4.023-5.0.1.el7.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit)
Installing : MariaDB-common-10.2.12-1.el7.centos.x86_64 1/5
Installing : MariaDB-compat-10.2.12-1.el7.centos.x86_64 2/5
Installing : MariaDB-client-10.2.12-1.el7.centos.x86_64 3/5
Installing : galera-25.3.22-1.rhel7.el7.centos.x86_64 4/5
Installing : MariaDB-server-10.2.12-1.el7.centos.x86_64 5/5
Verifying : MariaDB-client-10.2.12-1.el7.centos.x86_64 1/5
Verifying : MariaDB-compat-10.2.12-1.el7.centos.x86_64 2/5
Verifying : MariaDB-common-10.2.12-1.el7.centos.x86_64 3/5
Verifying : galera-25.3.22-1.rhel7.el7.centos.x86_64 4/5
Verifying : MariaDB-server-10.2.12-1.el7.centos.x86_64 5/5

Installed:
MariaDB-client.x86_64 0:10.2.12-1.el7.centos MariaDB-server.x86_64 0:10.2.12-1.el7.centos

Dependency Installed:
MariaDB-common.x86_64 0:10.2.12-1.el7.centos MariaDB-compat.x86_64 0:10.2.12-1.el7.centos galera.x86_64 0:25.3.22-1.rhel7.el7.centos

Complete!

# rpm -qa |grep MariaDB
MariaDB-compat-10.2.12-1.el7.centos.x86_64
MariaDB-server-10.2.12-1.el7.centos.x86_64
MariaDB-common-10.2.12-1.el7.centos.x86_64
MariaDB-client-10.2.12-1.el7.centos.x86_64

###########################
# Start MariaDB Server
###########################

# systemctl start mariadb

# mysql_secure_installation

# mysql -uroot -p

Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 18
Server version: 10.2.12-MariaDB MariaDB Server

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

MariaDB [(none)]> select @@version;
+-----------------+
| @@version |
+-----------------+
| 10.2.12-MariaDB |
+-----------------+
1 row in set (0.00 sec)

[Reference]
https://mariadb.com/kb/en/library/yum/