Skip to main content

Databases

Platform provides a set of scalable and fully manageable database servers that you can easily install and operate with. The process of a new database creation is fairly simple and can be accomplished in just a few minutes.

Create a Database​

  1. On the "Databases" page, click the "Add New" button to create a new Databases.

  2. Specify the "Project Name", the click the "Choose Region" button to select database region. Choosing a region determines where your database will be physically located. This can affect your data access speed and redundancy options.

  3. After selecting the region, you need to select the database engine. There are 3 different engine options, these are;

    1. SQL: SQL is ideal for relational databases
    2. NoSQL: NoSQL is more flexible and scalable
    3. Cache: Cache is used for speeding up data retrieval

  4. The database version determines the version of the software being used. Newer versions typically provide more features and security, but some older versions may offer better stability. Choose a version that fits your application needs.

    1. SQL: MySQL CE, MariDB, Percona, PostgreSQL
    2. NoSQL: MongoDB, Couchbase CE
    3. Cache: Redis

  5. After selecting the database version, you will be automatically directed to the page where you can customize the version. You can make the following customizations from this page;

    1. Auto-Clustering: Auto-clustering automatically adds or manages nodes to scale and optimize your database performance.
    2. Disk Limit: The recommended disk space for this database has been defined. You can customize the limit based on your storage needs.
    3. Public IPv4: Enable a public IPv4 address to allow external access to the database instance. Recommended only when secure connections are ensured.

  6. After making the customizations click "Create a Database" button.

  7. Enable the Cross Access Network: By enabling this feature, you can ensure secure and direct access from your virtual machines and kubernetes environments to DBP databases.

  8. Click to the "Create Database Cluster" button.

Managing Databases​

Effortlessly manage and optimize your database performance. Monitor critical metrics, ensure uptime, and perform quick adjustments to maintain smooth operations. Use advanced configuration options to meet your specific needs.

  1. On the "Databases" page, click on the database you want to edit.

  2. SSH Access:

    1. SSH Connection: Securely connect to your database using SSH for direct access. Perform administrative tasks, troubleshoot issues, and monitor system performance with full control. SSH provides an encrypted and secure connection for your database management needs.
    2. SFTP/Diirect SSH Access: Enable secure file transfer and direct SSH connections to your database environment. Transfer critical files, update configurations, and execute commands securely to keep your infrastructure running efficiently.

  3. Endpoints:

    1. Click "Add" button to create endpoints.
    2. On the "Add Endpoint" page, select the endpoint name in the drop-down list.
    3. After specify the name, select the endpoint protocol.
    4. Then click the "Add" button.

  4. Firewall:

    1. Overview: Firewall rules are used to define which inbound/outbound traffic is allowed to be processed by container.

    2. Inbound Rules: Inbound rules control the flow of incoming traffic to your database or application. By defining these rules, you can allow specific IP addresses, ports, and protocols to access your system while blocking unauthorized requests. This ensures a secure and filtered entry point for your infrastructure.

    3. Outbound Rules: Outbound rules define how traffic leaves your database or application to communicate with external services. By configuring these rules, you can restrict unnecessary outgoing connections and ensure only authorized communication happens, reducing the risk of data leaks and security breaches.

  5. Load Alerts:

    1. Settings: Customize your alert preferences to proactively monitor your database`s performance and respond to critical events. Set thresholds, notification channels, and specific triggers tailored to your operational needs.

    2. History: Review the history of alerts to track performance trends and analyze past incidents. Gain insights into how your database responds to various load conditions and optimize its behavior over time.

  6. Backup: Ensure the regular backup of your databases to minimize the risk of data loss. Create automatic backup plans, manage backup storage options, and ensure the system is always accessible.

  7. Scheduler: The scheduler, allows you to automate routine operations by specifying start and stop times for your environment. This helps optimize resource usage, reduce costs, and maintain operational efficiency. Configure schedules easily to align with your workflow and ensure seamless management of your resources.