Amazon RDS – MySQL Creating DB

Amazon RDS – MySQL Creating DB ”; Previous Next As a cloud platform AWS gives you very minimal number of steps to setup a DB in RDS. Creating a MYSqlDB can be done in three ways. Using AWS management console, AWS CLI or AWS API. We will look at each of these approaches one by one. Using AWS management Console AWS management console is the most convenient way to get started with RDS. You login to the AWS console using your AWS account details, locate the RDS service and then follow the steps shown below to create a MariaDB instance. Step-1 Select the MSSql Engine form the console. Step-2 Specify the required DB details. Step-3 In this step you decide on the db instance class, amount of storage allocated also set the master password along with few other details. Stpe—4 The final step is to click create database, after which the MySql DB is created with a available end point as shown below. Using CLI To create a MySql DB instance by using the AWS CLI, call the create-db-instance command with the parameters below. aws rds create-db-instance –db-instance-identifier mydbinstance –db-instance-class db.m1.small –engine MySQL –allocated-storage 20 –master-username masterawsuser –master-user-password masteruserpassword –backup-retention-period 3 Using API To create a MariaDB instance by using the Amazon RDS API, we call the CreateDBInstance action with the parameters as shown below. https://rds.us-west-2.amazonaws.com/ ?Action=CreateDBInstance &AllocatedStorage=20 &BackupRetentionPeriod=3 &DBInstanceClass=db.m3.medium &DBInstanceIdentifier=mydbinstance &DBName=mydatabase &DBSecurityGroups.member.1=mysecuritygroup &DBSubnetGroup=mydbsubnetgroup &Engine=mysql &MasterUserPassword=masteruserpassword &MasterUsername=masterawsuser &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20140213/us-west-2/rds/aws4_request &X-Amz-Date=20140213T162136Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=8052a76dfb18469393c5f0182cdab0ebc224a9c7c5c949155376c1c250fc7ec3 Print Page Previous Next Advertisements ”;

Amazon RDS – MySQL DB Export Import

Amazon RDS – MySQL DB Export Import ”; Previous Next Amazon RDS MySQL provides easy ways of importing data into the DB and exporting data from the DB. After we are able to successfully connect to the MySQL database we can use CLI tools to run the import and export commands to get the data from other sources in and out of the RDS database. Below are the scenarios to consider when deciding on the approach to the import the data into the Amazon RDS – MySQL database. From an Existing MySQL database An existing MySQL DB can be present on premise or in another EC2 instance. Diagrammatically what we do is shown below. Creating a backup from On-Premise DB As a first step we create a backup of the on-premise database using the below command. mysqldump -u user -p[user_password] [database_name] > backupfile.sql A file with name backupfile.sql is created which contains the table structure along with the data to be used. Storing the backup file in S3. Upload the backup file created above to a pre-decided Amazon S3 bucket in the same region where the target RDS MySQL DB database is present. You can follow this link to learn about how to upload. Import data from Amazon S3 to RDS- MySQL database You can use the following Amazon CLI command to import the data from S3 to MySQL DB. aws rds restore-db-instance-from-s3 –allocated-storage 125 –db-instance-identifier tddbidentifier –db-instance-class db.m4.small –engine mysql –master-user-name masterawsuser –master-user-password masteruserpassword –s3-bucket-name tpbucket –s3-ingestion-role-arn arn:aws:iam::account-number:role/rolename –s3-prefix bucketprefix –source-engine mysql –source-engine-version 5.6.27 From Another RDS-MySQL Instance There may be scenarios when you want data from an existing RDS MYSQL DB to be taken into another RDS MYSQL DB. For example, to cerate a Disaster recovery DB or create a DB only for business reporting etc. In such scenario, we create read replicas which are a copy of their source DB and then promote that read replica to a new DB instance. They are used to prevent direct heavy read from the original source DB when we want to copy the data. create a read-replica aws rds create-db-instance-read-replica –db-instance-identifier myreadreplica –source-db-instance-identifier mydbinstance Promote a Read replica to DB Instance Now as we have the replica, we can promote it to a standalone DB instance. This will serve our end need of importing data from o RDS – Mysql DB to a new one. The following command is used to complete the promotion of a read replica to a db instance. aws rds create-db-instance-read-replica –db-instance-identifier readreplica_name –region target_region_name –db-subnet-group-name subnet_name –source-db-instance-identifier arn:aws:rds:region_name:11323467889012:db:mysql_instance1 From Any Database In order to import data from any other database to Amazon RDS – MySQL, we have to use the amazon Data Migration Service also called Amazon DMS. It uses Schema conversion tool to translate the existing data base to a the MYSQL platform. The below diagram explains the overall process. Also it works on the similar principle of replication as described in the previous section. Exporting Data from MySQL Exporting of data from Amazon RDS Mysql DB is a straight forwards process where it works on the same replication principle we have seen above. Below are the steps to carry out the export process. Start the instance of MySQL running external to Amazon RDS. Designate the MySQL DB instance to be the replication source. Use mysqldump to transfer the database from the Amazon RDS instance to the instance external to Amazon RDS. Below is the code for the mysqldum command mysqldump -h RDS instance endpoint -u user -p password –port=3306 –single-transaction –routines –triggers –databases database database2 –compress –compact | mysql -h MySQL host -u master user -p password –port 3306 Print Page Previous Next Advertisements ”;

