????????MariaDB 11.8解決了2038問題,即在32位系統中將timestamp從2038-01-19 03:14:07 UTC擴展到2106-02-07 06:28:15 UTC,向后延長了68年。由于寫此文時Debian 12的源中還沒有MariaDB 11.8,采用源碼編譯又太費時,可用二進制碼或dpkg安裝 .下面簡要記錄采用dpkg安裝MariaDB-11.8.2的過程.
1.下載文件mariadb-11.8.2-debian-bookworm-amd64-debs.tar
網址:https://mariadb.com/downloads/
2.解壓
將mariadb-11.8.2-debian-bookworm-amd64-debs.tar復制到/usr/local/src中并解壓.
#tar -xvf mariadb-10.6.21-ubuntu-bionic-amd64-debs.tar
3.安裝
(1)停止正在運行的mariadb服務(過程略)
請務必備份/etc/mysql/mariadb.conf.d目錄,特別是其中的50-server.cnf(主配置文件)
(2)安裝
#apt update
#apt install libdbi-perl libdbd-mysql-perl psmisc libaio1 socat
#cd /usr/local/src/mariadb-11.8.2-debian-bookworm-amd64-debs
#dpkg --install ./mariadb-common*.deb ./mysql-common*.deb ./mariadb-client*.deb ./libmariadb3*.deb ./libmysqlclient18*.deb
…
#dpkg --install ./mariadb-server*.deb ./mariadb-backup*.deb ./galera-4*.deb
4.啟動MariaDB
(1)設置datadir
將備份的文件50-server.cnf替換現有的/etc/mysql/mariadb.conf.d中的50-server.cnf.
(2)查看啟動文件
(3)啟動MariaDB
#systemctl start mysqld
#systemctl status mysqld
(4)查看MariaDB
至此,Debian 12中安裝MariaDB 11.8.2成功.