DRサイトを作って耐障害性を高めたい

 [root@east01 ~]# dnf -y update
  
// Apache httpdのinstall
[root@east01 ~]# dnf -y install httpd
[root@east01 ~]# httpd -v
Server version: Apache/2.4.62 (Rocky Linux)
Server built:   Jan 10 2025 00:00:00
[root@east01 ~]#  systemctl start httpd
[root@east01 ~]# systemctl enable httpd
[root@east01 ~]# systemctl status httpd
[root@east01 ~]#  firewall-cmd --add-service=http --permanent
[root@east01 ~]# firewall-cmd --reload
// phpのinstall
[root@east01 ~]# dnf -y install epel-release
[root@east01 ~]# dnf -y install https://rpms.remirepo.net/enterprise/remi-release-9.rpm
[root@east01 ~]# dnf module reset php
[root@east01 ~]# dnf -y module enable php:remi-8.3
[root@east01 ~]# dnf -y install php php-devel php-mysqlnd php-pdo php-gd php-mbstring
[root@east01 ~]# php -v
[root@east01 ~]# systemctl restart httpd
[root@east01 ~]# vi /etc/yum.repos.d/mariadb.repo
~~~
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.11/rhel9-amd64
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enable=1
~~~
  
// レポジトリ追加の確認
[root@east01 ~]# dnf list MariaDB*
// MariaDBのinstall
[root@east01 ~]# dnf -y install MariaDB-server MariaDB-client MariaDB-devel --enablerepo=mariadb
[root@east01 ~]# dnf list installed | grep mariadb
[root@east01 ~]# systemctl start mariadb
[root@east01 ~]# systemctl enable mariadb
[root@east01 ~]# systemctl status mariadb
//SELinuxの設定変更
[root@east01 ~]# vi /etc/selinux/config
~~~
SELINUX=permissive
~~~
 
// レポジトリファイルの作成
// MariaDB公式サイト※に用意されているOS毎のレポジトリファイルを利用します。
// distribution:Rocky Linux9.4、MariDB Server version:10.11を選択時の設定例を示します。
// レポジトリを有効にするため、最後の行に「enable=1」を追加します。
 
 
● mariadb.service - MariaDB 10.6.4 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           mqmigrated-from-my.cnf-settings.conf
   Active: active (running) since 金 2021-10-29 18:37:13 JST; 15s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 57951 (mariadbd)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mariadb.service
           mq57951 /usr/sbin/mariadbd
10月 29 18:37:13 east01 mariadbd[57951]: 2021-10-29 18:37:13 0 [Note] InnoD....
10月 29 18:37:13 east01 mariadbd[57951]: 2021-10-29 18:37:13 0 [Note] InnoD...4
10月 29 18:37:13 east01 mariadbd[57951]: 2021-10-29 18:37:13 0 [Note] Plugi....
10月 29 18:37:13 east01 mariadbd[57951]: 2021-10-29 18:37:13 0 [Note] InnoD...l
10月 29 18:37:13 east01 mariadbd[57951]: 2021-10-29 18:37:13 0 [Note] Serve....
10月 29 18:37:13 east01 mariadbd[57951]: 2021-10-29 18:37:13 0 [Note] Serve....
10月 29 18:37:13 east01 mariadbd[57951]: 2021-10-29 18:37:13 0 [Note] /usr/....
10月 29 18:37:13 east01 mariadbd[57951]: Version: '10.6.4-MariaDB' socket:...r
10月 29 18:37:13 east01 systemd[1]: Started MariaDB 10.6.4 database server.
10月 29 18:37:13 east01 mariadbd[57951]: 2021-10-29 18:37:13 0 [Note] InnoD...3
Hint: Some lines were ellipsized, use -l to show in full. 

// mariadb-secure-installationを実行。詳細は下記URLをご参照ください。
// https://mariadb.com/kb/en/mariadb-secure-installation/
[root@east01 ~]# mariadb-secure-installation
 
// 文字化け対応
[root@east01 ~]# cp -p /etc/my.cnf.d/server.cnf /etc/my.cnf.d/server.cnf.org
[root@east01 ~]# vi /etc/my.cnf.d/server.cnf
// 以下のように「character-set-server=utf8」を追加します。
~~~
# this is read by the standalone daemon and embedded servers
[server]
character-set-server=utf8
~~~
// 設定を反映するため、MariaDBを再起動
[root@east01 ~]# systemctl restart mariadb

[root@east01 ~]# cd /var/www/html
[root@east01 html]# wget https://ja.wordpress.org/latest-ja.tar.gz
[root@east01 html]# tar xvf latest-ja.tar.gz
[root@east01 html]# rm latest-ja.tar.gz
[root@east01 html]# chown -R apache:apache .

