RoE | Wiki

User Tools

Site Tools

Trace:
servers: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
Last revisionBoth sides next revision
servers:mariadb [2020/07/28 21:20] – Add "table_definition_cache" for friendica Sean Rhoneservers:mariadb [2023/09/12 17:25] – [Settings] Sean Rhone
Line 3: Line 3:
   * MariaDB ((https://mariadb.org/about))   * MariaDB ((https://mariadb.org/about))
   * [[Information:Realm of Espionage]]   * [[Information:Realm of Espionage]]
 +
 +===== References =====
 +
 +  * https://mariadb.com/kb/en/configuring-mariadb-with-option-files/
 +  * https://mariadb.com/kb/en/legacy-clients-and-utilities/
  
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[distros:ubuntu_server|Ubuntu Server]]+  * [[distros:fedora_server|Fedora Server]]
  
 ====== Settings ====== ====== Settings ======
Line 12: Line 17:
   * Settings being done before installation is intentional   * Settings being done before installation is intentional
  
-  sudo -e '/etc/mysql/mariadb.conf.d/custom.cnf'+  sudo mkdir -p '/etc/my.cnf.d' && sudo -e '/etc/my.cnf.d/custom.cnf'
  
 <code> <code>
 [client] [client]
-default-character-set = utf8mb4+default-character-set = 'utf8mb4'
  
-[mysql] +[mariadb-client] 
-default-character-set = utf8mb4+default-character-set = 'utf8mb4'
  
-[mysqld] +[mariadbd] 
-character-set-client-handshake = FALSE +character-set-client-handshake = 'FALSE' 
-character-set-server = utf8mb4 +character-set-server = 'utf8mb4' 
-collation-server = utf8mb4_unicode_ci+collation-server = 'utf8mb4_unicode_ci'
 init-connect='SET NAMES utf8mb4' init-connect='SET NAMES utf8mb4'
-expire_logs_days = 7 +expire_logs_days = '7' 
-max_binlog_size = 100M +max_binlog_size = '100M' 
-skip-networking = On +skip-networking = 'On' 
-table_definition_cache = 1400</code>+table_definition_cache = '1400'</code>
  
 ==== Verify ===== ==== Verify =====
Line 41: Line 46:
 **** ****
  
-  sudo apt install 'mariadb-server'+  sudo dnf install 'mariadb-server'
  
 ====== Initial Setup ====== ====== Initial Setup ======
Line 47: Line 52:
 **** ****
  
-  sudo systemctl enable 'mariadb' --now && sudo mysql_secure_installation+  sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation
  
 ====== Database Repair and Optimization ====== ====== Database Repair and Optimization ======
Line 53: Line 58:
 ===== Create MySQL User ===== ===== Create MySQL User =====
  
-  sudo mysql+  sudo mariadb
  
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost' IDENTIFIED BY 'x';   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost' IDENTIFIED BY 'x';
Line 63: Line 68:
 ===== Authentication File ===== ===== Authentication File =====
  
-  sudo mkdir -p '/var/lib/mysql/auth' && sudo chown -R 'mysql':'mysql' '/var/lib/mysql/auth' && sudo -u 'mysql' -e '/var/lib/mysql/auth/maintenance' && sudo chmod '600' '/var/lib/mysql/auth/maintenance'+  sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/maintenance' && sudo chown -R 'mysql':'mysql' '/var/lib/mysql/auth' && sudo chmod '600' '/var/lib/mysql/auth/maintenance' && sync
  
 <code> <code>
-[mysqlcheck]+[mariadb-check]
 user=maintenance user=maintenance
 password=x</code> password=x</code>
Line 79: Line 84:
 Group=mysql Group=mysql
 Type=oneshot Type=oneshot
-ExecStart='/usr/bin/mysqlcheck' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --auto-repair --optimize --all-databases --force +ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --auto-repair --optimize --all-databases --force 
-ExecStartPost='/bin/sync'</code>+ExecStartPost='/usr/bin/sync'</code>
  
 ===== Timer ===== ===== Timer =====
Line 110: Line 115:
 **** ****
  
-  /var/run/mysqld/mysqld.sock+  /var/lib/mysql/mysql.sock 
/var/www/wiki/data/pages/servers/mariadb.txt · Last modified: 2024/03/06 21:01 by Sean Rhone