Stable production of DBMS Mariadb 10.10

Altus Intel
Altus Intel
  • Date Time

published The first stable release of the new DBMS branch mariadb 10.10 (10.10.2), in which a branch from MySQL develops that retains reverse compatibility and is characterized by the integration of additional storage and advanced capabilities. The development of Mariadb is supervised by the independent organization of Mariadb Foundation in accordance with the open and transparent development process, independent of individual manufacturers. Mariadb is supplied instead of MySQL in many distributions of Linux (Rhel, Suse, Fedora, Opensuse, Slackware, OpenMandriva, Rosa, Arch Linux, Debian) and implemented in large projects as Wikipedia, Google Cloud SQL and NIMBUZ. href=”https://mariadb.com/en/changes-improvements-in-mariadb-1010/”> improvements in Mariadb 10.10:

  • Added the function random_bytes to obtain a casual bytes of a given size.
  • Added type of data inet4 for storing IPV4 addresses in a 4-byte performance.
  • changed The default parameters “Change Master to”, which now uses the replication mode based on GTID ( Global Transaction ID) if the Master server supports this type of identifier. The outdated setting “Master_use_gtid = Current_POS” is announced instead of which the option “Master_Demote_to_SLAVE” should be used.
  • expanded optimizing the confluence with a large number of tables, including the possibility of using “eq_ref” to merge tables in any order .
  • implemented UCA algorithms (Unicode Collation Algoritm), defined in the UNICODE 14 specification and used to determine the rules of sorting and Comparisons taking into account the meaning of symbols (for example, when sorting digital values, the presence of a minus and points before the number and different types of spelling are taken into account, and when compared, the symbol register and the presence of a sign of stress are not taken into account). Increased performance of UCA operations in the Functions UTF8MB3 and UTF8MB4.
  • implemented the ability to add IP addresses to the list of galera cluster nodes, which are allowed to comply with SST/IST.
  • by default activated mode “ Explicit_defaults_for_Timestamp ” to bring behavior to MySQL (when performing “Show Create Table” does not show the contents of the DEFAULT blocks for the type).
  • In the default command line, enabled option –ssl (the installation of connections with TLS-shifts is enabled ).
  • redistribution Processing of the Update and Delete of the upper level.
  • The functions of Des_encrypt and Des_decrypt are outdated, as well as the variable innodb_prefix_index_cluster_optimization.
/Media reports.

© 2024 - Altus Intel