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.

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 yami.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