I-MySQL eya eMaria DB: Umhlahlandlela Wokufuduka Ngokushesha we-Debian

Lapho umkhiqizo osebenzayo futhi okhokhelayo, futhi lowo ungumthombo ovulekile, ungena ezandleni zenkampani inhloso yayo okungeyona enye ngaphandle kokwenza imali eyengeziwe, umhlaba uyathuthumela.

Sekuvele kwenzeka nge I-OpenOffice ngaleso sikhathi futhi manje sekuyithuba le- MySQL. Ukunikeza ku Oracle ngemuva akekho owaziyo okungenzeka futhi kuhle ukwazi ukuthi kunezinye izindlela futhi ikakhulukazi okuhle kunakho konke UMaria DB.

Ukucaphuna iWikipedia:

MariaDB Kuyinto a uhlelo lokuphathwa kwemininingwane egciniwe isuselwe kwi MySQL con Ilayisense ye-GPL. Kuthuthukiswa ngu UMichael Widenius (umsunguli we MySQL) nomphakathi wonjiniyela software free. Faka ezimbili izinjini zokugcina okusha, omunye ubiziwe Aria -okungena esikhundleni sezinzuzo I-MyISAM- nolunye ucingo I-XtraDB -ukufaka esikhundleni InnoDB. Inokusebenzisana okuphezulu ne-MySQL ngoba inemiyalo efanayo, izixhumi ezihlangene, ama-API kanye nemitapo yolwazi, inhloso yayo ukukwazi ukushintshela iseva eyodwa iye ngqo.

Ngakho-ke ngaphandle kokuqhubeka kwe-ado ake sibone ukuthi singasuka kanjani MySQL a UMaria DB.

Kubalulekile ukwazi ukuthi ukuze lokhu kusebenze nge-100%, kufanele sibe nohlobo olufanayo lwe-MySQL (5.5) neMaria DB (5.5)

Ukufuduka kusuka ku-MySQL kuye eMaria DB

Le nqubo ayikwazi ukwenziwa ishise. Ngamanye amagama, kufanele simise isikhashana izinsizakalo nezinqubo zethu ezisebenzayo MySQL.

# service stop apache2 # service stop nginx # service stop mysql

Kulokhu simisa i-Apache noma i-NGinx kuye ngokuthi sisebenzisa yiphi, futhi-ke simisa ne-MySQL.

Kamuva senza isipele sedatha yethu ye-MySQL:

# mysqldump -u root -p --all-databases > mysqlbackup.sql

Futhi sisusa wonke amaphakheji ahlobene ne-MySQL:

# aptitude remove mysql-server-core-5.5 mysql-server-5.5 mysql-server mysql-common mysql-client-5.5 libmysqlclient18

Manje kufanele sifake uMaria DB. Ngeshwa, ayikho ezinqolobaneni zeDebian okwamanje, kepha singayifaka sisebenzisa amakhosombe ayo. Ngokunye ukwabiwa, ungabona i- imiyalo lapha.

Sengeza okulandelayo kufayela lethu le- /etc/source.list:

Uhlu lokugcina lweMariaDB 5.5 - lwakhiwe 2013-08-02 13:48 UTC # http://mariadb.org/mariadb/repositories/ deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy okuyinhloko kwe-deb-src http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy main

Ngemuva kwalokho sivuselela futhi sifake uMaria DB:

ukuvuselelwa kwesudo apt apt fumana ukufaka mariadb-server

Siqala iMaria DB (uma ingakwenzanga ngokuzenzekelayo) bese ubheka ukuthi iyasebenza:

# mysql -u impande -p -Be 'bonisa imininingwane yolwazi' Faka iphasiwedi:

Ezinye izilungiselelo zishintshe kakhulu phakathi kwe-MySQL neMariaDB, kepha kulula kakhulu ukusebenza nayo. Cishe konke okuguqukile kuhlobene nezinqubo ezifakwe esikhundleni, isibonelo, ukuphindaphindeka. Kumele sikopishe kuphela izinketho zokwenza kahle ukusebenza ebesinakho kufayela my.cnf de MySQL, uphinde ulungise kabusha okunye ngesandla.

