Skip to main content

Managing Your Database

This guide covers the management and maintenance of your database instances.

Instance Lifecycle​

You can manage the state of your database node through the following actions:

  • Start: Resumes a stopped database. The IP address and credentials remain unchanged.
  • Stop: Shuts down the database and closes all active connections.
  • Restart: Reboots the database instance. This is useful for resetting connections or for troubleshooting.
  • Delete: Permanently deletes the database instance and all its data. This action is irreversible.

Resource Management​

Upgrading a Database Plan​

You can upgrade your database to a plan with higher resources (CPU, RAM).

info

The database instance must be in a stopped state before you can perform a plan upgrade.

Upgrades are available for both hourly and committed plans. The database will automatically restart with the new configuration upon completion.

Expanding Disk Size​

You can increase the storage volume size of your database instance without upgrading the entire plan.

warning

Disk size can only be expanded once per database instance. For further storage increases, you must upgrade to a higher plan.

Networking​

VPC Management​

You can attach or detach Virtual Private Clouds (VPCs) to your database instance.

  • A maximum of 3 VPCs can be attached to a single database.
  • To attach: Select an available VPC from the network settings and attach it.
  • To detach: Select a connected VPC and detach it.

IP Whitelisting​

Control access to your database by creating a whitelist of trusted IP addresses.

  • If no IP addresses are whitelisted, the database is accessible from any location with valid credentials.
  • Add the private IP address of the node you wish to grant access to.

It is a security best practice to restrict database access to known and trusted IP addresses to prevent unauthorized connections and potential attacks.

Snapshots​

Snapshots are point-in-time backups of your database. You can use them for data recovery, disaster recovery, or creating copies for testing and development.

Manual Snapshots​

  • Create Snapshot: Manually trigger a snapshot at any time. You will be prompted to provide a name for the snapshot.
  • Restore Snapshot: Revert your database to the state captured in a snapshot. This is useful for recovering from data corruption or system failures.
  • Delete Snapshot: Permanently delete a manual snapshot that is no longer needed.

Scheduled Snapshots​

Configure automatic snapshots at regular intervals.

  • Scheduling: Set up daily, weekly, or monthly snapshots at a specific time.
  • Editing: Modify the interval and time of existing snapshot schedules.
  • Disabling: You can disable a scheduled snapshot task.

Snapshot Lifecycle​

Automate the deletion of old snapshots to manage storage costs.

  • Configure a retention period for your snapshots. Snapshots older than the defined interval will be automatically deleted.
  • You can edit or disable the lifecycle policy as needed.

Monitoring and Logs​

Performance Monitoring​

View performance graphs for your database instance metrics on the Monitoring tab. This data helps you maintain the reliability, availability, and performance of your database.

Alerts​

Configure alerts to receive notifications based on specific trigger parameters.

  • Triggers: Define alerts based on metrics like CPU usage, memory, or disk space.
  • Notifications: Alerts are sent to a pre-configured user group via email. You can create and manage user groups for different notification purposes.

Slow Query Logs​

Identify and optimize performance bottlenecks by logging queries that exceed a specified execution time threshold.

  • You can configure the time threshold to define what constitutes a "slow" query.
  • The logs are available for analysis in the dashboard.

Activity Timeline​

The Activity Timeline provides a chronological log of all management activities performed on the database instance.

Log Export​

Export database logs to an Object Storage (EOS) bucket for long-term storage and analysis.

To enable log export:

  1. Create an EOS bucket and an access key.
  2. Provide the bucket name, access key, and secret key.
info
  • The first time you enable export, all existing logs are transferred. Subsequently, logs are exported automatically every 24 hours.
  • Log retention in the EOS bucket is controlled by your bucket's lifecycle policy.
  • If you disable log export, future logs will not be transferred, but existing logs in the bucket will remain.
  • You are responsible for managing and rotating your EOS access credentials.

Enable SSL​

You can enable SSL for your DBaaS instance directly from the dashboard.

Steps to Enable SSL​

  1. Go to Manage DBaaS.
  2. Select the DBaaS instance for which you want to enable SSL.
  3. Click on the Actions menu.
  4. Choose Enable SSL from the list.
  5. Confirm the action when prompted.

info

For MySQL, MariaDB, and PostgreSQL databases, the CA certificate is available for download from the DBaaS Details page after enabling SSL.If you are using a third-party application and are unable to establish a connection, ensure that SSL is enabled in the application settings and configure the SSL parameters according to the customer’s setup and requirements.