How to host Adminer DB on Google Cloud VM Instance - 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 choosing a hosting platform for Adminer DB, opting for Google Cloud ensures reliability with its scalable infrastructure and straightforward deployment options. ServerAvatar makes the deployment of the Adminer DB on the Google Cloud platform an easy step-by-step process.

Create a VM Instance in Google Cloud

Getting started with Google Cloud:

Google is one of the most famous and reliable cloud providers among all of its competitors in the market. Google Cloud Platform provides a robust and comprehensive set of cloud computing services, catering to diverse business needs from startups to large enterprises. With its focus on scalability, performance, security, and innovation, GCP enables organizations to build, deploy, and scale applications and services efficiently in the cloud. Whether it's computing, storage, data analytics, machine learning, or networking, GCP offers a powerful and flexible platform for modern cloud computing requirements.

Google Cloud Platform’s Compute Engine offers robust virtual machine capabilities designed to meet the needs of modern cloud computing environments. Whether you’re looking for flexibility, scalability, performance, or integration with other Google Cloud services, Compute Engine provides a comprehensive solution for running your applications and workloads in the cloud efficiently and securely. Here’s a detailed introduction to Google Cloud as a virtual machine provider:

• Compute Engine as a primary service: It allows you to quickly scale VMs up or down based on demand, allowing you to handle varying workloads effectively. Users have the flexibility to select VM instance types tailored to their needs for CPU, memory, and disk capacities. Google provides predefined machine types optimized for different tasks, or you can customize machine types to allocate resources according to specific requirements.
• Key Features and Capabilities: It provides preemptible VMs at a greatly reduced price, ideal for fault-tolerant and batch-processing tasks. VM instances can be migrated live between host systems without any downtime, ensuring exceptional availability and reliability. Users have the option to either create custom VM images or utilize Google's pre-built images for quick deployment of popular software configurations.
• Integration with Google Services: It offers Control access and permissions for VM instances by managing IAM roles and policies. Compute Engine seamlessly integrates with Google Cloud's VPC networking, enabling the creation of secure and isolated networks tailored for your VMs. It also supports VPNs, Cloud Interconnect, and Google Cloud Load Balancing to efficiently manage network traffic. Moreover, Google's Deployment Manager can be used to automate the creation and management of VMs and associated resources following Infrastructure-as-Code principles.
• Management and Monitoring: Administer VM instances using the Google Cloud Console, which offers a graphical interface for deploying, monitoring, and managing resources. Engage with Compute Engine programmatically through Google Cloud SDK tools and APIs, enabling automation and seamless integration with other systems.
• Security and Compliance: Compute Engine incorporates security features such as encryption of data at rest and in transit, secure boot, and IAM controls to safeguard VM instances and data. Google Cloud Platform adheres to various compliance standards (e.g., ISO, SOC, GDPR), providing assurances for regulatory requirements across different industries.

Let’s get started with creating a Virtual Machine on the Google Cloud Platform:

Step 1: Creating a VM in Google Cloud Platform

• Click on the below link and log in to your Google account.

  • https://console.cloud.google.com

• Here you can create a New project or you can select the project you want, and then click on Create a VM as shown in the image below.

Step 2: Creating a VM Instance

• For creating a VM instance click on the sidebar, select the Compute Engine, and then click on the VM instances and Create Instance, as depicted in the images below.

Step 3: Configuring a New VM Instance

• Click on New VM Instance, here you can give Name to your virtual machine. Additionally, you can select the Region and Zone of your choice. Moreover, you can select the machine according to your needs from the available types. Refer to the image below.

Step 4: Select the Machine type

• Now you have the option to select a Machine Type with predefined configurations of vCPUs and memory which is suitable for most workloads. In addition to this, you can also add Availability policies according to your needs. (Recommended Standard policy)

• Also, you can customize your machine that is suitable for your workload as shown in the image below.

Step 5: Select the Boot disk

• In this step, you have to select the Operating System for your instance. Click on the Change button to select the boot disk as shown in the image below.

• Generally, the Adminer DB requires Ubuntu 18.04 LTS or a later version for compatibility and support.ServerAvatar supports both Ubuntu 20.04 LTS and Ubuntu 22.04 LTS. Therefore, choose one of these supported operating systems.
• Moreover, you can select the disk type you want; however, we recommend you select a Balanced persistence disk with a minimum 25 GB disk size, then click on the Select button as depicted in the following image.

Step 6: Firewall rules

• The next step is to allow firewall rules that are available at the time of creating an instance in Google. Select the checkbox next to the HTTP and HTTPS to allow incoming traffic. Click on the Create button to create a VM instance in Google as shown in the image below.

Step 7: Creating New Firewall Rule

• Now, you have to go to the VPC network by clicking on the sidebar and then clicking on the Firewall section. After that click on Create Firewall Rule as shown in the images below.

• Here you have to enter the details such as the Name of the rule and its description. You can also turn on firewall logs. In addition to this leave the network and priority sections as default. The direction of traffic should be Ingress and Allow the action. In the Targets section, you have three options: All instances in the network, Specified target tags, and Specified service accounts, select from them according to your needs. Furthermore, set the Source filter to IPv4 ranges you can specify the ranges as per your requirement in the Source IPv4 ranges input field. To understand it better refer to the image below.

• Lastly, you need to specify the Protocols and ports. ServerAvatar requires 43210 port to be open and the protocol is TCP so add the port number in that field and click on Create as shown in the image below.

• Congratulations! You have successfully created your instance in Google Cloud 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.