MTN Managed Database Provisioning Workflow on MTN Cloud

Connection Details

This displays essential connectivity parameters, such as hostnames, IP addresses, port configurations, and necessary credentials or connection strings required to link applications to the database instance.

Tip: Click the refresh button to apply changes made in the settings.

Insights

This provides comprehensive real-time performance monitoring, including metrics for Database Connections, Throughput (QPS), Queries per Second, Database Size, Cache Hit Ratio etc.

Settings

The Settings tab provides granular control over the Managed Database configurations, such as

• User Management: View existing users, or add and create new user accounts. Reset passwords for existing user accounts

Users can be added by clicking the + Add User button, which opens a wizard where you can specify the username, password, account expiry date, and whether the account is for a service or an individual.

Manage existing users by resetting passwords, setting expiration dates, locking accounts, or deleting users.

• Databases: Manage existing databases, create new ones, and assign ownership or access permissions.

To add a new database, click the + Add Database button. This opens a wizard where you can specify the database name, assign a user, and set access permissions (Owner, Read/Write, or Read Only).

Manage existing databases by managing user access and permissions either by updating or removing users with access, deleting databases

• Network/Access: Secure remote database access by configuring SSL settings and defining allowed client CIDRs (PostgreSQL only).

Select the SSL checkbox to enable secure connections for your managed database instances. To restrict remote access to PostgreSQL databases by IP, click + ADD CIDR, enter the authorized range, and click Save to apply your changes.

• Active Sessions: The Active Sessions tab provides a real-time overview of current client connections. Use the refresh button to update this information on demand.

• Parameters: View and modify configurable settings and performance parameters for your MySQL or PostgreSQL managed database instance.

Managed MySQL Parameters

Managed PostgreSQL Parameters

• Monitoring & Logging: - Enable Fluent Bit, Prometheus, or both to configure comprehensive logging and monitoring for your managed database instance.

To enable Fluent Bit, click ‘Enable’ to launch the configuration wizard. Once open, select your preferred log destinations and enter the required input details. By default, logs are stored locally on each node; you can add multiple destinations to ship these logs externally.

• Grafana Loki

• ElasticSearch / OpenSearch

• HTTP Endpoint

• Fluent Forward

For each destination, you can enable TLS by selecting the “Use TLS” checkbox.

To further secure your connection, check “Verify Certificate” to validate the certificate against the collector’s hostname. Note that you must use the hostname for verification, as certificates rarely match a bare IP address.

Choose a log destination, test the configuration, and save your changes. This reconfigures the Fluent Bit output and restarts the service, which may cause a brief connection gap.

To enable Prometheus, click the ‘Enable’ button to activate prometheus

Once activated, you can view connection details for monitoring & logging services under the Connection Details tab.

Note: Getting to the prometheus webpage, your logging credentials are your admin username and admin password

SQL Editor

The SQL Editor tab provides an integrated, web-based console, allowing you to execute ad-hoc queries and perform database maintenance tasks directly within the portal.

You can add multiple query tabs by clicking the plus icon.

You can select the database against which you want to run queries by clicking on the dropdown menu.

The SQL Editor allows Admin and service accounts to execute queries on their assigned databases, while the Admin account has universal access across all databases.

Run SQL commands in the SQL Editor by typing or pasting your queries, then clicking ‘Run’ or highlighting specific rows and clicking ‘Run Selection’.

Query results are displayed in rows directly below the editor box upon execution.

Topology

The Topology tab displays your managed database’s cluster layout, including single or multi-node configurations (multi-node support coming soon), and lists each node alongside its assigned role.

Note: Refresh to view the real-time cluster status.