--- title: Manage your Database sidebar_position: 2 --- # 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. ::: ---