Developing Amazon RDS applications – Unix

The boto3 Python library provides a rich set of classes and function to manipulate RDS database instances. 

Creating an RDS instance

The RDS database instance can be created using the create_db_instance() function. It requires the parameters that define the instance such as instance identifier, master user name, master user password, instance class, type of database engine such as Oracle, MySQL, and so on, and the storage to be allocated to the instance.

The following Python code demonstrates the creation of a MySQL database instance with the name packtpub with 5 GB in size:

#!/usr/bin/env python

import boto3
rds = boto3.client('rds')
try:
        response = rds.create_db_instance(
        DBInstanceIdentifier='packtpub',
        MasterUsername='dbadmin',
        MasterUserPassword='password',
        DBInstanceClass='db.t2.micro',
        Engine='mysql',
        AllocatedStorage=5)
        print response
except Exception as error:
        print error...