Mokhoa oa ho theha database ho MariaDB?

Ntlafatso ea ho qetela: 26/09/2023

U ka etsa database joang ho MariaDB?

Lefats'eng Lefapheng la tsamaiso ea database, MariaDB e se e tumme ka ts'ebetso ea eona, ho ts'epahala, le ho lumellana le MySQL. Leha ho ka bonahala ho rarahane ho theha database ho MariaDB, ha e le hantle ke ts'ebetso e bonolo e ka finyelloang ka mehato e seng mekae feela. Sehloohong sena, re tla hlahloba mokhoa o qaqileng oa mokhoa oa ho theha database ho MariaDB, ho tloha ho kenya MariaDB ho theha le ho lokisa database e ncha ho seva.

Ho kenya MariaDB

Pele ho theha database Ho MariaDB, ho bohlokoa hore re be le software e kentsoeng tsamaisong ea rona. Ts'ebetso ea ho instola e ka fapana ho latela maemo mokhoa oa tšebetso, empa ka kakaretso, ho kenyelletsa ho khoasolla sephutheloana sa ho kenya se tsamaisanang le ho latela mehato e fanoeng ke MariaDB ho hlophisa ts'ebetso. Ha re se re kentse MariaDB, re tla be re itokiselitse ho qala ho theha database ea rona.

Ho fihlella ho seva sa MariaDB

Hang ha MariaDB e kentsoe, re hloka ho fihlella seva sa database e le hore re thehe le ho laola marang-rang a rona. Ho etsa sena, re ka sebelisa lisebelisoa tse joalo mola oa taelo oa MariaDB kapa lits'ebetso tsa mokha oa boraro joalo ka Sebaka sa Mosebetsi sa MySQL. Lisebelisoa tsena li re lumella ho sebelisana le seva li-database, hlahisa lipotso ⁤'me u hlophise datha ea rona.

Ho theha database e ncha

Ha re se re fihletse seva sa MariaDB, re se re loketse ho theha database ea rona. Ho etsa sena, re tla sebelisa litaelo tsa SQL, e leng puo ea lenaneo e sebelisetsoang tsamaiso ea database. Ka litaelo tsena, re ka etsa litafole, ra hlalosa litšiea, le ho hlakisa litšitiso bakeng sa database ea rona.

Database⁢ Configuration⁤

Kamora ho theha database, ho bohlokoa ho etsa litlhophiso tse ling ho ntlafatsa ts'ebetso le ts'ireletso ea eona. Ka ho hlophisa database ea rona ka nepo, re ka netefatsa ts'ebetso e nepahetseng le e sireletsehileng ea lits'ebetso tsa rona le lits'ebetso tse e sebelisang.

Kaha joale re tseba ts'ebetso e qaqileng ea mokhoa oa ho theha database ho MariaDB, re ka qala ho nka monyetla ka melemo eohle e fanoang ke sesebelisoa sena se matla sa taolo ea database. Ka database e entsoeng hantle le e hlophisitsoeng hantle ho MariaDB, re ka boloka le ho fumana lintlha. ka katleho, ⁢ho netefatsa ts'ebetso e tsitsitseng le e tšepahalang ea lits'ebetso le litsamaiso tsa rona.

1. ⁣Selelekela ho MariaDB: Mokhoa o mong ho MySQL o nang le likarolo tse matla le ts'ebetso

MariaDB ke mokhoa o matla le o matla haholo ho MySQL. Ka mefuta e mengata ea likarolo le ts'ebetso e ikhethang, database ena e fana ka khetho e tšepahalang bakeng sa ba batlang tharollo e sebetsang ea taolo ea data. E 'ngoe ea melemo e hlahelletseng ea MariaDB ke ho lumellana ha eona le puo e tloaelehileng ea SQL, e etsang hore ho falla ho tsoa litsing tse ling ho be bonolo. Ho feta moo, e na le enjene e matla ea polokelo e kang InnoDB, e tiisang botšepehi le botsitso ba data.

Ho theha database ho MariaDB ke ts'ebetso e bonolo le e tobileng. Ntlha ea pele, u lokela ho etsa bonnete ba hore u na le sephutheloana sa MariaDB se kentsoeng tsamaisong ea hau. Ha e se e kentsoe, u ka ⁢ bula mohala oa taelo oa MariaDB 'me u kene ka lintlha tsa motsamaisi oa hau, joale u ka sebelisa taelo ea "CREATE DATABASE" e lateloang ke lebitso leo u le batlang bakeng sa database ea hau. Ketso ena e tla theha database e ncha e se nang letho eo u ka e sebelisang ho boloka le ho laola data ea hau.

