##
MariaDB 11.8 LTS版本来了
1、概述
MariaDB 11.8 will be a long-term release, and is currently in development.
This list includes all features since the previous long-term release, MariaDB 11.4 (those introduced in the MariaDB 11.5, MariaDB 11.6 and MariaDB 11.7 rolling releases).
又是一个LTS版本!
2、新特性
1.Vectors–现在不提Vectors的数据库都跟不上了。???客户多吗???
2.Character Sets。—终于从latin1改到utf8mb4了。
3.优化器。–ICP支持分区表了
4.临时表和参数限制
5.数据类型。–把TIMESTAMP最大值从 ‘2038-01-19 03:14:07 UTC’改成’2106-02-07 06:28:15 UTC’.了,之前有人还担心这个事,现在看来完全不用DBA瞎操心。
6.AHI,不懂为啥还在修复。禁用就好了
7.备份恢复mariadb-dump和mariadb-import,下一期可以详细讲讲
8.UUID。v4和v7。
9.GIS相关的现在兼容mysql 8.为啥server还不兼容mysql 8呢?
10.其他参考
https://mariadb.com/kb/en/changes-improvements-in-mariadb-11-8/
3、小测试
[root@mydb ~]# cat /etc/redhat-release && mariadb --version
Rocky Linux release 9.4 (Blue Onyx)
mariadb from 11.8.1-MariaDB, client 15.2 for linux-systemd (x86_64) using readline 5.1