MariaDB 10.4 kumasulidwa kokhazikika

Pambuyo pa chaka cha chitukuko ndi zisanu ndi chimodzi zisanachitike okonzeka kutulutsidwa koyamba kwa nthambi yatsopano ya DBMS Chithunzi cha MariaDB 10.4, momwe nthambi ya MySQL ikupangidwira yomwe imasunga kuyanjana kwam'mbuyo ndi zosiyana kuphatikiza kwa injini zosungirako zowonjezera ndi luso lapamwamba. Thandizo la nthambi yatsopano lidzaperekedwa kwa zaka 5, mpaka June 2024.

Kukula kwa MariaDB kumayang'aniridwa ndi MariaDB Foundation yodziyimira payokha, kutsatira njira yotseguka komanso yowonekera bwino yomwe ili yodziyimira pawokha kwa ogulitsa. MariaDB imaperekedwa m'malo mwa MySQL m'magawo ambiri a Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ndipo yakhazikitsidwa m'mapulojekiti akuluakulu monga Wikipedia, Google Cloud SQL и Ndimbuzz.

Chinsinsi kuwongolera Chithunzi cha MariaDB 10.4:

• Mulinso ukadaulo wa synchronous multi-master replication Galera 4, yomwe imalola kuti topology yogwira ntchito yambiri yomwe imatha kuwerengedwa ndi kulembedwa ndi node iliyonse. Ndi kubwereza kofanana, ma node onse amakhala ndi deta yamakono, i.e. palibe zochitika zotayika zomwe zimatsimikiziridwa, popeza ntchitoyo ikuchitika pokhapokha deta itafalitsidwa ku mfundo zonse. Kubwereza kumachitika munjira yofananira, pamzere wa mzere, kusamutsa zidziwitso zokhazokha zosintha;
• Pa machitidwe ngati Unix, pulogalamu yowonjezera yovomerezeka imayatsidwa mwachisawawa alireza, zomwe zimakulolani kugwiritsa ntchito ma akaunti omwe alipo mu dongosolo kuti mugwirizane ndi DBMS pogwiritsa ntchito socket ya unix;
• Zowonjezedwa mwayi kupatsa moyo wachinsinsi wa wogwiritsa ntchito, pambuyo pake mawu achinsinsi amalembedwa kuti atha. Kukhazikitsa tsiku lotha ntchito yachinsinsi mu "CREATE USER" ndi "ALTER USER", mawu oti "PASSWORD EXPIRE INTERVAL N DAY" awonjezedwa;
• Thandizo lowonjezera kutseka Ogwiritsa ntchito a DBMS kudzera pa mawu akuti "ACCOUNT LOCK" muzochita za "CREATE USER" ndi "ALTER USER";
• Kuchitidwa kwaufulu kumayang'ana mu kasinthidwe ndi chiwerengero chachikulu cha ogwiritsa ntchito kapena malamulo olowa nawo akhala akufulumira kwambiri;
• anasiya pogwiritsa ntchito matebulo a mysql.user ndi mysql.host. The mysql.global_priv table tsopano imagwiritsidwa ntchito kusunga maakaunti ndi mwayi wapadziko lonse lapansi;
• В mapulagini kutsimikizika anawonjezera kuthandizira mawu akuti "SET PASSWORD";
• Zowonjezedwa kuthekera kogwiritsa ntchito pulogalamu yowonjezera yotsimikizika yopitilira imodzi pa akaunti iliyonse, yomwe ingakhale yothandiza pakusamutsa ogwiritsa ntchito pang'onopang'ono kupita ku pulogalamu yowonjezera ed25519. Mukapanga root@localhost wosuta ndi mysql_install_db script, mapulagini awiri ovomerezeka tsopano athandizidwa mwachisawawa - unix_socket ndi mysql_native_password;
• InnoDB yosungirako imagwiritsa ntchito mizati yochotsa nthawi yomweyo (ALTER TABLE ... DROP COLUMN ... ALGORITHM=INSTANT) ndikusintha ndondomeko ya mizati. Kukula kwa chipika choyambirira cha ma rollback (redo log) chachepetsedwa. Thandizo lothandizira lozungulira la innodb_encrypt_log. Anakhazikitsa algorithm yowunika macheke
  innodb_checksum_algorithm=full_crc32. Amapereka kukulitsa pompopompo kwa mtundu wa VARCHAR ndikusintha kabisidwe ka mawu pamizati yopanda index;

• optimizer bwino. Adawonjezera kuthekera kotsata chowongolera, chothandizidwa ndi makina osinthika optimizer - kufufuza. Zosasintha kuphatikizidwa kusunga ziwerengero popanda injini zosungira.
  Pali mitundu iwiri yatsopano ya use_stat_tables - COMPLEMENTARY_FOR_QUERIES ndi PREFERABLY_FOR_QUERIES. optimize_join_buffer_size mode ndiyoyatsidwa. Zatsopano zawonjezeredwa mbendera rowid_sefa ndi condition_pushdown_from_having;

• Thandizo la matebulo osinthidwa kachitidwe, omwe samangosunga kagawo kakang'ono ka deta, komanso kusunga chidziwitso cha zosintha zonse zomwe zasinthidwa kale, zakulitsidwa. ntchito ndi nthawi;
• Anawonjezera lamulo latsopano la "FLUSH SSL" kuti mulowetsenso ziphaso za SSL popanda kuyambitsanso seva;
• Thandizo lowonjezera la mawu akuti "NGATI KULIPO" ndi "Ngati ILIPO" muzochita za "INSTALL PLUGIN", "UNINSTALL PLUGIN" ndi "UNINSTALL SONAME";
• Matebulo olimbana ndi kuwonongeka amaperekedwa, kuti asungidwe momwe injini imagwiritsidwira ntchito Ariya;
• Kusintha kwa kugwiritsa ntchito muyezo wa C ++11 kwapangidwa (ntchito za atomiki zikukhudzidwa);
• Kuchita kwa Collation locale properties kwa Unicode kwasintha kwambiri, kukulolani kuti mutchule malamulo osankhidwa ndi njira zofananira malinga ndi tanthauzo la zilembo;
• Awonjezedwa plugin yofotokozera mitundu yanu yam'munda;
• Thandizo lowonjezera pawindo UDF ntchito (Ntchito Zofotokozedwa ndi Wogwiritsa);
• Mu "FLUSH TABLES" ntchito zakhazikitsidwa "BACKUP LOCK" mode, yomwe ingagwiritsidwe ntchito posunga mafayilo a database;
• Zowonjezedwa kuthandizira malamulo a seva kuyambira mariadb, njira zina zoyambira ndi "mysql" (mwachitsanzo, mariadump m'malo mwa mysqldump).

Source: opennet.ru