Ha u se u thehile database ea hau ho MariaDB, u ka qala ho sebetsa le eona. Ho bohlokoa ho totobatsa ⁢hore MariaDB e fana ka mefuta e mengata e fapaneng ea likhetho le likhetho tse u lumellang ho ikamahanya le database ho ⁤litlhoko tsa hau tse ikhethileng.⁤ U ka theha litafole, ua hlalosa likamano lipakeng tsa tsona le ho theha lithibelo tsa botšepehi ho netefatsa ho tsitsa ha hau. data. Ho feta moo, MariaDB e kenyelletsa⁤ mesebetsi e mengata e tsoetseng pele le litaelo tse u lumellang ho etsa lipotso tse thata⁤ le ho fumana liphetho tse nepahetseng. Ka bokhutšoanyane, MariaDB ke mokhoa o matla le o ka tšeptjoang ho MySQL, o fana ka likarolo tse tsoetseng pele le ts'ebetso e ikhethang bakeng sa tsamaiso ea database.

2. Ho kengoa⁢ ha MariaDB ho sistimi eo u e ratang ea ho sebetsa

MaríaDB ke sistimi e bulehileng ea taolo ea likamano tsa database e fumaneng botumo lilemong tsa morao tjena. Haeba u thahasella ⁢ho natefeloa ⁢melemo eo MaríaDB e fanang ka eona, ka tlase re tla u bontša mokhoa oa ho e kenya ho sistimi eo u e ratang haholo.

Ho kenya Windows:

Ho kenya MaríaDB ho Windows, o tlameha ho latela mehato e latelang:
- Khoasolla sesebelisoa sa MaríaDB bakeng sa Windows ho tsoa webosaeteng ea semmuso.
- Matha sets'oants'o ebe u khetha khetho ea "full install".
- Latela litaelo tsa sesebelisoa 'me u fane ka lintlha tse hlokahalang, joalo ka senotlolo sa mosebelisi oa MaríaDB.
- Hang ha ts'ebetso e phethiloe, o ka fihlella MaríaDB ka molaetsa oa taelo kapa ka ho sebelisa moreki oa database o lumellanang.

Litaba tse ikhethileng - Tobetsa Mona  Mokhoa oa ho theha tafole e ncha ho pgAdmin?

Ho kenya Linux:

Ho kengoa ha MaríaDB ho Linux ho ka fapana ho latela phepelo⁢ eo u e sebelisang. Maemong a mangata, o ka kenya MaríaDB o sebelisa mookameli oa sephutheloana sa hau sa Linux. Mohlala, haeba u sebelisa Ubuntu, u ka tsamaisa taelo e latelang ho terminal:

Sudo apt-kenya kenya mariadb-server

Hang ha ts'ebetso e phethiloe, u ka qala tšebeletso ea MaríaDB ka ho sebelisa taelo e latelang:

sudo systemctl qala mariadb

Hopola hore o tla hloka hape ho lokisa ts'ireletso ea MariaDB mme o behe phasewete bakeng sa mosebelisi oa motso. Joale u se u loketse ho qala ho sebelisa MaríaDB ho sistimi eo u e ratang ea ho sebetsa!

3. Tlhophiso ea pele ea MariaDB: Ho beha likhetho tsa ts'ireletso le boinotši

Tlhophiso ea pele ea MariaDB: Ho qala ho sebelisa MariaDB le ho theha database, ho bohlokoa ho beha likhetho tse nepahetseng tsa ts'ireletso le boinotši. Tlhophiso ea pele ea MariaDB e re lumella ho sireletsa tlhahisoleseling ea rona le ho netefatsa hore ke batho ba lumelletsoeng feela ba ka e fihlelang.

Ho beha likhetho tsa ts'ireletso: ⁢ E 'ngoe ea mehato ea pele eo re tlamehang ho e nka ke ho theha phasewete e matla bakeng sa ⁢ mosebelisi oa motso. Sena se ka etsoa ka ho sebelisa taelo e latelang ho terminal: ⁤ mysql_secure_installation. Taelo ena e tla re tataisa ts'ebetsong ea ho sebelisana moo re ka hlophisang password le likhetho tse ling tsa ts'ireletso, joalo ka ho tima phihlello e hole ho seva.

