Leitfaden für Vorstellungsgespräche für erfahrene Systemadministratoren: Umfassende Fragen und Antworten

# VMs auflisten
virsh list --all

# VM starten
virsh start vm-name

# VM aus XML erstellen
virsh define vm-config.xml

# VM klonen
virt-clone --original vm1 --name vm2 --auto-clone

# VM-Ressourcenzuweisung
virsh setmem vm-name 4G
virsh setvcpus vm-name 4

# Cluster-Software installieren
sudo apt install pacemaker corosync pcs

# Cluster-Authentifizierung konfigurieren
sudo passwd hacluster
sudo pcs cluster auth node1 node2 -u hacluster

# Cluster erstellen
sudo pcs cluster setup --name mycluster node1 node2

# Cluster starten
sudo pcs cluster start --all
sudo pcs cluster enable --all

# STONITH für Tests deaktivieren (in der Produktion aktivieren)
sudo pcs property set stonith-enabled=false

# Virtuelle IP-Ressource erstellen
sudo pcs resource create virtual_ip ocf:heartbeat:IPaddr2 \
    ip=192.168.1.100 cidr_netmask=24 \
    op monitor interval=30s

# Webdienst-Ressource erstellen
sudo pcs resource create webserver ocf:heartbeat:apache \
    configfile=/etc/apache2/apache2.conf \
    statusurl="http://localhost/server-status" \
    op monitor interval=1min

# Ressourcen gruppieren
sudo pcs resource group add webgroup virtual_ip webserver

# Ressourcenbeschränkungen festlegen
sudo pcs constraint colocation add webserver with virtual_ip INFINITY
sudo pcs constraint order virtual_ip then webserver

# Clusterstatus überprüfen
sudo pcs status
sudo crm_mon -1

# Keepalived installieren
sudo apt install keepalived

# Auf dem Master konfigurieren
sudo vi /etc/keepalived/keepalived.conf

vrrp_instance VI_1 {
    state MASTER
    interface eth0
    virtual_router_id 51
    priority 100
    advert_int 1
    
    authentication {
        auth_type PASS
        auth_pass secret123
    }
    
    virtual_ipaddress {
        192.168.1.100/24
    }
    
    track_script {
        chk_nginx
    }
}

vrrp_script chk_nginx {
    script "/usr/bin/killall -0 nginx"
    interval 2
    weight 2
}

# Master-Konfiguration
[mysqld]
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = production

# Replikationsbenutzer erstellen
CREATE USER 'repl'@'%' IDENTIFIED BY 'password';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
FLUSH PRIVILEGES;

# Masterstatus abrufen
SHOW MASTER STATUS;

# Slave-Konfiguration
[mysqld]
server-id = 2
relay-log = /var/log/mysql/mysql-relay-bin
log_bin = /var/log/mysql/mysql-bin.log
read_only = 1

# Slave konfigurieren
CHANGE MASTER TO
    MASTER_HOST='master-ip',
    MASTER_USER='repl',
    MASTER_PASSWORD='password',
    MASTER_LOG_FILE='mysql-bin.000001',
    MASTER_LOG_POS=107;

START SLAVE;
SHOW SLAVE STATUS\G

#!/bin/bash
# Skript zur Überprüfung des Dienstzustands

check_service() {
    if systemctl is-active --quiet $1; then
        return 0
    else
        return 1
    fi
}

if ! check_service nginx; then
    echo "Nginx down, attempting restart"
    systemctl restart nginx
    sleep 5
    if ! check_service nginx; then
        echo "Nginx failed to restart, triggering failover"
        # Failover auslösen
        pcs resource move webgroup node2
    fi
fi

# Knotenausfall simulieren
sudo pcs cluster stop node1

# Failover überprüfen
sudo pcs status
ping 192.168.1.100

# Knoten wiederherstellen
sudo pcs cluster start node1

#!/bin/bash
# Automatisierte Serverzustandsprüfung

HOSTNAME=$(hostname)
DATE=$(date '+%Y-%m-%d %H:%M:%S')
REPORT="/var/log/health-check.log"

echo "=== Health Check: $DATE ===" >> $REPORT

# CPU-Last
LOAD=$(uptime | awk -F'load average:' '{print $2}')
echo "Load Average: $LOAD" >> $REPORT

# Speichernutzung
MEM=$(free -h | grep Mem | awk '{print "Used: "$3" / "$2}')
echo "Memory: $MEM" >> $REPORT

# Festplattennutzung
echo "Disk Usage:" >> $REPORT
df -h | grep -vE '^Filesystem|tmpfs|cdrom' >> $REPORT

