MySQL ho Maria DB: Tataiso e Potlakileng ea ho Falla bakeng sa Debian

Ha sehlahisoa se sebetsang le se lefang, 'me e le mohloli o bulehileng, se oela matsohong a k'hamphani eo sepheo sa eona e seng ho etsa chelete e ngata le ho feta, lefatše lea thothomela.

Ho se ho etsahetse ka OpenOffice ka nako eo joale ke nako ea MySQL. Ho beha ho oracle ka morao ha ho motho ea tsebang se ka etsahalang mme ho hotle ho tseba hore ho na le mekhoa e meng mme ka ho khetheha e molemohali ho tsohle Maria DB.

Ho qotsa Wikipedia:

MariaDB Ke sistimi ea taolo ea database e tsoa ho MySQL , con Laesense ea GPL. E ntlafatsoa ke Michael Widenius (mothehi oa MySQL) le sechaba sa ntlafatso software e sa lefelloeng. Kenya tse peli dienjini tsa polokelo e ncha, e mong bitsoa Aria -e nkang sebaka sa melemo MOTSOALLE- le mohala o mong XtraDB -a tlosa sebaka InnoDB. E na le tšebelisano e phahameng le MySQL kaha e na le litaelo tse tšoanang, li-interface, li-API le lilaeborari, sepheo sa eona e le ho khona ho fetola seva e le ngoe ka kotloloho.

Kahoo ntle le ho feta, a re boneng hore na re ka tloha joang MySQL a Maria DB.

Ho bohlokoa ho tseba hore hore sena se sebetse 100%, re tlameha ho ba le mofuta o tšoanang oa MySQL (5.5) le Maria DB (5.5)

Ho tloha MySQL ho ea Maria DB

Ts'ebetso ena e ke ke ea etsoa e chesa. Ka mantsoe a mang, re tlameha ho emisa nakoana lits'ebeletso le lits'ebetso tse ntseng li sebetsa MySQL.

# service stop apache2 # service stop nginx # tšebeletso emisa mysql

Maemong ana re emisa Apache kapa NGinx ho latela hore na re sebelisa e fe, 'me ehlile re emisa MySQL.

Hamorao re etsa backup ea database ea MySQL:

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

Mme re tlosa liphutheloana tsohle tse amanang le MySQL:

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

Joale re tlameha ho kenya Maria DB. Ka bomalimabe, ha e sa le litsing tsa polokelo tsa Debian, empa re ka e kenya re sebelisa polokelo ea eona. Bakeng sa liphallelo tse ling, u ka bona file ea litaelo mona.

Re eketsa tse latelang ho file ea rona /etc/source.list:

Lethathamo la polokelo ea # MariaDB 5.5 - e entsoe 2013-08-02 13:48 UTC # http://mariadb.org/mariadb/repositories/ deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy main deb-src http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy ka sehloohong

Ebe re ntlafatsa le ho kenya Maria DB:

Sudo aptup update sudo apt-get kenya mariadb-server

Re qala Maria DB (haeba e sa e etse ka bo eona) ebe re netefatsa hore e ea sebetsa:

# mysql -u motso -p -Be 'bonts'a marang-rang' Kenya phasewete:

Litlhophiso tse ling li fetohile haholo lipakeng tsa MySQL le MariaDB, empa ho bonolo haholo ho sebetsana le tsona. Hoo e batlang e le ntho e ngoe le e ngoe e fetohileng e amana le lits'ebetso tse nchafalitsoeng, mohlala, ho ikatisa. Re tlameha feela ho kopitsa likhetho tsa ntlafatso ea ts'ebetso tseo re neng re na le tsona faeleng my.cnf de MySQL, 'me le fetole litšoantšo tse setseng ka letsoho.

Ka mohlala, lintlha tsena:

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 bongata_insert_buffer_size = 16M tmp_table_size = 64M max_heap_table_size = 64M

Re etsa liphetoho tse hlokahalang ebe re qala hape Maria DB.

