WordPress環境デプロイ完了！DNS設定からSSL証明書プロビジョニングまで【トラブル解決編】

1for domain in ai-jisso.tech infra-career.tech cloud-migration.tech; do
2  dig +short $domain A
3done

1gcloud compute instances get-serial-port-output prod-web-7511 \
2  --zone asia-northeast1-a | tail -50

 1# ❌ 修正前
 2apt-get install -y \
 3  ...
 4  mysql-client \
 5  nfs-common \
 6
 7# ✅ 修正後
 8apt-get install -y \
 9  ...
10  default-mysql-client \
11  nfs-common \

1cd terraform/environments/prod
2terraform apply -auto-approve

1gcloud compute instance-groups managed stop-autoscaling prod-web-mig \
2  --region=asia-northeast1

1terraform apply -auto-approve
2
3# 成功！
4Apply complete! Resources: 1 added, 2 changed, 1 destroyed.

1gcloud compute instances list --filter="labels.service=wordpress"
2
3# 結果
4prod-web-65vr  asia-northeast1-a  RUNNING  (NEW)
5prod-web-jfxp  asia-northeast1-b  RUNNING  (NEW)
6prod-web-7511  asia-northeast1-a  RUNNING  (OLD)
7prod-web-3t70  asia-northeast1-b  RUNNING  (OLD)

1gcloud compute instances get-serial-port-output prod-web-65vr \
2  --zone asia-northeast1-a | tail -100

1# ❌ 旧Cloud Logging Agent
2curl -sSO https://dl.google.com/cloudagents/add-logging-agent-repo.sh
3bash add-logging-agent-repo.sh --also-install
4
5# ✅ Ops Agent（Logging + Monitoring統合）
6curl -sSO https://dl.google.com/cloudagents/add-google-cloud-ops-agent-repo.sh
7bash add-google-cloud-ops-agent-repo.sh --also-install

1terraform apply -auto-approve

1gcloud compute instance-groups managed stop-autoscaling prod-web-mig \
2  --region=asia-northeast1
3
4terraform apply -auto-approve
5
6# 成功！
7Apply complete! Resources: 1 added, 2 changed, 1 destroyed.

1gcloud compute instances list --filter="labels.service=wordpress"
2
3NAME           ZONE               STATUS   CREATION_TIMESTAMP
4prod-web-tng4  asia-northeast1-c  RUNNING  2025-11-16T05:34:24
5prod-web-pd9s  asia-northeast1-a  RUNNING  2025-11-16T05:36:45

1gcloud compute instances get-serial-port-output prod-web-pd9s \
2  --zone asia-northeast1-a | tail -50

1gcloud compute instance-groups managed set-autoscaling prod-web-mig \
2  --region=asia-northeast1 \
3  --mode=on \
4  --min-num-replicas=2 \
5  --max-num-replicas=4 \
6  --target-cpu-utilization=0.7 \
7  --cool-down-period=60

1status: ACTIVE
2mode: ON
3recommendedSize: 2
4minNumReplicas: 2
5maxNumReplicas: 4
6cpuUtilization:
7  utilizationTarget: 0.7

1gcloud compute ssl-certificates describe prod-wordpress-ssl --global

1gcloud compute ssl-certificates describe prod-wordpress-ssl --global \
2  --format="yaml" | grep -A 15 "domainStatus:"

 1domainStatus:
 2  ai-jisso.tech: ACTIVE                ✅
 3  cloud-migration.tech: ACTIVE         ✅
 4  engineer-money.tech: ACTIVE          ✅
 5  infra-career.tech: ACTIVE            ✅
 6  learn-code.tech: ACTIVE              ✅
 7  monitoring-tools.tech: ACTIVE        ✅
 8  remote-dev.tech: ACTIVE              ✅
 9  self-hosting.tech: ACTIVE            ✅
10  tech-books.tech: ACTIVE              ✅
11  travel-hack.tech: ACTIVE             ✅

1for domain in ai-jisso.tech infra-career.tech cloud-migration.tech; do
2  echo "=== Testing HTTPS: $domain ==="
3  curl -I https://$domain/health
4done

1curl -I -k https://34.50.146.93/health

1curl -sSO https://dl.google.com/cloudagents/add-google-cloud-ops-agent-repo.sh
2bash add-google-cloud-ops-agent-repo.sh --also-install

1# Terraformで自動管理
2lifecycle {
3  create_before_destroy = true
4}

1curl -I https://example.com
2# HTTP/2 200 ← HTTP/2で応答していることを確認

1gcloud compute instances get-serial-port-output <INSTANCE_NAME> \
2  --zone <ZONE> | tail -100

1# エラー検索
2| grep -i error
3
4# 特定のキーワード前後
5| grep -A 5 -B 5 "startup-script"
6
7# 最新ログのみ
8| tail -100

1# リソース一覧
2terraform state list
3
4# 特定リソース詳細
5terraform state show <RESOURCE>
6
7# State更新
8terraform refresh

1# SSL証明書
2gcloud compute ssl-certificates list
3
4# MIG状態
5gcloud compute instance-groups managed describe <MIG_NAME> --region <REGION>
6
7# Autoscaler
8gcloud compute instance-groups managed describe <MIG_NAME> \
9  --region <REGION> --format="yaml" | grep -A 10 autoscaler

1git commit -m "fix: terraform apply成功のための修正
2
3- Cloud SQL innodb_buffer_pool_sizeを4224MBに調整
4- Filestoreネットワーク設定修正
5- 起動スクリプトTerraform変数エスケープ
6- IAM Secret Manager権限調整
7- Instance Template Service Account Scope修正
8- Monitoring Log Sink Phase 2延期"

 1git commit -m "fix: 起動スクリプトのパッケージエラーを修正
 2
 3## 修正内容
 4
 51. MySQL Clientパッケージ名修正
 6   - mysql-client → default-mysql-client
 7   
 82. Logging Agent を Ops Agent に更新
 9   - 旧Cloud Logging Agent → Google Cloud Ops Agent
10   - Ops AgentはLogging + Monitoring統合
11
12## 検証結果
13
14✅ 新VM 2台で起動スクリプト正常完了
15✅ Health Check正常応答
16
17## デプロイ状況
18
19- VM: 2台稼働中
20- Load Balancer IP: 34.50.146.93
21- SSL証明書: 全10ドメインACTIVE
22- DNS: 全10ドメイン設定完了"

1# VMにSSH接続
2gcloud compute ssh prod-web-pd9s --zone=asia-northeast1-a
3
4# WordPressセットアップ（サイト1）
5sudo /usr/local/bin/setup-wordpress-site.sh 1 ai-jisso.tech "AI実装ブログ"
6
7# 管理者パスワード取得
8gcloud secrets versions access latest \
9  --secret=prod-wordpress-admin-password-1