Menene MariaDB? Ta yaya MariaDB ke Aiki?

MariaDB, cokali mai yatsa na MySQL yana ɗaya daga cikin shahararren mashahurin buɗe tushen SQL (Tsarin Ingantaccen Tambaya) tsarin tsarin sarrafa bayanai, wanda asalin masu haɓaka MySQL suka yi. An tsara shi don sauri, aminci, da sauƙin amfani.

Tsarin tsarin MySQL ne na asali a cikin ma'ajiyar ajiya mafi yawansu idan ba duk manyan rarrabuwa Linux ba har da RHEL (RedHat Enterprise Linux) da Fedora Linux. Hakanan yana aiki akan Windows da macOS, da sauran tsarin aiki da yawa. Ana amfani dashi azaman maye gurbin tsarin tsarin MySQL a cikin LAMP (Linux + Apache + MariaDB + PHP) da LEMP (Linux + Engine-X + MariaDB + PHP).

Ci gaba ne ya fara saboda damuwar da ta taso a lokacin da kamfanin Oracle Corporation ya samu MySQL a shekara ta 2009. Yanzu, masu haɓakawa da masu kula da MariaDB suna haɗuwa kowane wata tare da lambar lambar MySQL ɗin don tabbatar da cewa MariaDB tana da duk wani gyaran bug da ya dace da aka ƙara zuwa MySQL.

Ana samun uwar garken MariaDB a ƙarƙashin lasisin GPL, fasali na 2, kuma ɗakunan karatu na abokan cinikin su na C, Java, da ODBC ana rarraba su a ƙarƙashin lasisin LGPL, sigar ta 2.1 ko sama da haka. Ana bayar da shi a cikin bugu biyu daban-daban.

Na farko shine MariaDB Community Server wanda zaku iya zazzagewa, amfani dashi, kuma gyara shi kyauta. Buga na biyu shine MariaDB Server Server wanda akayi niyya don maye gurbin bayanai na mallaka da kuma karɓar tushen buɗewa a cikin masana'antar.

  • Zazzage Marubucin MariaDB na Al'umma
  • Zazzage Sabis ɗin Kasuwancin MariaDB

Ta yaya MariaDB ke Aiki?

Kamar dai MySQL, MariaDB kuma yana amfani da samfurin abokin ciniki/uwar garke tare da shirin sabar wanda ke buƙatar buƙatun daga shirye-shiryen abokin ciniki. Kamar yadda yake na al'ada na tsarin kwamfuta na abokin ciniki/uwar garken, sabar da shirye-shiryen abokin ciniki na iya kasancewa akan runduna daban-daban.

Mahimman Ayyuka na MariaDB

MariaDB tana dacewa sosai da MySQL kamar yadda kowane nau'in MariaDB yake aiki azaman\"maye gurbin-saukarwa" don makamancin tsarin MySQL ɗin, kodayake, tare da iyakancewa kamar wata.

Idan kana yin ƙaura zuwa MariaDB, fayilolin data ɗinsa gabaɗaya sun dace da waɗanda suke daga irinta ta MySQL ɗin, kuma har ila yau yarjejeniya ta abokin cinikin MariaDB tana dacewa da binar na abokin ciniki na MySQL.

  • Yana tallafawa maganganun SQL daban-daban, tsari, da ƙa'idodi, ayyuka da matakai, ayyuka masu ayyana mai amfani (mai amfani don faɗaɗa MariaDB), masu canjin sabar, da kuma hanyoyin SQL, rarraba tebur, ajiyar bayanai, da sabuntawa, saka idanu kan sabar da kuma rajistan ayyukan. Hakanan yana jigilar kayayyaki da yawa kamar kayan aikin duba MariaDB, da ƙari.
  • MariaDB ya zo tare da sababbin zaɓuɓɓuka da yawa, fasali, da kari, injunan adanawa, da kuma gyaran ƙwari waɗanda ba sa cikin MySQL. Wasu sabbin abubuwa a cikin MariaDB suna ci gaba ne tare da Galera Cluster 4, fasalulluka masu jituwa tare da Oracle Database, da kuma Temporal Data Tables (wanda zai baka damar tambayar bayanan kamar yadda yake a kowane wuri a da), da ƙari sosai.
    • Waɗannan siffofin tsaro iri ɗaya a cikin MySQL suna cikin MariaDB. Allyari, ya kamata ku yi la'akari da mafi kyawun ayyuka don amintar da sabar bayananku. Hakanan, tabbatar da bayananka yakamata ya fara daidai a hanyar sadarwa da kuma matakin uwar garke.

Yana da mahimmanci a fahimta cewa kodayake MariaDB ya kasance mai dacewa da MySQL, amma ainihin tushe ne (kuma al'umma ta haɓaka shi da ruhun buɗe ido na gaskiya), ba shi da kowane rufin tushen kayan aiki kamar waɗanda ke cikin MySQL Editionab'in ciniki.

Takaddun MariaDB zai taimaka muku don fahimtar bambance-bambance tsakanin MySQL da MariaDB.

MariaDB Abokin ciniki da Kayan aiki

Ga duka MariaDB da MySQL, duk APIs na kwastomomi iri ɗaya ne, duk mashigai da kwasfa iri ɗaya ne, kuma duk masu haɗin MySQL don yarukan shirye-shirye kamar su Python, Perl, PHP, Ruby, Java, da MySQL C mai haɗawa, da sauransu basu canzawa ba ƙarƙashin MariaDB.

Hakanan, MariaDB tana zuwa tare da shirye-shiryen abokan ciniki da yawa kamar su shahararrun abubuwan amfani da layin umarni: mysql, mysqldump, don gudanar da bayanan bayanai.

Wanene ke Amfani da MariaDB?

Wasu kamfanoni masu amfani da MariaDB sun haɗa da RedHat, Ubuntu, Google, Wikipedia, Tumblr, Amazon Web Services, SUSE Linux, da ƙari.

Anan ga wasu labarai masu amfani game da MariaDB:

  • Amfani da MySQL/MariaDB Ayyukan Gyarawa da Tipswarewar Inganci
  • Yadda za a Canza Tushen Kalmar sirri na MySQL ko MariaDB a cikin Linux
  • Yadda za a Canza Tsoho MySQL/MariaDB Port a Linux
  • Yadda Ake Canza Tsoffin MySQL/MariaDB Littafin Bayanai a Linux
  • Kayan Amfani na Umurnin amfani 4 don Kula da Ayyukan MySQL a cikin Linux