How to Configure Database Hosting in a Cloud Environment?

Database Cloud Kb Viewed: 189

How to Configure Database Hosting in a Cloud Environment?

Database hosting in AccuWeb 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.

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.

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

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.

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

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

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.

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.

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.

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).

{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.

Conclusion:

In summary, configuring database hosting in AccuWeb 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 your applications that rely on it.