createDBInstanceReadReplica method

Future<CreateDBInstanceReadReplicaResult> createDBInstanceReadReplica({
  1. required String dBInstanceIdentifier,
  2. required String sourceDBInstanceIdentifier,
  3. bool? autoMinorVersionUpgrade,
  4. String? availabilityZone,
  5. bool? copyTagsToSnapshot,
  6. String? dBInstanceClass,
  7. String? dBParameterGroupName,
  8. String? dBSubnetGroupName,
  9. bool? deletionProtection,
  10. String? domain,
  11. String? domainIAMRoleName,
  12. List<String>? enableCloudwatchLogsExports,
  13. bool? enableIAMDatabaseAuthentication,
  14. bool? enablePerformanceInsights,
  15. int? iops,
  16. String? kmsKeyId,
  17. int? maxAllocatedStorage,
  18. int? monitoringInterval,
  19. String? monitoringRoleArn,
  20. bool? multiAZ,
  21. String? optionGroupName,
  22. String? performanceInsightsKMSKeyId,
  23. int? performanceInsightsRetentionPeriod,
  24. int? port,
  25. String? preSignedUrl,
  26. List<ProcessorFeature>? processorFeatures,
  27. bool? publiclyAccessible,
  28. ReplicaMode? replicaMode,
  29. String? sourceRegion,
  30. String? storageType,
  31. List<Tag>? tags,
  32. bool? useDefaultProcessorFeatures,
  33. List<String>? vpcSecurityGroupIds,
})

Creates a new DB instance that acts as a read replica for an existing source DB instance. You can create a read replica for a DB instance running MySQL, MariaDB, Oracle, PostgreSQL, or SQL Server. For more information, see Working with Read Replicas in the Amazon RDS User Guide.

Amazon Aurora doesn't support this action. Call the CreateDBInstance action to create a DB instance for an Aurora DB cluster.

All read replica DB instances are created with backups disabled. All other DB instance attributes (including DB security groups and DB parameter groups) are inherited from the source DB instance, except as specified.

May throw DBInstanceAlreadyExistsFault. May throw InsufficientDBInstanceCapacityFault. May throw DBParameterGroupNotFoundFault. May throw DBSecurityGroupNotFoundFault. May throw InstanceQuotaExceededFault. May throw StorageQuotaExceededFault. May throw DBInstanceNotFoundFault. May throw InvalidDBInstanceStateFault. May throw DBSubnetGroupNotFoundFault. May throw DBSubnetGroupDoesNotCoverEnoughAZs. May throw InvalidSubnet. May throw InvalidVPCNetworkStateFault. May throw ProvisionedIopsNotAvailableInAZFault. May throw OptionGroupNotFoundFault. May throw DBSubnetGroupNotAllowedFault. May throw InvalidDBSubnetGroupFault. May throw StorageTypeNotSupportedFault. May throw KMSKeyNotAccessibleFault. May throw DomainNotFoundFault.

Parameter dBInstanceIdentifier : The DB instance identifier of the read replica. This identifier is the unique key that identifies a DB instance. This parameter is stored as a lowercase string.

Parameter sourceDBInstanceIdentifier : The identifier of the DB instance that will act as the source for the read replica. Each DB instance can have up to five read replicas.

Constraints:

  • Must be the identifier of an existing MySQL, MariaDB, Oracle, PostgreSQL, or SQL Server DB instance.
  • Can specify a DB instance that is a MySQL read replica only if the source is running MySQL 5.6 or later.
  • For the limitations of Oracle read replicas, see Read Replica Limitations with Oracle in the Amazon RDS User Guide.
  • For the limitations of SQL Server read replicas, see Read Replica Limitations with Microsoft SQL Server in the Amazon RDS User Guide.
  • Can specify a PostgreSQL DB instance only if the source is running PostgreSQL 9.3.5 or later (9.4.7 and higher for cross-region replication).
  • The specified DB instance must have automatic backups enabled, that is, its backup retention period must be greater than 0.
  • If the source DB instance is in the same AWS Region as the read replica, specify a valid DB instance identifier.
  • If the source DB instance is in a different AWS Region from the read replica, specify a valid DB instance ARN. For more information, see Constructing an ARN for Amazon RDS in the Amazon RDS User Guide. This doesn't apply to SQL Server, which doesn't support cross-region replicas.

Parameter autoMinorVersionUpgrade : A value that indicates whether minor engine upgrades are applied automatically to the read replica during the maintenance window.

