Using the Amazon RDS management console, the AWS RDS command-line interface, or called with simple API calls to access the capabilities of a production-ready relational database.We can modify a DB instance to specify them. The available optional parameters depend on the DB engine and DB engine version, specified with the option group and a DB parameter group when you create the DB instance. A DB parameter group acts as the container for engine configuration values applied to one or more DB instances in the container. We can also configure the DB instance with an option group and a DB parameter group with specified features called the options available for the particular Amazon RDS DB instance.Also, it will determine where the DB instance will be run by choosing the AWS region. Before we create the DB instance, we will decide on the DB instance class that will run the DB instance. RDS is available from Amazon, enabling us to spin with any relational database instance without worrying about the infrastructure.It also used and created the database instance types optimized for the memory and performance of input and output operations. Amazon RDS is also used for DB and SQL as a query language, such as PaaS, not in IAAS.
If you have not already done so, provide values for the required connection properties in the data source name (DSN). Follow the procedure below to start the MySQL remoting service of the SQL Gateway and work with live Amazon DynamoDB data in MySQL Workbench. You can use the SQL Gateway from the ODBC Driver for Amazon DynamoDB to query Amazon DynamoDB data through a MySQL interface.