How to Configure Database Hosting in a Cloud Environment?

How to Configure Database Hosting in a Cloud Environment?

Database hosting in AccuWeb.Cloud is suitable for a wide range of applications, from small websites and web applications to large-scale enterprise databases. It offers the advantages of resource efficiency, isolation, flexibility, and scalability, making it a popular choice for hosting and managing databases in a virtualized environment.

Database Hosting Creation

Step 1: Log in to your AccuWeb.Cloud account.

Step 2: Click on the “New Environment” option located in the upper left corner of the screen.

New Environment

Step 3: In the Topology wizard, navigate to the SQL option. Then, choose MariaDB and select the desired version (e.g., Mariadb 11.0.2 as an example) from the drop-down list of available DB management systems, which includes SQL (MySQL 5.6 / 5.7, MariaDB 5.5 / 10.1, PostgreSQL 9.5, PerconaDB 5.6, MSSQL 2012).

Please note that the availability of database servers may vary based on your hosting provider settings. If certain servers are not available, contact your hosting provider for activation.

Configure MariaDB

Step 4: Click on the Mariadb database to access the SQL Databases section.

Configure SQL Database

Step 5: In the Environment field, enter the desired name for browsing the database (e.g., accu-database as an example). Then, click the “Create” button to create the database.

Enter Environment Name

Step 6: You’ll receive a confirmation message on the screen once the process is complete.

Environment Created Successfully

You will also receive an email notification containing credentials (access URL, login, and password) for the database administration panel.

MariaDB Node Created

Step 7: To access your database admin panel, click the “Open in Browser” button next to the target database node on the dashboard. Alternatively, you can manually compose the admin panel URL.

Open in Browser

Step 8: In the opened page, use the credentials from the email to log in and configure the settings required by your application. The database admin console is available via https:// by default for containers without a public IP address.

PHP Login Page

Database Password Reset

To reset the password for a database node, click the settings icon next to it on the dashboard. Then, select the “Reset Password” option. You will receive an email with a new password to access your database admin console.

Reset Password

Database Admin Panel URL

The administration panel URL for DB servers should follow this format

https://node{node_id}-{environment_name}.{hoster_domain}

Where

{node_id} is the ID of the target database container, which can be found on the dashboard (e.g., 2140 for Mariadb).

Node ID

{environment_name} is the environment name where you’ve added the server (e.g., database).
{hoster_domain} is your hosting provider’s domain, typically found in the last column of the appropriate table on the Hosters Info page.

So, in our case, the access URL for the database administration panel would be:

https://node2140-accu-database.us-accuweb.cloud/

Please note that your environment’s {hoster_domain} value may differ from the general platform’s domain if your hosting provider offers multiple environment regions.

phpMyAdmin

Conclusion

In summary, configuring database hosting in AccuWeb.Cloud involves a systematic process that starts with selecting the appropriate database software and version and concludes with accessing and managing your database through the admin panel. Properly configuring your database is essential for ensuring the reliability and performance of the applications that rely on it