Bii o ṣe le Fi sii MariaDB lori CentOS 8

MariaDB jẹ orisun ṣiṣi, eto idari ibatan ibatan ibatan ti idagbasoke idagbasoke ti agbegbe. O ti forked lati MySQL ati ṣẹda ati itọju nipasẹ awọn aṣagbega ti o ṣẹda MySQL. MariaDB ti pinnu lati wa ni ibaramu giga pẹlu MySQL ṣugbọn awọn ẹya tuntun ti ni afikun si MariaDB bi awọn ẹrọ ayọkẹlẹ titun (Aria, ColumnStore, MyRocks).

Ninu nkan yii, a yoo wo fifi sori ẹrọ ati iṣeto ti MariaDB lori CentOS 8 Linux.

Igbesẹ 1: Muu ibi ipamọ MariaDB ṣiṣẹ lori CentOS 8

Lọ si oju-iwe awọn gbigba lati ayelujara MariaDB osise ki o yan CentOS bi pinpin ati CentOS 8 bi ẹya ati MariaDB 10.5 (ẹya idurosinsin) lati gba ibi ipamọ.

Lọgan ti o yan awọn alaye naa, iwọ yoo gba gbogbo ibi ipamọ MariaDB YUM. Daakọ ati lẹẹ awọn titẹ sii wọnyi sinu faili ti a pe ni /etc/yum.repos.d/MariaDB.repo.

$ sudo vim /etc/yum.repos.d/mariadb.repo

# MariaDB 10.5 CentOS repository list - created 2020-12-15 07:13 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

Lọgan ti faili ibi ipamọ wa ni ipo, o le ṣe idaniloju ibi ipamọ nipa ṣiṣe pipaṣẹ atẹle.

$ dnf repolist

Igbesẹ 2: Fifi MariaDB sori CentOS 8

Bayi lo aṣẹ dnf lati fi sori ẹrọ package MariaDB.

$ sudo dnf install MariaDB-server -y

Nigbamii, bẹrẹ iṣẹ MariaDB ki o mu ki o bẹrẹ ni idojukọ lakoko ibẹrẹ eto.

$ systemctl start mariadb
$ systemctl enable mariadb

Ṣayẹwo ipo iṣẹ MariaDB nipa ṣiṣe pipaṣẹ atẹle.

$ systemctl status mariadb 

Ti o ba ti ṣiṣẹ ogiriina kan, o nilo lati ṣafikun MariaDB si ofin ogiriina nipa ṣiṣe pipaṣẹ isalẹ. Lọgan ti a ba fi ofin kun, ogiriina nilo lati tun gbejade.

$ sudo firewall-cmd --permanent --add-service=mysql
$ sudo firewall-cmd --reload

Igbesẹ 3: Ni ifipamo olupin MariaDB lori CentOS 8

Gẹgẹbi igbesẹ ti o kẹhin, a nilo lati ṣiṣe iwe afọwọkọ fifi sori ẹrọ MariaDB ti o ni aabo. Iwe afọwọkọ yii ṣe itọju ti ṣeto ọrọigbaniwọle gbongbo, tun ṣe awọn anfani lati tun ṣe, yiyọ awọn apoti isura data idanwo, gbigba gbigba wiwọle root.

$ sudo mysql_secure_installation

Bayi sopọ si MariaDB bi olumulo gbongbo ati ṣayẹwo ẹya nipasẹ ṣiṣe awọn ofin wọnyi.

$ mysql -uroot -p

Iyẹn ni fun nkan yii. A ti rii bii a ṣe le fi sori ẹrọ ati tunto MariaDB lori CentOS 8 Linux.