Yadda ake Sanya MariaDB 10 akan Debian da Ubuntu


MariaDB cokali mai yatsa ce mai kyauta kuma buɗaɗɗen mashahurin software na sarrafa bayanai na MySQL. An haɓaka shi ƙarƙashin GPLv2 (Sigar Lasisi na Jama'a na Gabaɗaya 2) ta ainihin masu haɓaka MySQL kuma an yi niyya don kasancewa buɗe tushen.

An ƙera shi don cimma babban jituwa tare da MySQL. Don farawa, zaku iya karanta fasalulluka na MariaDB vs MySQL don ƙarin bayani kuma mahimmanci, manyan kamfanoni/ƙungiyoyi ke amfani da shi kamar Wikipedia, WordPress.com, Google da ƙari da ƙari mai yawa.

A cikin wannan labarin, za mu nuna maka yadda ake shigar da MariaDB 10.1 barga version a cikin daban-daban na rarraba Debian da Ubuntu.

Sanya MariaDB a cikin Debian da Ubuntu

1. Kafin shigar da MariaDB, dole ne ku shigo da maɓallin ma'ajiyar ku kuma ƙara ma'ajiyar MariaDB tare da umarni masu zuwa:

$ sudo apt-get install software-properties-common
$ sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8
$ sudo add-apt-repository 'deb [arch=amd64,i386] http://www.ftp.saix.net/DB/mariadb/repo/10.1/debian sid main'
$ sudo apt-get install software-properties-common
$ sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8
$ sudo add-apt-repository 'deb [arch=amd64] http://www.ftp.saix.net/DB/mariadb/repo/10.1/debian stretch main'
$ sudo apt-get install software-properties-common
$ sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
$ sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://www.ftp.saix.net/DB/mariadb/repo/10.1/debian  jessie main'
$ sudo apt-get install python-software-properties
$ sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
$ sudo add-apt-repository 'deb [arch=amd64,i386] http://www.ftp.saix.net/DB/mariadb/repo/10.1/debian wheezy main'
$ sudo apt-get install software-properties-common
$ sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
$ sudo add-apt-repository 'deb [arch=amd64,i386] http://www.ftp.saix.net/DB/mariadb/repo/10.1/ubuntu yakkety main'
$ sudo apt-get install software-properties-common
$ sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
$ sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://www.ftp.saix.net/DB/mariadb/repo/10.1/ubuntu xenial main'
$ sudo apt-get install software-properties-common
$ sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
$ sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://www.ftp.saix.net/DB/mariadb/repo/10.1/ubuntu trusty main'

2. Sannan sabunta jerin tushen fakitin tsarin, kuma shigar da uwar garken MariaDB kamar haka:

$ sudo apt-get update
$ sudo apt-get install mariadb-server

Yayin lokacin shigarwa, za a tambaye ku don saita uwar garken MariaDB; saita amintaccen kalmar sirrin mai amfani a cikin dubawar da ke ƙasa.

Sake shigar da kalmar wucewa kuma latsa [Enter] don ci gaba da tsarin shigarwa.

3. Lokacin da shigarwa na MariaDB kunshe-kunshe ya cika, fara daemon uwar garken bayanai na tsawon lokaci kuma ya ba shi damar farawa ta atomatik a taya na gaba kamar haka:

------------- On SystemD Systems ------------- 
$ sudo systemctl start mariadb
$ sudo systemctl enable mariadb
$ sudo systemctl status mariadb

------------- On SysVinit Systems ------------- 
$ sudo service mysql  start 
$ chkconfig --level 35 mysql on
OR
$ update-rc.d mysql defaults
$ sudo service mysql status

4. Sa'an nan kuma gudanar da rubutun mysql_secure_installation don tabbatar da bayanan da za ku iya:

  1. saitin kalmar sirri (idan ba'a saita shi a matakin daidaitawa a sama ba).
  2. kashe ramut tushen shiga
  3. cire bayanan gwaji
  4. cire masu amfani da
  5. sake shigar da gata

$ sudo mysql_secure_installation

5. Da zarar an kiyaye uwar garken bayanai, duba sigar shigar da shi kuma shiga cikin harsashi na MariaDB kamar haka:

$ mysql -V
$ mysql -u root -p

Don fara koyon MySQL/MariaDB, karanta ta hanyar:

  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

Kuma duba waɗannan kayan aikin layin umarni masu amfani guda 4 zuwa 15 masu amfani MySQL/MariaDB daidaita ayyukan aiki da nasihun ingantawa.

Shi ke nan. A cikin wannan labarin, mun nuna muku yadda ake shigar da MariaDB 10.1 barga version a cikin daban-daban na Debian da Ubuntu. Kuna iya aiko mana da kowace tambaya/tunani ta hanyar sharhin da ke ƙasa.