MySQL Primary-Replica Replication on Gentoo Linux

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH...

MySQL Primary-Replica Replication on NetBSD 10

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH my...

MySQL Primary-Replica Replication on OpenBSD 7.5

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH...

MySQL Primary-Replica Replication on RHEL 9

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH mysql...

MySQL Primary-Replica Replication on Ubuntu 24.04

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH...

Install Dev Tools, PHP, Nginx

  sudo yum install nginx php php-fpm php-common gcc glibc glibc-common gd gd-devel make net-snmp unzip -y
  sudo yum groupinstall 'Development Tools' -y

Nginx – Nagios Configuration

  cd /etc/nginx/conf.d
  sudo vi nagios.conf

Nginx - Nagios Configuration with P

Install Ajenti

apt-get update

wget http://repo.ajenti.org/debian/key -O- | apt-key add -

echo "deb http://repo.ajenti.org/ng/debian main main ubuntu" >> /etc/apt/sources.list

apt-get update

apt-get install ajenti

service ajenti restart

Install Ajenti-v

apt-get install ajenti-v ajenti...

There are two modes when you don't want Certbot to edit your configuration:

• Standalone: replaces the webserver to respond to ACME challenges
• Webroot: needs your webserver to serve challenges from a known folder.

Webroot is better because it doesn't need to replace Nginx (to bind to port...

Nginx Load Balancing on AlmaLinux 9

Round-robin (default)

upstream myapp {
    server 192.168.1.10:8080;
    server 192.168.1.11:8080;
    server 192.168.1.12:8080;
}
server {
    listen 80;
    server_name lb.example.com;
    location / { proxy_pass http://myapp; }
}

Least connections

upstr...

Nginx Load Balancing on Arch Linux

Round-robin (default)

upstream myapp {
    server 192.168.1.10:8080;
    server 192.168.1.11:8080;
    server 192.168.1.12:8080;
}
server {
    listen 80;
    server_name lb.example.com;
    location / { proxy_pass http://myapp; }
}

Least connections

upstre...

Nginx Load Balancing on Debian 12

Round-robin (default)

upstream myapp {
    server 192.168.1.10:8080;
    server 192.168.1.11:8080;
    server 192.168.1.12:8080;
}
server {
    listen 80;
    server_name lb.example.com;
    location / { proxy_pass http://myapp; }
}

Least connections

upstrea...

Nginx Load Balancing on Gentoo Linux

Round-robin (default)

upstream myapp {
    server 192.168.1.10:8080;
    server 192.168.1.11:8080;
    server 192.168.1.12:8080;
}
server {
    listen 80;
    server_name lb.example.com;
    location / { proxy_pass http://myapp; }
}

Least connections

upst...

Nginx Load Balancing on NetBSD 10

Round-robin (default)

upstream myapp {
    server 192.168.1.10:8080;
    server 192.168.1.11:8080;
    server 192.168.1.12:8080;
}
server {
    listen 80;
    server_name lb.example.com;
    location / { proxy_pass http://myapp; }
}

Least connections

upstrea...

Nginx Load Balancing on OpenBSD 7.5

Round-robin (default)

upstream myapp {
    server 192.168.1.10:8080;
    server 192.168.1.11:8080;
    server 192.168.1.12:8080;
}
server {
    listen 80;
    server_name lb.example.com;
    location / { proxy_pass http://myapp; }
}

Least connections

upstr...

Nginx Load Balancing on RHEL 9

Round-robin (default)

upstream myapp {
    server 192.168.1.10:8080;
    server 192.168.1.11:8080;
    server 192.168.1.12:8080;
}
server {
    listen 80;
    server_name lb.example.com;
    location / { proxy_pass http://myapp; }
}

Least connections

upstream m...

Nginx Load Balancing on Ubuntu 24.04

Round-robin (default)

upstream myapp {
    server 192.168.1.10:8080;
    server 192.168.1.11:8080;
    server 192.168.1.12:8080;
}
server {
    listen 80;
    server_name lb.example.com;
    location / { proxy_pass http://myapp; }
}

Least connections

upst...

Nginx Rate Limiting on AlmaLinux 9

Define zones in http block

http {
    limit_req_zone $binary_remote_addr zone=api:10m     rate=10r/s;
    limit_req_zone $binary_remote_addr zone=login:10m   rate=5r/m;
}

Apply to locations

location /api/ {
    limit_req zone=api burst=20 nodelay;
    lim...

Nginx Rate Limiting on Arch Linux

Define zones in http block

http {
    limit_req_zone $binary_remote_addr zone=api:10m     rate=10r/s;
    limit_req_zone $binary_remote_addr zone=login:10m   rate=5r/m;
}

Apply to locations

location /api/ {
    limit_req zone=api burst=20 nodelay;
    limi...

Nginx Rate Limiting on Debian 12

Define zones in http block

http {
    limit_req_zone $binary_remote_addr zone=api:10m     rate=10r/s;
    limit_req_zone $binary_remote_addr zone=login:10m   rate=5r/m;
}

Apply to locations

location /api/ {
    limit_req zone=api burst=20 nodelay;
    limit...

Nginx Rate Limiting on Gentoo Linux

Define zones in http block

http {
    limit_req_zone $binary_remote_addr zone=api:10m     rate=10r/s;
    limit_req_zone $binary_remote_addr zone=login:10m   rate=5r/m;
}

Apply to locations

location /api/ {
    limit_req zone=api burst=20 nodelay;
    li...

Nginx Rate Limiting on NetBSD 10

Define zones in http block

http {
    limit_req_zone $binary_remote_addr zone=api:10m     rate=10r/s;
    limit_req_zone $binary_remote_addr zone=login:10m   rate=5r/m;
}

Apply to locations

location /api/ {
    limit_req zone=api burst=20 nodelay;
    limit...

Nginx Rate Limiting on OpenBSD 7.5

Define zones in http block

http {
    limit_req_zone $binary_remote_addr zone=api:10m     rate=10r/s;
    limit_req_zone $binary_remote_addr zone=login:10m   rate=5r/m;
}

Apply to locations

location /api/ {
    limit_req zone=api burst=20 nodelay;
    lim...

Nginx Rate Limiting on RHEL 9

Define zones in http block

http {
    limit_req_zone $binary_remote_addr zone=api:10m     rate=10r/s;
    limit_req_zone $binary_remote_addr zone=login:10m   rate=5r/m;
}

Apply to locations

location /api/ {
    limit_req zone=api burst=20 nodelay;
    limit_re...

Nginx Rate Limiting on Ubuntu 24.04

Define zones in http block

http {
    limit_req_zone $binary_remote_addr zone=api:10m     rate=10r/s;
    limit_req_zone $binary_remote_addr zone=login:10m   rate=5r/m;
}

Apply to locations

location /api/ {
    limit_req zone=api burst=20 nodelay;
    li...