Yadda ake Shigar da Amintacce MariaDB 10 a cikin CentOS 7

MariaDB cokali ne na kyauta kuma buɗaɗɗen sanannen software na uwar garken sarrafa bayanai na MySQL, wanda kwakwalwar da ke bayan MySQL ta haɓaka, ana hasashen ta kasance tushen kyauta/buɗewa.

A cikin wannan koyawa, za mu nuna muku yadda ake shigar da sigar daidaitawar MariaDB 10.1 a cikin mafi yawan nau'ikan rarraba RHEL/CentOS da Fedora da ake amfani da su.

Don bayanin ku, Red Hat Enterprise Linux/CentOS 7.0 ya sauya daga goyan bayan MySQL zuwa MariaDB azaman tsarin sarrafa bayanai na asali.

Lura cewa a cikin wannan koyawa, za mu ɗauka aikin ku akan sabar azaman tushen, in ba haka ba, yi amfani da umarnin sudo don gudanar da duk umarni.

Mataki 1: Ƙara Ma'ajiyar MariaDB Yum

1. Fara da ƙara fayil ɗin ajiyar MariaDB YUM MariaDB.repodon tsarin RHEL/CentOS da Fedora.

# vi /etc/yum.repos.d/MariaDB.repo

Yanzu ƙara layin masu zuwa zuwa nau'in rarraba Linux ɗin ku kamar yadda aka nuna.

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/rhel7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Mataki 2: Sanya MariaDB a cikin CentOS 7

2. Da zarar an ƙara ma'ajiyar MariaDB, zaka iya shigar dashi cikin sauƙi tare da umarni ɗaya kawai.

# yum install MariaDB-server MariaDB-client -y

3. Da zaran an gama shigarwar fakitin MariaDB, fara daemon uwar garken bayanai na ɗan lokaci, sannan kuma ya ba shi damar farawa ta atomatik a taya na gaba kamar haka:

# systemctl start mariadb
# systemctl enable mariadb
# systemctl status mariadb

Mataki 3: Amintacce MariaDB a cikin CentOS 7

4. Yanzu lokaci ya yi don tabbatar da MariaDB ta hanyar saita kalmar sirri, kashe ramut tushen shiga, cire bayanan gwajin da kuma masu amfani da ba a san su ba kuma a ƙarshe sake loda gata kamar yadda aka nuna a hoton allo a ƙasa:

# mysql_secure_installation

5. Bayan tabbatar da uwar garken bayanai, kuna iya bincika wasu fasalulluka na MariaDB kamar: sigar shigarwa, jerin muhawarar shirin tsoho, da kuma shiga cikin harsashin umarnin MariaDB kamar haka:

# mysql -V
# mysqld --print-defaults
# mysql -u root -p

Mataki 4: Koyi Gudanarwar MariaDB

Idan kun kasance sababbi ga MySQL/MariaDB, fara farawa ta hanyar bin waɗannan jagororin:

  1. Koyi MySQL/MariaDB don Mafari - Kashi na 1
  2. Koyi MySQL/MariaDB don Masu farawa - Kashi na 2
  3. MySQL Dokokin Gudanarwa na Basic Database – Sashe na III
  4. 20 MySQL (Mysqladmin) Umarni don Gudanar da Database – Sashe na IV

Hakanan duba waɗannan labaran masu zuwa don daidaita aikin MySQL/MariaDB ɗinku kuma kuyi amfani da kayan aikin don saka idanu akan ayyukan bayananku.

  1. Nasihu 15 don Tuna da Inganta Ayyukan MySQL/MariaDB naku
  2. 4 Kayayyakin Amfani don Kula da Ayyukan Bayanai na MySQL/MariaDB

Shi ke nan a yanzu! A cikin wannan koyawa mai sauƙi, mun nuna muku yadda ake shigar da MariaDB 10.1 barga version a cikin RHEL/CentOS da Fedora daban-daban. Yi amfani da fom ɗin amsa da ke ƙasa don aiko mana da kowace tambaya ko kowane tunani game da wannan jagorar.