Labarin Bayan Samun MySQL ta Sun Microsystem da Rise na MariaDB

Database wani bayani ne da aka tsara ta yadda tsarin kwamfuta zai iya shiga cikin bayanan da aka adana ko wani sashi nasa. Ana adana wannan tsarin fayil ɗin lantarki, sabuntawa, zaɓi da sharewa ta amfani da wani shiri na musamman mai suna Database Management System (DBMS). Akwai babban jeri na DBMS, kaɗan daga cikinsu sun sanya cikin jerin sunayen - MySQL, MariaDB, SQL Server, Oracle, DB2, LibreOffice Base, Harkokin Microsoft, da sauransu.

Wadanda suka yi aiki a kan Muhalli na Linux tabbas sun san cewa MySQL ya kasance yana zama Tsarin Gudanar da Bayanan Bayanai na Default na dogon lokaci kafin a maye gurbinsa da MariaDB. Me ya faru kwatsam? Me yasa aikin Linux yayi wa wannan aikin. Kafin mu ci gaba da wannan batu bari mu ɗan sami taƙaitaccen bayani.

An kafa MySQL daga Allan Larsson, Michael Widenius da David Axmark a cikin shekara ta 1995, shekaru 19 da suka gabata. An sake shi da sunan co-kafa Michael Widenius 'yar, 'My'. An fito da wannan aikin ƙarƙashin lasisin Jama'a na GNU da kuma ƙarƙashin wasu lasisin Mallaka. MySQL mallakar MySQL AB kamfani ne har sai da ya shiga hannun Oracle Corporation. An rubuta shi a cikin Harshen Shirye-shiryen - C da C++ kuma yana samuwa ga Windows, Linux, Solaris, MacOS da FreeBSD.

Bayan Samun MySQL ta Oracle Inc. da kuma buƙatar ingantaccen Database mai ƙima ya sa malamai suyi tunanin wasu hanyoyi kamar PostgreSQL da MongoDB. Canjawa zuwa ɗayan biyun bai kasance mai sauƙi ba ko mafi kyawun maye daga hangen nesa na gaba.

A lokaci guda a cikin shekara ta 2009, Michael Widenius ya fara aiki akan MarisDB a matsayin cokali mai yatsa na MySQL. A cikin 2012 an kafa tubali na Gidauniyar MariaDB mai zaman kanta. An ba shi sunan 'yar wanda ya kafa Maria.

MariaDB cokali ne na Tsarin Gudanar da Bayanan Bayanai na MySQL wanda kuma aka sake fitowa a ƙarƙashin lasisin Jama'a na GNU. An rubuta shi a cikin Harshen Shirye-shiryen - C, C++, Perl da Bash kuma yana samuwa ga Linux Systems, Windows , Solaris, MacOS da FreeBSD.

Samun MySQL

Dala biliyan 1 ba ƙaramin kuɗi ba ne ga kamfanin MySQL AB haka kuma ba sa so su bar damar ta tafi a banza don aikin buɗe tushen don shigo cikin babban duniya kuma don haka MySQL ya zo ƙarƙashin Collar of Sun Microsystem a cikin Shekarar 2008 .

Wani lamari ne na kwatsam cewa Oracle Inc., ya sayi Sun Microsystem kuma a ƙarshe MySQL ya kasance mallakin Oracle, a cikin shekara ta 2009. Tare da wannan ɗaukar nauyi an haifar da tambayoyi da yawa a wancan lokacin. Kamar:

  1. Shin zai yi kyau ga Kasuwa?
  2. Shin zai kasance da amfani ga masu amfani?
  3. Oracle ta hanyar ba da tallafi da fitar da sabuntawa don buɗaɗɗen tushen DBMS, akan hanyar Oracle, yana yin wani alheri?
  4. Shin za a tabbatar da shi azaman Armor of Oracle ne?
  5. Menene tasirin sa akan Kasuwar mallakar mallaka?
  6. Kamfanoni kamar Microsoft, Apple za su nuna haɓakar haɓakawa a kasuwa?
  7. Shin zai zama lafiya ko cutarwa ga IBM?
  8. Shin zai lalatar da FOSS Mai Hakuri?

