آموزش نصب و راه‌اندازی رپلیکیشن MariaDB در اوبونتو و دبیان

سرور اصلی

(
set -euo pipefail
sudo install -d -o root -g mysql -m 0750 /etc/mysql/tls
sudo install -o root -g mysql -m 0640 /root/academy-pki/ca.pem /etc/mysql/tls/ca.pem
sudo install -o root -g mysql -m 0640 /root/academy-pki/primary-fullchain.pem /etc/mysql/tls/server.pem
sudo install -o root -g mysql -m 0640 /root/academy-pki/primary-key.pem /etc/mysql/tls/server.key
sudo openssl x509 -in /etc/mysql/tls/server.pem -noout -subject -issuer -dates -ext subjectAltName
sudo openssl x509 -in /etc/mysql/tls/server.pem -checkend 86400 -noout
sudo openssl x509 -in /etc/mysql/tls/server.pem -pubkey -noout | openssl sha256
sudo openssl pkey -in /etc/mysql/tls/server.key -pubout | openssl sha256
sudo -u mysql test -r /etc/mysql/tls/server.key
)

سرور اصلی

sudo nano /etc/mysql/mariadb.conf.d/90-academy-replication.cnf

محتوای فایل؛ در فایل مشخص‌شده ذخیره شود، نه در پوسته.

[mariadb]
server_id=101
bind_address=10.20.0.10
log_bin=/var/lib/mariadb/primary-bin
binlog_format=ROW
gtid_domain_id=0
gtid_strict_mode=ON
log_slave_updates=ON
sync_binlog=1
innodb_flush_log_at_trx_commit=1
binlog_expire_logs_seconds=604800
read_only=OFF
ssl_ca=/etc/mysql/tls/ca.pem
ssl_cert=/etc/mysql/tls/server.pem
ssl_key=/etc/mysql/tls/server.key

سرور اصلی

(
set -euo pipefail
sudo mariadbd --verbose --help >/dev/null
sudo systemctl restart mariadb
systemctl is-active mariadb
sudo mariadb -e "SHOW VARIABLES WHERE Variable_name IN ('server_id','log_bin','binlog_format','gtid_domain_id','gtid_strict_mode','read_only','have_ssl','sync_binlog','innodb_flush_log_at_trx_commit','binlog_expire_logs_seconds');"
sudo ss -lntp 'sport = :3306'
)
sudo mariadb -e "SELECT @@datadir;"

رپلیکا

(
set -euo pipefail
sudo install -d -o root -g mysql -m 0750 /etc/mysql/tls
sudo install -o root -g mysql -m 0640 /root/academy-pki/ca.pem /etc/mysql/tls/ca.pem
sudo -u mysql test -r /etc/mysql/tls/ca.pem
getent ahostsv4 db-primary.example.internal
)

رپلیکا

sudo nano /etc/mysql/mariadb.conf.d/90-academy-replication.cnf

محتوای فایل؛ در فایل مشخص‌شده ذخیره شود، نه در پوسته.

[mariadb]
server_id=102
bind_address=127.0.0.1
log_bin=/var/lib/mariadb/replica-bin
relay_log=/var/lib/mariadb/replica-relay
binlog_format=ROW
gtid_domain_id=0
gtid_strict_mode=ON
log_slave_updates=ON
sync_binlog=1
innodb_flush_log_at_trx_commit=1
binlog_expire_logs_seconds=604800
read_only=ON