This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[mysqld] | |
# InnoDB Buffer Pool Size: 70% von 32GB | |
innodb_buffer_pool_size=22G | |
max_allowed_packet=100M | |
# Maximale Anzahl an Verbindungen | |
max_connections=500 | |
# Query Cache | |
query_cache_type=1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# /etc/security/limits.conf | |
# Apache / Nginx | |
www-data soft nofile 30000 | |
www-data hard nofile 80000 | |
# MySQL | |
mysql soft nofile 30000 | |
mysql hard nofile 80000 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RewriteEngine on | |
RewriteBase / | |
# HTTP-Auth | |
#AuthType Basic | |
#AuthName "Freigabeserver" | |
#AuthUserFile /path/to/.htpasswd | |
#Require valid-user | |
# HTTPS-Auth |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Switch to customer-folder | |
cd /$PATH/ | |
# Check the current mySQL-Config | |
cat www/htdocs/system/config/localconfig.php (e.g.) | |
# Backup MySQL | |
mysqldump --default-character-set=utf8 --routines -u dbXXXX -p dbXXXX > dbXXXX_YYMMDD_1XX.sql |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/sh | |
apt update | |
apt upgrade | |
apt install net-tools | |
apt install network-manager | |
######################## | |
# Change hostname | |
######################## |