Mgbe otu afọ nke mmepe na anọ tupu mwepụta ntọhapụ kwụsiri ike nke mbụ nke ngalaba DBMS ọhụrụ , n'ime nke a na-emepụta alaka MySQL nke na-akwado ndakọrịta azụ na mwekota nke ọzọ nchekwa engines na elu ike. A ga-enye nkwado maka alaka ọhụrụ ahụ ruo afọ 5, ruo June 2025.
MariaDB Foundation nọọrọ onwe ya na-ahụ maka mmepe MariaDB, na-eso usoro mmepe mepere emepe ma doo anya nke na-adabereghị na ndị na-ere ahịa nke ọ bụla. A na-eziga MariaDB dị ka nnọchi maka MySQL n'ọtụtụ nkesa. Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ma tinye ya n'ọrụ n'ọrụ ndị buru ibu dịka , и .
Igodo :
- Igwe nchekwa agbakwunyere , nke na-enye gị ohere ịkwado tebụl MariaDB na Amazon S3 ma ọ bụ ihe ọ bụla ọzọ ọha ma ọ bụ nchekwa igwe ojii nke na-akwado S3 API. A na-akwado itinye ma tebụl oge niile na nke kewara na S3. Mgbe a na-etinye tebụl ndị kewara n'ime igwe ojii, enwere ike iji ha mee ihe ozugbo, gụnyere site na ihe nkesa ọzọ nwere ohere ịnweta nchekwa S3.
- Igwe nchekwa agbakwunyere , nke na-echekwa data jikọtara na kọlụm na ojiji kesara ije. Injin ahụ dabere na mmepe nke nchekwa MySQL na ezubere maka ịhazi nhazi na mmezu nke ajụjụ nyocha gbasara nnukwu data (Data Warehouse).
ColumnStore na-echekwa data ọ bụghị n'usoro n'usoro, kama site na kọlụm, nke na-enye gị ohere ịkwalite arụmọrụ nke nchịkọta site na kọlụm sitere na nnukwu nchekwa data, gụnyere petabytes nke data. A na-akwado usoro nhazi nke linear, nchekwa data abịakọrọ, nkewa kwụ ọtọ na kwụ ọtọ, yana mmezu nke arịrịọ asọmpi nke ọma. - Ihe niile executable malite na okwu "mysql" ka ahagharịrị ka ha jiri okwu "mariadb". A na-echekwa aha ochie n'ụdị njikọ ihe atụ.
- Ụdị data ọhụrụ agbakwunyere maka ịchekwa adreesị IPv6.
- Emeela ọrụ iji kewaa ihe ùgwù n'ime obere akụkụ. Kama ịbụ ihe ùgwù SUPER izugbe, a na-atụpụta usoro nhọrọ nhọrọ "BINLOG ADMIN",
"ỊKWU OKWU BLOG"
"njikọ ADMIN"
"Federated ADMIN"
"GỤKWUO_ONỊ ADMIN",
"MAPỤTA MASTER ADMIN"
"REPLICATION OWU ADMIN" na
"SET USER". - A kpọgharịala ikike "MKPỤRỤ CLIENT" ka ọ bụrụ "BINLOG MONITOR" na okwu "SHOW MASTER STATUS" ka ọ bụrụ "GOSỊ ỌNỤKWỤKWỤKWỤKWỤKWỤKWỤKWỤKWỤKWỤKWỤKWỤKWỤKWỤKWASỊ". Nhazigharị aha ahụ na-eme ka omume ahụ doo anya ma ejikọtaghị ya na nhazi ndọrọ ndọrọ ọchịchị, ọrụ ahụ anaghị ahapụ okwu nna ukwu / ohu na ọbụna gbakwunyere ihe ùgwù ọhụrụ "MASTER ADMIN" na " ADMIN SLAVE ". N'otu oge ahụ, agbakwunyere igodo ọhụrụ "REPLICA" na okwu SQL, nke bụ otu okwu maka "ohu".
- Maka okwu ụfọdụ, a gbanweela ihe ùgwù ndị a chọrọ iji mezuo ha. "Gosi BINLOG EVENTS" ugbu a chọrọ ihe ùgwù "BINLOG MONITOR" kama ịbụ "Ohu REPLICATION", "SHOW SLAVE HOSTS" chọrọ ihe ùgwù "REPLICATION MASTER ADMIN" kama ịbụ "Ohu REPLICATION", "Gosi ọnọdụ ohu" chọrọ" ADMIN ORU REPLICATION" ma ọ bụ " SUPER " kama ịbụ "CLIENT REPLICATION", "Gosi ihe omume RELAYLOG" chọrọ ikike "REPLICATION SLAVE ADMIN" kama ịbụ "OHU NSỤKỌ".
- Atụmatụ agbakwunyere""Na"", na-eweghachi ndepụta nke ndenye agbakwunyere / dochie anya n'ụdị dị ka a ga-asị na ejiri okwu SELECT weghachiri uru (dị ka "HIchapụ ... NTỤTA").
Tinye n'ime t2 VALUES (1,'Nkịta'),(2,'Ọdụm'),(3,'Agu'),(4,'agụ owuru')
RETURNING id2,id2+id2,id2&id2,id2||id2;
+——+————————————-+
| id2 | id2+ id2 | id2&id2 | id2||id2 |
+——+————————————-+
| 1 | 2 | 1 | 1 |
| 2 | 4 | 2 | 1 |
| 3 | 6 | 3 | 1 |
| 4 | 8 | 4 | 1 |
+——+————————————-+ - Okwu agbakwunyere""Na"» iji wepụrụ/ịgbakwunye nsonaazụ ya na ụkpụrụ akọwapụtara.
- Ọ ga-ekwe omume ugbu a ịkọwapụta nkọwa n'ime ihe mgbochi "Mepụta DATABASE" na "ALTER DATABASE".
- Ihe nrụpụta agbakwunyere maka ịnyegharị ndeksi na kọlụm aha ""Na"".
- N'ime ọrụ "ALTER TABLE" na "RENAME TABLE", agbakwunyere nkwado maka ọnọdụ "Ọ BỤRỤ EXISTS" iji rụọ ọrụ ahụ naanị ma ọ bụrụ na tebụl dị;
- Maka ndeksi dị na "Mepụta TABLE" njirimara "".
- agbakwunyere okwu "CYCLE" iji chọpụta loops na-emegharịghachi .
- Atụmatụ agbakwunyere и iji weghachi ihe n'usoro ma ọ bụ ihe JSON na ụkpụrụ nke kọlụm akọwapụtara.
- Tebụl ozi agbakwunyere (THREAD_POOL_GROUPS, THREAD_POOL_QUEUES, THREAD_POOL_STATS na THREAD_POOL_WAITS) maka ọdọ mmiri eri (thread_pool).
- A na-agbasawanye okwu ANALYZE iji gosi oge ejiri lelee ngọngọ WHERE na ịrụ ọrụ inyeaka.
- The nso nhazi optimizer na-eburu n'uche na "bụghị efu" àgwà
- Ogo faịlụ nwa oge ejiri mgbe ị na-ahazi ụdị VARCHAR, CHAR na BLOB belatara nke ukwuu.
- В , eji ahazi ntugharị, agbakwunyela mpaghara metadata ọhụrụ, gụnyere igodo isi, Aha kọlụm, Ntọala agwa na ụdị geometry. Utility mariadb-binlog na iwu “GOSỊ BINLOG EVENTS” na “GOSỊ RELAYLOG EVENTS” na-enye ngosipụta nke ọkọlọtọ mmegharị.
- Owuwu ugbua ọ dị mma tebụl ndị na-anọgide na engine nchekwa ọ bụrụgodị na enweghị faịlụ ".frm" ma ọ bụ ".par".
- Tinyere ụdị ngwaike ngwaike nke ọrụ crc32() maka AMD64, ARMv8 na POWER 8 CPUs.
- Gbanwee ụfọdụ ntọala ndabara. abawanyela innodb_encryption_threads ruo 255 yana max_sort_length agbagoro site na 4 ruo 8.
- E gosipụtara ọtụtụ njikarịcha arụmọrụ maka injin InnoDB.
- Agbakwunyela nkwado zuru oke na usoro mmegharị ọtụtụ nna ukwu Galera (NJ azụmahịa zuru ụwa ọnụ), ihe nchọpụta azụmahịa na-ahụkarị na ọnụ ụyọkọ niile.
- Emeela mgbanwe gaa n'alaka ụlọ akwụkwọ ọhụrụ (Nkwupụta Okwu Dakọtara Perl), kama usoro PCRE 8.x kpochapụrụ.
- Atụpụtala ụdị nke harnesses ọhụrụ maka ijikọ na MariaDB na MySQL DBMS site na mmemme dị na Python na C: и . Ejikọ Eke Ọgba kwekọrọ na Python DB API 2.0, edere ya na C wee jiri ọba akwụkwọ njikọ/C jikọọ na sava ahụ.
isi: opennet.ru
