Bii o ṣe le Fi sii MariaDB 10 lori Debian ati Ubuntu

MariaDB jẹ orita orisun ọfẹ ati ṣiṣi ti olokiki olupin sọfitiwia iṣakoso data MySQL. O ti dagbasoke labẹ GPLv2 (Ẹya Iwe-aṣẹ Gbogbogbo ti Gbogbogbo ẹya 2) nipasẹ awọn oludasile atilẹba ti MySQL ati pe a pinnu lati wa orisun ṣiṣi.

A ṣe apẹrẹ lati ṣaṣeyọri ibaramu giga pẹlu MySQL. Fun awọn ibẹrẹ, o le ka awọn ẹya MariaDB vs MySQL fun alaye diẹ sii ati pataki, o lo nipasẹ awọn ile-iṣẹ nla/awọn ajo bii Wikipedia, WordPress.com, Google plus ati ọpọlọpọ diẹ sii.

Ninu nkan yii, a yoo fi ọ han bi o ṣe le fi sori ẹrọ ikede iduroṣinṣin MariaDB 10.1 ni ọpọlọpọ awọn idasilẹ pinpin Debian ati Ubuntu.

Fi MariaDB sori Debian ati Ubuntu

1. Ṣaaju ki o to fi sii MariaDB, iwọ yoo ni lati gbe bọtini ifipamọ wọle ki o ṣafikun ibi ipamọ MariaDB pẹlu awọn ofin wọnyi:

$ 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. Lẹhinna mu imudojuiwọn awọn orisun awọn idii eto, ki o fi sori ẹrọ olupin MariaDB bii bẹẹ:

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

Lakoko iṣẹ fifi sori ẹrọ, ao beere lọwọ rẹ lati tunto olupin MariaDB; ṣeto ọrọigbaniwọle olumulo to ni aabo ni wiwo ni isalẹ.

Tun-tẹ ọrọ igbaniwọle sii ki o tẹ [Tẹ] lati tẹsiwaju pẹlu ilana fifi sori ẹrọ.

3. Nigbati fifi sori ẹrọ ti awọn idii MariaDB pari, bẹrẹ daemon olupin data data fun akoko ti o tumọ si ki o jẹ ki o bẹrẹ laifọwọyi ni bata atẹle bi atẹle:

------------- 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. Lẹhinna ṣiṣe mysql_secure_installation iwe afọwọkọ lati ni aabo ibi ipamọ data nibiti o le:

  1. ṣeto ọrọ igbaniwọle gbongbo (ti ko ba ṣeto ni igbesẹ iṣeto loke).
  2. mu wiwọle latọna jijin wiwọle
  3. yọ ibi ipamọ data idanwo
  4. yọ awọn olumulo alailorukọ kuro ati
  5. tun gbe awọn anfani pada 

$ sudo mysql_secure_installation

5. Ni kete ti o ti ni olupin olupin data, ṣayẹwo ẹya ti o ti fi sii ati buwolu wọle si ikarahun aṣẹ MariaDB gẹgẹbi atẹle:

$ mysql -V
$ mysql -u root -p

Lati bẹrẹ kọ ẹkọ MySQL/MariaDB, ka nipasẹ:

  1. Kọ ẹkọ MySQL/MariaDB fun Awọn Ibẹrẹ - Apá 1
  2. Kọ ẹkọ MySQL/MariaDB fun Awọn ibẹrẹ - Apá 2
  3. Awọn pipaṣẹ Isakoso data ipilẹ MySQL - Apakan III
  4. 20 MySQL (Mysqladmin) Awọn pipaṣẹ fun Isakoso data - Apakan IV

Ati ṣayẹwo awọn irinṣẹ pipaṣẹ iwulo 4 wọnyi to wulo si 15 tunes iṣẹ iṣe MySQL/MariaDB ati awọn imọran ti o dara julọ.

Gbogbo ẹ niyẹn. Ninu nkan yii, a fihan ọ bi o ṣe le fi ẹya iduroṣinṣin MariaDB 10.1 sori ẹrọ ni ọpọlọpọ awọn idasilẹ Debian ati Ubuntu. O le firanṣẹ eyikeyi awọn ibeere/ero nipasẹ fọọmu asọye ni isalẹ.