MySQL zuwa Maria DB: Jagorar Shige da fice cikin sauri don Debian

Lokacin da wani samfuri da yake aiki kuma yake biyan kudi, kuma yake buda ido, ya fada hannun wani kamfani wanda burinshi baya wuce neman karin kudi, duniya tana girgiza.

Ya riga ya faru da OpenOffice a lokacin kuma yanzu lokaci ne na MySQL. Qazanta zuwa Oracle a bayan babu wanda ya san abin da zai iya faruwa kuma yana da kyau a san cewa akwai wasu hanyoyi kuma musamman mafi kyau duka Mariya DB.

Ana faɗar Wikipedia:

MariaDB ne mai tsarin sarrafa bayanai samo daga MySQL con GPL lasisi. An inganta ta michael widenius (wanda ya kafa MySQL) da kuma al'umma masu tasowa software kyauta. Shigar da biyu injunan ajiya sabo, daya kira Aria -wanda ya maye gurbinsa da fa'idodi MISALI- da kuma wani kiran XtraDB -imakawa InnoDB. Yana da babban aiki tare da MySQL tunda yana da umarni iri ɗaya, musaya, APIs da dakunan karatu, maƙasudin kasancewa iya canza sabar ɗaya zuwa wani kai tsaye.

Don haka ba tare da ƙarin damuwa ba bari mu ga yadda za a tafi MySQL a Mariya DB.

Yin ƙaura daga MySQL zuwa Maria DB

Ba za a iya yin wannan aikin da zafi ba. A wasu kalmomin, dole ne mu tsaya na ɗan lokaci ayyukanmu da matakan da muke gudanarwa MySQL.

# sabis na dakatar da apache2 # sabis na dakatar da nginx # sabis na dakatar da mysql

A wannan yanayin mun dakatar da Apache ko NGinx ya danganta da wacce muke amfani da ita, kuma hakika mun dakatar da MySQL.

Daga baya zamuyi ajiyar bayanan MySQL dinmu:

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

Kuma muna cire duk fakitin da suka danganci MySQL:

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

Yanzu dole mu girka Maria DB. Abun takaici, ba a cikin wuraren ajiye Debian ba har yanzu, amma za mu iya shigar da shi ta amfani da wuraren ajiya na kansa. Don sauran rarrabawa, kuna iya ganin umarnin nan.

Muna ƙara waɗannan zuwa fayil ɗinmu /etc/sources.list:

# MariaDB 5.5 jerin kayan ajiya - an kirkireshi 2013-08-02 13:48 UTC # http://mariadb.org/mariadb/repositories/ deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy babban deb-src http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy main

Sannan mun sabunta kuma mun girka Maria DB:

sudo basira sabunta sudo dace-samun shigar mariadb-uwar garken

Mun fara Maria DB (idan ba ta yi ta atomatik ba) kuma duba cewa yana aiki:

# mysql -u tushen -p -Be 'nuna bayanan bayanai' Shigar da kalmar wucewa:

Wasu saitunan sun canza sosai tsakanin MySQL da MariaDB, duk da haka yana da sauƙin aiki tare. Kusan duk abin da ya canza yana da alaƙa da hanyoyin da aka maye gurbinsu, misali, maimaitawa. Dole ne kawai mu kwafa zaɓukan inganta ayyukan da muke da su a cikin fayil ɗin ku.cnf de MySQL, kuma sake saita sauran ta hannu.

Misali, waɗannan bayanan:

adireshin ɗaure = 127.0.0.1 max_connections = 10 connect_timeout = 30 wait_timeout = 600 max_allowed_packet = 16M thread_cache_size = 256 KO tsara = 16M bulk_insert_buffer_size = 16M tmp_table_size = 64M max_heap_table_size = 64M

Muna yin canje-canje masu mahimmanci kuma zamu sake farawa Maria DB.

# sabis mysql sake kunnawa Dakatar da uwar garken bayanan MariaDB: mysqld. Fara uwar garken MariaDB uwar garken bayanai: mysqld. . . Dubawa don cin hanci da rashawa, ba a rufe tsaftace ba kuma haɓaka haɓaka tebura .. # mysql -u root -p -Be 'nuna bayanan bayanai' Shigar da kalmar wucewa:

Haka ne, Mariya DB adana wannan sunan na MySQL don sake kunna sabis ɗin, don kiyaye kyakkyawan jituwa. Idan komai yayi daidai, to zamu fara sauran ayyukan:

# service apache2 fara # service nginx fara

Kuma a shirye. Idan muna so mu koma baya (wanda bana ba da shawara), kawai dai mu gudu:

# service mysql stop # apt-cire cire mariadb-server-5.5 mariadb-gama mariadb-abokin ciniki-5.5 libmariadbclient18 # dace-samu shigar mysql-server

Source: Labari da aka ɗauka kuma an gyara daga BeginLinux