How to host Adminer DB on UpCloud Cloud Server - ServerAvatar

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

Create a Server in UpCloud

Getting Started with UpCloud:

UpCloud is a high-performance VPS (Virtual Private Server) hosting platform designed for developers, businesses, and IT professionals. Renowned for its speed and reliability, UpCloud features the unique MaxIOPS storage technology, delivering performance significantly faster than traditional SSDs. This makes it an excellent choice for applications with high I/O demands, such as databases and web hosting. With its user-friendly control panel, UpCloud simplifies server management, making it an attractive option for anyone needing superior VPS hosting solutions.

To deploy any application on UpCloud, we must first set up a server. Therefore, our initial step will be to deploy a server and complete its initial setup.

Step 1: Server Deployment

• Log in to your Upcloud account. If you don’t have an account, create an account on UpCloud.
• Then, Navigate to Server → Server List and click on the Deploy Server button, as shown in the image below.

Step 2: Select Location

• The first thing you have to do is select the location for your server. UpCloud provides different options for selecting the location.
• The general rule is to select the region that is closest to your audience. It means that for the majority of your audience, Your sites will load faster due to lower latency.

Step 3: Select the plan for your Server

• Here you have to select the plan of your Droplet. UpCloud offers a variety of plans. Select the one that best meets your requirements.
• The minimum requirements for Adminer DB are a minimum of 1GB or more RAM for better performance, especially if the server is handling other services or a large number of database connections, and a minimum of 5GB of free disk space is recommended, but more may be needed depending on the Adminer’s files, logs, and any associated database storage.
• If your site is new and has low traffic, begin with a smaller plan. As your project gains and attracts more visitors, you can upgrade to a plan to handle the increased traffic.

Step 4: Add New Storage Device

• In the Storage section, you can attach new storage devices as needed. Your initial storage is based on the selected server plan. You can attach up to 16 storage devices, each with a maximum size of 4 TB.
• To add more disks, click the "Add new device" button and adjust the storage size with the slider. You can modify the storage configuration later by adding, removing, or resizing disk devices.

Step 5: Automated Backups

• You can also enable Automated Backups by clicking the toggle button on the right side. You can choose from Day, Week, Month, or Year plans.
• After selecting the appropriate plan, you can set a backup schedule using the drop-down menu below.

Step 6: Choose an Operating System

• In this step, you need to select your server operating system. We recommend selecting Ubuntu 20.04 LTS x64 or Ubuntu 22.04 LTS x64. If you are using ServerAvatar to manage your servers, these operating systems are required.

Step 7: Select Network Configuration

• In this step, by default network configurations are set that include IPv4 and IPv6 addresses, and a private Utility Network connection is set. You can customize these settings and attach your private network by clicking on the “Attach Private Network” option.

Step 8: Additional Options

• In this step, you can enable or disable IPv6 support and metadata service. Also, you can set the desired TimeZone and select between network and display adapters.
• If it suits you, we suggest keeping these options at their default settings.

Step 9: Select Login Method

• Now you have to select the Login method. There are two types of login methods. They are:
  1. Authentication via SSH Keys
  2. Authentication via One-Time Password
• If you are using SSH keys for authentication, It is the best option. You can also click on the “Add New” button to import your keys.
• If you do not know what is SSH key, You can go with the One-Time password method. You have to set a new password after the first time you log into this server.
• Make sure to set a strong password for your root user, which is the most powerful user with all the privileges on Linux OS. You can select the convenient way to have the password.

Step 10: Enter Initialization Script

• The Initialization scripts are user-defined automation scripts supported by all Linux public templates. When you select one of your stored scripts, it will appear in the edit field.
• You can make changes to the scripts or write a new one. The server will execute the script during the first bootup.

Step 11: Finalise Details

• In the last step of this process, We have to enter the Host Name, Server Name, and number of servers you want to deploy. Click on the Deploy button to create a server.

• In a few minutes, You will have the Server up and running.
• Now, We have to perform the initial step to allow the Serveravatar port from the firewall configuration.
• To allow the Serveravatar port from firewall configuration, Click on the Server → Server List Option and then click on the icon next to your server as shown in the below image.

• Now, navigate to the Firewall Section and Click on “Add Rule”.

• Create a rule to allow ServerAvatar Communication Port - 43210 as shown in the below image. Click on the Ok to add the firewall rule.

• Now, click on the “Save Changes” button to save the changes to Firewall Rules as shown in the below image.

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.