Bayan shekara guda na ci gaba da kuma sakewa guda hudu barga na farko na sabon reshe na DBMS , wanda a cikinsa ake haɓaka reshe na MySQL wanda ke kula da dacewa da baya da kuma haɗewar ƙarin injunan ajiya da ƙarfin ci gaba. Za a ba da tallafi ga sabon reshe na shekaru 5, har zuwa Yuni 2025.
MariaDB Foundation mai zaman kanta ce ke kula da ci gaban MariaDB, yana bin tsarin ci gaba gaba ɗaya buɗe kuma madaidaiciyar tsari wanda ke zaman kansa na kowane dillalai. Ana ba da MariaDB maimakon MySQL a yawancin rarrabawar Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kuma an aiwatar da shi a cikin manyan ayyuka kamar , и .
Maɓalli :
- Ƙara injin ajiya , wanda ke ba ku damar ɗaukar nauyin tebur na MariaDB akan Amazon S3 ko duk wani ajiyar girgije na jama'a ko masu zaman kansu waɗanda ke goyan bayan S3 API. Ana goyan bayan sanya duka tebur na yau da kullun da na rabe-rabe a cikin S3. Lokacin da aka sanya allunan da aka raba a cikin gajimare, ana iya amfani da su kai tsaye, gami da daga wata uwar garken da ke da damar zuwa ma'ajiyar S3.
- Ƙara injin ajiya , wanda ke adana bayanai daure zuwa ginshiƙai da amfani rarraba gine-gine. Injin ya dogara ne akan ci gaban ajiyar MySQL kuma an yi niyya ne don tsara sarrafawa da aiwatar da tambayoyin nazari kan manyan bayanai (Data Warehouse).
ColumnStore yana adana bayanai ba layi-layi ba, amma ta ginshiƙai, wanda ke ba ku damar haɓaka aikin haɗawa ta ginshiƙai daga babban bayanan bayanai, gami da petabytes na bayanai. Ana goyan bayan sikeli na layi, ma'ajin bayanai da aka matsa, rarrabuwa a tsaye da kwance, da ingantaccen aiwatar da buƙatun gasa. - Duk masu aiwatarwa da suka fara da kalmar "mysql" an canza suna zuwa amfani da kalmar "mariadb". Ana adana tsoffin sunaye a cikin hanyar haɗin kai na alama.
- An ƙara sabon nau'in bayanai don adana adiresoshin IPv6.
- An yi aiki don raba gata zuwa ƙananan sassa. Maimakon babban gata na SUPER, an gabatar da jerin gata na zaɓi "BINLOG ADMIN",
"SAKE YIWA BLOG"
"CONNECTION ADMIN"
"ADMIN TARAYYA"
"KARANTA_KAI ADMIN",
"MISALI MALAM ADMIN"
"MAIYI BAWAN ADMIN" da
"SATA MAI AMFANI". - An canza gata ta "CLICT CLIENT" zuwa "BILOG MONITOR" da "NUNA MATSAYIN MASTER" zuwa "NUNA MATSAYIN BINLOG". Sake suna yana fayyace ɗabi'a kuma ba'a haɗa shi da daidaiton siyasa, aikin baya watsi da sharuɗɗan master / bawa har ma da ƙarin sabbin gata "MASTER ADMIN" da " ADMIN BAYI ". A lokaci guda, an ƙara sabon maɓalli "REPLICA" zuwa furcin SQL, wanda shine ma'anar "SLAVE".
- Ga wasu maganganu, an canza gatan da ake buƙata don aiwatar da su. "NUNA BINLOG EVENTS" yanzu yana buƙatar gata na "BINLOG MONITOR" maimakon "BAWA MAI MAIMAITA", "NUNA BAWA" yana buƙatar gata "REPLICATION MASTER ADMIN" maimakon "SAURARA BAWAN", "NUNA MATSAYIN BAWAN" yana buƙatar "MAI YIWA ADMIN BAWAN" ko "SUPER" maimakon "MAI YIWA CLIENT", "NUNA AL'AMURAN RELAYLOG" yana buƙatar haƙƙoƙin "KYAUTATA BAWAN ADMIN" maimakon "MAI YIWA BAWAN".
- Ƙarin ƙira""Kuma"", mayar da jerin shigarwar da aka saka/maye gurbinsu a cikin tsari kamar an dawo da kimar ta amfani da kalmar SELECT (mai kama da "SHAKE ... MAYARWA").
SHIGA T2 DABI'U (1,'Kare'),(2,'Lion'),(3,'Tiger'),(4,'Damisa')
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 |
+——————————————-+ - Karin magana""Kuma"» don ware/ƙara da sakamakon tare da ƙayyadaddun ƙima.
- Yanzu yana yiwuwa a saka tsokaci a cikin tubalan "CREATE DATABASE" da "ALTER DATABASE".
- Ƙarfafa ginin don sake suna firikwensin da ginshiƙai""Kuma"".
- A cikin ayyukan "ALTER TABLE" da "Sake suna TABLE", an ƙara goyon bayan yanayin "IF EXISTS" don yin aikin kawai idan tebur ya kasance;
- Don fihirisa a cikin "CREATE TABLE" sifa "".
- Ƙara kalmar "CYCLE" don gano madaukai masu maimaitawa .
- An ƙara fasali и don dawo da tsararru ko abu JSON tare da ƙimar ƙayyadadden shafi.
- Ƙara teburin bayanin sabis (THREAD_POOL_GROUPS, THREAD_POOL_QUEUES, THREAD_POOL_STATS da THREAD_POOL_WAITS) don tafkin zaren (thread_pool).
- Ana faɗaɗa maganar ANALYZE don nuna lokacin da aka kashe don duba toshe INA da yin ayyukan taimako.
- Mai inganta kewayon sarrafa kewayon yana yin la'akari da halayen "BA KASANCEWA BA".
- Girman fayilolin wucin gadi da aka yi amfani da su lokacin rarrabawa tare da nau'ikan VARCHAR, CHAR da BLOB an ragu sosai.
- В , An yi amfani da shi don tsara kwafi, an ƙara sabbin filayen metadata, gami da Maɓalli na Farko, Sunan Rukunin, Saitin Halaye da Nau'in Geometry. Abubuwan amfani na mariadb-binlog da "NUNA BINLOG EVENTS" da "NUNA RELAYLOG EVENTS" suna ba da nunin tutocin kwafi.
- Ginin yanzu lafiya Tables da suka rage a cikin injin ajiya ko da babu ".frm" ko ".par" fayiloli.
- An aiwatar da sigar haɓaka kayan aikin crc32() don AMD64, ARMv8 da POWER 8 CPUs.
- Canza wasu saitunan tsoho. An ƙara innodb_encryption_threads zuwa 255 kuma an ƙara max_sort_length daga 4 zuwa 8.
- An gabatar da haɓaka ayyuka da yawa don injin InnoDB.
- An ƙara cikakken goyan baya zuwa ga tsarin na'urar kwafi-mafi-hujja da yawa na aiki tare (ID na Kasuwancin Duniya), masu gano ma'amala gama-gari ga duk nodes ɗin gungu.
- An canza canji zuwa sabon reshe na ɗakin karatu (Madaidaicin Magana na yau da kullun na Perl), maimakon PCRE 8.x na yau da kullun.
- An gabatar da sabbin nau'ikan harnesses don haɗawa zuwa MariaDB da MySQL DBMS daga shirye-shirye a Python da C: и . Daurin Python ya bi Python DB API 2.0, an rubuta shi cikin C kuma yana amfani da ɗakin karatu na Connector/C don haɗawa da sabar.
source: budenet.ru