LBeckX

Einrichtung Internet

sudo nano /etc/netplan/50-cloud-init.yaml

network:
  version: 2
 ethernets:

LBeckX

[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

LBeckX

RewriteEngine on
RewriteBase /

# HTTP-Auth
#AuthType Basic
#AuthName "Freigabeserver"
#AuthUserFile /path/to/.htpasswd
#Require valid-user

# HTTPS-Auth

LBeckX

# /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

LBeckX

#!/bin/sh

apt update
apt upgrade
apt install net-tools
apt  install network-manager

########################
# Change hostname
########################

LBeckX

# 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