RoE | Wiki

User Tools

Site Tools

Trace: • mariadb
servers:linux:mariadb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
servers:linux:mariadb [2025/12/20 02:28] – Sean Rhoneservers:linux:mariadb [2026/10/24 05:51] (current) – Sean Rhone
Line 7: Line 7:
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[linux:distros:server:ubuntu_server|Ubuntu Server]]+  * [[linux:distros:server:arm:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]]
  
 ====== Settings ====== ====== Settings ======
Line 13: Line 13:
   * Settings being done before installation is intentional   * Settings being done before installation is intentional
  
-  sudo mkdir -p '/etc/mysql/conf.d' && sudo -e '/etc/mysql/conf.d/custom.cnf'+  sudo mkdir -p '/etc/my.cnf.d' && sudo -e '/etc/my.cnf.d/custom.cnf'
  
 <code> <code>
Line 36: Line 36:
 ====== Dependencies ====== ====== Dependencies ======
  
-**** +  sudo zypper install 'mariadb'
- +
-  sudo apt install 'mariadb-server'+
  
 ====== Initial Setup ====== ====== Initial Setup ======
- 
-**** 
  
   sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation   sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation
Line 49: Line 45:
  
 ===== One-shot ===== ===== One-shot =====
- 
-**** 
  
   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair
Line 87: Line 81:
 Type=oneshot Type=oneshot
  
-ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair+WorkingDirectory=/tmp
  
-ExecStartPost='/usr/bin/sync'+ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair
  
 # End</code> # End</code>
Line 95: Line 89:
 ==== Timer ==== ==== Timer ====
  
-  * Weekly+  * Weekly (Sunday) ''07:10:00 AM''
  
   sudo -e '/etc/systemd/system/db-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'db-m.timer' --now   sudo -e '/etc/systemd/system/db-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'db-m.timer' --now
Line 105: Line 99:
  
 [Timer] [Timer]
-OnCalendar=weekly+OnCalendar=Sun *-*-* 07:10:00
 Persistent=true Persistent=true
  
Line 118: Line 112:
  
 ===== Settings ===== ===== Settings =====
- 
-**** 
  
   sudo mariadb-admin variables | egrep 'utf8|networking|socket'   sudo mariadb-admin variables | egrep 'utf8|networking|socket'
  
 ===== Show Users on Server ===== ===== Show Users on Server =====
- 
-**** 
  
   select User,Host from mysql.user;   select User,Host from mysql.user;
Line 131: Line 121:
 ===== Socket File ===== ===== Socket File =====
  
-**** +  /run/mysql/mysql.sock
- +
-  /run/mysqld/mysqld.sock+
  
 ===== No sudo auth file ===== ===== No sudo auth file =====
/srv/www/wiki/data/attic/servers/linux/mariadb.1766215694.txt.gz · Last modified: by Sean Rhone