# service mysql restart Ho emisa seva ea database ea MariaDB: mysqld. Ho qala seva ea database ea MariaDB: mysqld. . . Ho hlahloba bomenemene, bo sa koaloe hantle le ho ntlafatsa litafole tse hlokang .. # mysql -u motso -p -Be 'bonts'a database' Kenya phasewete:

E, Maria DB boloka lebitso le le leng la mysql ho qala ts'ebeletso hape, molemong oa ho boloka tšebelisano e ntle. Haeba tsohle li lokile, re tla qala litšebeletso tse ling kaofela:

# service apache2 qala # service nginx qala

'Me u itokiselitse. Haeba re batla ho khutlela morao (seo ke sa se khothalletseng), re tlameha feela ho matha:

# service mysql stop # apt-get tlosa mariadb-server-5.5 mariadb-e tloaelehileng mariadb-client-5.5 libmariadbclient18 # apt-get kenya mysql-server

Mohloli: Sengoloa se nkuoeng se fetotsoe ho tsoa ho StartLinux


Litaba tsa sengoloa sena li latela melao-motheo ea rona ea melao ea boitšoaro ea bongoli. Ho tlaleha phoso tlanya mona.

Maikutlo a 22, siea ea hau

Siea maikutlo a hau

aterese ya hao ya imeile ke ke ho phatlalatswa.

*

