How to host Adminer DB on AWS EC2 VM Instance - ServerAvatar

Adminer is an open-source database management tool known for its comprehensive functionality and ease of use. With its user-friendly interface and flexible capabilities, Adminer enables effective database management without needing extensive technical knowledge. It allows organizations to effectively manage and administer various database systems with features for querying, data manipulation, and user management. When choosing a hosting platform for Adminer DB, opting for AWS EC2 ensures reliability with its scalable infrastructure and straightforward deployment options. ServerAvatar makes the deployment of the Adminer DB on the AWS EC2 platform an easy step-by-step process.

Create an AWS EC2 Instance

Getting Started with AWS EC2:

In the dynamic landscape of cloud computing, Amazon EC2 (Elastic Compute Cloud) stands as a cornerstone service provided by Amazon Web Services (AWS), offering a flexible and scalable solution for hosting virtual servers in the cloud. Designed to cater to a diverse range of computing needs, EC2 allows businesses and developers to deploy virtual machines quickly and securely, enabling them to run various applications and manage workloads with ease.

From startups seeking cost-effective computing power to enterprises requiring robust, scalable infrastructure, EC2 provides a vast array of instance types optimized for different use cases. These instances offer customizable configurations, including computing power, memory, storage, and networking capabilities, empowering users to tailor their virtual environments precisely to their application requirements.

Whether it's launching a single instance for a small-scale project or orchestrating a complex network of instances across multiple regions, EC2 simplifies the process with its intuitive management console and comprehensive APIs. This versatility makes it a preferred choice for businesses looking to leverage the scalability and reliability of cloud computing without the overhead of managing physical hardware.

Using AWS EC2 instances offers a multitude of benefits that cater to diverse business needs and technical requirements. Here are some key advantages:

• Scalability: EC2 enables swift adjustments to your computing capacity according to demand, offering elasticity that efficiently manages fluctuating workloads for businesses, preventing resource over-provisioning.
• Cost-Effectiveness: With EC2, you pay only for the compute capacity you use. This pay-as-you-go pricing model eliminates the need for upfront investments in hardware and allows for cost optimization by scaling resources as needed.
• Flexibility: EC2 provides a diverse range of instance types tailored for various use cases, including compute-optimized, memory-optimized, storage-optimized, and GPU instances. This versatility allows you to select the ideal instance type that best suits your specific application needs.
• Security: AWS offers a secure environment for hosting EC2 instances, incorporating features such as security groups, network access control lists (ACLs), and Virtual Private Clouds (VPCs) to manage network access effectively. Integration with other AWS services, such as AWS Identity and Access Management (IAM), further enhances security by providing detailed access control capabilities.
• Ease of Use: EC2 instances can be easily launched, managed, and configured using the AWS Management Console, Command Line Interface (CLI), or SDKs/APIs. Automation tools like AWS CloudFormation and AWS Elastic Beanstalk further simplify deployment and management tasks.
• Reliability: AWS ensures a high level of reliability for EC2 instances with SLAs that guarantee a specific level of uptime. Additionally, EC2 instances can be configured to automatically recover from failures using features like Auto Scaling and Amazon Elastic Block Store (EBS) snapshots.

Let’s Get started with Creating a Virtual Machine on AWS EC2:

To create a server in Amazon. First log in to Amazon web service. Once you are there, Follow the steps given below.

Step 1: Search for the EC2 service in the AWS search bar

• The first step is to search for EC2 services, as Amazon provides multiple web services. Then click on the EC2 with virtual servers in the cloud option which is shown in the image below.

Step 2: Launching Instances from the EC2 Dashboard

• Now you are in the EC2 Dashboard, navigate to the running instances section. After that new tab for instances will be displayed there you have to click on the Launch Instances button as shown in the images below.

Step 3: Naming and Tagging Your EC2 Instance

• The next step is to name the instance of your choice and you can also add tags to your instance which can help organize, manage, and track resources.

Step 4: Select the OS for your Instance

• After following the steps, proceed to select the operating system for your instance. Generally, the Adminer DB requires Ubuntu 18.04 LTS or a later version for compatibility and support.
• In this case, First, click on Ubuntu and then select the Amazon Machine Image of Ubuntu Server 22.04 LTS as an operating system. In addition to this, select the architecture to 64-bit(x64/86) as shown in the image below.

Step 5: Select the Instance type

• In this step, select the size of your VM instance. AWS EC2 provides lots of different options when it comes to plans and pricing. The selection of instances completely depends on the requirements. So, select the instance based on the complexity and traffic of your sites.

Step 6: Select SSH Key pair or create one

• Here you can select the Key pair name for SSH. If you don't have any key pair stored, you can also create a new key pair by clicking on the Create new key pair option as shown in the following image.

Step 7: Configuring Network Settings

• In this step, you have to configure the network by simply clicking on the Edit button as shown in the following image.

