Managing services

To manage a database service, hover over the ellipsis icon (︙) at the right corner of the service. This icon gives options to Stop, Edit, or Delete the service.

These options are also available on the database service home page.

Stop the service

1. Select Stop to stop the database services. On selecting this option, a window pops up reminding you that stopping the service disconnects all the sessions.

2. Optionally, you can add comments to provide details regarding your action to stop the database service. Also, there is a check box asking “Are you sure you want to continue?”.

3. After you select the check box, the Stop button gets enabled.

4. Select the Stop button to stop the database service. The status of the database service changes to Stopping, the status turns to Stopped after the database service is completely stopped. After your database service is stopped, you can see the option to Start the database service on the ellipsis icon.

   Note:

   • This option is unavailable when stop protection is enabled.

   • Both the database and the VM are stopped if there is only one service.

   • In a multi-service deployment, only the database is stopped, not the VM.

   • To optimize your database costs, you can stop the service for activities such as daily development, testing, and training.

   • Stop operation is not allowed if a DR instance is added to the database service. Tessell’s service management is designed to ensure data integrity and replication continuity between primary and standby instances. DR is an asynchronous replica compared to synchronous on HA set-up. Hence the stop option is disabled for DR configuration.

Edit the service

1. Select Edit to edit the database service. The Edit service window pops up that allows to:

   • Edit the name of the database service.

   • Edit the description of the database service.

   • To enable delete protection, toggle the Enable delete protection button. It is disabled by default. When you enable this option, it does not allow you to delete the database service. This helps to safeguard against mistaken deletes.

   • To enable stop protection, toggle the Enable stop protection button. It is disabled by default. When you enable this option, it does not allow you to stop the database service.

   • To disable auto minor version update, toggle the Enable auto minor version update button.

     Note: Enabling auto minor version update functionality is a planned feature.

After the required edits, click the Update button to apply the changes.

Delete the service

1. Select Delete to delete the database service. The Delete confirmation window pops up with the warning “This action cannot be undone. Please read carefully”. It gives you the option “Do you want to retain the Availability Machine?”.

2. If you choose Yes, the Availability Machine is retained and only the database service is deleted.

   • Service Availability Machine and Azure/AWS Netapp files volumes are retained and one snapshot is taken before the service is deleted.

   • Manual snapshots are retained, automated snapshots and transaction logs are deleted as per the SLA.

   • Data access policies are retained until they are manually deleted.

3. If you choose No, the Availability Machine and the database service both are deleted. Also, all the existing snapshots, data access policies, and logs of the database service across all the regions are deleted.

4. Optionally, you can add comments to provide any details regarding the action.

5. For a multi-service VM, only the database service and its related storage are deleted, the VM stays as is. You can delete the VM from the Servers app after all the databases on that VM are deleted.

6. For a single service VM, both the database and underlying VM are deleted as part of this operation.

Note: This option is unavailable when delete protection is enabled.