# Fehlgeschlagene Dienste
FAILED=$(systemctl --failed --no-pager)
if [ -n "$FAILED" ]; then
    echo "Failed Services:" >> $REPORT
    echo "$FAILED" >> $REPORT
fi

# Benachrichtigung senden, wenn kritisch
DISK_USAGE=$(df -h / | tail -1 | awk '{print $5}' | sed 's/%//')
if [ $DISK_USAGE -gt 90 ]; then
    echo "CRITICAL: Disk usage above 90%" | mail -s "Alert: $HOSTNAME" [email protected]
fi

---
- name: Webserver konfigurieren
  hosts: webservers
  become: yes
  tasks:
    - name: Pakete installieren
      apt:
        name:
          - nginx
          - python3
          - git
        state: present
        update_cache: yes
    
    - name: Nginx-Konfiguration kopieren
      template:
        src: nginx.conf.j2
        dest: /etc/nginx/nginx.conf
      notify: nginx neu starten
    
    - name: Sicherstellen, dass Nginx läuft
      service:
        name: nginx
        state: started
        enabled: yes
  
  handlers:
    - name: nginx neu starten
      service:
        name: nginx
        state: restarted

# inventory/production
[webservers]
web[01:20].company.com

[databases]
db[01:05].company.com

[loadbalancers]
lb[01:02].company.com

[webservers: vars]
ansible_user=deploy
ansible_become=yes

# playbooks/site.yml
---
- name: Alle Server konfigurieren
  hosts: all
  roles:
    - common
    - security
    - monitoring

- name: Webserver konfigurieren
  hosts: webservers
  roles:
    - nginx
    - php
    - application
  
- name: Datenbanken konfigurieren
  hosts: databases
  roles:
    - mysql
    - backup

# roles/common/tasks/main.yml
---
- name: Alle Pakete aktualisieren
  apt:
    upgrade: dist
    update_cache: yes
    cache_valid_time: 3600

- name: Allgemeine Pakete installieren
  apt:
    name:
      - vim
      - htop
      - curl
      - git
    state: present

- name: NTP konfigurieren
  template:
    src: ntp.conf.j2
    dest: /etc/ntp.conf
  notify: ntp neu starten

- name: Sicherstellen, dass Dienste laufen
  service:
    name: "{{ item }}"
    state: started
    enabled: yes
  loop:
    - ntp
    - rsyslog

#!/usr/bin/env python3
# dynamic_inventory.py - AWS EC2 dynamisches Inventar

import json
import boto3

def get_inventory():
    ec2 = boto3.client('ec2')
    response = ec2.describe_instances()
    
    inventory = {
        '_meta': {'hostvars': {}},
        'all': {'hosts': []}
    }
    
    for reservation in response['Reservations']:
        for instance in reservation['Instances']:
            if instance['State']['Name'] != 'running':
                continue
            
            hostname = instance['PrivateIpAddress']
            inventory['all']['hosts'].append(hostname)
            
            # Nach Tags gruppieren
            for tag in instance.get('Tags', []):
                if tag['Key'] == 'Role':
                    role = tag['Value']
                    if role not in inventory:
                        inventory[role] = {'hosts': []}
                    inventory[role]['hosts'].append(hostname)
    
    return inventory

if __name__ == '__main__':
    print(json.dumps(get_inventory(), indent=2))

# Git-Workflow
git checkout -b feature/update-nginx-config
# Änderungen vornehmen
git add .
git commit -m "Update nginx SSL configuration"
git push origin feature/update-nginx-config
# Pull Request zur Überprüfung erstellen

# Playbook-Syntax testen
ansible-playbook --syntax-check site.yml

# Trockenlauf
ansible-playbook site.yml --check

# Zuerst auf Staging ausführen
ansible-playbook -i inventory/staging site.yml

# In der Produktion bereitstellen
ansible-playbook -i inventory/production site.yml

# Ansible Vault
ansible-vault create secrets.yml
ansible-vault encrypt vars/passwords.yml
ansible-playbook site.yml --ask-vault-pass

# Oder Passwortdatei verwenden
ansible-playbook site.yml --vault-password-file ~/.vault_pass

# Schlecht - nicht idempotent
- name: Zeile zur Datei hinzufügen
  shell: echo "config=value" >> /etc/app.conf

# Gut - idempotent
- name: Sicherstellen, dass die Konfigurationszeile vorhanden ist
  lineinfile:
    path: /etc/app.conf
    line: "config=value"
    state: present

# Gleichzeitig auf 10 Hosts ausführen
ansible-playbook -i inventory site.yml --forks 10

