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 [2019/10/24 13:07] – 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/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</code>+skip-networking = 'On' 
 +table_definition_cache = '1400'</code>
  
 ==== Verify ===== ==== Verify =====
Line 40: Line 46:
 **** ****
  
-  sudo apt install 'mariadb-server'+  sudo dnf install 'mariadb-server'
  
 ====== Initial Setup ====== ====== Initial Setup ======
Line 46: 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 52: 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 62: 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 78: 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 109: 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