Amazon RDS – Overview

Amazon RDS – Overview ”; Previous Next As RDS is a managed service provided by AWS, we can expect that like other AWS services it will provide scalability, security and cost effectiveness to the various RDBMS it provides. The database products available through AWS RDS are as listed below. MySQL – Support versions for MySQL 5.5 to 5.7. Minor upgrades happen automatically without needing any involvement from the user. MariaDB – Support versions for MariaDB from 10.0 to 10.2. Oracle – Supports version 11g and 12c. You can use the oracle license provided by aws or bring your own license. The costing for these two are different. Microsoft SQL Server – Supports version 200t to 2017. Also AWS supports the various editions like – Enterprise, Standard, Web and Express. PostgreSQL – Supports version 9 to 11. Can be configured as a multi A-Z deployment with read replicas. Amazon Aurora – This is Amazon’s own RDBMS. We will be covering it in a separate tutorial. Each of these Database software is offered as Software as a Service (saas) by providing following features. Customization of CPU capacity, Memory allocation and IOPS(Input Output per second) for a database instance. Manage software patching, failure and recovery of the RDBMS software without any user intervention. Allow manual or automated backup of the database using snapshots. Restore the database from these snapshots. Provide high availability by creating a primary and secondary instance which are synchronous. In case of a failure of primary AWS RDS automatically fails over to secondary. Put the databases in a virtual private cloud (VPC) and aslo use AWS IAM (Identity and Access management) service to control access to the databases. There are two purchase options for AWS RDS service. On-Demand Instances and Reserved Instances. For on-Demand instance you pay for every hour of usage while for Reserved instance you make a upfront payment for one year to three period time frame. Print Page Previous Next Advertisements ”;

Amazon RDS – MS SQL features