# Auf bestimmte Hosts beschränken
ansible-playbook site.yml --limit webservers

# Bestimmte Tags ausführen
ansible-playbook site.yml --tags "configuration,deploy"

#!/bin/bash
# Automatisierte Sicherung mit Aufbewahrung

BACKUP_SOURCE="/var/www /etc /home"
BACKUP_DEST="/mnt/backup"
REMOTE_SERVER="backup.company.com"
RETENTION_DAYS=30

# Backup erstellen
DATE=$(date +%Y%m%d)
tar -czf $BACKUP_DEST/backup-$DATE.tar.gz $BACKUP_SOURCE

# Mit Remote synchronisieren
rsync -avz --delete $BACKUP_DEST/ $REMOTE_SERVER:/backups/

# Alte Backups bereinigen
find $BACKUP_DEST -name "backup-*.tar.gz" -mtime +$RETENTION_DAYS -delete

# Backup überprüfen
tar -tzf $BACKUP_DEST/backup-$DATE.tar.gz > /dev/null
if [ $? -eq 0 ]; then
    echo "Backup verified successfully"
else
    echo "Backup verification failed!" | mail -s "Backup Alert" [email protected]
fi

# MySQL Master-Slave-Setup
# Auf dem Master:
CHANGE MASTER TO
  MASTER_HOST='master-server',
  MASTER_USER='repl_user',
  MASTER_PASSWORD='password',
  MASTER_LOG_FILE='mysql-bin.000001',
  MASTER_LOG_POS=107;

START SLAVE;
SHOW SLAVE STATUS\G

# Automatisierte Sicherheitsupdates (Ubuntu)
sudo apt install unattended-upgrades
sudo dpkg-reconfigure -plow unattended-upgrades

# /etc/ssh/sshd_config
Port 2222  # Standardport ändern
PermitRootLogin no
PasswordAuthentication no
PubkeyAuthentication yes
AllowUsers admin devops
MaxAuthTries 3
ClientAliveInterval 300
ClientAliveCountMax 2

# iptables-Regeln
iptables -P INPUT DROP
iptables -P FORWARD DROP
iptables -P OUTPUT ACCEPT

# Etablierte Verbindungen zulassen
iptables -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT

# SSH zulassen (benutzerdefinierter Port)
iptables -A INPUT -p tcp --dport 2222 -j ACCEPT

# HTTP/HTTPS zulassen
iptables -A INPUT -p tcp --dport 80 -j ACCEPT
iptables -A INPUT -p tcp --dport 443 -j ACCEPT

# Regeln speichern
iptables-save > /etc/iptables/rules.v4

# AIDE installieren
sudo apt install aide
sudo aideinit

# Auf Änderungen prüfen
sudo aide --check

# auditd aktivieren
sudo systemctl enable auditd
sudo systemctl start auditd

# Dateizugriff überwachen
sudo auditctl -w /etc/passwd -p wa -k passwd_changes
sudo auditctl -w /etc/shadow -p wa -k shadow_changes

# CPU
mpstat 1 10

# Speicher
vmstat 1 10

# Festplatten-I/O
iostat -x 1 10

# Netzwerk
iftop
nethogs

# Nginx-Tuning
worker_processes auto;
worker_connections 4096;
keepalive_timeout 65;
gzip on;
gzip_types text/plain text/css application/json;

# MySQL-Tuning
innodb_buffer_pool_size = 4G
max_connections = 200
query_cache_size = 64M

# /etc/sysctl.conf
net.core.somaxconn = 4096
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.tcp_fin_timeout = 30
vm.swappiness = 10
fs.file-max = 100000

# Prometheus + Grafana
# Node Exporter für Systemmetriken
# Benutzerdefinierte Warnungen für Schwellenwerte

# prometheus.yml
global:
  scrape_interval: 15s
  evaluation_interval: 15s

scrape_configs:
  - job_name: 'node'
    static_configs:
      - targets:
        - 'server1:9100'
        - 'server2:9100'
        - 'server3:9100'
  
  - job_name: 'mysql'
    static_configs:
      - targets: ['db1:9104']
  
  - job_name: 'nginx'
    static_configs:
      - targets: ['web1:9113']

alerting:
  alertmanagers:
    - static_configs:
      - targets: ['localhost:9093']

rule_files:
  - 'alerts/*.yml'

