MySQL ilaa Maria DB: Tilmaamaha Socdaalka Degdegga ah ee Debian

Markay shey shaqeynaya waxna tarayaan, ilna furan yahay, ay gacanta u gasho shirkad hadafkeedu uusan ahayn in lacag badan la helo iyo in kale, aduunku wuu gariiraa

Horay ayey ula dhacday OpenOffice waqtiga iyo hadda waa markiisa MySQL. U dhashay Oracle gadaashiisa cidina ma oga waxa dhici kara waxaana wanaagsan in la ogaado in ay jiraan waxyaabo kale oo si qaas ah waxa ugu fiican ay tahay Maria DB.

Xigasho Wikipedia:

MariaDB waa a nidaamka maareynta keydka macluumaadka laga soo bilaabo MySQL con Ruqsadda GPL. Waxaa soo saaray Michael widenius (aasaasaha MySQL) iyo bulshada horumariyaha software bilaash ah. Gali laba matoorada keydinta cusub, mid loo yaqaan Aria -waxuu ku badalaa faa iidooyin MIISAM- iyo wicitaan kale XtraDB -sameynta InnoDB. Waxay leedahay iswaafajin sare oo MySQL ah maadaama ay leedahay amarro isku mid ah, iswaafaqaadyo, API-yo iyo maktabado, ujeeddadeeduna tahay inay awood u leedahay inay si toos ah hal server ugu beddesho mid kale.

Markaa iyada oo aan la sii fahmin bal aan aragno sida looga baxo MySQL a Maria DB.

Ka guuritaanka MySQL illaa Maria DB

Nidaamkan laguma sameyn karo kuleyl. Si kale haddii loo dhigo, waa inaan daqiiqad yar istaagnaa adeegyadeenna iyo howlaheenna fulinaya MySQL.

# adeegga joojinta apache2 # adeegga joojinta nginx # adeegga joojinta mysql

Xaaladdan oo kale waxaan joojineynaa Apache ama NGinx iyadoo ku xiran midka aan isticmaaleyno, dabcan sidoo kale waxaan joojineynaa MySQL.

Goor dambe ayaannu keyd ka dhignaa kaydkeenna xogta MySQL:

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

Waxaanan ka saareynaa dhammaan xirmooyinka la xiriira MySQL:

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

Hadda waa inaan rakibnaa Maria DB. Nasiib darrose, weli kuma jirto keydka Debian, laakiin waxaan ku rakibi karnaa innaga oo isticmaaleyna keydkeeda. Qeybin kale, waad arki kartaa tilmaamaha halkan.

Waxaan ku darnaa waxyaabaha soo socda feylkeena /etc/sources.list:

# MariaDB 5.5 liiska kaydinta - oo la abuuray 2013-08-02 13:48 UTC # http://mariadb.org/mariadb/repositories/ deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy deb-src weyn http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy main

Kadib waxaan cusbooneysiineynaa oo aan ku dhejinaynaa Maria DB:

cusboonaysiinta sudo sudo aptitude sudo apt-get rakib mariadb-server

Waxaan bilaabeynaa Maria DB (haddii aysan si otomaatig ah u sameynin) oo waxaan hubinnaa inay shaqeyneyso:

# mysql -u root -p -Be 'muuji xog-hoosaadyada' Gali lambarka sirta ah:

Dejinta qaarkood si weyn ayey isu beddeleen inta udhaxeysa MySQL iyo MariaDB, si kastaba ha noqotee way fududahay in lala shaqeeyo. Ku dhowaad wax kasta oo beddelay waxay la xiriiraan farsamooyinka la beddelay, tusaale ahaan, soo-celin. Kaliya waa inaan nuqul ka dhignaa xulashooyinka waxqabad ee waxqabad ee aan ku haynay faylka my.cnf de MySQL, oo inta kale gacanta ku habee.

Tusaale ahaan, xogtan:

cinwaan-xira = 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

Waxaan sameyneynaa isbeddelada lagama maarmaanka ah waxaan dib u bilaabaynaa Maria DB.

# adeegga mysql dib u bilaabi Joojinta serverka keydka ee MariaDB: mysqld. Bilaabida adeegaha keydka ee MariaDB: mysqld. . . Hubinta musuqmaasuqa, oo aan si nadiif ah u xirneyn iyo kor u qaadista miisaska u baahan .. # mysql -u root -p -Be 'muuji xog-hoosaadka' Gali lambarka sirta ah:

Haa, Maria DB hayso magaca mysql isku mid ah si aad dib ugu bilowdo adeegga, si loo ilaaliyo is waafajinta wanaagsan. Haddii wax waliba hagaagaan, markaa waxaan bilaabi doonnaa inta ka hartay adeegyada:

# service apache2 bilaw # adeeg nginx bilow

Oo diyaar. Haddii aan rabno inaan dib u laabanno (oo aanan kugula talin), waa inaan ordi:

# adeegga mysql jooji # apt-ka saar mariadb-server-5.5 mariadb-macaamiisha mariadb-guud-5.5 libmariadbclient18 # apt-get rakib mysql-server

Xigasho: Maqaalka laga soo qaatay lagana bedelay StartinLinux