Default: Inherits from the source DB instance

Parameter availabilityZone : The Availability Zone (AZ) where the read replica will be created.

Default: A random, system-chosen Availability Zone in the endpoint's AWS Region.

Example: us-east-1d

Parameter copyTagsToSnapshot : A value that indicates whether to copy all tags from the read replica to snapshots of the read replica. By default, tags are not copied.

Parameter dBInstanceClass : The compute and memory capacity of the read replica, for example, db.m4.large. Not all DB instance classes are available in all AWS Regions, or for all database engines. For the full list of DB instance classes, and availability for your engine, see DB Instance Class in the Amazon RDS User Guide.

Default: Inherits from the source DB instance.

Parameter dBParameterGroupName : The name of the DB parameter group to associate with this DB instance.

If you do not specify a value for DBParameterGroupName, then Amazon RDS uses the DBParameterGroup of source DB instance for a same region read replica, or the default DBParameterGroup for the specified DB engine for a cross region read replica. Constraints:

  • Must be 1 to 255 letters, numbers, or hyphens.
  • First character must be a letter
  • Can't end with a hyphen or contain two consecutive hyphens

Parameter dBSubnetGroupName : Specifies a DB subnet group for the DB instance. The new DB instance is created in the VPC associated with the DB subnet group. If no DB subnet group is specified, then the new DB instance isn't created in a VPC.

Constraints:

  • Can only be specified if the source DB instance identifier specifies a DB instance in another AWS Region.
  • If supplied, must match the name of an existing DBSubnetGroup.
  • The specified DB subnet group must be in the same AWS Region in which the operation is running.
  • All read replicas in one AWS Region that are created from the same source DB instance must either:>
    • Specify DB subnet groups from the same VPC. All these read replicas are created in the same VPC.
    • Not specify a DB subnet group. All these read replicas are created outside of any VPC.
Example: mySubnetgroup

Parameter deletionProtection : A value that indicates whether the DB instance has deletion protection enabled. The database can't be deleted when deletion protection is enabled. By default, deletion protection is disabled. For more information, see Deleting a DB Instance.

Parameter domain : The Active Directory directory ID to create the DB instance in. Currently, only MySQL, Microsoft SQL Server, Oracle, and PostgreSQL DB instances can be created in an Active Directory Domain.

For more information, see Kerberos Authentication in the Amazon RDS User Guide.

Parameter domainIAMRoleName : Specify the name of the IAM role to be used when making API calls to the Directory Service.

Parameter enableCloudwatchLogsExports : The list of logs that the new DB instance is to export to CloudWatch Logs. The values in the list depend on the DB engine being used. For more information, see Publishing Database Logs to Amazon CloudWatch Logs in the Amazon RDS User Guide.

Parameter enableIAMDatabaseAuthentication : A value that indicates whether to enable mapping of AWS Identity and Access Management (IAM) accounts to database accounts. By default, mapping is disabled.

For more information about IAM database authentication, see IAM Database Authentication for MySQL and PostgreSQL in the Amazon RDS User Guide.

Parameter enablePerformanceInsights : A value that indicates whether to enable Performance Insights for the read replica.

For more information, see Using Amazon Performance Insights in the Amazon RDS User Guide.

Parameter iops : The amount of Provisioned IOPS (input/output operations per second) to be initially allocated for the DB instance.

Parameter kmsKeyId : The AWS KMS key identifier for an encrypted read replica.

The AWS KMS key identifier is the key ARN, key ID, alias ARN, or alias name for the AWS KMS CMK.

If you create an encrypted read replica in the same AWS Region as the source DB instance, then do not specify a value for this parameter. A read replica in the same Region is always encrypted with the same AWS KMS CMK as the source DB instance.

If you create an encrypted read replica in a different AWS Region, then you must specify a AWS KMS key identifier for the destination AWS Region. AWS KMS CMKs are specific to the AWS Region that they are created in, and you can't use CMKs from one AWS Region in another AWS Region.

You can't create an encrypted read replica from an unencrypted DB instance.

Parameter maxAllocatedStorage : The upper limit to which Amazon RDS can automatically scale the storage of the DB instance.

Parameter monitoringInterval : The interval, in seconds, between points when Enhanced Monitoring metrics are collected for the read replica. To disable collecting Enhanced Monitoring metrics, specify 0. The default is 0.

If MonitoringRoleArn is specified, then you must also set MonitoringInterval to a value other than 0.

Valid Values: 0, 1, 5, 10, 15, 30, 60

Parameter monitoringRoleArn : The ARN for the IAM role that permits RDS to send enhanced monitoring metrics to Amazon CloudWatch Logs. For example, arn:aws:iam:123456789012:role/emaccess. For information on creating a monitoring role, go to To create an IAM role for Amazon RDS Enhanced Monitoring in the Amazon RDS User Guide.

If MonitoringInterval is set to a value other than 0, then you must supply a MonitoringRoleArn value.

Parameter multiAZ : A value that indicates whether the read replica is in a Multi-AZ deployment.

You can create a read replica as a Multi-AZ DB instance. RDS creates a standby of your replica in another Availability Zone for failover support for the replica. Creating your read replica as a Multi-AZ DB instance is independent of whether the source database is a Multi-AZ DB instance.

Parameter optionGroupName : The option group the DB instance is associated with. If omitted, the option group associated with the source instance is used.

Parameter performanceInsightsKMSKeyId : The AWS KMS key identifier for encryption of Performance Insights data.

The AWS KMS key identifier is the key ARN, key ID, alias ARN, or alias name for the AWS KMS customer master key (CMK).

If you do not specify a value for PerformanceInsightsKMSKeyId, then Amazon RDS uses your default CMK. There is a default CMK for your AWS account. Your AWS account has a different default CMK for each AWS Region.

Parameter performanceInsightsRetentionPeriod : The amount of time, in days, to retain Performance Insights data. Valid values are 7 or 731 (2 years).

Parameter port : The port number that the DB instance uses for connections.

Default: Inherits from the source DB instance

Valid Values: 1150-65535

Parameter preSignedUrl : The URL that contains a Signature Version 4 signed request for the CreateDBInstanceReadReplica API action in the source AWS Region that contains the source DB instance.

You must specify this parameter when you create an encrypted read replica from another AWS Region by using the Amazon RDS API. Don't specify PreSignedUrl when you are creating an encrypted read replica in the same AWS Region.

The presigned URL must be a valid request for the CreateDBInstanceReadReplica API action that can be executed in the source AWS Region that contains the encrypted source DB instance. The presigned URL request must contain the following parameter values:

  • DestinationRegion - The AWS Region that the encrypted read replica is created in. This AWS Region is the same one where the CreateDBInstanceReadReplica action is called that contains this presigned URL.

    For example, if you create an encrypted DB instance in the us-west-1 AWS Region, from a source DB instance in the us-east-2 AWS Region, then you call the CreateDBInstanceReadReplica action in the us-east-1 AWS Region and provide a presigned URL that contains a call to the CreateDBInstanceReadReplica action in the us-west-2 AWS Region. For this example, the DestinationRegion in the presigned URL must be set to the us-east-1 AWS Region.

  • KmsKeyId - The AWS KMS key identifier for the key to use to encrypt the read replica in the destination AWS Region. This is the same identifier for both the CreateDBInstanceReadReplica action that is called in the destination AWS Region, and the action contained in the presigned URL.
  • SourceDBInstanceIdentifier - The DB instance identifier for the encrypted DB instance to be replicated. This identifier must be in the Amazon Resource Name (ARN) format for the source AWS Region. For example, if you are creating an encrypted read replica from a DB instance in the us-west-2 AWS Region, then your SourceDBInstanceIdentifier looks like the following example: arn:aws:rds:us-west-2:123456789012:instance:mysql-instance1-20161115.
To learn how to generate a Signature Version 4 signed request, see Authenticating Requests: Using Query Parameters (AWS Signature Version 4) and Signature Version 4 Signing Process.

Implementation

