How to create a MySQL relational database in AWS

With the benefit of cloud AWS computing services, businesses of all sizes can implement sophisticated relational database solutions quickly and efficiently.

Cloud computing with computer network

Image: brijith vijayan, Getty Images/iStockphoto

For the modern business enterprise, collecting, processing, and retrieving large amounts of data has always been a major part of the standard operating procedure. However, with the widespread adoption of big data solutions, IoT devices, and cloud computing services, retrieving data and transforming it into something useful is more vital than ever. In this environment, the relational database has become a staple tool for businesses, both large and small.

With the benefit of cloud computing services, businesses can implement sophisticated relational database solutions quickly and efficiently without having to deploy additional hardware or hire additional specialized engineers. A prime example of one of these cloud-based tools is the Amazon Relational Database Service (Amazon RDS), which supports several database instance types, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server.

This tutorial shows you how to use the AWS console to create and deploy a basic MySQL database using Amazon RDS.

SEE: Amazon Web Services: An insider’s guide (free PDF) (TechRepublic)

How to create a MySQL database using Amazon RDS

The first step is to log in to AWS using administration-level credentials. Once that is accomplished, use the dashboard to navigate to the RDS page located under the Database section on the list of available services.

On the RDS dashboard (Figure A), click the Databases item located on the left-hand navigation bar. Click or tap the Create database button to start the creation process.


Figure A

The first section…