Amazon RDSリザーブドインスタンスで「1年/3年」「前払いなし/一部前払い/全前払い」すべての組み合わせが対応しているわけではない

{
    "ReservedDBInstancesOfferings": [
        {
            "CurrencyCode": "USD",
            "UsagePrice": 0.0,
            "ProductDescription": "oracle-se2(li)",
            "ReservedDBInstancesOfferingId": "005bdee3-9ef4-4182-aa0c-58ef7cb6c2f8",
            "MultiAZ": true,
            "DBInstanceClass": "db.m4.xlarge",
            "OfferingType": "Partial Upfront",
            "RecurringCharges": [
                {
                    "RecurringChargeAmount": 0.594,
                    "RecurringChargeFrequency": "Hourly"
                }
            ],
            "FixedPrice": 4089.0,
            "Duration": 31536000
        },
    ...some output truncated...
}

REGION=ap-northeast-1
ENGINE=mysql

% aws rds describe-reserved-db-instances-offerings \
  --region ap-northeast-1 \
  --output json \
| jq -r '[.ReservedDBInstancesOfferings[].ProductDescription] | unique[]'

aurora-mysql
aurora-postgresql
custom-sqlserver-ee(byol)
custom-sqlserver-ee(li)
custom-sqlserver-se(byol)
custom-sqlserver-se(li)
custom-sqlserver-web(li)
db2-ae(byol)
db2-ae(mpl)
db2-se(byol)
db2-se(mpl)
mariadb
mysql
oracle-ee(byol)
oracle-se2 (byol)
oracle-se2(li)
postgresql
sqlserver-ee(li)
sqlserver-ex(li)
sqlserver-se(li)
sqlserver-web(li)

REGION=ap-northeast-1
ENGINE=mysql
TS=$(date +%Y%m%d_%H%M%S)

aws rds describe-reserved-db-instances-offerings \
  --product-description "$ENGINE" \
  --region "$REGION" \
  --output json \
| jq -r '
  ["1yr_NoUpfront","1yr_PartialUpfront","1yr_AllUpfront","3yr_NoUpfront","3yr_PartialUpfront","3yr_AllUpfront"] as $cols
  | [
      .ReservedDBInstancesOfferings[]
      | . as $o
      | ($o.Duration/3600) as $hours
      | (($o.RecurringCharges // []) | map(select(.RecurringChargeFrequency=="Hourly") | .RecurringChargeAmount) | add // 0) as $rec
      | (((($o.FixedPrice/$hours) + $rec) * 10000) | round / 10000) as $eff
      | {
          class: $o.DBInstanceClass,
          az: (if $o.MultiAZ then "Multi-AZ" else "Single-AZ" end),
          col: ((if $o.Duration==31536000 then "1yr" else "3yr" end) + "_" + ($o.OfferingType | gsub(" ";""))),
          val: $eff
        }
    ]
  | group_by([.class, .az])
  | map({
      class: .[0].class,
      az: .[0].az,
      cols: (map({key: .col, value: .val}) | from_entries)
    })
  | sort_by(.class, .az)
  | ( [["DBInstanceClass","MultiAZ"] + $cols]
      + map(. as $row | [$row.class, $row.az] + ($cols | map($row.cols[.] // "-"))) )[]
  | @csv
' > rds_ri_${ENGINE}_${REGION}_effective_hourly_usd_${TS}.csv

echo "rds_ri_${ENGINE}_${REGION}_effective_hourly_usd_${TS}.csv"

check_diff() {
  local SRC="$1"
  tail -n +2 "$SRC" | awk -F, '
    {
      cls=$1; az=$2
      gsub(/"/,"",cls); gsub(/"/,"",az)
      split(cls,p,".")
      classtype=p[1]"."p[2]
      bits=""
      for(i=3;i<=NF;i++){ v=$i; gsub(/"/,"",v); bits = bits (v=="-" ? "0" : "1") }

      if (az=="Single-AZ") single[cls]=bits
      else multi[cls]=bits
      classlist[cls]=1

      if (!(classtype in ctPattern)) { ctPattern[classtype]=bits; ctRef[classtype]=cls }
      else if (ctPattern[classtype]!=bits) { ctDiffFlag[classtype]=1; ctDiff[classtype]=ctDiff[classtype]" "cls"("az")="bits }
    }
    END {
      print "=== AZ構成による差異 ==="
      az_diff_found=0
      for (c in classlist) {
        if ((c in single) && (c in multi) && single[c]!=multi[c]) {
          print c"\tSingle="single[c]"\tMulti="multi[c]
          az_diff_found=1
        }
      }
      if (!az_diff_found) print "なし"

      print "=== DBインスタンスクラスタイプ内差異 ==="
      ct_diff_found=0
      for (t in ctDiffFlag) {
        print t": "ctRef[t]"="ctPattern[t]" と異なる ->"ctDiff[t]
        ct_diff_found=1
      }
      if (!ct_diff_found) print "なし"
    }
  '
}

% check_diff rds_ri_mysql_ap-northeast-1_effective_hourly_usd_20260828_135435.csv
=== AZ構成による差異 ===
なし
=== DBインスタンスクラスタイプ内差異 ===
なし

% check_diff rds_ri_sqlserver-ee_li_ap-northeast-1_effective_hourly_usd_20260828_135435.csv
=== AZ構成による差異 ===
db.r5.12xlarge	Single=111011	Multi=011011
db.r5.24xlarge	Single=111011	Multi=011011
db.r5.8xlarge	Single=111011	Multi=011011
db.r5.xlarge	Single=111011	Multi=011011
db.r5.2xlarge	Single=111011	Multi=011011
db.r5.16xlarge	Single=111011	Multi=011011
db.r5.4xlarge	Single=111011	Multi=011011
=== DBインスタンスクラスタイプ内差異 ===
r5: db.r5.12xlarge=011011 と異なる -> db.r5.12xlarge(Single-AZ)=111011 db.r5.16xlarge(Single-AZ)=111011 db.r5.24xlarge(Single-AZ)=111011 db.r5.2xlarge(Single-AZ)=111011 db.r5.4xlarge(Single-AZ)=111011 db.r5.8xlarge(Single-AZ)=111011 db.r5.xlarge(Single-AZ)=111011

make_simple() {
  local SRC="$1"
  local OUT="${SRC/_effective_hourly_usd_/_simple_}"

  {
    head -1 "$SRC" | awk -F, '{h="ClassType"; for(i=3;i<=NF;i++){v=$i; gsub(/"/,"",v); gsub(/Upfront$/,"",v); gsub(/Partial/,"Part",v); gsub(/_/,"",v); h=h","v}; print h}'
    tail -n +2 "$SRC" | awk -F, '
      { cls=$1; gsub(/"/,"",cls); split(cls,p,"."); classtype=p[1]"."p[2]
        if (classtype in seen) next
        seen[classtype]=1
        line=classtype
        for(i=3;i<=NF;i++){ v=$i; gsub(/"/,"",v); line=line","(v=="-"?"×":"○") }
        print line
      }' | sort -t, -k1,1
  } > "$OUT"

  echo "$OUT"
}

% make_simple rds_ri_mysql_ap-northeast-1_effective_hourly_usd_20260828_135435.csv
rds_ri_mysql_ap-northeast-1_simple_20260828_135435.csv