Skip to content

Instantly share code, notes, and snippets.

@bluethundr
Created December 17, 2018 19:56
Show Gist options
  • Save bluethundr/092ca6e39016188f56d8b46b203be06d to your computer and use it in GitHub Desktop.
Save bluethundr/092ca6e39016188f56d8b46b203be06d to your computer and use it in GitHub Desktop.
{
"DBInstances": [
{
"PubliclyAccessible": false,
"MasterUsername": "admin",
"MonitoringInterval": 60,
"LicenseModel": "general-public-license",
"MonitoringRoleArn": "arn:aws:iam::123456789101:role/rds-monitoring-role",
"VpcSecurityGroups": [
{
"Status": "active",
"VpcSecurityGroupId": "sg-76512e0c"
},
{
"Status": "active",
"VpcSecurityGroupId": "sg-62880f04"
},
{
"Status": "active",
"VpcSecurityGroupId": "sg-e0bcd59c"
}
],
"InstanceCreateTime": "2018-08-27T15:05:36.654Z",
"CopyTagsToSnapshot": false,
"OptionGroupMemberships": [
{
"Status": "in-sync",
"OptionGroupName": "default:aurora-5-6"
}
],
"PendingModifiedValues": {},
"Engine": "aurora",
"MultiAZ": false,
"DBSecurityGroups": [],
"DBParameterGroups": [
{
"DBParameterGroupName": "default.aurora5.6",
"ParameterApplyStatus": "in-sync"
}
],
"PerformanceInsightsEnabled": false,
"AutoMinorVersionUpgrade": true,
"PreferredBackupWindow": "09:18-09:48",
"PromotionTier": 1,
"DBSubnetGroup": {
"Subnets": [
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-4f98c038",
"SubnetAvailabilityZone": {
"Name": "us-east-1d"
}
},
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-66b7504d",
"SubnetAvailabilityZone": {
"Name": "us-east-1c"
}
}
],
"DBSubnetGroupName": "cpmdwprod",
"VpcId": "vpc-5227a337",
"DBSubnetGroupDescription": "Subnet Group for CPMDWPROD",
"SubnetGroupStatus": "Complete"
},
"ReadReplicaDBInstanceIdentifiers": [],
"AllocatedStorage": 1,
"DBInstanceArn": "arn:aws:rds:us-east-1:123456789101:db:ab-u-klt-scheduler",
"BackupRetentionPeriod": 1,
"DBName": "abukltscheduler",
"PreferredMaintenanceWindow": "thu:09:06-thu:09:36",
"Endpoint": {
"HostedZoneId": "Z2R2ITUGPM61AM",
"Port": 3306,
"Address": "ab-u-klt-scheduler.cfu2upkm0i0k.us-east-1.rds.amazonaws.com"
},
"DBInstanceStatus": "available",
"IAMDatabaseAuthenticationEnabled": false,
"EngineVersion": "5.6.10a",
"EnabledCloudwatchLogsExports": [
"audit",
"error",
"general",
"slowquery"
],
"EnhancedMonitoringResourceArn": "arn:aws:logs:us-east-1:123456789101:log-group:RDSOSMetrics:log-stream:db-LQFKWMULD277V7TGJBBUWGHUSU",
"DeletionProtection": false,
"AvailabilityZone": "us-east-1d",
"DomainMemberships": [],
"DBClusterIdentifier": "abukltscheduler",
"StorageType": "aurora",
"DbiResourceId": "db-LQFKWMULD277V7TGJBBUWGHUSU",
"CACertificateIdentifier": "rds-ca-2015",
"KmsKeyId": "arn:aws:kms:us-east-1:123456789101:key/1ecbc845-befe-43a6-893e-114cbf6d57d4",
"StorageEncrypted": true,
"DBInstanceClass": "db.t2.medium",
"DbInstancePort": 0,
"DBInstanceIdentifier": "ab-u-klt-scheduler"
},
{
"PubliclyAccessible": true,
"MasterUsername": "adadmin",
"MonitoringInterval": 0,
"LicenseModel": "bring-your-own-license",
"VpcSecurityGroups": [
{
"Status": "active",
"VpcSecurityGroupId": "sg-1888fb62"
}
],
"InstanceCreateTime": "2016-09-20T17:41:44.320Z",
"CopyTagsToSnapshot": true,
"OptionGroupMemberships": [
{
"Status": "in-sync",
"OptionGroupName": "default:oracle-se2-12-1"
}
],
"PendingModifiedValues": {},
"Engine": "oracle-se2",
"MultiAZ": false,
"LatestRestorableTime": "2018-12-17T19:17:44Z",
"DBSecurityGroups": [],
"DBParameterGroups": [
{
"DBParameterGroupName": "default.oracle-se2-12.1",
"ParameterApplyStatus": "in-sync"
}
],
"AutoMinorVersionUpgrade": false,
"PreferredBackupWindow": "03:24-03:54",
"DBSubnetGroup": {
"Subnets": [
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-e6f62491",
"SubnetAvailabilityZone": {
"Name": "us-east-1d"
}
},
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-d2c8aae8",
"SubnetAvailabilityZone": {
"Name": "us-east-1e"
}
},
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-d23e22fa",
"SubnetAvailabilityZone": {
"Name": "us-east-1c"
}
},
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-26af537f",
"SubnetAvailabilityZone": {
"Name": "us-east-1a"
}
}
],
"DBSubnetGroupName": "default",
"VpcId": "vpc-4a67da2f",
"DBSubnetGroupDescription": "default",
"SubnetGroupStatus": "Complete"
},
"ReadReplicaDBInstanceIdentifiers": [],
"AllocatedStorage": 10,
"DBInstanceArn": "arn:aws:rds:us-east-1:123456789101:db:cob",
"BackupRetentionPeriod": 1,
"DBName": "COBDEV",
"PreferredMaintenanceWindow": "tue:08:33-tue:09:03",
"Endpoint": {
"HostedZoneId": "Z2R2ITUGPM61AM",
"Port": 3020,
"Address": "cob.cfu2upkm0i0k.us-east-1.rds.amazonaws.com"
},
"DBInstanceStatus": "available",
"IAMDatabaseAuthenticationEnabled": false,
"EngineVersion": "12.1.0.2.v4",
"DeletionProtection": false,
"CharacterSetName": "AL32UTF8",
"AvailabilityZone": "us-east-1e",
"DomainMemberships": [],
"StorageType": "gp2",
"DbiResourceId": "db-HHB5DBXGPH2CJLQCGD4ACGELHQ",
"CACertificateIdentifier": "rds-ca-2015",
"StorageEncrypted": false,
"DBInstanceClass": "db.m3.medium",
"DbInstancePort": 0,
"DBInstanceIdentifier": "cob"
},
{
"PubliclyAccessible": false,
"MasterUsername": "cpmdwprodmaster",
"MonitoringInterval": 60,
"LicenseModel": "general-public-license",
"MonitoringRoleArn": "arn:aws:iam::123456789101:role/rds-monitoring-role",
"VpcSecurityGroups": [
{
"Status": "active",
"VpcSecurityGroupId": "sg-0fa29b8884cf3be5e"
}
],
"InstanceCreateTime": "2018-04-03T20:04:26.992Z",
"CopyTagsToSnapshot": false,
"OptionGroupMemberships": [
{
"Status": "in-sync",
"OptionGroupName": "default:aurora-5-6"
}
],
"PendingModifiedValues": {},
"Engine": "aurora",
"MultiAZ": false,
"DBSecurityGroups": [],
"DBParameterGroups": [
{
"DBParameterGroupName": "cpm-etl-prod-rds",
"ParameterApplyStatus": "in-sync"
}
],
"PerformanceInsightsEnabled": false,
"AutoMinorVersionUpgrade": false,
"PreferredBackupWindow": "04:30-05:00",
"PromotionTier": 1,
"DBSubnetGroup": {
"Subnets": [
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-4f98c038",
"SubnetAvailabilityZone": {
"Name": "us-east-1d"
}
},
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-66b7504d",
"SubnetAvailabilityZone": {
"Name": "us-east-1c"
}
}
],
"DBSubnetGroupName": "cpmdwprod",
"VpcId": "vpc-5227a337",
"DBSubnetGroupDescription": "Subnet Group for CPMDWPROD",
"SubnetGroupStatus": "Complete"
},
"ReadReplicaDBInstanceIdentifiers": [],
"AllocatedStorage": 1,
"DBInstanceArn": "arn:aws:rds:us-east-1:123456789101:db:cpmdwprod",
"BackupRetentionPeriod": 7,
"DBName": "cpmdwh",
"PreferredMaintenanceWindow": "fri:05:00-fri:05:30",
"Endpoint": {
"HostedZoneId": "Z2R2ITUGPM61AM",
"Port": 5432,
"Address": "cpmdwprod.cfu2upkm0i0k.us-east-1.rds.amazonaws.com"
},
"DBInstanceStatus": "available",
"IAMDatabaseAuthenticationEnabled": false,
"EngineVersion": "5.6.10a",
"EnhancedMonitoringResourceArn": "arn:aws:logs:us-east-1:123456789101:log-group:RDSOSMetrics:log-stream:db-CLGAWO344TZZQD4QDJQAVYZIAM",
"DeletionProtection": false,
"AvailabilityZone": "us-east-1c",
"DomainMemberships": [],
"DBClusterIdentifier": "cpmdwprod",
"StorageType": "aurora",
"DbiResourceId": "db-CLGAWO344TZZQD4QDJQAVYZIAM",
"CACertificateIdentifier": "rds-ca-2015",
"KmsKeyId": "arn:aws:kms:us-east-1:123456789101:key/1ecbc845-befe-43a6-893e-114cbf6d57d4",
"StorageEncrypted": true,
"DBInstanceClass": "db.t2.small",
"DbInstancePort": 0,
"DBInstanceIdentifier": "cpmdwprod"
},
{
"PubliclyAccessible": false,
"MasterUsername": "cpmdwprodmaster",
"MonitoringInterval": 60,
"LicenseModel": "general-public-license",
"MonitoringRoleArn": "arn:aws:iam::123456789101:role/rds-monitoring-role",
"VpcSecurityGroups": [
{
"Status": "active",
"VpcSecurityGroupId": "sg-0fa29b8884cf3be5e"
}
],
"InstanceCreateTime": "2018-04-03T20:11:12.220Z",
"CopyTagsToSnapshot": false,
"OptionGroupMemberships": [
{
"Status": "in-sync",
"OptionGroupName": "default:aurora-5-6"
}
],
"PendingModifiedValues": {},
"Engine": "aurora",
"MultiAZ": false,
"DBSecurityGroups": [],
"DBParameterGroups": [
{
"DBParameterGroupName": "default.aurora5.6",
"ParameterApplyStatus": "in-sync"
}
],
"PerformanceInsightsEnabled": false,
"AutoMinorVersionUpgrade": false,
"PreferredBackupWindow": "04:30-05:00",
"PromotionTier": 1,
"DBSubnetGroup": {
"Subnets": [
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-4f98c038",
"SubnetAvailabilityZone": {
"Name": "us-east-1d"
}
},
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-66b7504d",
"SubnetAvailabilityZone": {
"Name": "us-east-1c"
}
}
],
"DBSubnetGroupName": "cpmdwprod",
"VpcId": "vpc-5227a337",
"DBSubnetGroupDescription": "Subnet Group for CPMDWPROD",
"SubnetGroupStatus": "Complete"
},
"ReadReplicaDBInstanceIdentifiers": [],
"AllocatedStorage": 1,
"DBInstanceArn": "arn:aws:rds:us-east-1:123456789101:db:cpmdwprod-us-east-1d",
"BackupRetentionPeriod": 7,
"DBName": "cpmdwh",
"PreferredMaintenanceWindow": "fri:09:37-fri:10:07",
"Endpoint": {
"HostedZoneId": "Z2R2ITUGPM61AM",
"Port": 5432,
"Address": "cpmdwprod-us-east-1d.cfu2upkm0i0k.us-east-1.rds.amazonaws.com"
},
"DBInstanceStatus": "available",
"IAMDatabaseAuthenticationEnabled": false,
"EngineVersion": "5.6.10a",
"EnhancedMonitoringResourceArn": "arn:aws:logs:us-east-1:123456789101:log-group:RDSOSMetrics:log-stream:db-RK6Q2GO62ZQ3JQOTDBOTPYOIBA",
"DeletionProtection": false,
"AvailabilityZone": "us-east-1d",
"DomainMemberships": [],
"DBClusterIdentifier": "cpmdwprod",
"StorageType": "aurora",
"DbiResourceId": "db-RK6Q2GO62ZQ3JQOTDBOTPYOIBA",
"CACertificateIdentifier": "rds-ca-2015",
"KmsKeyId": "arn:aws:kms:us-east-1:123456789101:key/1ecbc845-befe-43a6-893e-114cbf6d57d4",
"StorageEncrypted": true,
"DBInstanceClass": "db.t2.small",
"DbInstancePort": 0,
"DBInstanceIdentifier": "cpmdwprod-us-east-1d"
},
{
"PubliclyAccessible": false,
"MasterUsername": "rrfdbadmin",
"MonitoringInterval": 60,
"LicenseModel": "postgresql-license",
"MonitoringRoleArn": "arn:aws:iam::123456789101:role/rds-monitoring-role",
"VpcSecurityGroups": [
{
"Status": "active",
"VpcSecurityGroupId": "sg-8ce149c4"
}
],
"InstanceCreateTime": "2018-05-15T16:20:32.337Z",
"CopyTagsToSnapshot": false,
"OptionGroupMemberships": [
{
"Status": "in-sync",
"OptionGroupName": "default:aurora-postgresql-9-6"
}
],
"PendingModifiedValues": {},
"Engine": "aurora-postgresql",
"MultiAZ": false,
"DBSecurityGroups": [],
"DBParameterGroups": [
{
"DBParameterGroupName": "rrf-prod",
"ParameterApplyStatus": "in-sync"
}
],
"PerformanceInsightsEnabled": true,
"AutoMinorVersionUpgrade": false,
"PreferredBackupWindow": "05:59-06:29",
"PromotionTier": 1,
"DBSubnetGroup": {
"Subnets": [
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-20b7500b",
"SubnetAvailabilityZone": {
"Name": "us-east-1c"
}
},
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-1b5d4646",
"SubnetAvailabilityZone": {
"Name": "us-east-1a"
}
}
],
"DBSubnetGroupName": "prod-rrf_dbsubnetgrp",
"VpcId": "vpc-5227a337",
"DBSubnetGroupDescription": "prod-rrf_dbsubnetgrp",
"SubnetGroupStatus": "Complete"
},
"ReadReplicaDBInstanceIdentifiers": [],
"AllocatedStorage": 1,
"DBInstanceArn": "arn:aws:rds:us-east-1:123456789101:db:rapidredflag-prod",
"BackupRetentionPeriod": 7,
"DBName": "rapidredflagDB",
"PreferredMaintenanceWindow": "sun:03:05-sun:03:35",
"Endpoint": {
"HostedZoneId": "Z2R2ITUGPM61AM",
"Port": 5432,
"Address": "rapidredflag-prod.cfu2upkm0i0k.us-east-1.rds.amazonaws.com"
},
"DBInstanceStatus": "available",
"PerformanceInsightsKMSKeyId": "arn:aws:kms:us-east-1:123456789101:key/acdf7600-2ec6-4b54-81ec-650294349d70",
"IAMDatabaseAuthenticationEnabled": false,
"EngineVersion": "9.6.8",
"EnhancedMonitoringResourceArn": "arn:aws:logs:us-east-1:123456789101:log-group:RDSOSMetrics:log-stream:db-PILJAPLRFROMYEU7SFRUTOIDLY",
"DeletionProtection": false,
"AvailabilityZone": "us-east-1c",
"DomainMemberships": [],
"DBClusterIdentifier": "rapidredflag-prod-cluster",
"StorageType": "aurora",
"DbiResourceId": "db-PILJAPLRFROMYEU7SFRUTOIDLY",
"CACertificateIdentifier": "rds-ca-2015",
"KmsKeyId": "arn:aws:kms:us-east-1:123456789101:key/acdf7600-2ec6-4b54-81ec-650294349d70",
"StorageEncrypted": true,
"DBInstanceClass": "db.r4.2xlarge",
"DbInstancePort": 0,
"DBInstanceIdentifier": "rapidredflag-prod"
},
{
"PubliclyAccessible": false,
"MasterUsername": "rrfdbadmin",
"MonitoringInterval": 60,
"LicenseModel": "postgresql-license",
"MonitoringRoleArn": "arn:aws:iam::123456789101:role/rds-monitoring-role",
"VpcSecurityGroups": [
{
"Status": "active",
"VpcSecurityGroupId": "sg-8ce149c4"
}
],
"InstanceCreateTime": "2018-05-15T16:31:51.305Z",
"CopyTagsToSnapshot": false,
"OptionGroupMemberships": [
{
"Status": "in-sync",
"OptionGroupName": "default:aurora-postgresql-9-6"
}
],
"PendingModifiedValues": {},
"Engine": "aurora-postgresql",
"MultiAZ": false,
"DBSecurityGroups": [],
"DBParameterGroups": [
{
"DBParameterGroupName": "rrf-prod",
"ParameterApplyStatus": "in-sync"
}
],
"PerformanceInsightsEnabled": true,
"AutoMinorVersionUpgrade": false,
"PreferredBackupWindow": "05:59-06:29",
"PromotionTier": 1,
"DBSubnetGroup": {
"Subnets": [
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-20b7500b",
"SubnetAvailabilityZone": {
"Name": "us-east-1c"
}
},
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-1b5d4646",
"SubnetAvailabilityZone": {
"Name": "us-east-1a"
}
}
],
"DBSubnetGroupName": "prod-rrf_dbsubnetgrp",
"VpcId": "vpc-5227a337",
"DBSubnetGroupDescription": "prod-rrf_dbsubnetgrp",
"SubnetGroupStatus": "Complete"
},
"ReadReplicaDBInstanceIdentifiers": [],
"AllocatedStorage": 1,
"DBInstanceArn": "arn:aws:rds:us-east-1:123456789101:db:rapidredflag-prod-us-east-1a",
"BackupRetentionPeriod": 7,
"DBName": "rapidredflagDB",
"PreferredMaintenanceWindow": "sun:03:05-sun:03:35",
"Endpoint": {
"HostedZoneId": "Z2R2ITUGPM61AM",
"Port": 5432,
"Address": "rapidredflag-prod-us-east-1a.cfu2upkm0i0k.us-east-1.rds.amazonaws.com"
},
"DBInstanceStatus": "available",
"PerformanceInsightsKMSKeyId": "arn:aws:kms:us-east-1:123456789101:key/acdf7600-2ec6-4b54-81ec-650294349d70",
"IAMDatabaseAuthenticationEnabled": false,
"EngineVersion": "9.6.8",
"EnhancedMonitoringResourceArn": "arn:aws:logs:us-east-1:123456789101:log-group:RDSOSMetrics:log-stream:db-N3TLT7WHCZZVOJTFGZISDWOIPU",
"DeletionProtection": false,
"AvailabilityZone": "us-east-1a",
"DomainMemberships": [],
"DBClusterIdentifier": "rapidredflag-prod-cluster",
"StorageType": "aurora",
"DbiResourceId": "db-N3TLT7WHCZZVOJTFGZISDWOIPU",
"CACertificateIdentifier": "rds-ca-2015",
"KmsKeyId": "arn:aws:kms:us-east-1:123456789101:key/acdf7600-2ec6-4b54-81ec-650294349d70",
"StorageEncrypted": true,
"DBInstanceClass": "db.r4.2xlarge",
"DbInstancePort": 0,
"DBInstanceIdentifier": "rapidredflag-prod-us-east-1a"
},
{
"PubliclyAccessible": false,
"MasterUsername": "rrfdbadmin",
"MonitoringInterval": 60,
"LicenseModel": "postgresql-license",
"MonitoringRoleArn": "arn:aws:iam::123456789101:role/rds-monitoring-role",
"VpcSecurityGroups": [
{
"Status": "active",
"VpcSecurityGroupId": "sg-046c6a92fef3304e7"
}
],
"InstanceCreateTime": "2018-11-14T09:10:25.584Z",
"CopyTagsToSnapshot": false,
"OptionGroupMemberships": [
{
"Status": "in-sync",
"OptionGroupName": "default:aurora-postgresql-9-6"
}
],
"PendingModifiedValues": {},
"Engine": "aurora-postgresql",
"MultiAZ": false,
"DBSecurityGroups": [],
"DBParameterGroups": [
{
"DBParameterGroupName": "ridd-uat",
"ParameterApplyStatus": "in-sync"
}
],
"PerformanceInsightsEnabled": false,
"AutoMinorVersionUpgrade": true,
"PreferredBackupWindow": "10:14-10:44",
"PromotionTier": 1,
"DBSubnetGroup": {
"Subnets": [
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-1b5d4646",
"SubnetAvailabilityZone": {
"Name": "us-east-1a"
}
},
{
"SubnetStatus": "Active",
"SubnetIdentifier": "subnet-66b7504d",
"SubnetAvailabilityZone": {
"Name": "us-east-1c"
}
}
],
"DBSubnetGroupName": "ridd-uat_dbsubnetgrp",
"VpcId": "vpc-5227a337",
"DBSubnetGroupDescription": "ridd-uat_dbsubnetgrp",
"SubnetGroupStatus": "Complete"
},
"ReadReplicaDBInstanceIdentifiers": [],
"AllocatedStorage": 1,
"DBInstanceArn": "arn:aws:rds:us-east-1:123456789101:db:rapidredflag-uat",
"BackupRetentionPeriod": 7,
"DBName": "rapidredflagDB",
"PreferredMaintenanceWindow": "sun:03:05-sun:03:35",
"Endpoint": {
"HostedZoneId": "Z2R2ITUGPM61AM",
"Port": 5432,
"Address": "rapidredflag-uat.cfu2upkm0i0k.us-east-1.rds.amazonaws.com"
},
"DBInstanceStatus": "available",
"IAMDatabaseAuthenticationEnabled": false,
"EngineVersion": "9.6.8",
"EnhancedMonitoringResourceArn": "arn:aws:logs:us-east-1:123456789101:log-group:RDSOSMetrics:log-stream:db-IEZ2YRHMCKIYPX77VANATTKYMI",
"DeletionProtection": false,
"AvailabilityZone": "us-east-1c",
"DomainMemberships": [],
"DBClusterIdentifier": "rapidredflag-uat-cluster",
"StorageType": "aurora",
"DbiResourceId": "db-IEZ2YRHMCKIYPX77VANATTKYMI",
"CACertificateIdentifier": "rds-ca-2015",
"KmsKeyId": "arn:aws:kms:us-east-1:123456789101:key/4d120c28-4f4a-4fe0-84ae-c0da92ded53d",
"StorageEncrypted": true,
"DBInstanceClass": "db.r4.xlarge",
"DbInstancePort": 0,
"DBInstanceIdentifier": "rapidredflag-uat"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment