Bayan shekara guda na ci gaba da saki uku na farko, an buga farkon barga saki na sabon reshe na MariaDB 10.6 DBMS, a cikin abin da ake haɓaka reshe na MySQL wanda ke kula da dacewa da baya kuma an bambanta ta hanyar haɗakar ƙarin injunan ajiya. da ci-gaba iyawa. Za a ba da tallafi ga sabon reshe na shekaru 5, har zuwa Yuli 2026.
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 azaman maye gurbin MySQL a yawancin rarrabawar Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kuma an aiwatar dashi a cikin manyan ayyuka kamar Wikipedia, Google Cloud SQL da Nimbuzz.
Maɓallin haɓakawa a cikin MariaDB 10.6:
- An tabbatar da aiwatar da aiwatar da atomic na furcin "CREATE TABLE|VIEW|SEQUENCE|TRIGER", "MASALLATA TABLE|JISIN", "SAKE SANIN TABLE|TABLES", "DUBA TABLE|VIEW|VIEW|TRIGGER|DATABASE" gaba daya ya kammala ko kuma a mayar da komai zuwa yadda yake). A cikin yanayin ayyukan "DROP TABLE" waɗanda ke share tebur da yawa lokaci ɗaya, ana tabbatar da atomity a matakin kowane tebur. Manufar canjin shine don tabbatar da mutunci a yayin da wani hatsarin uwar garke yayin aiki. A baya can, bayan faɗuwa, tebur na wucin gadi da fayiloli na iya kasancewa, ana iya ɓata aiki tare da tebura a cikin injinan ajiya da fayilolin frm, kuma tebur ɗaya ɗaya na iya kasancewa ba a sake suna ba lokacin da aka canza sunan tebur da yawa a lokaci ɗaya. Ana tabbatar da mutunci ta hanyar kiyaye bayanan dawo da jihar, hanyar da za a iya ƙayyade ta hanyar sabon zaɓi "-log-ddl-recovery=file" (ddl-recovery.log ta tsohuwa).
- An aiwatar da ginin "SELECT ... OFFSET ... FETCH" da aka ayyana a cikin ma'auni na SQL 2008, yana ba ku damar nuna takamaiman adadin layuka waɗanda suka fara daga ƙayyadadden biya, tare da ikon yin amfani da ma'aunin "WITH TIES" zuwa haɗa wata ƙima ta gaba. Misali, kalmar "Zabi i DAGA T1 ORDER BY i ASC OFFSET 1 ROWS FETCH FARKO 3 RUDUN FARKO WITH TIES" ya sha bamban da ginin "SELECT i FROM t1 ORDER BY i ASC LIMIT 3 OFFSET 1" ta hanyar fitar da karin kashi daya a cikin wutsiya. (maimakon layukan 3 za a buga).
- Don ingin InnoDB, an aiwatar da tsarin haɗin gwiwar "SELECT ... SKIP LOCKED", wanda ke ba ku damar keɓance layuka waɗanda ba za a iya saita kulle ba ("LOCK IN SHARE MODE" ko "DOMIN UPDATE").
- An aiwatar da ikon yin watsi da firikwensin (a cikin MySQL 8, ana kiran wannan aikin "ma'auni marar ganuwa"). Alamar fihirisar don yin watsi da ita ana yin ta ta amfani da tutar IGNORED a cikin bayanin ALTER TABLE, bayan haka fihirisar tana nan a bayyane kuma ana sabunta ta, amma mai ingantawa baya amfani da ita.
- Ƙara aikin JSON_TABLE() don juyar da bayanan JSON zuwa hanyar alaƙa. Misali, ana iya canza daftarin aiki na JSON don amfani a cikin mahallin tebur, wanda za'a iya ƙididdige shi a cikin toshe FROM a cikin bayanin SELECT.
- Ingantacciyar dacewa tare da Oracle DBMS: Ƙara tallafi don abubuwan da ba a san su ba a cikin toshewar FROM. An aiwatar da ginin MINUS (daidai da SAI BA). An ƙara ADD_MONTHS(), TO_CHAR(), SYS_GUID() da ayyukan ROWNUM().
- A cikin injin InnoDB, an ƙara ƙara sakawa cikin tebur marasa komai. An saita tsarin kirtani COMPRESSED zuwa yanayin karantawa kawai ta tsohuwa. Tsarin SYS_TABLESPACES ya maye gurbin SYS_DATAFILES kuma yana nuna halin kai tsaye a cikin tsarin fayil. Ana ba da tallafin rubutu malalaci don sararin tebur na wucin gadi. An dakatar da goyan bayan tsohon checksum algorithm, wanda aka riƙe don dacewa da MariaDB 5.5.
- A cikin tsarin kwafi, an ƙara girman ƙimar ma'aunin master_host daga haruffa 60 zuwa haruffa 255, kuma master_user zuwa 128. An ƙara canjin binlog_expire_logs_seconds don saita lokacin ƙarewar log ɗin binary a cikin daƙiƙa (a baya, lokacin sake saiti ya kasance. an ƙaddara kawai a cikin kwanaki ta hanyar canjin_logs_days.
- Na'urar kwafi-mafi-mafi-mafi-mafi-nauyi tare da Galera tana aiwatar da madaidaicin wsrep_mode don saita sigogin API na WSREP (Rubuta Saitin Replication). An yarda da jujjuyawar Galera daga sadarwar da ba a ɓoye ba zuwa TLS ba tare da dakatar da gungu ba.
- An aiwatar da tsarin sys-schema, wanda ya ƙunshi tarin ra'ayoyi, ayyuka da matakai don nazarin ayyukan bayanai.
- Ƙara teburin sabis don nazarin aikin kwafi.
- An ƙara ra'ayoyin INFORMATION_SCHEMA.KEYWORDS da INFORMATION_SCHEMA.SQL_FUNCTIONS cikin jerin tebur na bayanai, suna nuna jerin mahimman kalmomi da ayyuka.
- An cire ma'ajiyar TokuDB da CassandraSE.
- An canza rikodin utf8 daga wakilcin baiti huɗu utf8mb4 (U+0000..U+10FFFF) zuwa utf8mb3-byte uku (ya ƙunshi kewayon Unicode U+0000..U+FFFF).
- Ƙara tallafi don kunna soket a cikin systemd.
- GSSAPI plugin ɗin ya ƙara goyan baya ga sunayen ƙungiyar Active Directory da SIDs.
- An ƙara rajista don kasancewar fayil ɗin sanyi $MARIADB_HOME/my.cnf ban da $MYSQL_HOME/my.cnf.
- An aiwatar da sabbin masu canjin tsarin binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode da Innodb_buffer_pool_pages_lru_freed.
source: budenet.ru