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. Every database service has a separate home page with its statistics.

Activities and updates

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

If a manual or an automatic snapshot for the database service is in process it will display the snapshot icon next to that status. Click on the icon to view the details of the Snapshot in progress.

Patching

If a patch is available from Tessell for the database service it displays New patch is available next to status. 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.

• Optionally, edit the number of instances to patch if the service has more than one instance. By default, all the instances are patched.

• Select the Patch Database Engine Version check box.

• Select Start Patch button at the bottom.

The request to apply the patch is updated and following steps takes place automatically:

• Request is submitted to patch the software for DB service instances from older version to new version.

• Installs the new binaries.

• Patches the DB Service Instance(s).

• Service is ready, and updates the Tessell metadata.

Parameter Update

If a new version of parameter profile is available for the database service, it displays Parameter Update available. Hover over the parameter update to see which new parameter profiles are available for the DB service. For more information, see change parameter profile.

Upcoming schedules

If a start/stop/delete schedule is coming up, it displays Upcoming schedules next to the status. Hover over the schedule to view the details of which schedule is coming up and what actions are scheduled.

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 restore the database service. You can do in-place restore or out of place restore. For restore, the possible options are:

• Snapshot - Select snapshot option, if you need to restore the database service to an automated or manual snapshots. It provides you the available snapshots lists with the timestamp. Select the snapshot, review the details of the selected snapshot like creation timestamp, size, number of databases, and the cloud details. Click on Select to Restore button at the bottom. Provide the Master Username and Master Password of the database service. Use the code button at the bottom to view the code in different languages like Shell, Python, Go, Java, Javascript, and PowerShell. Use copy button to copy the code and download button to download the code from the top-right corner. Use Close button at the bottom to return back to main window. Select Restore button from the bottom to restore the database service upto the selected snapshot time. It automatically performs the following steps:

  • Request is submitted to restore the database service upto given snapshot time

  • Create compute instance(s)

  • Configures the database

  • Availability Machine is setup

  • Triggers first snapshot

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

  • Pick a time to Restore your service on the Regions and Availability Zones

  • Click Select to Restore button at the bottm

  • Provide Master Username and Master Password of the database service

  • Use the code button at the bottom to view the code in different langauges like Shell, Python, Go, Java, Javascript, and PowerShell. Use copy button to copy the code and download button to download the code from the top-right corner. Use Close button at the bottom to return back to main window. Select Restore button from the bottom to restore the database service upto the selectime timestamp. It automatically performs the following steps:

    • Request is submitted to restore the database service upto given snapshot time

    • Create compute instance(s)

    • Configures the database

    • Availability Machine is setup

    • Triggers first snapshot

• 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, memory or number of CPUs. For more information, see Compute Shapes to update the compute shapes and see Storage. On the Resize compute page as you select the No of vCPUs, see the respective change in Select compute shape. Optionally, you can choose from Select compute shape drop down list to modify the settings. At the bottom, it displays the Estimated change in cost. Select the I understand the consequences, resize the compute check box. Use code button to view the code in different languages like Shell, Python, Go, Java, JavaScript, and PowerShell. Select Close button to return back to the main window and select Save. Automatically the following steps are taken:

• Submits the request with new settings

• Stops the databases

• Applies the new settings to the database

• Start the database

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.

• Read IOPS — It provides the maximum number of read operations allowed per second.

• Write IOPS — It provides the maximum number of write operations allowed per second.

• 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.