Future<CreateDBInstanceReadReplicaResult> createDBInstanceReadReplica({
  required String dBInstanceIdentifier,
  required String sourceDBInstanceIdentifier,
  bool? autoMinorVersionUpgrade,
  String? availabilityZone,
  bool? copyTagsToSnapshot,
  String? dBInstanceClass,
  String? dBParameterGroupName,
  String? dBSubnetGroupName,
  bool? deletionProtection,
  String? domain,
  String? domainIAMRoleName,
  List<String>? enableCloudwatchLogsExports,
  bool? enableIAMDatabaseAuthentication,
  bool? enablePerformanceInsights,
  int? iops,
  String? kmsKeyId,
  int? maxAllocatedStorage,
  int? monitoringInterval,
  String? monitoringRoleArn,
  bool? multiAZ,
  String? optionGroupName,
  String? performanceInsightsKMSKeyId,
  int? performanceInsightsRetentionPeriod,
  int? port,
  String? preSignedUrl,
  List<ProcessorFeature>? processorFeatures,
  bool? publiclyAccessible,
  ReplicaMode? replicaMode,
  String? sourceRegion,
  String? storageType,
  List<Tag>? tags,
  bool? useDefaultProcessorFeatures,
  List<String>? vpcSecurityGroupIds,
}) async {
  ArgumentError.checkNotNull(dBInstanceIdentifier, 'dBInstanceIdentifier');
  ArgumentError.checkNotNull(
      sourceDBInstanceIdentifier, 'sourceDBInstanceIdentifier');
  final $request = <String, dynamic>{};
  $request['DBInstanceIdentifier'] = dBInstanceIdentifier;
  $request['SourceDBInstanceIdentifier'] = sourceDBInstanceIdentifier;
  autoMinorVersionUpgrade
      ?.also((arg) => $request['AutoMinorVersionUpgrade'] = arg);
  availabilityZone?.also((arg) => $request['AvailabilityZone'] = arg);
  copyTagsToSnapshot?.also((arg) => $request['CopyTagsToSnapshot'] = arg);
  dBInstanceClass?.also((arg) => $request['DBInstanceClass'] = arg);
  dBParameterGroupName?.also((arg) => $request['DBParameterGroupName'] = arg);
  dBSubnetGroupName?.also((arg) => $request['DBSubnetGroupName'] = arg);
  deletionProtection?.also((arg) => $request['DeletionProtection'] = arg);
  domain?.also((arg) => $request['Domain'] = arg);
  domainIAMRoleName?.also((arg) => $request['DomainIAMRoleName'] = arg);
  enableCloudwatchLogsExports
      ?.also((arg) => $request['EnableCloudwatchLogsExports'] = arg);
  enableIAMDatabaseAuthentication
      ?.also((arg) => $request['EnableIAMDatabaseAuthentication'] = arg);
  enablePerformanceInsights
      ?.also((arg) => $request['EnablePerformanceInsights'] = arg);
  iops?.also((arg) => $request['Iops'] = arg);
  kmsKeyId?.also((arg) => $request['KmsKeyId'] = arg);
  maxAllocatedStorage?.also((arg) => $request['MaxAllocatedStorage'] = arg);
  monitoringInterval?.also((arg) => $request['MonitoringInterval'] = arg);
  monitoringRoleArn?.also((arg) => $request['MonitoringRoleArn'] = arg);
  multiAZ?.also((arg) => $request['MultiAZ'] = arg);
  optionGroupName?.also((arg) => $request['OptionGroupName'] = arg);
  performanceInsightsKMSKeyId
      ?.also((arg) => $request['PerformanceInsightsKMSKeyId'] = arg);
  performanceInsightsRetentionPeriod
      ?.also((arg) => $request['PerformanceInsightsRetentionPeriod'] = arg);
  port?.also((arg) => $request['Port'] = arg);
  preSignedUrl?.also((arg) => $request['PreSignedUrl'] = arg);
  processorFeatures?.also((arg) => $request['ProcessorFeatures'] = arg);
  publiclyAccessible?.also((arg) => $request['PubliclyAccessible'] = arg);
  replicaMode?.also((arg) => $request['ReplicaMode'] = arg.toValue());
  sourceRegion?.also((arg) => $request['SourceRegion'] = arg);
  storageType?.also((arg) => $request['StorageType'] = arg);
  tags?.also((arg) => $request['Tags'] = arg);
  useDefaultProcessorFeatures
      ?.also((arg) => $request['UseDefaultProcessorFeatures'] = arg);
  vpcSecurityGroupIds?.also((arg) => $request['VpcSecurityGroupIds'] = arg);
  final $result = await _protocol.send(
    $request,
    action: 'CreateDBInstanceReadReplica',
    version: '2014-10-31',
    method: 'POST',
    requestUri: '/',
    exceptionFnMap: _exceptionFns,
    shape: shapes['CreateDBInstanceReadReplicaMessage'],
    shapes: shapes,
    resultWrapper: 'CreateDBInstanceReadReplicaResult',
  );
  return CreateDBInstanceReadReplicaResult.fromXml($result);
}