IT in Education

High performance MySQL databases on AWS

awsThis article describes how to create a MySQL database on Amazon, and use it for a Joomla website. My web host platform was very prescriptive over which version of MySQL it would provide. Using Amazon RDS allowed me to choose from many different versions of MySQL.


Amazon RDS

Start by logging on to AWS using your root account.

  1. Search for Aurora or RDS, and click RDS.
  2. Select Databases in the left pane.
  3. Click the Create database button.
    1. Select the Standard create option.
    2. For Engine type choose MySQL.
    3. For Version choose 5.7.34.
    4. For Template choose Free tier.
    5. Enter a name for DB instance identifier (e.g. myschool-db1).
    6. Enter your own Master username.
    7. Create a Master password.
    8. DB instance class is automatically selected as db.t2.micro.
    9. Storage is initiated as 20GB.
    10. In the Connectivity section, choose the Create new VPC security group option.
    11. Enter a New VPC security group name (e.g. myschool-dbs).
    12. Click Create database.

Your database and VPC security group will now be created.

The automatically created VPC security will do the following:

  • Allow inbound 3306 traffic from your current IP address.
  • Allow outbound traffic to anywhere.

Joomla

To use this database with Joomla, install Joomla in the usual way. For the database section you'll need the host name.

  1. On the AWS console, search for RDS.
  2. Select Databases in the left pane.
  3. Click your newly created Database name to open its details section.
  4. On Connectivity & security tab, note the Endpoint address.

The Endpoint is the hostname that you need to use in the Joomla install, along with your Master username and Master password. Note that because this db host is not the localhost, Joomla will ask you to delete a randomly created file in your Installation folder, to prove that you own the web host space.


Thanks for visiting,
Steven