Buat Container dengan template Debian 12
- Install apache2
- Install php
- Install mariadb-server
- Install HAProxy
Konfigurasi Apache untuk mengijinkan htaccess
nano /etc/apache2/apache2.conf
Ubah AllowOverride None menjadi AllowOverride All:
<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
</Directory>
Restart Apache
systemctl restart apache2
Pengaturan database mariadb
Import database
mysql -u root -p -e "CREATE DATABASE nama_database;"
mysql -u root -p nama_database < backup.sql
Membuat user baru
mysql -u root -p
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
Membuat hak akses
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
buat user agar bisa akses dari jaringan:
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Mengijinkan mysql diakses dari server lain
nano /etc/mysql/mariadb.conf.d/50-server.cnf
Ubah bind-address = 127.0.0.1 menjadi bind-address = 0.0.0.0
Restart mariadb
systemctl restart mariadb
Buka port untuk mariadb
sudo ufw allow 3306/tcp
sudo systemctl restart mariadb
Pengaturan HAProxy untuk load balancer
1. Install HAProxy
apt install haproxy -y
2. Edit Konfigurasi di /etc/haproxy/haproxy.cfg
nano /etc/haproxy/haproxy.cfg
3. Tambahkan konfigurasi
frontend http_front
bind *:80
default_backend web_servers
backend web_servers
balance roundrobin
server web1 192.168.10.11:80 check
server web2 192.168.10.12:80 check
server web3 192.168.10.13:80 check
4. Restart haproxy
systemctl restart haproxy
systemctl enable haproxy
Tags:
Debian