*

  1. E ikarabella bakeng sa data: Miguel Ángel Gatón
  2. Morero oa data: Laola SPAM, tsamaiso ea maikutlo.
  3. Molao: Tumello ea hau
  4. Puisano ea data: Lintlha li ke ke tsa tsebisoa batho ba boraro ntle le ka tlamo ea molao.
  5. Polokelo ea data: Database e hapiloeng ke Occentus Networks (EU)
  6. Litokelo: Nako efe kapa efe o ka fokotsa, oa hlaphoheloa mme oa hlakola tlhaiso-leseling ea hau.

  1.   Mauricio a re

    Ha mojaro oa bekapo ea database e le sieo.

    1.    ela a re

      Ha ke nahane hakaalo, empa ke leboha tlhakiso eo. Re ile ra etsa bekapo haeba database ea hajoale e ka hloleha, hobane ho nna ho bonahala eka ka bobeli ba sebelisa DB e tšoanang. Ke tla tlameha ho bala haholoanyane ka taba ena.

  2.   Ozkar. a re

    Fedora 19 e se e ntse e tla le Maria ka boiketsetso, empa leha e le khuts'oane kapa botsoa ke ile ka fallisetsa li -app tsa ka tsa marang-rang ho PostgreSQL, kaha MySQL e re otlile manaka, ke ts'epa hore PostgreSQL e lula e ts'epahalla bonyane lilemo tse 2-3.

    1.    ela a re

      ArchLinux e boetse e kenyelletsa Maria DB 😀

      1.    Ozkar. a re

        U na le motlatsi oa Arch ... Le nna ke na le meno a fokolang mme ke batla ho e sebelisa hape ... empa ke botsoa. 😀

  3.   3ndriago a re

    Ke bona tloaelo ea litsamaiso tse kenyeletsang ts'ehetso ea MariaDB mme ho latela seo ke se balileng ho bonahala e le boemong ba MySQL mme ebile e e feta ka likarolo tse ling, empa potso ea ka ke hore: taba ea hore Oracle e se e le ka mora MySQL ho falla le kahoo tseleng ke mookameli oa li-bd ea lekiloeng ka nako?

    1.    ela a re

      U nepile. Ho re feela Oracle ke lebaka le lekaneng hore o felloe ke MySQL. Hape, Maria DB ke fereko ea MySQL e bolokiloeng ke moetsi oa MySQL le Sechaba. Ha ke tsebe ka uena, empa bonyane seo se mpha tšireletseho e kholo. Mme haeba re eketsa hore khokahano e ntle haholo, hobane ke nahana hore ha ho na mabaka a ho fetohela ho Maria DB.

      😉

      1.    likeletso3000 a re

        Ke ka lebaka leo ke hanang ho kenya Java ho Debian ea ka. Ha ke sebelise OpenJDK ka IcedTea mme e sebetsa ka mokhoa o makatsang, ebile e betere ho feta Java.

      2.    3ndriago a re

        Hantle, monna, ke kholoa hore o tlameha ho ba le mabaka a hau a ho hloea Oracle (e nkha joalo ka tse u etsang hore u hloee Microsoft, Apple esita le Google) empa ho tloha ha Oracle a sa nketsa letho ... mme ke nahana hore ke tla u fe SPARC bakeng sa letsatsi la tsoalo la XD

        1.    likeletso3000 a re

          E bua ka boemo ba software, eseng boemo ba hardware.

          1.    3ndriago a re

            Che, haeba re tla hloea, re hloile ntho e ngoe le e ngoe, hore mehato ea halofo ha e pholile ... hehehehehehe

          2.    ela a re

            xDDD

  4.   lenapella a re

    Thanks elav, ka tsela eo, na ho bohlokoa hore u be le li-server ka bobeli ebe u li qala ka nako e le 'ngoe?

    Kea leboha!

    1.    ela a re

      Batho ba bang ba sebelisa Apache joalo ka seva ea webo le NGnix e le moemeli oa likopo tsa webo. Ho senyehile haholo. Mohlala ha o sebelisa Node.js, e sebelisang boema-kepe ho tloha ka morao moo ho seng motho ea e sebelisang mme mohlomong ISP ea hau e koetse 😀

  5.   likeletso3000 a re

    Morupeli ea hantle oa ho falla. Hape, Slackware khale e ile ea fallela MariaDB ho qoba tlhekefetso le MySQL.

    Hang ha e le repo ea ts'ireletso ea morao-rao ea Debian, ke tla e phatlalatsa kapele kamoo ho ka khonehang. Ha joale ke ntse ke bokella thupelo ea ka ho kenya / ho hlophisa / ho etsa Slackware.

  6.   jlbaena a re

    Empa na kde e ntse e ipapisitse le mysql (ho debian) kapa ka ho falla hona ha ho sa hlokahala?

  7.   brunocascio a re

    Joale ho latela seo ke se utloisisang, ts'ebeliso e ngoe le e ngoe e hlophisitsoeng le mysql ha e na ho tlameha ho hlophisa bocha letho la eona? Kenya feela MariaDB ('me u tlose mysql) ebe u boloka mabitso e le mysql na e lokela ho sebetsa?

    Mabapi le ts'ebetso, liphetoho tsa enjene li boletsoe.
    Na ba sebetsa ka mokhoa o ikhethang le MylSam ea khale le InnoDB?

    Motho e mong o sebelisitse metriki efe kapa efe?

      1.    brunocascio a re

        Ke utloisisitse haha, Kea leboha!

  8.   helena_ryuu a re

    Ke leboha haholo! joale haeba ho hlakile ho 'na; D.

  9.   Javier a re

    Ha e khone ho beha phasewete bakeng sa mosebelisi oa "motso" oa MariaDB

    Phoso e etsahetse ha ho beoa phasewete bakeng sa MariaDB │
    User mosebelisi oa tsamaiso. Sena se kanna sa etsahala hobane ak'haonte e se e ntse e le │
    │ e na le phasewete, kapa ka lebaka la bothata ba puisano le MariaDB │
    │ seva. │
    │ │
    │ O lokela ho hlahloba phasewete akh'aonto mora tlhomamiso sephutheloana. │
    │ │
    Ka kopo bala /usr/share/doc/mariadb-server-10.1/README.Debian file │
    │ bakeng sa tlhaiso-leseling e batsi.

    1.    Javier a re

      Ke kentse liphutheloana tsa mariadb maridb-server
      Ke tlositse directory / var / lib / mysql.
      3 E kentse bocha liphutheloana tsa Mariadb, Mariadb-server.
      systemct qala mariadb; systemctl e thusa mariadb (tharollo ea mathata).

bool('nete)