Simplified Joomla Deployment Leveraging Amazon RDS for Effortless Setup

Overview

In today’s digital world, Joomla is still a flexible and easy-to-use content management system that helps people and businesses easily make websites. It comes with many different designs, extra tools, and add-ons you can change, letting you create all sorts of websites. It’s simple to use, you can drag things around, and it works well on phones and tablets. Joomla is a reliable choice to make websites that can do many different things.

Joomla is a tool that many people use to make websites, and Amazon RDS (Relational Database Service) is a tool that helps manage databases on the Cloud. In this blog, we will see how to set up Amazon RDS specifically for Joomla. After that, we will see how to make Joomla and the database work together smoothly.

Introduction

Joomla is an open-source software platform that helps people create online applications. It’s like a tool that lets you build and manage a website without writing much code. It offers a user-friendly interface where you can easily create and customize websites for various purposes, such as blogs, E-Commerce stores, corporate websites, community portals, and more for businesses or organizations.

Pioneers in Cloud Consulting & Migration Services

Reduced infrastructural costs
Accelerated application deployment

Get Started

Steps to Create an Amazon EC2 Instance

Step 1 – Select the AMI as the Ubuntu Server of version 22.04

ec1

Step 2 – Select the t2.micro instance type, and we have created a key-pair called ‘Joomla’. You can also select the default key-pair.

ec2

Step 3 – Configure security groups by adding the source type to the Amazon EC2 security group.

ec3

Steps to SSH into the Amazon EC2 Instance

Open the Command line interface and use these commands for SSH:

Go to the folder where you saved your “pem” file using the command “cd (folder name).”
Copy the command from your SSH client and paste it into the command line.
ssh -i “Joomla.pem” ubuntu@ec2-3-6-40-209.ap-south-1.compute.amazonaws.com

ssh

Creating an Amazon RDS Database for Joomla

Step 1 – To begin, we need to log in to the AWS console, select Amazon RDS service, click on Create Database, and select MySQL as a Database.

rds1

Step 2 – We selected the free tier based on our use case in the template section.

rds2

Step 3 – In the Settings section, fill in “Joomla” as the value for the “DB instance identification” field. Enter the username and password for the database.

rds3

Step 4 – In this step, we will set up Amazon RDS for MySQL. Choose “Joomla” as the name for your database. Then click on “Create database”.

rds4

Step 5 – Database is created Successfully.

rds5

Steps to Configure Joomla on Amazon EC2

After SSH, run the following commands.

You must install Apache and PHP programs to set up the necessary environment.

Step 1 – You can do this by running the command below

apt-get update

1	apt-get update

Step 2 – Install Apache by running the command below

apt-get -y install apache2

1	apt-get -y install apache2

This command will install Joomla’s dependencies, so when you enter your instance’s IP address in a web browser, you can view the Apache2 test page.

joomla2

Step 3 – To Install the PHP, use the following commands to complete the installation

apt-get -y install php libapache2-mod-php
apt-get -y install php-cli php-common php-mbstring php-gd php-intl php-xml php-mysql php-zip php-curl php-xmlrpc

1 2	apt-get -y install php libapache2-mod-php apt-get -y install php-cli php-common php-mbstring php-gd php-intl php-xml php-mysql php-zip php-curl php-xmlrpc

Step 4 – Install MySQL

To install MySQL, run the following command

apt-get -y install mysql-server

1	apt-get -y install mysql-server

joomla4

mysql -u root –p
create database joomla;
create user 'joomla_user'@'localhost' identified by 'password';
grant all privileges on joomla.* to 'joomla_user'@'localhost';
flush privileges;
quit;

mysql -u root –p

create database joomla;

create user 'joomla_user'@'localhost' identified by 'password';

grant all privileges on joomla.* to 'joomla_user'@'localhost';

flush privileges;

quit;

joomla4b

Step 5 – Download and install the Joomla Application

To get Joomla, visit the Joomla downloads page. Choose the newest version, which is Joomla 4.2.3. In this guide, we’ll choose the .zip format. Then click on the “Download” button.

