Database Service home page

Selecting any of the database services from the Service name field takes you to the home page of that database service. Each database service has a separate home page with its statistics.

On the database service home page, the status of the database service is displayed below the service name along with number of dots indicating the number of instances for the database service. Next to status, you can view:

• Snapshot in progress - if a snapshot for the database service is in process. Hover over the Snapshot in progress, to view the details like snapshot id and whether it is a manual snapshot or scheduled.

• New Patch Available - if a patch is available from Tessell for the database service. Hover over the Patch Available to see which new versions are available for your DB Service. If you wish to run a patch on your service then select Patch Now. A Patch Database Engine Version window pops up where you can select the version of the database engine available from the drop-down list. After selecting the version of the database engine, select the Patch Database Engine Version check box and select Start Patch button at the bottom.

  • Submitting Request - if a patch application is in progress. Select Submitting Request to see the complete list of actiion in progress. First the request gets submitted to apply the patch. Next it will install the binaries.

  • Install Binaries - if a patch application is in progress. After submitting the request it installs the binaries for the newer version of the datbase to be applied. Next it will patch the database service instances.

  • Patching DB Service Instance(s) - if a patch application is in progress. After installing the binaries for the newer version it patches the database instances one by one if multiple. Next it will update the Tessell metadata.

  • Service Ready, updating Tessell metadata - if a patch application is in progress. At last it updates the Tessell metadata and the service is ready with the new updated version.

• Parameter Update Available - if a new version of paramter profile is available for the database service.

• Upcoming schedules - if a start/stop/delete schedule is coming up.

On the top right-side, you see the following options:

• Availability Machine - Click on this, to go to the Availability Machine home page of the database service. For more information, see Availability Machine home page.

• Dataflix - Click on this, to go to the Dataflix home page of the database service. For more information, see Dataflix home page.

• Start Service - Click on this, to start the database service. This option is available if the database service is stopped.

• Stop Service - Click on this, to stop the database service. This option is available if the database service is up and running.

• Ellipsis icon - Click on the ellipsis icon, for following actions:

  • Restore - Click on this option, if you need to recover the database service. The possible options are:

    • Snapshot - Select snapshot option, if you need to restore the database service to an automated or manual snapshots.

    • PITR - Select PITR option, if you need to restore to a particular point in time from the available continous data region.

    • Maximum Recoverability - Select this option, if you need to restore the database service to the last committed transaction.

  • Edit Service - Select Edit Service option, if you need to rename the database service, update the description of the database service, enable delete/stop protection or enable auto minor version update. For more information, see Edit the Service.

  • Resize - Select Resize option, if you need to update the storage, RAM, or CPU. For more information, see Compute Shapes to update the compute shapes and see Storage.

  • Change Parameter Profile - Select this option, if you need to update the parameter profile for the database service. A Change Parameter Profile window pops up. Select the new parameter profile from the drop-down list. Then select when to apply the changes. Two options are available:

    • Apply in upcoming maintenance window - Select this option, if you want to update the parameter profile in the upcoming scheduled maintenance window.

    • Apply immediately - Select this option, if you want to apply the changes immediately. This changes are applied asynchronously immediately, irrespective of the maintenance window schedule. View the Code from the bottom. The code is available in different languages like Shell, Python, Go, Java, JavaScript, and PowerShell. Select Apply button to apply the changes.

  • Delete - Select this option, if you need to delete the service. For more information, see Delete the service.

Summary

The top bar gives a summary of the database service. Click on the drop-down button on the right corner to view the complete details of the database service:

Cloud details

• Cloud — It provides the name of the cloud hosting your database service.

• Region — It provides the name of the cloud region hosting your database service.

• Availability Zone(s) — It provides the short name of the cloud region hosting your database service.

• Subscription — It provides the name of the subscription you selected from your account.

• VPC — It provides the name of your Virtual Private Cloud. The name of the VPC is unique per tenant.

Database engine details

• Software version — It provides the name and version of the database engine you selected for your database service.

• Parameter — It provides the name of the parameter profile selected for your database service. Click on the tooltip next to the profile name to view the complete information about all the parameters and their values for the assigned profile.

• Maintenance window — It provides the day and time scheduled for the maintenance of your database service.

• Edition — It provides the edition of the selected database engine for your database service.

Compute shape details

• Compute — It provides the selected compute shape for your database service. Click on the tooltip next to the shape to view the information about the compute shape.

• vCPUs — It provides the number of CPUs allocated for your database service.

• Memory — It provides the amount of memory allocated for your database service.

• Storage — It provides the amount of storage space allocated for your database service.

• Encryption — It provides the name of the encryption key assigned to your database service.

User details

• Owner — It provides the name of the owner of your Tessell account.

• My Role — It provides your role for the database service. The possible values are Owner, Co-owner, or Read-only.

• Date created — It provides the date and time when the database service was created.

• Running since — It provides the date and time since your database is up and running.

• Stopped since - It provides the date and time since your database is down and not running.

• TRN — It provides the Tessell resource name. The TRN is a globally unique name.