Mgbe otu afọ nke mmepe na isii tupu mwepụta ntọhapụ kwụsiri ike nke mbụ nke ngalaba DBMS ọhụrụ , n'ime nke a na-emepụta alaka MySQL nke na-akwado ndakọrịta azụ na mwekota nke ọzọ nchekwa engines na elu ike. A ga-enye nkwado maka alaka ọhụrụ ahụ ruo afọ 5, ruo June 2024.
MariaDB Foundation nọọrọ onwe ya na-ahụ maka mmepe MariaDB, na-agbaso usoro mmepe mepere emepe na nke doro anya nke na-anọghị na ndị na-ere ahịa n'otu n'otu. A na-enye MariaDB kama MySQL n'ọtụtụ nkesa Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ma etinyere ya na nnukwu ọrụ dị ka. , и .
Igodo :
- Gụnyere teknụzụ mmegharị ọtụtụ nna ukwu gakọrịtara , nke na-enye ohere maka topology multi-master na-arụ ọrụ nke nwere ike ịgụ ma dee ya site na ọnụ ọ bụla. Site na mmegharị mmekọrịta, ọnụ niile na-enwe data ọhụrụ mgbe niile, ya bụ. Ọ dịghị azụmahịa furu efu na-ekwe nkwa, ebe ọ bụ na a na-eme azụmahịa ahụ naanị mgbe agbasasịrị data ahụ na ọnụ ụzọ niile. A na-eme mmegharị ahụ na ọnọdụ yiri ya, na ọkwa ahịrị, na-ebufe naanị ozi gbasara mgbanwe;
- Na sistemụ dị ka Unix, a na-akwado ngwa mgbakwunye nyocha site na ndabara , nke na-enye gị ohere iji akaụntụ dị na sistemụ jikọọ na DBMS site na iji oghere unix mpaghara;
- agbakwunyere na-ekenye oge ndụ maka paswọọdụ onye ọrụ, emesia akara paswọọdụ ka kubie ume. Iji tọọ ụbọchị ngwụcha okwuntughe n'ọrụ “CREATE USER” na “ALTER USER”, agbakwunyela okwu “PASSWORD EXPIRE INTERVAL N DAY”;
- nkwado agbakwunyere Ndị ọrụ DBMS site na okwu "ACCOUNT LOCK" na arụrụ ọrụ "CREATE USER" na "ALTER USER";
- A na-emewanye ngwa ngwa nyocha nke ihe ùgwù na nhazi yana ọnụ ọgụgụ buru ibu nke ndị ọrụ ma ọ bụ iwu ịnweta;
- iji mysql.user na mysql.host tables. A na-eji tebụl mysql.global_priv ugbu a iji chekwaa akaụntụ na ihe ùgwù zuru ụwa ọnụ;
- В nyocha nkwado maka okwu “SET PASSWORD”;
- ike iji ihe karịrị otu ngwa mgbakwunye nyocha maka akaụntụ ọ bụla, nke nwere ike ịba uru maka ndị ọrụ ji nwayọọ nwayọọ na-akwaga na ngwa mgbakwunye ahụ. . Mgbe ị na-emepụta mgbọrọgwụ @ localhost onye ọrụ na mysql_install_db script, a na-akwado plugins abụọ ugbu a site na ndabara - unix_socket na mysql_native_password;
- Nchekwa InnoDB na-arụ ọrụ nke ihichapụ kọlụm ozugbo (ALTER TABLE ... DROP COLUMN ... ALGORITHM= INSTANT) na-agbanwe usoro nke kọlụm. Ebelatala nha ndekọ mbụ maka ịrụ ọrụ nlọghachi (nkọgharị redo). Nkwado ntụgharị igodo agbakwunyere maka innodb_encrypt_log. Tinyere algọridim maka ịlele ndenye ego
innodb_checksum_algorithm=full_crc32. Na-enye mgbasawanye ngwa ngwa nke ụdị VARCHAR na-agbanwe ederede ederede maka ogidi ndị na-edeghị aha; - Ihe nkwalite emelitere. Agbakwunyere ike ịchọta njikarịcha, enyere site na mgbanwe sistemụ . Ọdabara na-ejigide ọnụ ọgụgụ na-adabere na engines nchekwa.
Enwere ụdị ojiji_stat_tables ọhụrụ abụọ - COMPLEMENTARY_FOR_QUERIES na PREFERABLY_FOR_QUERIES. Gbanyere ọnọdụ optimize_join_buffer_size. Ndị ọhụrụ agbakwunyere rovid_filter na condition_pushdown_site na inwe; - Nkwado maka tebụl ụdị sistemụ, nke na-abụghị naanị na-echekwa ibe data dị ugbu a, kamakwa na-echekwa ozi gbasara mgbanwe niile emere na mbụ, gbasaa. na ogologo oge;
- Agbakwunyere iwu “FLUSH SSL” ọhụrụ ka ibugharịa asambodo SSL na-enweghị ịmalitegharị ihe nkesa;
- N'ọrụ "INSTALL PLUGIN", "UnINSTALL PLUGIN" na "UnINSTALL SONAME" gbakwunyere nkwado maka okwu ndị a "Ọ BỤRỤ NA Ọ BỤGHỊ" na "Ọ BỤRỤ NA ỌDỤ";
- A na-atụ aro tebụl sistemu na-egbochi mkpọka, maka ịchekwa nke a na-eji injin ;
- Emeela mgbanwe na iji ọkọlọtọ C ++ 11 (a na-etinye aka na arụ ọrụ atomic);
- A na-emeziwanye arụmọrụ mpaghara mpaghara Collation maka Unicode, na-enye gị ohere ịkọwapụta usoro nhazi na usoro dakọtara dabere na mpụtara mkpụrụedemede;
- ngwa mgbakwunye maka ịkọwapụta ụdị ubi nke gị;
- agbakwunyere nkwado maka windo (Ọrụ akọwapụtara nke onye ọrụ);
- Na ọrụ "FLUSH TABLES". Ọnọdụ “BaCKUP LOCK”, nke enwere ike iji mgbe ị na-akwado faịlụ nchekwa data;
- nkwado maka iwu nkesa na-amalite site na mariadb, uzo ozo maka iwu malite na "mysql" (dịka ọmụmaatụ, mariadump kama mysqldump).
isi: opennet.ru