I-MySQL ukuya kuMaria DB: Isikhokelo sokufuduka ngokukhawuleza kweDebian

Xa imveliso esebenza kwaye ihlawula, kwaye ingumthombo ovulekileyo, iwela ezandleni zenkampani enjongo yayo ingeyiyo enye ngaphandle kokwenza imali nangakumbi, ilizwe liyangcangcazela.

Sele yenzekile kunye OpenOffice ngelo xesha kwaye ngoku lithuba lika MySQL. Ukunikela ku Oracle ngasemva akukho mntu waziyo ukuba kwenzeka ntoni kwaye kulungile ukwazi ukuba kukho ezinye iindlela kwaye ezizezona zilunge ngakumbi UMaria DB.

Ukucaphula iWikipedia:

MariaDB Yiyo Inkqubo yolawulo lwedatha ithathwe kwi MySQL nge Ilayisensi ye-GPL. Iphuhliswe ngu UMichael Widenius (umseki we MySQL) kunye noluntu lophuhliso software free. Faka ezimbini iinjini zokugcina entsha, enye ibizwa Sanctum -okutshintsha izinto eziluncedo I-MyISAM-nenye ifowuni XtraDB -ukubeka endaweni I-InnoDB. Inokuhambelana okuphezulu ne-MySQL kuba inemiyalelo efanayo, ujongano, ii-API kunye neelayibrari, injongo yayo kukukwazi ukutshintsha iserver enye iye ngqo.

Ngaphandle kokuqhubela phambili masibone ukuba ungaphuma phi MySQL a UMaria DB.

Ukufuduka ukusuka kwi-MySQL ukuya eMaria DB

Le nkqubo ayinakwenziwa ishushu. Ngamanye amagama, kufuneka sime okomzuzwana iinkonzo zethu kunye neenkqubo ezisebenzayo MySQL.

# inkonzo yeka apache2 # inkonzo yeka nginx # inkonzo yeka mysql

Kule meko simisa i-Apache okanye i-NGinx ngokuxhomekeke ekubeni sisebenzisa yiphi na, kwaye ke simisa ne-MySQL.

Emva kwexesha senza ugcino lwedatha yethu ye-MySQL:

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

Kwaye sisusa zonke iipakeji ezinxulumene ne-MySQL:

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

Ngoku kufuneka sifake uMaria DB. Ngelishwa, ayikho kwii-repositi zeDebian okwangoku, kodwa singayifaka sisebenzisa iindawo zayo zokugcina. Olunye ulwabiwo, ungabona iifayile ze- imiyalelo apha.

Songeza oku kulandelayo kwifayile yethu /etc/source.list:

# Uluhlu lweMariaDB 5.5-lwenziwe ngo-2013-08-02 13:48 kwi-UTC # http://mariadb.org/mariadb/repositories/ deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy eyintloko yedeb-src http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy main

Emva koko sihlaziya kwaye sifake uMaria DB:

Uhlaziyo lwe-sudo apt-fumana uhlaziyo lwe-mariadb-server

Siqala uMaria DB (ukuba khange ayenze ngokuzenzekelayo) kwaye ujonge ukuba iyasebenza:

# mysql -u ingcambu -p -Bonisa 'iziseko zedatha' Faka iphasiwedi:

Ezinye iisetingi zitshintshile kakhulu phakathi kwe-MySQL kunye neMariaDB, nangona kulula kakhulu ukusebenza nayo. Phantse yonke into etshintshileyo inento yokwenza neendlela eziye zatshintshwa, umzekelo, ukuphindaphinda. Kuphela kufuneka sikope ukukhethwa kokusebenza kokusebenza ebesinako kwifayile yam.cnf de MySQL, uze uphinde uyilungelelanise ngesandla.

Umzekelo, ezi datha:

bopha idilesi = 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 utshintsho oluyimfuneko kwaye siqala ngokutsha uMaria DB.

# inkonzo mysql qala kwakhona Ukuyeka iserver yedatha kaMariaDB: mysqld. Ukuqala kweseva yedatha kaMariaDB: mysqld. . . Ukujonga ukonakala, kungavali kucociwe kwaye kuphuculwe iitafile ezifunekayo .. # mysql -u ingcambu -p -Be 'bonisa iziseko zedatha

ukuba UMaria DB gcina igama elifanayo le-mysql ukuqala inkonzo kwakhona, ukuze ugcine ukuhambelana okungcono. Ukuba konke kulungile, emva koko siqala ezinye iinkonzo:

# service apache2 qala # service nginx qala

Kwaye ukulungele. Ukuba sifuna ukubuyela umva (endingacebisi ukuba), kufuneka sibaleke:

# service mysql yeka # apt-fumana ukususa i-mariadb-server-5.5 mariadb-eqhelekileyo i-mariadb-client-5.5 libmariadbclient18 # apt-fumana ukufaka i-mysql-server

Umthombo: Inqaku lithathiwe kwaye laguqulwa kwi-StartLinux