• Then you have to create a new security group by selecting the create security group radio button. You can enter the security group name of your choice and can also add a description for your security group for that you can refer to the image below.

Step 8: Add Inbound Security Group Rules

• The next step is to add inbound security group rules which are necessary to configure for connecting your instance to ServerAvatar. Click on the button shown in the image below to add security group rules.

• ServerAvatar requires 43210 port to be open. In total, You need to keep the following ports open on the instance.
  • 22 (SSH): To access your server via SSH
  • 80 (HTTP): To access your sites on HTTP
  • 443 (HTTPS): To access your sites on HTTPS
  • 43210 (ServerAvatar): To allow communication between ServerAvatar and your instance
• To understand and proceed further, please take the reference of the image depicted below.

Step 9: Configure the storage for your instance

• The final step is to configure the storage. You can select the size of the storage according to your needs. However, it is recommended to select at least 25GB disk volume, and in AWS EC2 there is also an option to select the root volume which you can choose as per your requirements. Now click on the Launch Instance button, as shown in the image below.

• Congratulations! You have successfully created your AWS EC2 Instance which is now ready to connect with ServerAvatar.

Initial Server Configuration

The Initial server configuration includes the installation and configuration of various packages required to host your website. Usually, You have to write commands and modify configuration files. Luckily, With ServerAvatar, Your full server configuration and optimization can be automated.

Here are the three ways to automatically configure your server with ServerAvatar.

wget https://srvr.so/install
chmod +x install
./install

Install and Setup Adminer DB on Cloud using ServerAvatar

Adminer - Database management using Adminer With ServerAvatar

What Is Adminer?

Adminer is a PHP-based, Free, and Open Source Database Management Tool. It is very simple to deploy on your server and easy to use. Here, you only need to upload a single PHP file, point your browser to it, and simply click the login button.

Requirements:

1. PHP: Ensure you have a PHP 5 or higher version installed.

Use Cases:

You can easily create, edit, and delete databases, tables, and rows, as well as execute SQL queries and view results in a clear and concise format. Adminer supports a wide range of database systems, including MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, etc.

Step-by-Step Installation Guide:

Let’s Configure Adminer with ServerAvatar.

First, you have to go to the following URL.

URL: https://www.adminer.org/

Step 1: Download the Adminer

Clicking on the link will take you to the official site of Adminer. Navigate to Downloads section and click on the version of Adminer according to your need.

Step 2: Create a GitHub application

Start by creating a GitHub application using ServerAvatar. Go to the Applications tab on the server panel and click on the Create button as shown in the image below.

To proceed with the installation and deployment of Adminer, ensure you have met the prerequisites.

• Enter an Application Name of your choice.
• Specify a Domain (choose between a Test Domain or a Primary Domain).

Now, Clone Adminer from the available public repository in Github. and then click on the Create Application button.

• Method: Git
• Service Provider: Github
• Repository Type: Public
• Clone HTTPS URL: https://github.com/vrana/adminer.git
• Branch: master

Step 3: Create Adminer Database

Go to the server panel, navigate to the Databases tab, and click on the Create button as shown in the following image.

On the following screen, complete the database details, including:

• Database Name
• Database Username
• Database Password

Step 4: Upload Adminer File

• Navigate to the Application Panel tab by clicking on the icon next to the application as shown in the below image.

• Now, go to the FIle Manager option and open the public_html folder.

• Click the Upload icon and choose the previously downloaded Adminer file to upload it into the public_html folder.

• You can see the Adminer file that you uploaded in the public_html directory as shown in the image below.

• Now, we need to rename the Adminer file that we uploaded. Select the checkbox next to the file and click on the rename icon, as shown in the image below. Rename the file to index.php.

Step 5: Accessing the Adminer Database Homepage

• Now, to access the Adminer Database Homepage, open your application.

• To log in to your Adminer’s Database Homepage, you need to have your database Username and Password. Navigate to the Application Dashboard and click on the Databases option to get the database credentials.
• After navigating to the Databases Section, you have to click on the users icon as highlighted in the below image.

• After clicking on the user's icon, you will navigate to the database users page. You will get the database credentials from there.

• Fill in the database information such as Database Name, Username, and Password on the login page of your Adminer as shown in the below image. After filling in the details click on the Login button.

• After successfully logging in, you will be able to see the dashboard.

• Now you can perform various tasks such as creating tables, altering tables, dropping tables, inserting values into tables, updating values, and deleting values.

Conclusion:

• Adminer is a powerful, lightweight, and user-friendly database management tool that offers a wide range of features in a single PHP file.
• Its simplicity, efficiency, and support for multiple database systems make it an excellent choice for developers and administrators looking for an alternative to more complex tools.
• Whether managing a small personal project or a large enterprise database, Adminer offers extensive functionalities. By using Adminer you can experience the benefits of efficient database management.