Otu esi etinye MariaDB 10 na Debian na Ubuntu

MariaDB bụ ndụdụ efu na mepere emepe nke ngwanrọ njikwa nchekwa data MySQL ewu ewu. Emebere ya n'okpuru GPLv2 (ụdị ikike ọhaneze 2) site n'aka ndị nrụpụta izizi MySQL na e bu n'obi ka ọ nọgide na-emeghe.

Emebere ya iji nweta ndakọrịta dị elu na MySQL. Maka mmalite, ị nwere ike ịgụ MariaDB vs MySQL atụmatụ maka ozi ndị ọzọ na ihe dị mkpa, nnukwu ụlọ ọrụ/òtù dị ka Wikipedia, WordPress.com, Google gbakwunyere na ọtụtụ ndị ọzọ na-eji ya.

N'ime edemede a, anyị ga-egosi gị otu esi etinye MariaDB 10.1 kwụsiri ike na mwepụta nkesa Debian na Ubuntu dị iche iche.

Wụnye MariaDB na Debian na Ubuntu

1. Tupu ịwụnye MariaDB, ị ga-ebubata igodo nchekwa ma tinye ebe nchekwa MariaDB na iwu ndị a:

$ 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. Wee melite ndepụta nchịkọta ngwugwu sistemụ, wee wụnye ihe nkesa MariaDB dị ka nke a:

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

N'oge ntinye, a ga-agwa gị ka ịhazie ihe nkesa MariaDB; tọọ paswọọdụ onye ọrụ mgbọrọgwụ echekwara na interface dị n'okpuru.

Tinyegharịa paswọọdụ wee pịa [Tinye] ka ịga n'ihu na usoro nwụnye.

3. Mgbe ntinye nke ngwugwu MariaDB zuru, malite daemon nkesa nchekwa data maka oge ọ bụla ma mee ka ọ malite na-akpaghị aka na akpụkpọ ụkwụ na-esote dị ka ndị a:

------------- 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. wee mee mysql_secure_installation script iji chekwaa nchekwa data ebe ị nwere ike:

  1. tọọ okwuntughe mgbọrọgwụ (ma ọ bụrụ na edoghị ya na usoro nhazi n'elu).
  2. gbanyụọ nbanye mgbọrọgwụ ime ime
  3. wepu nchekwa data nnwale
  4. wepu ndị ọrụ na-amaghị aha na
  5. bugharịa ihe ùgwù

$ sudo mysql_secure_installation

5. Ozugbo echekwara ihe nkesa nchekwa data, lelee ụdị arụnyere ya wee banye na shei iwu MariaDB dị ka ndị a:

$ mysql -V
$ mysql -u root -p

Iji malite ịmụ MySQL/MariaDB, gụọ site na:

  1. Mụta MySQL/MariaDB maka ndị mbido – Akụkụ 1
  2. Mụta MySQL/MariaDB maka ndị mbido – Nkebi nke 2
  3. MySQL Basic Database Administration Iwu – Nkebi III
  4. 20 MySQL (Mysqladmin) Iwu maka nchịkwa nchekwa data - Nkebi IV

Lelee ngwa ọrụ iwu 4 ndị a bara uru ka 15 bara uru MySQL/MariaDB nrụzi arụmọrụ yana ndụmọdụ kachasị mma.

Ọ gwụla. N'isiokwu a, anyị gosiri gị otu esi etinye MariaDB 10.1 n'ụdị dị iche iche nke Debian na Ubuntu. Ị nwere ike izipu anyị ajụjụ/echiche ọ bụla site na ụdị nkọwa n'okpuru.