Yadda ake Sanya MariaDB akan Rocky Linux da AlmaLinux


MariaDB tsarin bayanai ne na alaƙa kyauta kuma haɓakar al'umma wanda shine madaidaicin juzu'in maye gurbin babban mashahurin tsarin sarrafa bayanai na MySQL.

An yi watsi da shi daga MySQL bayan ainihin masu haɓaka MySQL sun bayyana ra'ayinsu game da siyan MySQL ta Oracle. Tun daga wannan lokacin, MariaDB yana da tabbacin kasancewa kyauta kuma buɗe tushen ƙarƙashin lasisin GNU.

MariaDB ya shahara sosai saboda saurin aikinsa, haɓakawa, kwanciyar hankali, da ƙarfi. Ya dace da tsarin aiki da yawa da suka haɗa da Linux, FreeBSD, Mac, da Windows.

Ƙaƙƙarfan tsarin injunan ajiya, plugins, da sauran kayan aikin sanyi waɗanda yake bayarwa sun sa ya zama kyakkyawan zaɓi don lokuta daban-daban na amfani kamar nazarin bayanai, ajiyar bayanai, sarrafa ma'amala, da sauransu. A haƙiƙa, babban maɓalli ne na tarin LEMP waɗanda ake amfani da su don ɗaukar aikace-aikacen yanar gizo.

Mahimman siffofi na MariaDB sun haɗa da:

  • Fasahar tari ta Galera.
  • Sabbin injunan ajiya kamar InnoDB, XtraDB, Aria, TokuDB, CONNECT, da SEQUENCE don ambaton kaɗan.
  • Mafi sauri kuma ingantacciyar kwafi.
  • Babban tafkin zaren da ke iya tallafawa haɗin kai har 200,00+.
  • Sabbin fasaloli kamar su tebur mai sigar tsarin, nau'ikan bayanan da aka angi, da tantance soket na UNIX don ambata kaɗan.

A cikin wannan labarin, muna tafiya ta hanyar yadda ake shigar da uwar garken bayanan MariaDB akan Rocky Linux 8 da AlmaLinux 8.

Mataki 1: Ƙara Ma'ajiyar MariaDB a cikin Rocky Linux

Ta hanyar tsoho, wurin ajiyar Rocky Linux AppStream yana ba da MariaDB 10.3. Duk da haka, wannan ba shine sabon sigar ba. A halin yanzu, kwanciyar hankali na yanzu shine MariaDB 10.6.

Don shigar da sabon sigar, ƙirƙiri fayil ɗin ajiya na MariaDB akan tsarin ku kamar haka.

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

Manna layin da aka nuna.

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

Sannan ajiye canje-canje kuma fita daga fayil ɗin.

Na gaba, sabunta ma'ajiyar tsarin don Rocky don yin rajistar sabuwar ma'ajiyar da aka ƙara.

$ sudo dnf update

Mataki 2: Sanya MariaDB a cikin Rocky Linux

Tare da wurin ajiyar wurin, matsa tare kuma shigar da uwar garken bayanan MariaDB kamar yadda aka nuna:

$ sudo dnf install mariadb-server mariadb

Da zarar an shigar, kunna sabis na MariaDB don farawa akan lokacin taya kuma fara sabis ta amfani da umarni masu zuwa.

$ sudo systemctl enable mariadb
$ sudo systemctl start mariadb

Sannan tabbatar da matsayin mai gudana na MariaDB.

$ sudo systemctl status mariadb

Sakamakon ya nuna cewa komai yana aiki kamar yadda ya kamata.

Mataki 3: Amintacce MariaDB a cikin Rocky Linux

MariaDB ya zo tare da saitunan tsoho waɗanda suke da rauni kuma suna fuskantar haɗarin tsaro waɗanda zasu iya haifar da amfani da uwar garken bayanan ta hanyar hackers. Don haka, muna buƙatar ɗaukar ƙarin matakai don amintar uwar garken bayanai.

Don yin haka, za mu gudanar da rubutun da ke ƙasa.

$ sudo mysql_secure_installation

Da farko, saita tushen kalmar sirri.

Don sauran tsokana, danna 'Y' don share masu amfani da ba a san su ba, hana tushen shiga nesa kuma cire bayanan gwajin da ba a buƙata a samarwa kuma a ƙarshe adana canje-canje.

Don shiga cikin uwar garken bayanai na MariaDB, gudanar da umarni mai zuwa

$ sudo mysql -u root -p

Samar da tushen kalmar sirrin da kuka saita a mataki na baya kuma danna ENTER don samun damar harsashin MariaDB.

Kuma ku tafi. Mun sami nasarar shigar da uwar garken bayanan MariaDB akan Rocky Linux 8. Ka tuna, har yanzu kuna iya amfani da sigar da aka bayar ta wurin ajiyar AppStream wanda zai yi aiki daidai. Koyaya, idan kuna neman shigar da sabon sigar MariaDB, to ƙara ma'ajiyar zai yi abin zamba.