As the download will be a zip archive, you must install the unzip tool to extract its contents. Below are the commands

apt-get -y install unzip

1	apt-get -y install unzip

Afterwards, navigate to the ‘/tmp’ directory and proceed to download the Joomla

cd/tmp
wget

1 2	cd/tmp wget

https://downloads.joomla.org/cms/joomla4/4-2-3/Joomla_4-2-3-Stable-Full_Package.zip?format=zip

Once downloaded, Joomla will be stored as an archive file named ‘Joomla_4-2-3-Stable-Full_Package.zip’.
You have to unzip this file. After that copy it to the root of your website. Create a directory at the root of your website, and you can choose any name you prefer for this directory. For example, you can use ‘Joomla’ as the name for this directory.

mkdir /var/www/html/joomla 
unzip Joomla_4-2-3-Stable-Full_Package.zip -d /var/www/html/Joomla

1 2	mkdir /var/www/html/joomla unzip Joomla_4-2-3-Stable-Full_Package.zip -d /var/www/html/Joomla

For required file permissions use the below commands:

chown -R www-data.www-data /var/www/html/joomla 
 
chmod -R 755 /var/www/html/joomla

Command to restart the Apache Server:

systemctl restart apache2

chown -R www-data.www-data /var/www/html/joomla

chmod -R 755 /var/www/html/joomla

Command to restart the Apache Server:

systemctl restart apache2

Steps for Joomla Installation via the Web Browser

Open your web browser and type in your web server’s IP address followed by “/joomla.”

In our example, we used the following address in the browser: “http://13.232.124.185/joomla.”

You’ll see the Joomla website setup screen. Pick the language you want, then click the “Next” button.

Enter the name of the Joomla site: mysite

web

Click on “Setup Login Data” to proceed to the next step. In this step, you must provide information to create your admin account, including your name, username, email address, and password.

web2

Enter the Database information required to connect to the Joomla database and then click on Install Joomla.

web3

web4

The Joomla installation was finished successfully.

web5

Conclusion

Integrating Amazon RDS with Joomla simplifies website deployment and guarantees excellent performance. With Amazon RDS managing the database setup, you can concentrate on crafting compelling web content and enhancing user experiences without dealing with technical complexities. The outcome is a seamless and dependable Joomla website setup that elevates your web development process.

Drop a query if you have any questions regarding Amazon RDS with Joomla and we will get back to you quickly.

Making IT Networks Enterprise-ready – Cloud Management Services

Accelerated cloud migration
End-to-end view of the cloud environment

Get Started

About CloudThat

CloudThat is an official AWS (Amazon Web Services) Advanced Consulting Partner and Training partner, AWS Migration Partner, AWS Data and Analytics Partner, AWS DevOps Competency Partner, Amazon QuickSight Service Delivery Partner, AWS EKS Service Delivery Partner, and Microsoft Gold Partner, helping people develop knowledge of the cloud and help their businesses aim for higher goals using best-in-industry cloud computing practices and expertise. We are on a mission to build a robust cloud computing ecosystem by disseminating knowledge on technological intricacies within the cloud space. Our blogs, webinars, case studies, and white papers enable all the stakeholders in the cloud computing sphere.

To get started, go through our Consultancy page and Managed Services Package, CloudThat’s offerings.

FAQs

1. Can I use my existing Joomla website with Amazon RDS?

ANS: – Yes, you can migrate your Joomla website to Amazon RDS without difficulties. Amazon offers tools and guides to make the process of moving your database seamlessly.

2. Does using Amazon RDS with Joomla affect the overall cost of deployment?

ANS: – While Amazon RDS offers various pricing options, it can be cost-effective in the long run. The pay-as-you-go model allows you to scale resources as needed, optimizing costs based on your website’s traffic and demands.

WRITTEN BY Chamarthi Lavanya

Lavanya Chamarthi is working as a Research Associate at CloudThat. She is a part of the Kubernetes vertical, and she is interested in researching and learning new technologies in Cloud and DevOps.