Ho beha likhetho tsa lekunutu: Ntle le ho hlophisa ts'ireletso, re tlameha ho etsa bonnete ba hore re beha likhetho tse nepahetseng tsa lekunutu. Ka mohlala, ho kgothaletswa ho fetola lebitso la database ya kamehla. Sena E ka finyelloa ho fetola faele ea tlhophiso ea MariaDB ⁢(my.cnf) le ho fetola boleng ba phapano datadir sebakeng se secha sa database. Ho bohlokoa hape ho theha melao ea phihlello ea database, ho hlalosa litumello tsa basebelisi le ho fokotsa phihlello ha ho hlokahala.

4. Moralo oa sebopeho sa database: Ho rala le ho theha litafole tse sebetsang hantle

Karolong ena re tlil'o sebetsana le ⁤moralo oa ⁤sebopeho sa bobolokelo ⁢ho MariaDB, re tsepamisitse maikutlo ⁢ho rala le ho theha litafole tse sebetsang hantle. Ho qala, ho bohlokoa ho hlakisa sepheo sa database ea rona le litlhoko tse ikhethileng tseo e tlamehang ho li akaretsa. Sena se tla re lumella ho fumana hore na ke litafole le likamano life tseo re tla li hloka ho hlophisa boitsebiso ka katleho.

Ha re se re hlalositse litafole tse hlokahalang, ho bohlokoa ho ela hloko likeletso tse ling ho netefatsa hore litafole tsa rona li sebetsa hantle. Pele ho tsohle, ho eletsoa ho rala litafole ka tsela e qobang ho fokotseha ha data. Sena se kenyelletsa ho qoba ho pheta-pheta tlhahisoleseding litafoleng tse 'maloa, kaha sena se ka lebisa ho se lumellane' me sa etsa hore ho boloka polokelo ea boitsebiso ho be thata. Tšebeliso ⁤e nepahetseng ea⁢ likamano le linotlolo tsa mantlha le⁢ tsa kantle ho naha ⁤ e tla re thusa ho finyella sena, kaha e tla re lumella ho theha maqhama pakeng tsa litafole ho e-na le ho kopitsa boitsebiso.

Ho feta moo, ho eletsoa ho abela mefuta e nepahetseng ea data kholumong ka 'ngoe ea litafole tsa rona. Sena se tla re lumella ho ntlafatsa polokelo ea data le lipotso. Ka mohlala, haeba re tseba hore kholomo e itseng e tla ba le litekanyetso tsa linomoro feela, ho molemo haholo ho e abela mofuta oa data oa linomoro ho e-na le mofuta oa data oa mongolo. Khetho e nepahetseng ea mefuta ea data E tla boela e re thuse ho netefatsa botšepehi ba data le ho qoba liphoso ha re e fetola.

Ka kakaretso, ho rala sebopeho sa database ho MariaDB ke mohato oa bohlokoa molemong oa ho theha database e sebetsang hantle. ⁢Ho rera ka hloko ha litafole le likamano tsa bona, hammoho le ts'ebeliso e nepahetseng ea linotlolo tsa mantlha le tsa kantle ho naha, ho tla re lumella ho qoba ho fokotsoa ha data le ho boloka bots'epehi ba tlhahisoleseling e tla re thusa⁢ ho ntlafatsa polokelo ea data ⁤le potso. Ka ho latela melao-motheo ena, re tla be re le tseleng e lebisang polokelong ea litaba e sebetsang hantle le eo ho leng bonolo ho e hlokomela.

5. Tlhaloso ea likamano lipakeng tsa litafole le lithibelo: Ho netefatsa botšepehi ba data.

Ho hlalosa likamano lipakeng tsa litafole: Ho netefatsa botšepehi ba data ho database, ho bohlokoa ho utloisisa le ho theha likamano lipakeng tsa litafole. Ho MariaDB, likamano li hlalosoa ho sebelisoa linotlolo tsa mantlha le linotlolo tsa kantle ho naha Senotlolo sa mantlha ke sebaka se ikhethileng se khethollang rekoto e 'ngoe le e' ngoe tafoleng, athe senotlolo sa kantle ke lebala le leng tafoleng e le 'ngoe e ts'oanang le senotlolo sa tafole se seng.

Litaba tse ikhethileng - Tobetsa Mona  Nka abela moedi wa tshebediso ho mosebedisi jwang ho Oracle Database Express Edition?

