欢迎访问

  In this tutorial I'm going to cover how to install   MariaDB 10.6   on an   Ubuntu 20.04   server. Prerequisites Setup Ubuntu 20.04 Step 1 - Login to server Login to your server with root user: ssh root@10.0.0.1 Step 2 - Update your server After a successful login, we need to update our server. For this we run the following command: sudo apt-get update && sudo apt-get upgrade -y Step 3 - Install required packages Next, we will install software-properties-common. Run below command for that. sudo apt install software-properties-common -y Step 4 - Add MariaDB APT Repository Now with the below commands, we are going to add MariaDB signing key and add MariaDB APT repository. curl -LsS -O https://downloads.mariadb.com/MariaDB/mariadb_repo_setup sudo bash mariadb_repo_setup --mariadb-server-version = 10.6 You’ll get an output with contents like the ones shown below: [ info ] Checking for script prerequisites. [ info ] Repository file success...

如何在 Ubuntu 20.04 將 MariaDB 10.3 升級到 MariaDB 10.5 由於想把 Zabbix 5.0 LTS 升級到 6.0 LTS，但是 Zabbix 6.0 LTS 要求 MariaDB版本最好為 10.5，所以我們先來進行資料庫升級。 數據備份 最好在升級之前執行備份，如果在升級過程中遇到問題，您可以使用備份將 MariaDB Server 數據庫恢復到舊版本。確認升級完成沒有問題，再將備份刪除。 administrator@zabbix:~$ sudo apt-get install mariadb-backup administrator@zabbix:~$ sudo mariadb-backup --backup \ --user=mariabackup_user \ --password=mariabackup_passwd \ --target-dir=/data/backup/preupgrade_backup administrator@zabbix:~$ ll /data//backup/preupgrade_backup/ total 81528 drwxr-xr-x 5 root root 4096 Aug 10 13:57 ./ drwxr-xr-x 3 root root 4096 Aug 10 13:48 ../ -rw-r----- 1 root root 729088 Aug 10 13:57 aria_log.00000001 -rw-r----- 1 root root 52 Aug 10 13:57 aria_log_control -rw-r----- 1 root root 324 Aug 10 13:57 backup-my.cnf -rw-r----- 1 root root 16857 Aug 10 13:57 ib_buffer_pool -rw-r----- 1 root root 79691776 Aug 10 13:50 ibdata1 -rw-r----- 1 root root 2976768 Aug 10 13:57 ib_logfile0 drwx------ 2 root root ...