Ukukhishwa okuzinzile kwe-MariaDB 10.4

Ngemva konyaka wokuthuthukiswa kanye nokukhishwa kwangaphambili okuyisithupha zilungisiwe ukukhishwa kokuqala okuzinzile kwegatsha elisha le-DBMS UMariaDB 10.4, lapho kuthuthukiswa khona igatsha le-MySQL eligcina ukuhambisana okusemuva kanye ezahlukene ukuhlanganiswa kwezinjini ezengeziwe zokugcina kanye namakhono athuthukile. Ukusekelwa kwegatsha elisha kuzonikezwa iminyaka emi-5, kuze kube uJuni 2024.

Ukuthuthukiswa kwe-MariaDB kwenganyelwe i-MariaDB Foundation ezimele, kulandela inqubo yentuthuko evuleleke ngokuphelele futhi esobala ezimele kubathengisi ngabanye. I-MariaDB ihlinzekwa esikhundleni se-MySQL ezindaweni eziningi ezisatshalaliswa ze-Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) futhi seyenziwe kumaphrojekthi amakhulu njenge. Wikipedia, I-Google Cloud SQL и Nimbuzz.

Ukhiye ukuthuthukiswa UMariaDB 10.4:

• Kufaka phakathi ubuchwepheshe bokuphindaphinda be-multi-master okuvumelanisa Igalari 4, okuvumela i-multi-master topology esebenzayo esebenzayo engafundwa futhi ibhalwe inodi. Ngokuphindaphinda okuvumelanayo, wonke ama-node ahlala equkethe idatha yakamuva, i.e. akukho ukuthengiselana okulahlekile okuqinisekisiwe, njengoba ukuthengiselana kwenziwa kuphela ngemva kokuba idatha isakazwe kuwo wonke ama-node. Ukuphindaphinda kwenziwa ngemodi efanayo, ezingeni lomugqa, kudlulisa ulwazi kuphela mayelana nezinguquko;
• Kumasistimu afana ne-Unix, i-plugin yokuqinisekisa inikwe amandla ngokuzenzakalelayo unix_socket, okuvumela ukuthi usebenzise ama-akhawunti akhona ohlelweni ukuze uxhume ku-DBMS usebenzisa isokhethi yendawo ye-unix;
• Kwengeziwe ithuba ukwabela iphasiwedi yomsebenzisi impilo yonke, ngemva kwalokho iphasiwedi imakwa njengephelelwe yisikhathi. Ukuze usethe idethi yokuphelelwa yisikhathi kwephasiwedi emisebenzini ethi “DALA UMSEBENZISI” kanye “NOMSEBENZISI WASE-ALTER”, inkulumo ethi “IPASSWORD EXPIRE INTERVAL N DAY” yengeziwe;
• Ukwesekwa okwengeziwe ukuvimba Abasebenzisi be-DBMS ngenkulumo ethi “ACCOUNT LOCK” emisebenzini ethi “DALA UMSEBENZISI” kanye nokuthi “ALTER USER”;
• Ukwenziwa kokuhlolwa kwelungelo ekucushweni ngenani elikhulu labasebenzisi noma imithetho yokufinyelela kusheshiswe kakhulu;
• iyekisiwe usebenzisa amatafula we-mysql.user kanye ne-mysql.host. Ithebula le-mysql.global_priv manje selisetshenziselwa ukugcina ama-akhawunti namalungelo omhlaba;
• В ama-plugin ubuqiniso kwengezwe usekelo lwenkulumo ethi “SET PASSWORD”;
• Kwengeziwe amandla okusebenzisa i-plugin yokuqinisekisa engaphezu kweyodwa ku-akhawunti ngayinye, okungaba usizo ekuthutheleni kancane kancane abasebenzisi ku-plugin ed25519. Lapho udala umsebenzisi we-root@localhost ngesikripthi se-mysql_install_db, ama-plugin amabili okufakazela ubuqiniso manje anikwe amandla ngokuzenzakalela - unix_socket kanye ne-mysql_native_password;
• Isitoreji se-InnoDB sisebenzisa ukusebenza kokususa amakholomu khona manjalo (ITHEBULA LOKUHLUKANA ... DULA IKHOLOMU ... ALGORITHM=INSTANT) nokushintsha ukuhleleka kwamakholomu. Usayizi welogi yokuqala yemisebenzi yokuhlehlisa (ukwenza kabusha ilogu) uncishisiwe. Kwengezwe ukhiye wokusekela wokuzungezisa we-innodb_encrypt_log. Kusetshenziswe i-algorithm yokuhlola ama-checksum
  innodb_checksum_algorithm=full_crc32. Inikeza ukunwetshwa okusheshayo kohlobo lwe-VARCHAR nokushintsha umbhalo wekhodi wamakholomu angenankomba;

• Isilungiseleli esithuthukisiwe. Kwengezwe amandla okulandelela isilungiseleli, esinikwe amandla ngokushintshashintsha kwesistimu i-optimizer-trace... Okuzenzakalelayo kufakiwe ukugcina izibalo ezizimele ezinjinini zokulondoloza.
  Kukhona izindlela ezimbili ezintsha ze-use_stat_tables - COMPLEMENTARY_FOR_QUERIES kanye ne-PREFERABLY_FOR_QUERIES. Imodi ye-optimize_join_buffer_size inikwe amandla. Kwengezwe ezintsha amafulege rowid_filtha kanye condition_pushdown_from_having;

• Ukusekelwa kwamathebula enguqulo yesistimu, angagcini nje kuphela ucezu lwedatha yamanje, kodwa futhi alondoloze ulwazi mayelana nazo zonke izinguquko ezenziwe ngaphambilini, kunwetshiwe. imisebenzi ngezigaba zesikhathi;
• Kwengezwe umyalo omusha we-"FLUSH SSL" ukuze ulayishe kabusha izitifiketi ze-SSL ngaphandle kokuqalisa kabusha iseva;
• Ukwesekwa okwengeziwe kwezinkulumo ezithi “UMA AYIKHONA” kanye nesithi “UMA YIKHO” emisebenzini ethi “FAKA I-PLUGIN”, “KHIPHA I-PLUGIN” kanye “KHIPHA I-SONAME”;
• Amathebula esistimu amelana nokuphahlazeka ayahlongozwa, ukuze agcinwe lapho kusetshenziswa khona injini Aria;
• Ukushintshela ekusetshenzisweni kwezinga le-C++11 kwenziwe (kubandakanyeka ukusebenza kwe-athomu);
• Ukusebenza kwezindawo ze-Collation locale ze-Unicode kuthuthukiswe kakhulu, okukuvumela ukuba ucacise imithetho yokuhlunga nezindlela zokumadanisa ngokusekelwe encazelweni yezinhlamvu;
• Kwengezwe i-plugin yokuchaza izinhlobo zakho zensimu;
• Kwengezwe usekelo lwe-window Imisebenzi ye-UDF (Imisebenzi Echazwe Ngabasebenzisi);
• Kumsebenzi othi "FLUSH TABLES". kwenziwe Imodi ethi “ISIKHIPHA SESIPELE”, engasetshenziswa lapho ugcina amafayela esizindalwazi;
• Kwengeziwe ukusekela imiyalo yeseva eqala ngo-mariadb, ezinye izindlela zemiyalo eqala ngo-"mysql" (isibonelo, i-mariadump esikhundleni se-mysqldump).

Source: opennet.ru