Servers
Servers app in the Infrastructure Management app family lets you manage your shared and dedicated servers for your database services. Server-level management allows you to control operations like compute resizing, starting/stopping, and setting maintenance windows individually for each server, instead of service level. Servers app enables role-based server management to prevent mismanagement in shared environments. It also enables centralized visibility and control of servers intended to host multiple DB Services.
Prerequisites
Ensure that you have created your server in the Provisioning application under the DB Services app family.
For more information on provisioning, see Provisioning an Oracle DB service.
Servers dashboard
On the left menu bar of Tessell portal, select Servers under the Infrastructure Management app family to view the Servers dashboard. This lists all the available servers on its dashboard. Users can see servers where they are granted consumer, co-owner, or owner privileges.
Dashboard filters have the following fields:
Search - Specify a name of the server to search for a specific server in the search bar. As you type, the list automatically filters and displays server names that match the characters you specify.
All Servers N - Select this filter to view a list of all the servers, both shared and dedicated. ‘N’ represents the total number of servers.
Shared N - Select this filer to view the list of shared servers. ‘N’ represents the number of shared servers. A shared server is created by selecting the option “Allow multiple services to be hosted on this server” option during provisioning.
Dedicated N - Select this filter to view the list of dedicated servers. ‘N’ represents the number of dedicated servers.
Subscriptions - You can choose a specific subscription from the dropdown list. By default, all the subscriptions added to your account (if you are the account owner) are listed. The available options are All, or the number of subscriptions added to your account or accessible to you depending on your role.
Cloud - You can choose a cloud provider from the dropdown list. By default, all the cloud providers are listed. The available options are All, AWS, Azure or GCP.
Engine - You can choose a database engine from the dropdown list. By default, all the database engines are listed. The available options are All, MySQL, Oracle, PostgreSQL, or SQL Server.
Status - You can choose a server status from the dropdown list. By default, all the statuses are listed. The available options are All, Running, or Stopped.
Owner - You can choose a specific username from the dropdown list to view the details of the server specific to the user. By default, all the servers that are shared with you are listed.
Servers table displays following columns:
Bulk sharing - A check box is provided before the Server Name column on the dashboard for bulk sharing of servers. Only users with owner or co-owner privileges can do bulk sharing of servers.
Select the servers to share with Data Owners in bulk for consumption. Upon selecting, you can view the number of selected servers and the Share button at the bottom center of the page.
Click the Share button to share in bulk.
The ‘Share N servers’ dialog box opens on the right-side, where ‘N’ is the number of selected servers.
Note:
Only the Consumer role can be assigned for bulk sharing of the selected servers. To share with a different persona or assign a different role, go to the Sharing tab of each server and complete the action individually.
Updating roles in bulk sharing does not override the existing roles on the selected servers.
In the search bar, specify the Data Owner names or select from the list to share.
Click Share at the bottom.
As an alternative method, use code to share the servers in bulk.
Use the Code button at the top-right corner to view the code in different languages like Shell, Python, Go, Java, Javascript, and PowerShell. You can also view the corresponding APIs.
You can copy or download the code using the respective buttons in the top-right corner.
Use the Close button at the bottom-right corner to return back to the main window.
Server Name - Displays the name of your servers on the servers page. Tessell auto-generates this name by using the server name given during provisioning. You can update this name in the Settings tab.
Status - Displays the current status of your server. It shows status Up when the server is up and running, Stopped when the server is stopped, or Down when the server is down.
Subscription - Displays the subscription you chose during provisioning your server. You can define and add the subscriptions as per your requirement using the Subscriptions app under the Governance app family.
Utilization - Displays the server’s memory utilization in percentage. This also displays the memory utilization bar for current memory usage. The bar turns from green to orange when the memory is almost full and turns red when usage reaches 100%.
DB Instances - Displays the number of database instances running in the server.
Region/AZ - Displays the cloud region and availability zone you chose for your server during provisioning.
Compute - Displays the compute shape you chose for your server during provisioning. You can also view the number of vCPUs and memory available in this compute shape.
Created - Displays the creation date and time of your server. It also displays the username that was used to log in to the Tessell portal and create the server.
Ellipsis icon - Using this option you can delete the server, this option is available when no instances are attached to the server.
Figure 1 - Servers dashboard
Servers home page
Selecting any of the servers from the dashboard takes you to the home page. On the top, you can view the server name along with the server type whether shared or dedicated, and its status.
Below the server name, you can view further information such as the database engine selected for the server, cloud subscription, cloud region and availability zone, and a More Info icon that gives a summary of the server.
Following details are displayed when you click More info icon:
Cloud details
Cloud - Displays the cloud provider selected for your server.
Region - Displays the cloud region selected for your server.
Availability Zone - Displays the availability zone selected for your server.
Timezone - Displays the timezone selected for your server.
Subscription - Displays the cloud subscription selected for your server.
Compute details
Compute - Displays the selected compute shape for your server.
vCPUs - Displays the number of vCPUs allocated for your server.
Memory - Displays the amount of memory allocated for your server.
Available memory - Displays the amount of available memory out of allocated memory for your server.
Engine details
Engine - Displays the database engine selected for your server.
Software release - Displays the major database software version selected for your server.
Software versions - Displays the minor database software version selected for your server. For shared servers, this displays a list of software versions selected for each database instance in the server.
Network
VPC - Displays the VPC network selected for your server. Click the tooltip next to it to view the subnet information.
Port - Displays the database port number selected for communication on your server.
Publicly available - Displays whether connection to the database is publicly available via public IPs.
General details
Created by - Displays the username who created the server.
Created on - Displays the creation date and time of the server.
TRN - Displays the Tessell resource name. The TRN is a global unique id and can be used in operating servers through Tessell Rest APIs. You can copy the TRN using the button next to the TRN name.
At the top right-side of the home page, following options are displayed:
Stop the server - Select this option to stop the server during non-working hours. This option is available when the server is running and all the database service instances are stopped. Stop functionality is supported for shared servers managing multiple services. For dedicated servers, you have to stop the server along with the database service in the My services page of that DB service.
Start the server - Select this option to start the server. This option is available when the server is stopped.
Select the ellipsis icon (︙) for the following options:
Restrict provisioning - Select this option to prevent users from provisioning new database services. If you restrict, existing services can continue to run without any interruption.
Allow provisioning - This option is available when the provisioning is restricted. Select this option to allow users provisioning new database services.
Resize - Select this option to resize the compute shape of your shared server. This is a downtime operation. For a dedicated server, resize is done at the database service level.
Note: The resize operation is supported for servers that host database services with either a single instance or DR/RR instance.
To resize:
Drag the slider to select the No. of vCPUs, see the respective change in Compute shape dropdown list.
Choose a compute shape from the Compute shape dropdown list.
Select the I understand the consequences and consent to resize the server’s compute shape check box.
Click Submit.
Delete server - Select this option to delete the server. To delete a server, you should delete all the attached database service instances before attempting to delete a server.
Overview
The Overview tab offers a comprehensive look at various components, including the compute shape, network connectivity, active database services, and scheduled maintenance windows.
At the top of the Overview tab, following options are displayed depending on server type:
For a shared server:
Provision Another Service - Selecting this option takes you to the Provisioning application to provision another database service in the shared server.
Share Server - Selecting this option takes you to the Sharing tab of the servers app.
For dedicated server:
Convert to a Shared Server - Selecting this option converts your dedicated server to a shared server.
Server Insights
Details
Compute Shape - Displays the compute shape you chose for your server during provisioning. You can also view the number of vCPUs and memory available in this compute shape.
Description - Displays the description given to your server, you can change this description in the Settings tab of Servers app.
Connectivity
Port - Displays the database engine specific port given during provisioning which is used to connect to the database services hosted in the server.
SSL - Displays whether SSL connection is enabled or disabled for your database services hosted in the server.
Public Access - Displays whether public access is enabled or disabled for your database service hosted in the server.
Allowed IP Address - Displays a list of allowed IP addresses mentioned during provisioning.
Database Services
The Database Services section displays the number of attached database instances. Additionally, it displays the role of those instances, which can be Primary, Fail Over, Disaster Recovery (DR), or Read Replica.
Monitoring
The Monitoring section displays the amount of memory used out of allocated memory. This also displays the memory utilization bar for current memory usage. The bar turns from green to orange when the memory is almost full and turns red when usage reaches 100%.
Upcoming Maintenance Window
This section displays whether any maintenance window is scheduled for the server. You can add or update the maintenance window from the Settings tab of Servers app.
Quick Actions
VM Access
Customers hold complete ownership and control over the VM and the entire infrastructure. However, for continued delivery of optimal services, Tessell recommends that you refrain from manually altering configurations. This option provides the visibility on VM accesses to Tessell.
For a shared server, you can request VM access for your server through this option. After the request is approved, the access to your VM is enabled.
For a dedicated server, you can request VM access directly from the My services page of that particular database service.
This access is enabled via a bastion host which you need to deploy either in the same network as the server or in a network which has access to the server subnet.
To request VM access, click Request.
The ‘Request VM access’ dialog box opens.
Choose a duration in hours from the dropdown list.
Specify the reason for access.
Specify the allowed IP addresses to connect to your VM.
Only private IP addresses are allowed. This is the IP of the bastion host as described previously.
Click Request.
After the request is approved, click Connect and download the access key.
Use the access key provided in the downloaded folder to access your VM.
After the VM access is enabled, ellipsis icon provides following options:
View details - Displays the details of your VM access including duration, reason, and allowed IP addresses.
Withdraw access - Selecting this option revokes your access to the VM. If you need access again, a new request is required.
Extend duration - Selecting this option allows you to extend the duration of your VM access.
VM Access for Tessell Support
This feature enables Tessell support to assist with troubleshooting and maintenance on your server VM. After you approve the VM access request, Tessell support can log in to the server VM(s).
To disable the access, select the Withdraw access option from the ellipsis icon.
Figure 2 - Servers home page and Overview tab
DB Services
The DB Services tab lists all the DB services hosted in the server along with their details.
Following filters are displayed in the DB services tab:
Search - Specify a name of the DB service to search for a specific service in the search bar. As you type, the list automatically filters and displays service names that match the characters you specify.
Status - You can choose a DB service status from the dropdown list. By default, all the statuses are listed. The available options are All, Up, or Stopped.
Owner - You can choose a specific username from the dropdown list to view the details of the DB service specific to the user.
DB services table displays following columns:
DB Service - Displays the DB service name you assigned during provisioning.
Instance - Displays the role of your instance. The possible values are Primary, HA Replica (Automatic Failover), RR (Read Replica), and DR (Disaster Recovery). Below the role is the name of your instance.
Status - Displays the current status of your DB service. It shows status Up when the service is running or the status Stopped if the service is stopped.
Parameter Profile - Displays the name of the parameter profile selected for your DB service at the time of provisioning. Below the name, you can view if the parameter profile is in-sync or out-of-sync.
Allowed IPs - Displays the client IP addresses from which connection requests are accepted. This provides access only for the database port.
Owner - Displays the username of the user who created the database service.
Figure 3 - DB Services tab
Monitoring
The monitoring tab offers an overall view of your server’s metrics that include CPU usage, memory usage, network usage, and so on.
To view specific monitoring metrics charts together, use the search bar and select from the list.
You can manually refresh metrics using the refresh button on the right.
For a specific duration, select time intervals of 1h, 3h, 6h, 12h, 1d, 3d, or 1w to display the data for that duration on each graph. The default time interval is 1h. The graphs display the averaged values for the selected period.
For custom time duration:
Select the Custom option, choose your desired date and time range, and click Apply.
The graphs explained below display the most recent metrics for your server. To examine the graph on a specific section, select and drag on the graph using the cross-hair cursor.
CPU Usage - This graph displays the server’s CPU usage in percentage values, sampled at 10-minute intervals by default.
The Used (latest): N value is displayed at the top left-side of the graph where N is the latest CPU percentage used.
The Min, Max, and Avg values are displayed at the top-center in the graph.
System Load Average - This graph displays the amount of system load average for the server as a count in the interval of 10-minutes by default.
Displays the system load average for every one minute, five minutes, and fifteen minutes using three different colors in the same graph.
Displays ‘1 min (latest): N’, ‘5 min (latest): N1’, and ‘15 min (latest): N2’ where N, N1, and N2 are the system load average counts in numeric value for one minute, five minutes, and fifteen minutes at the top of the graph respectively.
The Min, Max, and Avg values are displayed at the top-right in the graph.
Memory Usage - This graph displays the details of used and available memory in GiB for your server at a 10-minutes interval by default.
Displays the used and available memory charts using two different colors in the same graph.
Displays ‘Used (latest): N’ and ‘Available (latest) N1’ values where N and N1 are the amount of used and available memory in GiB at the top of the graph.
The Min, Max, and Avg values are displayed at the top-right in the graph.
Swap Usage - This graph displays the details of used and free swap area in GiB for your server at a 10-minutes interval by default.
Displays the used and free swap area charts using two different colors in the same graph.
Displays ‘Used (latest): N’ and ‘Free (latest): N1’ values where N and N1 are the amount of swap area used and free available in GiB at the top of the graph.
The Min, Max, and Avg values are displayed at the top-right in the graph.
Network Usage - This graph displays the details of sent and received data across the network in MiB/s for your server at a 10-minutes interval by default.
Displays the sent and received data charts using two different colors in the same graph.
Displays ‘Sent (latest): N’ and ‘Received (latest): N1’ values where N and N1 are the amount of sent and received data in MiB/s at the top of the graph.
The Min, Max, and Avg values are displayed at the top-right in the graph.
Top Processes by CPU - This table displays the processes that are using the most CPU time.
Displays three columns, Process ID (PID), Processes, and the average value in percentage of the CPU used. These process details are independent of the time range. This graph displays only the current data and not the older data.
Top Processes by Memory - This table displays the processes that are using the most amount of the memory.
Displays three columns, Process ID (PID), Processes, and the average value in percentage of the memory used. These process details are independent of the time range. This graph displays only the current data and not the older data.
Figure 4 - Monitoring tab
Integrations
The Integrations tab provides information about the third-party integrations enabled for your server.
Prerequisite:
Ensure that you have added integration endpoints in the DB Governance application under the Governance app family.
If there are any active integrations with the server, these are displayed at the top under the Active Integrations section.
You can configure following integrations under Add New section:
Qualys - Qualys is a cloud-based security and compliance platform. It has modules for vulnerability management (VM), continuous host and configuration scanning, web app scanning, and policy compliance. You can bring your own Qualys account and enable it to integrate with your server running on Tessell Portal.
Splunk - Splunk gives centralized visibility and analytics over all logs and events, which improves security, troubleshooting, SLA monitoring, and capacity planning. You can bring your own Splunk account and enable it to integrate with your server running on Tessell Portal.
To configure an integration:
Click Configure next to the integration. Before the configure button, it shows ‘N Option Available’ where N is the number of endpoints available for integration.
In the integration dialog box, choose an endpoint from the dropdown list.
Click Add to add the integration.
As an alternative method, use the code to configure an integration:
Use the Code button at the bottom-left corner to view the code in different languages like Shell, Python, Go, Java, Javascript, and PowerShell. You can also view the corresponding APIs.
You can copy or download the code using the respective buttons in the top-right corner.
Use the Close button at the bottom-right corner to return back to the main window.
Figure 5 - Integrations tab
Events
Events tab displays a vertical timeline of events. Each event includes a circle with a dot indicating an event. The most recent event is displayed at the top, and events are listed in descending chronological order, with the oldest event appearing at the bottom.
This tab presents a complete log of server events, detailing actions such as server creation, starting, and stopping. Each entry includes the date and time of the event, the specific action performed on the server, and the username of the user responsible for that action.
Sharing
The Sharing tab allows you to share your servers with other users. You can assign either Co-owner or Consumer roles.
All the personas who have access to Servers app can be made Co-owner for a server.
All the personas who have access to servers consumption access and not the servers access get Consumer role.
Data Owners with a Consumer role automatically receive read-only visibility of the server.
To share a server:
Click Share on the bottom-center corner of the empty page. If the server is shared with users, the Share button appears on the top-right corner.
The ‘Share Server’ dialog box opens.
Choose a role from the dropdown list, possible values are Co-owner and Consumer.
To grant access, add users from the dropdown list.
Only users with Infra Admin or Data Owner roles appear depending on the role chosen in the dropdown list.
Note: Users and roles are managed in IAM application under the Governance app family.
Click Share.
After the users are added in the Sharing tab, following filters are displayed:
Search: Specify a username to search for a specific user in the search bar. As you type, the list automatically filters and displays users that match the characters you specify.
Role: You can choose a role from the dropdown list. By default, all the roles are listed. The available options are All, Co-owner, or Consumer.
Table displays following columns:
User - Displays a list of usernames with whom the server is shared.
Role - Displays the user's defined role, which can be either Co-owner or Consumer.
Click the ellipsis icon on the right-side of the user details to see following options:
Change Role
Click this option to change the role of a user.
A dialog box pops up with the list of roles.
Select the role from the dropdown list, possible values are Co-owner and Consumer.
Click Update.
Remove User
Click this option to remove the user from sharing.
A dialog box pops up with confirmation to remove the user.
Click Remove.
Settings
The Settings tab provides options to modify your server’s attributes post creation. You can edit the server name and description, add resource tags, and schedule maintenance windows.
General
Server name - You can edit the server name in this field. You can choose a name that is suitable for your organization.
Description - You can edit the server description in this field. By default, the server's name is given as the description.
Resource Tags - Under Resource Tags, click +Add, then provide a name and value for your server's resource tag. Tags enhance server management and enable users to monitor usage, establish ownership, and implement policies more efficiently.
Additional settings
To enable delete protection, toggle the Delete Protection switch. It is disabled by default. Enabling this option helps to safeguard against accidental server deletes.
To enable stop protection, toggle the Stop Protection switch. It is disabled by default. Enabling this option helps in preventing unintended stoppage of the server ensuring continuous availability of the databases.
Maintenance Window
If any maintenance is scheduled, it is displayed under the Current Schedule.
Select Window
To update the displayed current maintenance schedule, select from the options Monthly or Weekly.
For monthly schedules, specify a day in the range (1-31) in the Start On field.
For weekly schedules, select the day from the Start Day dropdown list.
Specify a time in HH:mm format in the Start Time field.
Specify the duration (in 30-minutes increments) in the Duration field.
To enable auto minor version updates for servers during this maintenance window, toggle the Enable auto minor version update switch. It is disabled by default. It updates your servers during this maintenance window whenever a minor patch is released.
Click Save.
No Preferences
Choose this option if you do not require a specific maintenance window. Maintenance tasks are instead performed during the default maintenance window set by Tessell.
Figure 6 - Settings tab
Last updated
Was this helpful?