[アップデート] 新しいLTSバージョンであるAmazon Aurora MySQL 3.10がリリースされました

>  aws rds describe-db-major-engine-versions --engine aurora-mysql
{
    "DBMajorEngineVersions": [
        {
            "Engine": "aurora-mysql",
            "MajorEngineVersion": "5.7",
            "SupportedEngineLifecycles": [
                {
                    "LifecycleSupportName": "open-source-rds-standard-support",
                    "LifecycleSupportStartDate": "2018-02-06T00:00:00+00:00",
                    "LifecycleSupportEndDate": "2024-10-31T23:59:59.999000+00:00"
                },
                {
                    "LifecycleSupportName": "open-source-rds-extended-support",
                    "LifecycleSupportStartDate": "2024-11-01T00:00:00+00:00",
                    "LifecycleSupportEndDate": "2027-02-28T23:59:59.999000+00:00"
                }
            ]
        },
        {
            "Engine": "aurora-mysql",
            "MajorEngineVersion": "8.0",
            "SupportedEngineLifecycles": [
                {
                    "LifecycleSupportName": "open-source-rds-standard-support",
                    "LifecycleSupportStartDate": "2021-11-18T00:00:00+00:00",
                    "LifecycleSupportEndDate": "2028-04-30T23:59:59.999000+00:00"
                },
                {
                    "LifecycleSupportName": "open-source-rds-extended-support",
                    "LifecycleSupportStartDate": "2028-05-01T00:00:00+00:00",
                    "LifecycleSupportEndDate": "2029-07-31T23:59:59.999000+00:00"
                }
            ]
        }
    ]
}

>  aws rds describe-db-engine-versions --engine aurora-mysql --engine-version 8.0.mysql_aurora.3.10.0
{
    "DBEngineVersions": [
        {
            "Engine": "aurora-mysql",
            "EngineVersion": "8.0.mysql_aurora.3.10.0",
            "DBParameterGroupFamily": "aurora-mysql8.0",
            "DBEngineDescription": "Aurora MySQL",
            "DBEngineVersionDescription": "Aurora MySQL 3.10.0 (compatible with MySQL 8.0.42)",
            "ValidUpgradeTarget": [],
            "ExportableLogTypes": [
                "audit",
                "error",
                "general",
                "iam-db-auth-error",
                "instance",
                "slowquery"
            ],
            "SupportsLogExportsToCloudwatchLogs": true,
            "SupportsReadReplica": false,
            "SupportedEngineModes": [
                "provisioned"
            ],
            "SupportedFeatureNames": [
                "Bedrock"
            ],
            "Status": "available",
            "SupportsParallelQuery": true,
            "SupportsGlobalDatabases": true,
            "MajorEngineVersion": "8.0",
            "SupportsBabelfish": false,
            "SupportsLimitlessDatabase": false,
            "SupportsCertificateRotationWithoutRestart": true,
            "SupportedCACertificateIdentifiers": [
                "rds-ca-ecc384-g1",
                "rds-ca-rsa4096-g1",
                "rds-ca-rsa2048-g1"
            ],
            "SupportsLocalWriteForwarding": true,
            "SupportsIntegrations": true,
            "ServerlessV2FeaturesSupport": {
                "MinCapacity": 0.0,
                "MaxCapacity": 256.0
            }
        }
    ]
}

$ mysql -h database-304.cluster-cicjym7lykmq.us-east-1.rds.amazonaws.com -u admin -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 51
Server version: 8.0.28 8a6fbbbd

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

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

MySQL [(none)]> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 8.0.28    |
+-----------+
1 row in set (0.001 sec)

MySQL [(none)]> SELECT aurora_version();
+------------------+
| aurora_version() |
+------------------+
| 3.04.4           |
+------------------+
1 row in set (0.001 sec)

MySQL [non____97_db]> DROP SCHEMA IF EXISTS example;
Query OK, 0 rows affected (0.007 sec)

MySQL [non____97_db]> CREATE SCHEMA example;
Query OK, 1 row affected (0.002 sec)

MySQL [non____97_db]> USE example;
Database changed
MySQL [example]>
MySQL [example]> DROP TABLE IF EXISTS table1;
Query OK, 0 rows affected, 1 warning (0.001 sec)

MySQL [example]> CREATE TABLE table1
    -> (
    ->     id     INT AUTO_INCREMENT,
    ->     col_idx VARCHAR(28),
    ->     col_data  LONGTEXT,
    ->     PRIMARY KEY (id),
    ->     KEY `idx` (`col_idx`)
    -> ) CHARSET = utf8mb4
    ->   COLLATE = utf8mb4_general_ci;
Query OK, 0 rows affected (0.020 sec)

MySQL [example]>
MySQL [example]> DROP PROCEDURE IF EXISTS fill_data;
Query OK, 0 rows affected, 1 warning (0.000 sec)

MySQL [example]> DELIMITER //
MySQL [example]>
MySQL [example]> CREATE PROCEDURE fill_data()
    -> BEGIN
    ->     DECLARE i INT DEFAULT 0;
    ->     WHILE i < 100000
    ->         DO
    ->             INSERT INTO table1 (col_idx, col_data)
    ->             VALUES (REPEAT('a', 28),
    ->                     REPEAT('a', 5000));
    ->             SET i = i + 1;
    ->         END WHILE;
    -> END
    -> //
Query OK, 0 rows affected (0.003 sec)

MySQL [example]> DELIMITER ;
MySQL [example]> SET AUTOCOMMIT = true;
Query OK, 0 rows affected (0.000 sec)

MySQL [example]> call fill_data();
Query OK, 1 row affected (9.393 sec)

MySQL [example]> call fill_data();
Query OK, 1 row affected (9.564 sec)

MySQL [example]> call fill_data();
Query OK, 1 row affected (9.607 sec)

MySQL [example]> call fill_data();
Query OK, 1 row affected (10.555 sec)

MySQL [example]> call fill_data();
Query OK, 1 row affected (9.550 sec)

MySQL [example]> SELECT COUNT(*) FROM table1;
+----------+
| COUNT(*) |
+----------+
|   500000 |
+----------+
1 row in set (0.087 sec)

Attempt to upgrade the database instance 'database-304-instance-1' with zero downtime finished. The process took 14357 ms, 7 connections preserved, 0 connections dropped. See the database error log for details.

MySQL [example]> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 8.0.42    |
+-----------+
1 row in set (0.001 sec)

MySQL [example]> SELECT aurora_version();
+------------------+
| aurora_version() |
+------------------+
| 3.10.0           |
+------------------+
1 row in set (0.000 sec)

MySQL [example]> SELECT COUNT(*) FROM table1;
+----------+
| COUNT(*) |
+----------+
|   500000 |
+----------+
1 row in set (0.375 sec)

MySQL [example]> SELECT COUNT(*) FROM table1;
+----------+
| COUNT(*) |
+----------+
|   500000 |
+----------+
1 row in set (0.078 sec)

MySQL [example]> SELECT COUNT(*) FROM table1;
+----------+
| COUNT(*) |
+----------+
|   500000 |
+----------+
1 row in set (0.098 sec)

MySQL [example]> SELECT COUNT(*) FROM table1;
+----------+
| COUNT(*) |
+----------+
|   500000 |
+----------+
1 row in set (0.081 sec)