# alerts/system.yml
groups:
  - name: system_alerts
    interval: 30s
    rules:
      - alert: HighCPUUsage
        expr: 100 - (avg by(instance) (irate(node_cpu_seconds_total{mode="idle"}[5m])) * 100) > 80
        for: 5m
        labels:
          severity: warning
        annotations:
          summary: "Hohe CPU-Auslastung auf {{ $labels.instance }}"
          description: "Die CPU-Auslastung beträgt {{ $value }}%"
      
      - alert: HighMemoryUsage
        expr: (node_memory_MemTotal_bytes - node_memory_MemAvailable_bytes) / node_memory_MemTotal_bytes * 100 > 90
        for: 5m
        labels:
          severity: critical
        annotations:
          summary: "Hohe Speichernutzung auf {{ $labels.instance }}"
          description: "Die Speichernutzung beträgt {{ $value }}%"
      
      - alert: DiskSpaceLow
        expr: (node_filesystem_avail_bytes{mountpoint="/"} / node_filesystem_size_bytes{mountpoint="/"}) * 100 < 10
        for: 5m
        labels:
          severity: critical
        annotations:
          summary: "Wenig Festplattenspeicher auf {{ $labels.instance }}"
          description: "Nur noch {{ $value }}% Festplattenspeicher verfügbar"
      
      - alert: ServiceDown
        expr: up == 0
        for: 2m
        labels:
          severity: critical
        annotations:
          summary: "Dienst {{ $labels.job }} ausgefallen"
          description: "{{ $labels.instance }} ist seit mehr als 2 Minuten ausgefallen"

# alertmanager.yml
global:
  resolve_timeout: 5m
  slack_api_url: 'https://hooks.slack.com/services/YOUR/WEBHOOK/URL'

route:
  group_by: ['alertname', 'cluster']
  group_wait: 10s
  group_interval: 10s
  repeat_interval: 12h
  receiver: 'default'
  routes:
    - match:
        severity: critical
      receiver: 'pagerduty'
      continue: true
    - match:
        severity: warning
      receiver: 'slack'

receivers:
  - name: 'default'
    email_configs:
      - to: '[email protected]'
        from: '[email protected]'
        smarthost: 'smtp.company.com:587'
  
  - name: 'slack'
    slack_configs:
      - channel: '#alerts'
        title: '{{ .GroupLabels.alertname }}'
        text: '{{ range .Alerts }}{{ .Annotations.description }}{{ end }}'
  
  - name: 'pagerduty'
    pagerduty_configs:
      - service_key: 'YOUR_PAGERDUTY_KEY'

inhibit_rules:
  - source_match:
      severity: 'critical'
    target_match:
      severity: 'warning'
    equal: ['alertname', 'instance']

{
  "dashboard": {
    "title": "System Overview",
    "panels": [
      {
        "title": "CPU Usage",
        "targets": [
          {
            "expr": "100 - (avg by(instance) (irate(node_cpu_seconds_total{mode=\"idle\"}[5m])) * 100)"
          }
        ]
      },
      {
        "title": "Memory Usage",
        "targets": [
          {
            "expr": "(node_memory_MemTotal_bytes - node_memory_MemAvailable_bytes) / node_memory_MemTotal_bytes * 100"
          }
        ]
      }
    ]
  }
}

# SLO-Beispiel
- alert: SLOViolation
  expr: |
    (
      sum(rate(http_requests_total{status=~"2.."}[30d]))
      /
      sum(rate(http_requests_total[30d]))
    ) < 0.999
  labels:
    severity: critical
  annotations:
    summary: "SLO-Verletzung: Erfolgsrate unter 99,9 %"

# GPO erstellen
New-GPO -Name "Security Policy" -Comment "Enterprise security settings"

# Mit OU verknüpfen
New-GPLink -Name "Security Policy" -Target "OU=Servers,DC=company,DC=com"

# Kennwortrichtlinie konfigurieren
Set-ADDefaultDomainPasswordPolicy -Identity company.com `
    -MinPasswordLength 12 `
    -PasswordHistoryCount 24 `
    -MaxPasswordAge 90.00:00:00

# Software über GPO bereitstellen
# Computerkonfiguration > Richtlinien > Softwareeinstellungen > Softwareinstallation

# WSUS konfigurieren
Set-ItemProperty -Path "HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate" `
    -Name "WUServer" -Value "http://wsus.company.com:8530"

# Update-Prüfung erzwingen
wuauclt /detectnow /updatenow

# Remoting aktivieren
Enable-PSRemoting -Force

# Auf mehreren Servern ausführen
Invoke-Command -ComputerName server1,server2,server3 -ScriptBlock {
    Get-Service | Where-Object {$_.Status -eq "Stopped"}
}

# Parallele Ausführung
$servers = Get-Content servers.txt
$servers | ForEach-Object -Parallel {
    Test-Connection -ComputerName $_ -Count 1
} -ThrottleLimit 10