Dies ist eine alte Version des Dokuments!
Container 'mariadb'
System
- interne IPs
- 10.2.0.100, fd00:10:2:0::100
- 10.3.0.100, fd00:10:3:0::100 (MariaDB)
Dienste
- MariaDB 10
Installation
- Standard-Template mit Benutzern
MariaDB
- MariaDB-Server installieren
- apt-get install mariadb-server
- MariaDB - Erstkonfiguration
- mysql_secure_installation
- Set root password? [Y/n]: Y
- New password: PASSWORT
- Re-enter new password: PASSWORT
- Remove anonymous users? [Y/n]: Y
- Disallow root login remotely? [Y/n]: Y
- Remove test database and access to it? [Y/n]: Y
- Reload privilege tables now? [Y/n]: Y
- Benutzerdefinierte Konfiguration anlegen
/etc/mysql/mariadb.conf.d/99-bytecluster.cnf
[mysqld] # An lokale IP binden bind-address = 10.3.0.100 # Binlog deaktivieren skip-log-bin # InnoDB verwenden default_storage_engine = InnoDB # InnoDB-Optimierungen innodb_buffer_pool_size = 256M innodb_log_buffer_size = 8M innodb_log_file_size = 128M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_file_per_table = 1
- MariaDB neustarten
- systemctl restart mariadb.service