Lithibelo tsa ho netefatsa bots'epehi ba data: Ntle le ho hlalosa likamano lipakeng tsa litafole, ho bohlokoa hape ho theha lithibelo ho netefatsa botšepehi ba data e bolokiloeng polokelong ea litaba. Ho MariaDB, litšitiso li ka sebelisoa boemong ba likholomo kapa boemong ba tafole Mehlala e meng ea lithibelo tse tloaelehileng ke "NOT NULL constraint", e thibelang boleng hore bo se ke ba hlola bo e-ba lefeela kholomong, le UNIQUE, e netefatsang hore ha ho na kopi. boleng ka kholomong.

Ho netefatsa botšepehi ba data: Ka ho theha likamano lipakeng tsa litafole le ho sebelisa litšitiso, re netefatsa bots'epehi ba data bobolokelong ba rona Sena se re fa monyetla oa ho boloka botsitso le ho nepahala ha litaba tse bolokiloeng. Ho feta moo, ka ho hlalosa likamano lipakeng tsa litafole, re ka nka monyetla oa ho botsa lipotso tse thata le ho ntlafatsa ts'ebetso Ka kakaretso, ho utloisisa le ho sebelisa likamano le lithibelo ka nepo polokelong ea polokelo ea MariaDB ho bohlokoa ho netefatsa bots'epehi ba data le ho fumana sistimi e tšepahalang le e sebetsang hantle. .

6.⁢ Ho theha lipotso le li-filters tse tsoetseng pele ho MariaDB: Ho ntlafatsa ts'ebetso ea lipotso tsa hau.

Lefats'eng la li-database, ho bohlokoa ho tseba ho theha lipotso le li-filters tse tsoetseng pele ho ntlafatsa ts'ebetso ea lipotso tsa hau ho MariaDB. Sena se tla u lumella ho fumana liphetho tse potlakileng le tse nepahetseng haholoanyane, ka hona, ho ntlafatsa ts'ebetso ea lits'ebetso tsa hau. Ka tlase, re tla hlalosa mekhoa e meng le mekhoa e metle ea ho finyella sena.

1. Sebelisa li-index tse loketseng: Li-index ke sesebelisoa sa bohlokoa sa ho potlakisa lipotso ho MariaDB. Etsa bonnete ba hore u theha li-index likholomong tse sebelisoang ho WHERE kapa JOIN clause tsa lipotso tsa hau. Hape, nahana ka ho sebelisa li-index tse kopaneng haeba u hloka ho sefa likholomong tse ngata. Sena se tla fokotsa palo ea lintlha tseo enjine ea database e lokelang ho e hlahloba, ka hona, ho ntlafatsa ts'ebetso ea lipotso tsa hau.

2. Qoba tšebeliso e sa hlokahaleng ea mesebetsi: Leha MariaDB e na le mefuta e mengata e fapaneng ea mesebetsi e hahelletsoeng, o lokela ho ba hlokolosi ha u e sebelisa lipotsong tsa hau. ⁣Mesebetsi e joalo ka CONCAT, DATE_FORMAT kapa UPPER, har'a tse ling, e ka thusa maemong a mang, empa e ka fokotsa lipotso tsa hau ha e sebelisoa ⁤ ntle le khethollo. Leka ho qoba tšebeliso e sa hlokahaleng ea mesebetsi moo ho ka khonehang, 'me ho e-na le hoo, sebelisa data e tala ho etsa lipapiso le li-filters tse hlokahalang.

3. Ntlafatsa ⁤ lipotso tsa hau ka ⁢ JOIN e sebetsang hantle: JOIN ke karolo ea bohlokoa ea lipotso ho MariaDB, empa e ka ba tšitiso haeba e sa sebelisoe hantle. tsela e sebetsang hantle. Kamehla leka ho ngola lipotso ka JOIN tse hlakileng ho fapana le ho JOIN ka mokhoa o sa tobang, kaha sena se lumella MariaDB query optimizer ho etsa liqeto tse bohlale mabapi le mokhoa oa ho etsa potso. Hape, etsa bonnete ba hore u na le li-index tse nepahetseng likholomong tse sebelisitsoeng ho JOIN ho fokotsa palo ea data e lokelang ho bapisoa.