Amazon RDS – MS SQL features ”; Previous Next Microsoft SQL server is a prominent relational database in the industry. AWS RDS supports multiple versions of MS SQL server. Below list of supported versions and editions. All these versions support point-in-time restores, and automated or manual backups. DB instances running SQL Server can be used inside a VPC. You can also use SSL to connect to a DB instance running SQL Server. Amazon RDS currently supports Multi-AZ deployments for SQL Server using SQL Server Mirroring as a high-availability, failover solution. Supported Versions AWS RDS makes available the majors versions of MS SQL server from 2008 onwards. The details of these versions are as below. SQL Server 2017 RTM SQL Server 2016 SP1 SQL Server 2014 SP2 SQL Server 2012 SP4 SQL Server 2008 R2 SP3 Below is an example of how to get the supported DB Engine versions using AWS API in a python SDK program. import boto3 client = boto3.client(”rds”) response = client.describe_db_engine_versions( DBParameterGroupFamily=””, DefaultOnly=True, Engine=”sqlserver-ee”, EngineVersion=””, ListSupportedCharacterSets=False, #True, ) print(response) On running the above program, we get the following output − { “ResponseMetadata”: { “RetryAttempts”: 0, “HTTPStatusCode”: 200, “RequestId”: “186a9d70-7580-4207-8727-4d29aebb5213”, “HTTPHeaders”: { “x-amzn-requestid”: “186a9d70-7580-4207-8727-4d29aebb5213”, “date”: “Fri, 14 Sep 2018 05:39:11 GMT”, “content-length”: “1066”, “content-type”: “text/xml” } }, “u”DBEngineVersions””: [ { “u”Engine””: “sqlserver-ee”, “u”DBParameterGroupFamily””: “sqlserver-ee-14.0”, “u”SupportsLogExportsToCloudwatchLogs””: false, “u”SupportsReadReplica””: true, “u”DBEngineDescription””: “MicrosoftSQLServerEnterpriseEdition”, “u”EngineVersion””: “14.00.3035.2.v1”, “u”DBEngineVersionDescription””: “SQL Server 2017 14.00.3035.2.v1”, “u”ValidUpgradeTarget””: [] } ] } Microsoft SQL Server Licensing The software license for RDS DB instance is included in the pricing for using MS SQL server. The user does not need to bring in any license. Also the pricing includes software license, hardware resources and AWS RDS management features. Following are the MS SQL server editions that are available in the MS SQL Server editions. Enterprise Standard Web Express Unlike oracle, there is no additional licensing requirement for Multi A-Z deployment. Microsoft Server uses SQL server Database Mirroring for such deployment. For instances terminated because of licensing issues, AWS maintains DB snapshots from which the DB can be restored, when the licensing issue is resolved. Microsoft SQL Server Security The database engine of MS SQL server uses a role based security. The master user name used when creating a DB instance is a SQL Server Authentication login that is a member of the processadmin, public, and setupadmin fixed server roles.Any user who creates a database is assigned to the db_owner role for that database and has all database-level permissions except for those that are used for backups. Amazon RDS manages backups for the user. Features not Supported in RDS There are quite several features that are not supported by AWS RDS for MS SQL Server. Some of them are listed below. This is important for a scenario when the on-premise database is being taken to the cloud, availability of these features must be evaluated carefully. Always On Backing up to Microsoft Azure Blob Storage Buffer pool extension BULK INSERT and OPENROWSET(BULK…) features Data Quality Services Distributed Queries (i.e., Linked Servers) Distribution Transaction Coordinator (MSDTC) File tables FILESTREAM support Performance Data Collector Policy-Based Management SQL Server Audit Server-level triggers T-SQL endpoints (all operations using CREATE ENDPOINT are unavailable) Print Page Previous Next Advertisements ”;

Amazon RDS – MS SQL creating DB

Amazon RDS – MS SQL Creating DB ”; Previous Next As a cloud platform AWS gives you very minimal number of steps to setup a DB in RDS. Creating a MSSQL DB can be done in three ways. Using AWS management console, AWS CLI or AWS API. We will look at each of these approaches one by one. Using AWS management Console AWS management console is the most convenient way to get started with RDS. You login to the AWS console using your AWS account details, locate the RDS service and then follow the steps shown below to create a MSm SQL DB instance. Step-1 Select the MySQL db Engine form the console. Step-2 Specify the required DB details. Step-3 In this step you decide on the db instance class, amount of storage allocated also set the master password along with few other details. Stpe—4 This is the final step when you mention the vpc and security settings, encryption, backup options and log export etc. For brevity the screen shot has been shortened showing only the important options. Using CLI To create a MSSQL DB instance by using the AWS CLI, call the create-db-instance command with the parameters below. aws rds create-db-instance –engine sqlserver-se –db-instance-identifier mymsftsqlserver –allocated-storage 250 –db-instance-class db.m1.large –db-security-groups mydbsecuritygroup –db-subnet-group mydbsubnetgroup –master-user-name masterawsuser –master-user-password masteruserpassword –backup-retention-period 3 Using API To create a MSSQL DB instance by using the Amazon RDS API, we call the CreateDBInstance action with the parameters as shown below. https://rds.amazonaws.com/ ?Action=CreateDBInstance &AllocatedStorage=250 &BackupRetentionPeriod=3 &DBInstanceClass=db.m1.large &DBInstanceIdentifier=mydbinstance &DBSecurityGroups.member.1=mysecuritygroup &DBSubnetGroup=mydbsubnetgroup &Engine=sqlserver-se &MasterUserPassword=masteruserpassword &MasterUsername=masterawsuser &SignatureMethod=HmacSHA256 &SignatureVersion=4 &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQK/20140305/us-west-1/rds/aws4_request &X-Amz-Date=20140305T185838Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=d445654615b1522c5b2b37c13bsseb7575hdh45e209d4b3a064a3 Print Page Previous Next Advertisements ”;

Amazon RDS – DB Storages

Amazon RDS – DB Storages ”; Previous Next The RDS instances use Amazon Block Storage (EBS) volumes for storing data and log. These storage types can dynamically increase their size as and when needed. But based on the database workloads and price associated with these storage types we can customize the storage need. Following are the factors to be analysed while deciding on the storage types. IOPS – It represents the number of Input Output operations performed per second. Both read and write operations are summed up for finding the IOPS value. AWS creates a report of IOPS value for every 1 minute. It can have value from 0 to tens of thousands per second. Latency – It is the number of milliseconds elapsed between the initiation of an I/O request and the completion of the I/O request. A bigger latency indicates a slower performance. Throughput – The number of bytes transferred to and from the disk every second. AWS reports the read and write throughput separately for every 1-minute interval. Queue Depth – It is the number of I/O requests waiting in the queue before they can reach the disk. AWS reports the queue depth for every 1-minute interval. Also a higher queue-depth indicates a slower storage performance. Based on the above considerations, the aws storage types are as below. General Purpose SSD This is a cost-effective storage that is useful in most of the common database tasks. It can provide 3000 IOPS for a 1- TiB volume. In a 3.34 TiB size the performance can go up to 10000 IOPS. I/O Credits Each GB of storage allows 3 IOPs as a base line performance. Which mean a 100 GB volume can provide 300 IOPs. But there may be scenario when you need more IOPS. In such scenario you need to use some IO credit balance which is offered when the storage is initialized. It is 5.4 million IO credits which can be used when a burstable performance need arises. On the other hand when you use less IOPS than the baseline performance, you accumulate the credits which can be used in future requirement of burstable performances. Below is a equation which shows the relation between burst duration and Credit balance. Burst Duration = (credit Balance) / [(burst IOPS) – 3(Storage size in GB)] If your DB needs frequent and long duration burstable performance, then the next storage type will be a better choice. Provisioned IOPS Storage This is a type of storage system that gives sustained higher performance and consistently low latency which is most suitable for OLTP workloads. When creating the DB instance, you specify the required IOPS rate and volume size for such storage. Below is a chart which is used for reference for deciding about the IOPS and storage needed under provisioned storage. DB Engine Provisioned IOPS Range Storage Range MariaDB 1000 to 40000 100 GB to 16 TB SQL Server 1000 to 32000 20GB to 16 TB MySQL / Oracle/ PostgreSQL 1000 to 40000 100GB to 16 TB This is a very old storage technology which is maintained by aws, only for backward compatibility. Its features are very limited which are the following. Does not support Elastic Volumes Limited to maximum size of 4 TB Limited to maximum of 1000 IOPS Print Page Previous Next Advertisements ”;

Amazon RDS – MS SQL Connecting to DB

Amazon RDS – MS SQL Connecting to DB ”; Previous Next To connect to Amazon RDS MSSQL server we need a client software. In this case we use Sql Server Management Studio. Install it using the link SSMS . After it is successfully installed we follow the steps below to connect it to the Amazon RDS. Step-1 From the DB instance details get the end point. Step-2 Use the end point and the master user credentials as the connection details. Step-3 Once connected, we get the following window. Step-4 We can also query the MSSQL DB as shown below. Print Page Previous Next Advertisements ”;

Amazon RDS – Oracle Features

Amazon RDS – Oracle Features ”; Previous Next Oracle is very popular Relational DB which is available in the amazon RDS services with its enterprise edition features. Almost every feature of Oracle can be leveraged in the RDS platform. Below is a brief description on MYSQLs major features in RDS platform. Supported Versions The versions 11.2 and 12.1 are the major versions supported in the RDS platform. If no version is mentioned during the DB creation, it defaults to the most recent version at that point in time. Below is an example of how to get the supported DB Engine versions using AWS API in a python SDK program. import boto3 client = boto3.client(”rds”) response = client.describe_db_engine_versions( DBParameterGroupFamily=”oracle-ee-12.1”, DefaultOnly=True, Engine=””, EngineVersion=””, ListSupportedCharacterSets=False, #True, ) print(response) When we run the above program, we get the following output − { “ResponseMetadata”: { “RetryAttempts”: 0, “HTTPStatusCode”: 200, “RequestId”: “f6805635-3e16-4014-83cd-dfdaf3f17950”, “HTTPHeaders”: { “x-amzn-requestid”: “f6805635-3e16-4014-83cd-dfdaf3f17950”, “date”: “Fri, 14 Sep 2018 03:46:38 GMT”, “content-length”: “1455”, “content-type”: “text/xml” } }, “u”DBEngineVersions””: [ { “u”Engine””: “oracle-ee”, “u”DBParameterGroupFamily””: “oracle-ee-12.1”, “u”SupportsLogExportsToCloudwatchLogs””: true, “u”SupportsReadReplica””: false, “u”DefaultCharacterSet””: { “u”CharacterSetName””: “AL32UTF8”, “u”CharacterSetDescription””: “Unicode 5.0 UTF-8 Universal character set” }, “u”DBEngineDescription””: “Oracle Database Enterprise Edition”, “u”EngineVersion””: “12.1.0.2.v12”, “u”DBEngineVersionDescription””: “Oracle 12.1.0.2.v12”, “u”ExportableLogTypes””: [ “alert”, “audit”, “listener”, “trace” ], “u”ValidUpgradeTarget””: [] } ] } Oracle Licensing There are two options for using oracle licenses in RDS. They are License Included and Bring Your Own License. License Included Model In this model Amazon holds the license for the software you are going to use. Also AWS itself provides the support for both AWS and Oracle software thorugh its support program. So the user does not purchase any separate license. The platform pricing includes the charges for licensing cost the user pays. The two editions supported in this model are Standard Edition One and Standard Edition Two. Bring Your Own License (BYOL) In this model the user brings in the license she holds into RDS platform. It is the user’s responsibility to maintain the compatibility between the license, database instance class and database edition. The user directly contacts the Oracle support channel for any need. In this model the supported editions are Enterprise Edition (EE), Standard Edition (SE), Standard Edition One (SE1) and Standard Edition Two (SE2). For a multi A-Z deployment, the user should have license for both primary DB instance and the secondary DB instance. Oracle DB Parameter Group The oracle DB involves many DB parameters to be configured for various features and performance needs of the database. Aws makes these parameters visible through CLI commands, which the user can use to query for the parameter values. Below is the CLI command and the sample output. aws rds describe-engine-default-parameters –db-parameter-group-family oracle-ee-12.1 Below are the some important parameters obtained as a result of above CLI command. { “EngineDefaults”: { “Parameters”: [ { “AllowedValues”: “TRUE,FALSE”, “ParameterName”: “_allow_level_without_connect_by”, “ApplyType”: “dynamic”, “Description”: “_allow_level_without_connect_by”, “IsModifiable”: true, “Source”: “engine-default”, “DataType”: “boolean” }, { “AllowedValues”: “CHOOSE,OFF,CUBE,NESTED_LOOPS,MERGE,HASH”, “ParameterName”: “_always_semi_join”, “ApplyType”: “dynamic”, “Description”: “_always_semi_join”, “IsModifiable”: true, “Source”: “engine-default”, “DataType”: “string” }, { “AllowedValues”: “TRUE,FALSE”, “ParameterName”: “_b_tree_bitmap_plans”, “ApplyType”: “dynamic”, “Description”: “_b_tree_bitmap_plans”, “IsModifiable”: true, “Source”: “engine-default”, “DataType”: “boolean” }, { “AllowedValues”: “TRUE,FALSE”, “ParameterName”: “parallel_automatic_tuning”, “ApplyType”: “static”, “Description”: “enable intelligent defaults for parallel execution parameters”, “IsModifiable”: true, “Source”: “engine-default”, “DataType”: “boolean” }, { “AllowedValues”: “ENABLE,DISABLE”, “ParameterName”: “xml_db_events”, “ApplyType”: “dynamic”, “Description”: “are XML DB events enabled”, “IsModifiable”: false, “Source”: “engine-default”, “DataType”: “string” } ] } } Print Page Previous Next Advertisements ”;

Amazon RDS – Home

Amazon – RDS Amazon RDS is the Relational Database Service offered as a web service by Amazon. It makes it easy to set-up and operate a relational database in the cloud. It provides a very cost-effective way to use industry’s leading RDBMS software as a managed service. Because of this web service from amazon AWS, You do not have to buy any server or install any database software in it. You just have subscribe to the AWS RDS web service and start using the RDBMS features after some initial configuration involving memory and CPU capacity allocation etc . In this Tutorial we will learn about the different interfaces available in AWS RDS to use the industry’s leading RDBMS software. Audience This tutorial targets IT professionals, students, and management professionals who want a solid grasp of essential AWS RDS concepts. After completing this tutorial, you will achieve intermediate expertise in AWS RDS, and easily build on your knowledge to solve more challenging problems. Prerequisites This tutorial assumes general knowledge of database technology and querying languages. It also assumes familiarity with typical database operations in an application. If you are completely new to Amazon AWS then please refer our Amazon Web Services to get a sound understanding of the language. Print Page Previous Next Advertisements ”;

Amazon RDS – Interfaces

Amazon RDS – Interfaces ”; Previous Next The RDS interfaces are a way to access the RDS service we create. After the creation and configuration of the RDS service there is a need of accessing the data, uploading data to this database and running some other program which should be able to connect to the database. Such requirements of accessing and manipulating data by end users of the database and not necessarily the AWS account holder which created the database needs these interfaces. There are three main such interfaces. GUI Console This is the simplest of the interfaces where the user can login through a web browser and start using the DB services. The down side of such access is , it needs a human to interact with the RDS services and we cannot run a database program to do some regular tasks like – backup or analysing the DB etc. Command Line Interface It is also called CLI access where you can execute DB command through the AWS command prompt screen which should have been installed in the client computer you are using. Below are the steps to install CLI in your local system using which you will access AWS services. The steps to install AWS CLI are as below. Step-1 Check for the version of python in your environment. ubuntu@ubuntu:~$ python -V ubuntu@ubuntu:~$ python3 -V When we run the above program, we get the following output − Python 2.7.12 Python 3.5.2 If the version is less than 2.6 or 3.3 , then you need to upgrade the version of python in your system. Step -2 Check for availability of the python package named pip . It will be needed to install AWS CLI. Pip -V When we run the above program, we get the following output − pip 10.0.1 from /home/ubuntu/.local/lib/python3.5/site-packages/pip (python 3.5) Step -3 Issue the following command to install the AWS CLI. pip install awscli –upgrade –user aws –version When we run the above program, we get the following output − Aws-cli/1.11.84 Python/3.6.2 Linux/4.4.0 Step-4 Next we configure the aws CLI with credentials. We issue this command and then input the required values one by one. aws configure When we run the above program, we get the following output − AWS Access Key ID [None]: ****PLE AWS Secret Access Key [None]: ********8 Default region name [None]: us-west-2 Default output format [None]: json With the above configuration in place you are now ready to use CLI for communicating with AWS environments for setting up and using amazon RDS. In the next chapters we will see how we can do that. AWS API Amazon Relational Database Service (Amazon RDS) also provides an application programming interface (API). APIs are used when the information is exchanged between the systems rather than a human issuing the commands and receiving the result. For example, if you want to automate the addition of database instances to a RDS service when the number of transactions reach certain threshold , then you use a AWS SDK to write a program which will monitor the number of database transactions and spin-off a RDS instance when the required condition is met. Below is an example of API code that creates a copy of a DB snapshot. It is a python program which uses AWS sdk named boto3. The client library in boto3 has a method named copy_db_snapshot which is called by the python program to create a copy of the DB snapshot with the required parameters as shown. import boto3 client = boto3.client(”rds”) response = client.copy_db_snapshot( SourceDBSnapshotIdentifier=”mydbsnapshot”, TargetDBSnapshotIdentifier=”mydbsnapshot-copy”, ) print(response) When the above program is run we get the response which describes the various properties of the copy event. Here the term string represents the various names of parameters which is defined by the user for their environment. For example VpcID represents the ID of the vpc in which the copy action is happening. { ”DBSnapshot”: { ”DBSnapshotIdentifier”: ”string”, ”DBInstanceIdentifier”: ”string”, ”SnapshotCreateTime”: datetime(2015, 1, 1), ”Engine”: ”string”, ”AllocatedStorage”: 123, ”Status”: ”string”, ”Port”: 123, ”AvailabilityZone”: ”string”, ”VpcId”: ”string”, ”InstanceCreateTime”: datetime(2015, 1, 1), ”MasterUsername”: ”string”, ”EngineVersion”: ”string”, ”LicenseModel”: ”string”, ”SnapshotType”: ”string”, ”Iops”: 123, ”OptionGroupName”: ”string”, ”PercentProgress”: 123, ”SourceRegion”: ”string”, ”SourceDBSnapshotIdentifier”: ”string”, ”StorageType”: ”string”, ”TdeCredentialArn”: ”string”, ”Encrypted”: True|False, ”KmsKeyId”: ”string”, ”DBSnapshotArn”: ”string”, ”Timezone”: ”string”, ”IAMDatabaseAuthenticationEnabled”: True|False, ”ProcessorFeatures”: [ { ”Name”: ”string”, ”Value”: ”string” }, ] } } Print Page Previous Next Advertisements ”;