In this section, we are going to create our very first scalable database using the Amazon RDS service. For simplicity, I will be deploying a simple MySQL database using the RDS Management Console; however, you can use any of the database engines provided by RDS for your testing purposes, including Oracle, MariaDB, PostgreSQL, as well as SQL Server. Let's first examine our use case up to now:
For starters, we have already set up Auto Scaling and Load Balancing for our application's web server instances (see Chapter 7, Manage Your Applications with Auto Scaling and Elastic Load Balancing), as shown in the preceding image. We have also created a separate private subnet in each AZ for hosting our database instances. These subnets are named US-WEST-PROD-DB-1 (
192.168.5.0/24) and US-WEST-PROD-DB-2 (
192.168.6.0/24), respectively. Another extremely important point here is that the communication between the public subnets and the private subnets is also set up using a combination...