Ka mekhoa ena le mekhoa e metle, u tla khona ho ntlafatsa ts'ebetso ea lipotso tsa hau ho MariaDB mme u fumane liphetho tse potlakileng le tse sebetsang haholoanyane. ⁢Kamehla hopola ho sekaseka leano la ho etsa lipotso le ho etsa liteko tsa ts'ebetso ho tseba libaka tseo u ka li ntlafatsang, 'me u nke tsebo ea hau ea ho botsa le ho sefa boemong bo latelang ho MariaDB!

7.⁤ Ho kenya ts'ebetsong mekhoa e bolokiloeng ⁤le mesebetsi bakeng sa ho iketsetsa ho eketsehileng

Mekhoa e bolokiloeng: E 'ngoe ea likarolo tse matla ka ho fetisisa tsa MariaDB ke bokhoni ba ho kenya ts'ebetsong mekhoa e bolokiloeng. Tsena ke li-blocks tse hlalositsoeng esale pele tse ka bolokoang⁢ polokelong ea boitsebiso le ho sebelisoa neng kapa neng. Sena se fana ka boiketsetso bo boholo, kaha liketso tse rarahaneng li ka etsoa ka mohala o le mong ho mokhoa o bolokiloeng. Ka mohlala, o ka etsa mokhoa o bolokiloeng oa ho bala karolelano ea thekiso ea khoeli le khoeli le ho iketsetsa tlaleho.

Mesebetsi: Mesebetsi e tšoana le mekhoa e bolokiloeng, empa ho e-na le ho ba li-blocks tsa khoutu tse etsang liketso, mesebetsi e khutlisetsa boleng. Sena se bohlokoa ha o hloka ho etsa lipalo kapa manollo ea data mme o lebelletse sephetho se itseng. Ka mohlala, o ka etsa tšebetso e balang litheolelo tse lokelang ho sebelisoa ho sehlahisoa ho latela theko le tafole ea litheolelo.

Boiketsetso: Ka ho kenya ts'ebetsong lits'ebetso le ts'ebetso tse bolokiloeng polokelong ea polokelo ea MariaDB, ho fihleloa ho hoholo ha mesebetsi. Sena se bolela hore ⁢ tlhoko ea ho kenella ka letsoho e fokotsehile, e leng eona ⁤e fokotsang liphoso tsa batho le ho nolofatsa ⁤mesebetsi. Ntle le moo, ka ho sebelisa lits'ebetso le lits'ebetso tse bolokiloeng, o ka theha tšebetso e sebetsang hantle hobane o ka sebelisa khoutu hape likarolong tse fapaneng tsa kopo. Sena se etsa hore ho be bonolo ho boloka le ho nchafatsa ⁤database ha sistimi e ntse e fetoha.

Litaba tse ikhethileng - Tobetsa Mona  Mokhoa oa ho laola likamano ho SQLite Manager?

8. Backup Data ea MariaDB le Pholiso: Ho Boloka Boitsebiso ba Hao bo Sireletsehile

Ho netefatsa polokeho ea tlhahisoleseling ea hau ho MariaDB, ho bohlokoa ho e etsa li-backup nako le nako. Li-backups tsena li tla u lumella sireletsa⁢ data ea hau khahlanong le liphoso tse ka bang teng tsa sistimi, liphoso tsa batho kapa likoluoa ​​​​tsa tlhaho. Ka lehlohonolo,⁢ MariaDB⁢ e na⁤ lisebelisoa le mekhoa e fapaneng e tsamaisang ts'ebetso ena.

E 'ngoe ea litsela tse atileng haholo tsa ho etsa li-backups ho MariaDB ke ho sebelisa mosebetsi oa "mysqldump". Sesebelisoa sena se u lumella romela ka ntle khopi ya dikahare tsa polokelongtshedimosetso ya hao faeleng ya SQL, e ka ⁤ho khutlisetsoa haeba data e lahlehile. Ntle le moo, o ka hlophisa ⁢mesebetsi ea othomathike e le hore li-backups li etsoe nako le nako, ka hona, o netefatsa ts'ireletso ea kamehla. ea lintlha tsa hau.

Ntle le likopi tsa bekapo, ho bohlokoa ho ba le moralo oa ho khutlisa data maemong a liketsahalo. MariaDB e fana ka likhetho tse 'maloa bakeng sa ho khutlisa data, joalo ka ho sebelisa li-logo tsa binary ho hlaphoheloa ⁤liphetoho ⁢ tse entsoeng ka mor'a bekapo. Ho phaella moo, u ka sebelisa karolo ea ho hlaphoheloa ho khutlisetsa database ho boemo bo fetileng ha ho na le diphoso tse tebileng. Likarolo tsena li u fa khotso ea kelello ea ho tseba hore, haeba ho ka etsahala, data ea hau e tla sireletsoa 'me e ka fumanoa habonolo.

