Ka mor'a selemo sa ntshetsopele le tse 'nè pele ho lokolloa tokollo ea pele e tsitsitseng ea lekala le lecha la DBMS , moo ho ntseng ho ntlafatsoa lekala la MySQL le bolokang tšebelisano ea morao-rao le kopanyo ea lienjineri tse eketsehileng tsa polokelo le bokhoni bo tsoetseng pele. Ho tla fanoa ka tšehetso bakeng sa lekala le lecha ka lilemo tse 5, ho fihlela ka June 2025.
Nts'etsopele ea MariaDB e tsamaisoa ke Mokhatlo o ikemetseng oa MariaDB, ho latela ts'ebetso ea nts'etsopele e bulehileng ka ho felletseng e ikemetseng ho barekisi ka bomong. MariaDB e fanoe sebakeng sa MySQL ho li-distributions tse ngata tsa Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) 'me e kentsoe tšebetsong mererong e meholo joalo ka. , и .
Senotlolo :
- Enjene ea polokelo e ekelitsoeng , e u lumellang ho amohela litafole tsa MariaDB ho Amazon S3 kapa polokelo efe kapa efe ea sechaba kapa ea poraefete ea leru e tšehetsang S3 API. Ho beha litafole tse tloaelehileng le tse arohaneng ho S3 hoa tšehetsoa. Ha litafole tse arohaneng li behiloe marung, li ka sebelisoa ka kotloloho, ho kenyelletsa le ho tsoa ho seva se seng se nang le phihlello ea polokelo ea S3.
- Enjene ea polokelo e ekelitsoeng , e bolokang data e tlamelletsoeng ho likholomo le tšebeliso meaho e ajoang. Enjene e ipapisitse le nts'etsopele ea polokelo ea MySQL 'me e reretsoe ho hlophisa ts'ebetso le ts'ebetso ea lipotso tsa tlhahlobo holim'a data e ngata (Data Warehouse).
ColumnStore e boloka data eseng mola ka tatellano, empa ka mela, e u lumellang ho ntlafatsa ts'ebetso ea ho hlophisa ka likholomo ho tsoa polokelong e kholo, ho kenyeletsoa le li-petabytes tsa data. Ho atolosoa ha mela, polokelo ea data e hatelitsoeng, karohano e otlolohileng le e otlolohileng, le ho etsoa ka nepo ha likopo tse hlolisanoang lia tšehetsoa. - Liphetoho tsohle tse qalang ka lentsoe "mysql" li fetoletsoe ho sebelisa lentsoe "mariadb". Mabitso a khale a bolokiloe ka mokhoa oa lihokelo tsa tšoantšetso.
- E kentse mofuta o mocha oa data bakeng sa ho boloka liaterese tsa IPv6.
- Mosebetsi o entsoe ho arola litokelo ka likaroloana tse nyane. Sebakeng sa tokelo e akaretsang ea SUPER, ho hlahisoa letoto la litokelo tse ikhethileng "BINLOG ADMIN",
"BINLOG REPLAY"
"KOLAO ADMIN"
"FEDERATED ADMIN"
"BALA_FEELA ADMIN",
"REPLICATION MASTER ADMIN"
"REPLICATION LEKHOBA ADMIN" le
"BETA MOSEBETSI". - Monyetla oa "REPLICATION CLIENT" o fetoletsoe lebitso la "BINLOG MONITOR" le polelo ea "SHOW MASTER STATUS" ho "BONTŠA BINLOG STATUS". Ho reha bocha ho hlakisa boitšoaro 'me ha ho amane le ho nepahala ha lipolotiki, morero ha o tlohele mantsoe monghali / lekhoba mme o bile o ekelitse litokelo tse ncha "MASTER ADMIN" le "LAVE ADMIN". Ka nako e ts'oanang, senotlolo se secha "REPLICA" se kenyelelitsoe polelong ea SQL, e leng lentsoe le le leng la "LAVE".
- Bakeng sa lipolelo tse ling, litokelo tse hlokahalang bakeng sa ho li phetha li fetotsoe. "SHOW BINLOG EVENTS" jwale e hloka ditokelo tsa "BINLOG MONITOR" ho fapana le "REPLICATION SLAVE", "SHOW SLAVE Hosts" e hloka "REPLICATION MASTER ADMIN" ho fapana le "REPLICATION SLAVE", "SHOW SLAVE STATUS" e hloka "REPLICATION SLAVE ADMIN" kapa " SUPER" sebakeng sa "REPLICATION CLIENT", "SHOW RELAYLOG EVENTS" e hloka "REPLICATION SLLAVE ADMIN" ho fapana le "REPLICATION SLAVE".
- Meetso e ekelitsoeng ""Le"", ho khutlisa lethathamo la likenyo tse kentsoeng / tse nchafalitsoeng ka foromo joalo ka ha litekanyetso li khutlisitsoe ho sebelisoa poleloana ea KHETHA (e ts'oanang le "DELETE ... RETURNING").
KENYA HO t2 MATHEO (1,'Ntja'),(2,'Lion'),(3,'Tiger'),(4,'Leopard')
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 |
+——+———+————+————+ - Mantsoe a ekelitsoeng ""Le"»ho se kenyeletse/ho tlatselletsa sephetho ka sete e itseng ea boleng.
- Hona joale hoa khoneha ho hlakisa maikutlo ka har'a "CREATE DATABASE" le "ALTER DATABASE" blocks.
- Mehaho e ekelitsoeng bakeng sa ho reha mabitso a li-index le likholomo ""Mme"".
- Ts'ebetsong ea "ALTER TABLE" le "RENAME TABLE", ts'ehetso ea boemo ba "IF EXISTS" e kenyelelitsoe ho etsa ts'ebetso feela haeba tafole e le teng;
- Bakeng sa li-index ho "CREATE TABLE" tšobotsi "".
- E kentse polelo ea "CYCLE" ho supa li-loops tse iphetang .
- Likarolo li kentsoe и ho khutlisa sehlopha kapa ntho ea JSON e nang le boleng ba kholomo e boletsoeng.
- E kentsoe litafole tsa lintlha tsa litšebeletso (THREAD_POOL_GROUPS, THREAD_POOL_QUEUES, THREAD_POOL_STATS le THREAD_POOL_WAITS) bakeng sa letamo la khoele (thread_pool).
- Polelo ea ANALYZE e atolosoa ho bontša nako e sebelisitsoeng ho hlahloba WHERE thibela le ho etsa mesebetsi e thusang.
- Sesebediswa sa ho sebetsa ka mefuta e fapaneng se ela hloko litšobotsi tsa "IS NOT NULL".
- Boholo ba lifaele tsa nakoana tse sebelisoang ha ho hlophisoa ka mefuta ea VARCHAR, CHAR le BLOB bo fokotsehile haholo.
- В , e sebelisetsoang ho hlophisa ho pheta-pheta, masimo a macha a metadata a kenyelelitsoe, ho kenyeletsoa Key Key, Lebitso la Kholomo, Sebopeho sa Sebopeho le Mofuta oa Geometry. Sesebelisoa sa mariadb-binlog le litaelo tsa "SHOW BINLOG EVENTS" le "SHOW RELAYLOG EVENTS" li fana ka pontšo ea lifolakha tse pheta-phetoang.
- Ho haha jwale ho bolokehile litafole tse setseng enjeneng ea polokelo le haeba ho se na lifaele tsa ".frm" kapa ".par".
- E kentse tšebetsong mofuta o potlakileng oa lisebelisoa tsa crc32() bakeng sa li-CPU tsa AMD64, ARMv8 le POWER 8.
- E fetotse li-setting tse ling tsa kamehla. innodb_encryption_threads e ekelitsoe ho 255 mme max_sort_length e ekelitsoe ho tloha ho 4 ho isa ho 8.
- Lintlafatso tse ngata tsa ts'ebetso bakeng sa enjine ea InnoDB li hlahisoa.
- Tšehetso e feletseng e kenyelelitsoe mochineng oa Galera o lumellanang le mekhoa e mengata ea ho pheta-pheta (Global Transaction ID), li-identifiers tsa transaction tse tloaelehileng ho lihlopha tsohle tsa lihlopha.
- Phetolelo ea ho ea lekaleng le lecha la laeborari e entsoe (Perl Compatible Regular Expressions), sebakeng sa letoto la khale la PCRE 8.x.
- Ho hlahisitsoe mefuta e mecha ea lithapo bakeng sa ho hokela ho MariaDB le MySQL DBMS ho tsoa mananeong a Python le C: и . Tlamahano ea Python e lumellana le Python DB API 2.0, e ngotsoe ka C mme e sebelisa laebrari ea Connector / C ho hokahanya le seva.
Source: opennet.ru