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
servers:mariadb [2020/04/24 10:23] – [Settings] Sean Rhoneservers:mariadb [2024/03/06 21:01] (current) – 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</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 ======
 +
 +  * Not required for [[/servers:games:trinitycore_3.3.5_localhost|TrinityCore 3.3.5 localhost]]
  
 ===== 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 70:
 ===== 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 86:
 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 117:
 **** ****
  
-  /var/run/mysqld/mysqld.sock+  /var/lib/mysql/mysql.sock 
/var/www/wiki/data/attic/servers/mariadb.1587738180.txt.gz · Last modified: 2020/04/24 10:23 by Sean Rhone