Isibonelo, le datha:

bind-address = 127.0.0.1 max_connections = 10 connect_timeout = 30 wait_timeout = 600 max_allowed_packet = 16M thread_cache_size = 256 OR sort = 16M bulk_insert_buffer_size = 16M tmp_table_size = 64M max_heap_table_size = 64M

Senza izinguquko ezidingekayo bese siqala kabusha iMaria DB.

# service mysql restart Ukumisa iseva yedatha ye-MariaDB: mysqld. Iqala iseva yedatha ye-MariaDB: mysqld. . . Ihlolela ukonakala, hhayi ukuvalwa ngokuhlanzekile nokuthuthukisa amatafula adingekayo .. # mysql -u root -p -Be 'show database' Enter password:

Yebo, UMaria DB gcina igama elifanayo le-mysql ukuqala kabusha insiza, ukuze ugcine ukuhambisana okungcono. Uma konke kuhamba kahle, khona-ke siqala ezinye izinsiza:

# service apache2 qala # service nginx qala

Futhi ngomumo. Uma sifuna ukubuyela emuva (engingakuncomi), kufanele nje sigijime:

# service mysql stop # apt-get mariadb-server-5.5 mariadb-common mariadb-client-5.5 libmariadbclient18 # apt-get ukufaka i-mysql-server

Umthombo: I-Article ithathiwe futhi yaguqulwa kusuka ku-StartLinux


Okuqukethwe yi-athikili kunamathela ezimisweni zethu ze izimiso zokuhlelela. Ukubika iphutha chofoza lapha.

