ブルー/グリーンデプロイを使用してシングルAZ構成のRDS for MariaDBをアップグレードする

$ aws rds describe-db-engine-versions \
  --engine mariadb \
  --engine-version 10.4.32 \
  --query "DBEngineVersions[*].ValidUpgradeTarget[*].{EngineVersion:EngineVersion}" --output text | grep 10.11
10.11.4
10.11.5
10.11.6
10.11.7
10.11.8
10.11.9
10.11.10

CREATE DATABASE IF NOT EXISTS test_db;
USE test_db

CREATE TABLE IF NOT EXISTS users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
email VARCHAR(100) NOT NULL UNIQUE,
password_hash VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS posts (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
title VARCHAR(255) NOT NULL,
content TEXT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

INSERT INTO users (username, email, password_hash) VALUES ('naonishi', 'naonishi@example.com', 'hashedpassword1');
INSERT INTO posts (user_id, title, content) VALUES (1, 'naonishiの投稿', 'テスト');
SELECT * FROM posts;

[root@ip-172-30-30-101 ~]# mysql -u admin -p -h naonishi-dev-rds-mariadb.cxqwk26gardn.ap-northeast-1.rds.amazonaws.com
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 14
Server version: 10.4.32-MariaDB-log Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

（略）
MariaDB [test_db]> INSERT INTO posts (user_id, title, content) VALUES (1, 'naonishiの投稿', 'B/G環境作成中。');
Query OK, 1 row affected (0.007 sec)

MariaDB [test_db]> select * from posts;
+----+---------+----------------------------+----------------------------------------------------+---------------------+
| id | user_id | title                      | content                                            | created_at          |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
|  1 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:06:55 |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
1 rows in set (0.000 sec)

MariaDB [test_db]> INSERT INTO posts (user_id, title, content) VALUES (1, 'naonishiの投稿', 'B/G環境作成中。');
Query OK, 1 row affected (0.006 sec)

MariaDB [test_db]> select * from posts;
+----+---------+----------------------------+----------------------------------------------------+---------------------+
| id | user_id | title                      | content                                            | created_at          |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
|  1 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:06:55 |
|  2 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:19:26 |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
2 rows in set (0.001 sec)

MariaDB [test_db]> INSERT INTO posts (user_id, title, content) VALUES (1, 'naonishiの投稿', 'B/G環境作成中。');
Query OK, 1 row affected (0.007 sec)

MariaDB [test_db]> select * from posts;
+----+---------+----------------------------+----------------------------------------------------+---------------------+
| id | user_id | title                      | content                                            | created_at          |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
|  1 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:06:55 |
|  2 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:19:26 |
|  3 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:28:19 |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
3 rows in set (0.000 sec)

MariaDB [test_db]> INSERT INTO posts (user_id, title, content) VALUES (1, 'naonishiの投稿', 'B/G環境作成完了。');
Query OK, 1 row affected (0.007 sec)

MariaDB [test_db]> select * from posts;
+----+---------+----------------------------+----------------------------------------------------+---------------------+
| id | user_id | title                      | content                                            | created_at          |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
|  1 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:06:55 |
|  2 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:19:26 |
|  3 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:28:19 |
|  4 |       1 | naonishiの投稿             | B/G環境作成完了。                                  | 2025-01-14 11:44:24 |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
4 rows in set (0.000 sec)

MariaDB [test_db]> 

[root@ip-172-30-30-101 ~]# mysql -u admin -p -h naonishi-dev-rds-mariadb-green-qyhnos.cxqwk26gardn.ap-northeast-1.rds.amazonaws.com
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 72
Server version: 10.4.34-MariaDB-log Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use test_db;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [test_db]> select * from posts;
+----+---------+----------------------------+----------------------------------------------------+---------------------+
| id | user_id | title                      | content                                            | created_at          |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
|  1 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:06:55 |
|  2 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:19:26 |
|  3 |       1 | naonishiの投稿             | B/G環境作成中。                                    | 2025-01-14 11:28:19 |
|  4 |       1 | naonishiの投稿             | B/G環境作成完了。                                  | 2025-01-14 11:44:24 |
+----+---------+----------------------------+----------------------------------------------------+---------------------+
4 rows in set (0.000 sec)

MariaDB [test_db]> 

[root@ip-172-30-30-101 ~]# mysql -u admin -p -h naonishi-dev-rds-mariadb-old1.cxqwk26gardn.ap-northeast-1.rds.amazonaws.com
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 451
Server version: 10.4.32-MariaDB-log Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SHOW VARIABLES LIKE 'read_only';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| read_only     | ON    |
+---------------+-------+
1 row in set (0.001 sec)

MariaDB [(none)]>