MySQL kuna Maria DB: Kurumidza Kufambisa Gwara reDebian

Kana chigadzirwa chinoshanda uye chikabhadhara, uye chiri pachena sosi, chikawira mumaoko ekambani ine chinangwa chisiri chimwe kunze kwekuita mari yakawanda uye yakawanda, nyika inodedera.

Izvo zvakatoitika ne OpenOffice panguva yacho uye ikozvino inguva yeku MySQL. Kubereka ku pangataura kumashure hapana anoziva zvinoitika uye zvakanaka kuti uzive kuti kune dzimwe nzira uye zvakanakisa pane zvese Maria DB.

Kutora mazwi Wikipedia:

MariaDB Ndicho Dhatabhesi manejimendi system yakatorwa kubva MySQL game GPL rezinesi. Inogadzirwa ne michael widenius (muvambi we MySQL) uye nharaunda yekuvandudza free software. Pinda maviri injini dzekuchengetera nyowani, mumwe adaidzwa Aria -iyo inotsiva nezvakanakira MyISAM- uye imwe kufona XtraDB -kutsiva InnoDB. Iyo inoenderana kwazvo neMySQL sezvo iine iwo iwo mirairo, nzvimbo, maAPI nemaraibhurari, chinangwa chayo kuve kukwanisa kuchinjira sevha imwe kune imwe zvakananga.

Saka pasina imwezve ado ngatione kuti tingabva sei MySQL a Maria DB.

Kutama kubva kuMySQL kuenda kuMaria DB

Maitiro aya haagone kuitwa kupisa. Mune mamwe mazwi, isu tinofanirwa kumira kwekanguva masevhisi edu nemaitiro ari kuita MySQL.

# sevhisi mira apache2 # sevhisi mira nginx # sevhisi mira mysql

Mune ino kesi isu tinomisa Apache kana NGinx zvinoenderana neyatinoshandisa, uyezve isu tinomisawo MySQL.

Gare gare tinoita backup yeedu MySQL dhatabhesi:

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

Uye isu tinobvisa mapakeji ese ane chekuita neMySQL:

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

Iye zvino tinofanirwa kuisa Maria DB. Nehurombo, haisi mune yeDebian repositori parizvino, asi isu tinogona kuiisa isu tichishandisa yayo ezvayo marekodhi. Kune kumwe kugovera, iwe unogona kuona iyo rairo apa.

Tinowedzera zvinotevera ku /etc/source.list file:

# MariaDB 5.5 repository runyorwa - yakagadzirwa 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 main

Ipapo isu tinogadziridza nekuisa Maria DB:

sudo aptitude kugadzirisa sudo apt-tora kuisa mariadb-server

Isu tinotanga Maria DB (kana isina kuzviita otomatiki) uye tarisa kuti iri kushanda here:

# mysql -u mudzi -p -Be 'ratidza dhatabhesi' Pinda password:

Mamwe marongero akachinja zvakanyanya pakati peMySQL neMariaDB, zvisinei zviri nyore kwazvo kushanda nayo. Zvinenge zvese zvakachinja zvine chekuita nemaitiro akatsiviwa, semuenzaniso, kudzokorora. Isu tinongofanirwa kuteedzera sarudzo dzekugadzirisa mashandiro atakaita mufaira yangu.cnf de MySQL, uye kugadzirisa zvekare zvasara nemaoko.

Semuenzaniso, idzi data:

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

Isu tinoita shanduko dzakakodzera uye titangazve Maria DB.

# sevhisi mysql restart Kumisa MariaDB dhatabhesi dhatabhesi: mysqld. Kutanga server yaMariaDB dhatabhesi: mysqld. . . Kutarisa huwori, kwete kuvharwa zvakachena uye kusimudzira matafura anodiwa .. # mysql -u mudzi -p -Be 'ratidza dhatabhesi' Pinda password:

Hongu, Maria DB chengetedza iro rakafanana zita remysql kutangazve sevhisi, kuitira kuti urambe uchienderana zvirinani. Kana zvese zvanaka, saka tinotanga mamwe masevhisi:

# sevhisi apache2 kutanga # sevhisi nginx kutanga

Uye wakagadzirira. Kana isu tichida kudzokera kumashure (izvo zvandisingakurudzire), isu tinongofanirwa kumhanya:

# sevhisi mysql mira # apt-tora bvisa mariadb-server-5.5 mariadb-yakajairwa mariadb-mutengi-5.5 libmariadbclient18 # apt-tora kuisa mysql-server

Kwayaka: Chinyorwa chakatorwa uye chakashandurwa kubva StartLinux