9. Tlhokomelo le tokiso ea tšebetso ho MariaDB: Lintlafatso tse tsoelang pele ho ntlafatsa polokelong ea hau

El ho beha leihlo le ho lokisa tšebetso⁢ ho MariaDB Ke ts'ebetso ea bohlokoa ho boloka database e sebetsang hantle le e ntlafalitsoeng. Ha database ea hau e ntse e hola ka boholo le ho rarahana, ho bohlokoa ho etsa lintlafatso tse tsoelang pele ho netefatsa ts'ebetso e nepahetseng.

Ho na le lisebelisoa tse 'maloa ⁤le ⁢mekhoa eo u ka e sebelisang hlokomela le ho lokisa tshebetso ea database ea hau ho MariaDB. E 'ngoe ea lintho tsa pele tseo u lokelang ho li etsa ke ho lekola ts'ebetso ea hajoale ea database ea hau U ka sebelisa litaelo tse kang ⁢ SHOW STATUS y SHOW VARIABLES ho fumana leseli mabapi le boemo ba hajoale ba database.

Hang ha u se u khethile libaka tseo u lokelang ho li ntlafatsa, u ka khona tshebetso ya mmino ho tsoa ho database ea hau. Sena se ka kenyelletsa ho ntlafatsa lipotso ka li-index, ho lokisa litlhophiso tsa seva, le ho ntlafatsa hardware ha ho hlokahala. Hape ke habohlokoa hlokomela tshebetso ka mor'a ho etsa liphetoho ho netefatsa hore lintlafatso li sebetsa kamoo ho neng ho lebelletsoe.

10. Tlhokomelo le ntlafatso ea database ea MariaDB: Litlhahiso tsa ts'ebetso e tsoelang pele le e sireletsehileng.

Haeba u sebelisa ⁢MariaDB⁣ e le sistimi ea taolo ea polokelo ea hau, ho bohlokoa ho utloisisa bohlokoa ba tlhokomelo le ntlafatso ea kamehla. Sena se netefatsa ts'ebetso e tsoelang pele le e bolokehileng⁤ ea polokelo ea hau. Mona re fana ka litlhahiso tse ling ho etsa mesebetsi ena ka katleho:

Etsa li-backups khafetsa: Li-backups li bohlokoa bakeng sa polokeho le ts'ireletso ea data ea hau. ⁤ Etsa li-backups tsa kamehla tsa database ea hau 'me u li boloke sebakeng se sireletsehileng Ho phaella moo, etsa bonnete ba hore kamehla u lekola ho hlaphoheloa ho tsoa ho li-backups tsena ho netefatsa hore lintlha tsa hau li ka tsosolosoa ka katleho.

Kenya lintlafatso tsa software: Ho bohlokoa ho boloka sistimi ea hau ea taolo ea database e ntse e le teng. Lintlafatso li na le ntlafatso ea ts'ebetso, ⁢litokiso tsa liphoso le lipache tsa ts'ireletso⁢ tse thusang ho boloka polokelo ea hau ea boitsebiso e sirelelitsoe. Etsa bonnete ba hore u tseba lintlafatso life kapa life tse lokollotsoeng⁢ 'me u rera ho romelloa ha tsona khafetsa ho ⁤ho qoba ⁢ mathata a ho lumellana le ho netefatsa hore u nka monyetla ka botlalo ba likarolo tse ncha tse fanoang ke MariaDB.

Ntlafatsa ts'ebetso ea database ea hau: Database e sebetsang hantle ke senotlolo sa ts'ebetso e nepahetseng ea sistimi ea hau. Sebelisa lisebelisoa le lisebelisoa tse fanoeng ke MariaDB ho ntlafatsa ⁢ ts'ebetso ea polokelo ea hau. Etsa tlhahlobo le ho beha leihlo khafetsa ho fumana libaka tse ka ntlafatsoang, joalo ka indexing ea litafole kapa ho ntlafatsa lipotso. Ho feta moo, etsa bonnete ba hore u latela mekhoa e metle ea moralo oa database ho qoba mathata a ts'ebetso ea nako e telele.