Har yau, ba mu da amsar duk tambayoyin amma tabbas kasuwa ta tabbatar da yawa. Wasu canje-canjen da duniya ta gani.

Shahararrun gidan yanar gizo na shida na duniya ya motsa Database daga MySQL zuwa MariaDB.

Shahararren rukunin yanar gizon duniya an canja shi daga MySQL zuwa MariaDB.

MariaDB yana aiki mafi kyau kuma don haka Shafukan Yanar Gizon Yanar Gizon mafi yawan aiki a duniya suna amfani da shi. Kuma duk wanda ke tafiyar da Linux Seriously dole ne ya san cewa 'M' na LAMP tarin ya canza.

Tarukan kan layi da yawa da manazartan kasuwanci sun kalli wannan a matsayin trump da Oracle ya buga don ƙare tushen mai amfani na MySQL. Darwin ya ce ‘Survival of the Fittest’ kuma kasuwa tana son fahimtar wannan. MySQL cokali mai yatsu MariaDB tushe da rayuwa sun ƙirƙiri tarihi.

MySQL da MariaDB - Nazarin Kwatancen

Daidaituwar MariaDB tare da MySQL har ma da wasu abubuwan ci gaba sun zama ƙarfin MariaDB.

NOTE: Sauya-in maye yana nufin, idan aikace-aikacen yana aiki akan MySQL 5.5, zai kuma yi aiki akan MariaDB 5.5 ba tare da wata matsala ba.

Shigar da MariaDB a cikin Linux

MariaDB 10.0.12 shine ingantaccen saki na yanzu. Haka kuma MariaDB zazzage shafin ya ƙunshi takamaiman binaries don RPM tushen distro's da DPKG na tushen Distros, waɗanda za'a iya zazzage su daga hanyar haɗin da ke ƙasa.

  1. https://downloads.mariadb.org/mariadb/10.0.12/

Kawai zazzage madaidaicin fakitin RPM da DPKG kuma shigar da shi kamar yadda aka nuna a ƙasa.

# rpm -ivh maria*.rpm		[For RedHat based systems]
# dpkg -i maria*.deb		[For Debian based systems]

Hakanan zaka iya shigar da MariaDB daga wurin ajiya, amma yana da mahimmanci don saita repo, na farko. Bi hanyar haɗin da ke ƙasa kuma zaɓi distro ku tafi.

  1. Saita Ma'ajiya na MariaDB

Wannan ita ce hanya mafi sauƙi don shigar da MariaDB akan sabuwar da kuma tsohuwar tsayayyen Rarraba Linux. Koyaya, idan baku san yadda ake saita wuraren ajiya a ƙarƙashin tsarin Linux ba. Kuna iya bin labaran mu na ƙasa, inda muka rufe shigarwar MariaDB akan ƴan zaɓaɓɓun rabawa.

  1. Saita LAMP (Linux, Apache, MariaDB, PHP/PhpMyAdmin) a cikin RHEL/CentOS
  2. Saka LAMP (Linux, Apache, MariaDB, PHP) akan Ubuntu 14.04 Server
    3. Shigar LEMP (Nginx, PHP, MySQL tare da injin MariaDB da PhpMyAdmin) a cikin Arch Linux
  3. Shigar da LAMP (Linux, Apache, MySQL/MariaDB, da PHP/PhpMyAdmin) a cikin Arch Linux
    4. Ana shigar da LEMP (Linux, Nginx, MySQL/MariaDB, PHP/PHP-FPM da PhpMyAdmin) a cikin Linux Gentoo

Shi ke nan a yanzu. Ba karshensa ba. Mafarinsa ne. Tafiya da aka fara a 2009 har yanzu tana ci gaba kuma dole ne ta yi nisa daga nan. MariaDB yana da girma na MySQL kuma kuna jin a gida wanda ya dandana MySQL.

Za mu zo da labarin nan ba da jimawa ba wanda zai jagoranci daga yin ƙananan tebur zuwa gudanar da ƙananan tambayoyi. Har sai a saurara kuma ku haɗa zuwa Tecment. Kar ku manta da samar mana da ra'ayoyin ku masu mahimmanci a cikin sashin sharhin da ke ƙasa.