[root@east01 ~]# mysql -u root -p
MariaDB [(none)]> CREATE DATABASE wpdb;
MariaDB [(none)]> GRANT ALL PRIVILEGES ON wpdb.* TO wpuser@localhost IDENTIFIED BY 'password';   

[root@east01 ~]# cp -p /etc/my.cnf.d/server.cnf /etc/my.cnf.d/server.cnf.org
[root@east01 ~]# vi /etc/my.cnf.d/server.cnf 
// [mysqld]以下に設定を追加
~~~
[mysqld]
log-bin=mysql-bin
server-id=1
expire_logs_days=5
~~~
// 設定を反映するため、MariaDBを再起動
[root@east01 ~]# systemctl restart mariadb

[root@east01 ~]# mysql -u root -p
MariaDB [(none)]> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'IPアドレス名「west01」のIPアドレス' IDENTIFIED BY 'password';

[root@east01 ~]# mysql -u root -p
// 書き込みをおこなわないように、DBをロック
MariaDB [(none)]> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.000 sec)
 
// Masterポジションを確認。File, Positionの出力をメモ。
MariaDB [(none)]> SHOW MASTER STATUS;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 |      532 |              |                  |
+------------------+----------+--------------+------------------+
1 row in set (0.000 sec)

[root@east01 ~]# mysqldump -u root -p --all-databases --lock-all-tables > /var/tmp/dbdump.db

[root@east01 ~]# mysql -u root -p
MariaDB [(none)]> UNLOCK TABLES;

[root@west01 ~]# ssh-keygen

[root@west01 ~]# scp root@アドレス名「east01」のIPアドレス:/var/tmp/dbdump.db /var/tmp/

[root@west01 ~]# cp -p /etc/my.cnf.d/server.cnf /etc/my.cnf.d/server.cnf.org
[root@west01 ~]# vi /etc/my.cnf.d/server.cnf 
// [mysqld]以下に設定を追加
~~~
[mysqld]
log-bin=mysql-bin
server-id=2
read_only=1
~~~
// 設定を反映するため、MariaDBを再起動
[root@west01 ~]# systemctl restart mariadb

[root@west01 ~]# mysql -u root -p < /var/tmp/dbdump.db

[root@west01 ~]# mysql -u root -p
MariaDB [(none)]> CHANGE MASTER TO \
    -> MASTER_HOST='アドレス名「east01」のIPアドレス', \
    -> MASTER_USER='repl', \
    -> MASTER_PASSWORD='password', \
    -> MASTER_LOG_FILE='mysql-bin.000001', \
    -> MASTER_LOG_POS=532;
MariaDB [(none)]> START SLAVE;

[root@west01 ~]# mysql -u root -p
MariaDB [(none)]> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
                Slave_IO_State: Waiting for master to send event
                   Master_Host: <ipアドレス名「east01」のipアドレス>
                   Master_User: repl
                   Master_Port: 3306
                 Connect_Retry: 60
               Master_Log_File: mysql-bin.000001
           Read_Master_Log_Pos: 532
                Relay_Log_File: west01-relay-bin.000002
                 Relay_Log_Pos: 555
         Relay_Master_Log_File: mysql-bin.000001
              Slave_IO_Running: Yes
             Slave_SQL_Running: Yes
               Replicate_Do_DB:
           Replicate_Ignore_DB:
            Replicate_Do_Table:
        Replicate_Ignore_Table:
       Replicate_Wild_Do_Table:
   Replicate_Wild_Ignore_Table:
                    Last_Errno: 0
                    Last_Error:
                  Skip_Counter: 0
           Exec_Master_Log_Pos: 532
               Relay_Log_Space: 865
               Until_Condition: None
                Until_Log_File:
                 Until_Log_Pos: 0
            Master_SSL_Allowed: No
            Master_SSL_CA_File:
            Master_SSL_CA_Path:
               Master_SSL_Cert:
             Master_SSL_Cipher:
                Master_SSL_Key:
         Seconds_Behind_Master: 0
 Master_SSL_Verify_Server_Cert: No
                 Last_IO_Errno: 0
                 Last_IO_Error:
                Last_SQL_Errno: 0
                Last_SQL_Error:
   Replicate_Ignore_Server_Ids:
              Master_Server_Id: 1
                Master_SSL_Crl:
            Master_SSL_Crlpath:
                    Using_Gtid: No
                   Gtid_IO_Pos:
       Replicate_Do_Domain_Ids:
   Replicate_Ignore_Domain_Ids:
                 Parallel_Mode: optimistic
                     SQL_Delay: 0
           SQL_Remaining_Delay: NULL
       Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
              Slave_DDL_Groups: 0
Slave_Non_Transactional_Groups: 0
    Slave_Transactional_Groups: 0
1 row in set (0.001 sec)
                            </ipアドレス名「east01」のipアドレス>

[root@east01 ~]# systemctl stop httpd