Amazwana ayi-22, shiya okwakho

Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele imininingwane: Miguel Ángel Gatón
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.

  1.   Mauricio kusho

    Njengoba umthwalo wesipele sedatha ungekho.

    1.    izinga kusho

      Angicabangi ukuthi kunjalo, kodwa ngiyabonga ngokucaciswa. Senze isipele uma ngabe i-Database yamanje ihluleka, ngoba kubonakala kimi ukuthi bobabili basebenzisa i-DB efanayo. Kuzofanele ngifunde kabanzi ngale ndaba.

  2.   Ozkar kusho

    UFedora 19 usevele uza noMaria ngokuzenzakalela, kepha hhayi okufishane noma okuvilaphayo ngithuthele ama-web-apps ami ngiwafaka ePostgreSQL, kwazise iMySQL isishayile izimpondo, ngiyethemba iPostgreSQL ihlala ithembekile okungenani iminyaka engu-2-3.

    1.    izinga kusho

      I-ArchLinux ifaka noMaria DB 😀

      1.    Ozkar kusho

        Une-vice ye-Arch ... Ngisho nami nginamazinyo axegayo futhi ngifuna ukuwasebenzisa futhi ... kepha ngiyavilapha. 😀

  3.   3ndriago kusho

    Ngibona ukuthambekela kwezinhlelo kufaka phakathi ukusekelwa kukaMariaDB futhi ngokwalokho engikufundile kubonakala kusezingeni le-MySQL futhi ngaze ngakudlula kwezinye izici, kepha umbuzo wami uthi: iqiniso lokuthi i-Oracle manje isemuva kweMySQL yokufuduka futhi ngakho-ke ngendlela yokulahla umphathi we-bd ohlolwe isikhathi futhi osebenzisa izigidi?

    1.    izinga kusho

      Ushaye khona. Ukusho nje i-Oracle kunesizathu esanele sokuphelelwa i-MySQL. Futhi, iMaria DB imfoloko ye-MySQL egcinwe ngumdali we-MySQL noMphakathi. Angazi ngawe, kepha okungenani lokho kunginika ukuphepha okukhulu. Futhi uma singeza kulokho ukuthi ukuhambisana kuhle kakhulu, ngoba ngicabanga ukuthi azikho izaba zokushintshela kuMaria DB.

      (I.

      1.    eliotime3000 kusho

        Futhi yingakho ngenqaba ukufaka iJava kuDebian yami. Angisebenzisi neze i-OpenJDK nge-IcedTea futhi isebenza kahle, futhi ingcono kuneJava.

      2.    3ndriago kusho

        Hhayi, ndoda, ngineqiniso lokuthi kufanele ube nezizathu zakho zokuzonda i-Oracle (kunuka njengalezo ezikwenza uzonde iMicrosoft, i-Apple kanye neGoogle) kepha njengoba i-Oracle ingenzanga lutho kimi ... futhi ngicabanga ukuthi ngizokunika i-SPARC yosuku lwakho lokuzalwa lwe-XD

        1.    eliotime3000 kusho

          Kubhekiswa ezingeni lesoftware, hhayi ileveli yehadiwe.

          1.    3ndriago kusho

            Cha, uma sizokuzonda, sizonda konke, lezo zinyathelo ezinhlanu azipholile ... hehehehehehe

          2.    izinga kusho

            i-xDDD

  4.   umagazine kusho

    Ngiyabonga elav, ngasendleleni, kungakuhle yini ukuthi unamaseva womabili wewebhu futhi uqale ngasikhathi sinye?

    Ukubingelela!

    1.    izinga kusho

      Abanye abantu basebenzisa i-Apache njengeseva yewebhu kanye ne-NGnix njengommeleli wezicelo zewebhu. Impi impela. Isibonelo lapho usebenzisa i-Node.js, esebenzisa imbobo evela emuva engasetshenziswa muntu futhi mhlawumbe i-ISP yakho ivimbile

  5.   eliotime3000 kusho

    Umfundisi omuhle wokufuduka. Futhi, iSlackware kudala yathuthela eMariaDB ukugwema ukuqhubeka kokudideka nge-MySQL.

    Ngokushesha nje lapho kuse-repo yokuphepha yangemuva ye-Debian, ngizoyimemezela ngokushesha okukhulu. Okwamanje ngihlanganisa isifundo sami ekufakeni / ukumisa / ukwenza ngokwezifiso iSlackware.

  6.   jlbaena kusho

    Kepha ingabe i-kde isencike ku-mysql (ku-debian) noma ngalokhu kufuduka akusadingeki?

  7.   brunocascio kusho

    Ngakho-ke kulokho ebengikuqonda, lonke uhlelo lokusebenza olulungiselelwe nge-mysql bekungeke ludinga ukuphinda lucubungule noma yini yalo? Vele ufake iMariaDB (bese ukhipha i-mysql) bese ugcina amagama njenge-mysql kufanele isebenze?

    Mayelana nokusebenza, kushiwo izinguquko zenjini.
    Ngabe benza ngokugqamile ngeMylSam yakudala ne-InnoDB?

    Umuntu othile wenze noma yimaphi amamethrikhi?

      1.    brunocascio kusho

        Ngiqonde haha, Ngiyabonga!

  8.   helena_ryuu kusho

    Ngibonga kakhulu! manje uma kucacile kimi; D

  9.   Javier kusho

    Ayikwazi ukusetha iphasiwedi yomsebenzisi we-MariaDB "impande"

    Occurred Kuvele iphutha ngenkathi kusethwa iphasiwedi ye-MariaDB │
    │ umsebenzisi wokuphatha. Lokhu kungenzeka kwenzeke ngoba i-akhawunti isivele │
    │ unephasiwedi, noma ngenxa yenkinga yokuxhumana neMariaDB │
    │ iseva. │
    │ │
    Should Kufanele uhlole iphasiwedi ye-akhawunti ngemuva kokufakwa kwephakeji. │
    │ │
    │ Sicela ufunde i- / usr/share/doc/mariadb-server-10.1/README.Debian file │
    │ ukuthola eminye imininingwane.

    1.    Javier kusho

      Ngikhiphe amaphakheji we-mariadb maridb-server
      Ngisuse umkhombandlela / var / lib / mysql.
      3 Iphinde yafakwa kabusha amaphakheji we-Mariadb, Mariadb-server.
      systemct qala mariadb; i-systemctl inika amandla i-mariadb (ixazululwe inkinga).