# Data Store Detail

* On the **Data Stores** page, click the **Details** button.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.16%20Data%20Store%20Details.png" alt=""><figcaption><p>Data Stores Page - Details</p></figcaption></figure>

## Overview Tab

* On this **Overview** tab, user can view detailed informations from the data store. All informations are include of state of services, cloud, general information, network, and instance information.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.17%20Overview%20Tab.png" alt=""><figcaption><p>Overview Tab - Data Store Informations</p></figcaption></figure>

## Services Tab

* On this **Services** tab, user can view detailed of database connection information. All information including public IP to access database from external network, status, type/role/permissions, and connection informations. The user needs to click on the link to display the username and password for access to database.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.18%20Services%20Tab.png" alt=""><figcaption><p>Services Tab</p></figcaption></figure>

You can add datastore, here are the steps to add a datastore:

* On the Services tab page, click Add Service.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/3.1%20add%20services.png" alt=""><figcaption><p>Add Datastore (a)</p></figcaption></figure>

* Select Instance, Storage, Storage Size automatically according to your needs, then click the Add Service button.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/3.2%20add%20services.png" alt=""><figcaption><p>Add Datastore (b)</p></figcaption></figure>

* Your new service is deploying notification appears and wait for the deploy process to finish.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/3.3%20add%20service.png" alt=""><figcaption><p>Add Datastore (c)</p></figcaption></figure>

* The datastore has been deployed, so it's ready to use.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/3.4%20add%20services.png" alt=""><figcaption><p>Add Datastore (d)</p></figcaption></figure>

## Monitoring Tab

* On this **Monitoring** tab, users can see detailed data store usage information. The Monitoring tab displays the usage of (1) Chart set from the System or from the Database node, (2) IP Host used, (3) Present ranges users can choose the time range to be displayed, and (4) Slide On/Off button to Auto Refresh every 30 seconds.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.19%20Monitoring%20Tab.png" alt=""><figcaption><p>Monitoring Tab</p></figcaption></figure>

* When clicked **System** displays the usage of load average, CPU, RAM, network, disk space, disk IO utilization, disk IOPS, and disk throughout. Users can categorize the monitoring view of the metric graph by clicking on the available filter buttons.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.19%20Monitoring%20Tab-System.png" alt=""><figcaption><p>Tab Monitoring - System</p></figcaption></figure>

* When clicked On **Database Nodes** displays the use of handler stats, handler transaction stats, database connections, queries, scan operations, table locking, temporary tables, sorting, and aborted connections. Users can categorize the graph view monitoring the metric graph by clicking on the available filter button.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.19%20Monitoring%20Tab-DN.png" alt=""><figcaption><p>Tab Monitoring - Database Nodes</p></figcaption></figure>

## Query Stats Tab

* On this **Query Stats** tab, user can see the information of the current database connections and the latest running query of database.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.20%20Query%20Stats%20Tab.png" alt=""><figcaption><p>Query Stats Tab</p></figcaption></figure>

## Users and Databases Tab

* On this **Users and Databases** tab, user can add the connection assistant, user, and database in the data store manually by fill in the form.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.21%20Users%20and%20Databases%20Tab.png" alt=""><figcaption><p>Users and Databases Tab</p></figcaption></figure>

* Click on **Connection Assistant** button to add the connection assistant for database.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.22%20Connection%20Assistant.png" alt=""><figcaption><p>Connection Assistant</p></figcaption></figure>

* Fill in the **Connection Assistant** form.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.23%20Configure%20Connection%20Assistant.png" alt=""><figcaption><p>Form Create Connection Assistant</p></figcaption></figure>

<table><thead><tr><th width="201">Column</th><th>Description</th></tr></thead><tbody><tr><td><strong>Account</strong></td><td>Choose the database user account.</td></tr><tr><td><strong>Database Name</strong></td><td>Choose the database name.</td></tr><tr><td><strong>Host</strong></td><td>Choose the database host.</td></tr><tr><td><strong>Technology</strong></td><td>Choose the technology of database connectivity. The technology can be selected by one of these following vendors:<br>- DSN<br>- ADO.NET<br>- JDBC<br>- NODE.JS<br>- ODBC<br>- PHP<br>- PHP.PDO<br>- PHP.PEAR.DB</td></tr><tr><td><strong>Connection String</strong></td><td>Connection string is a string that specifies information about a data source and the means of connecting to it.</td></tr></tbody></table>

* Click on **Create New User** button to add a new user to the database.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.24%20Create%20New%20User.png" alt=""><figcaption><p>Create New User</p></figcaption></figure>

* Fill in the **New User** form.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.25%20Create%20New%20User.png" alt=""><figcaption><p>Create New User</p></figcaption></figure>

<table><thead><tr><th width="217">Column</th><th>Description</th></tr></thead><tbody><tr><td><strong>Username</strong></td><td>Add the username for new user.</td></tr><tr><td><strong>Password</strong></td><td>Add the password for new user.</td></tr><tr><td><strong>Allowed Host</strong></td><td>Enter IP Address for database access.</td></tr><tr><td><strong>Database Name</strong></td><td>Choose the database for new user.</td></tr><tr><td><strong>Admin User Toggle</strong></td><td>User can enable or disable the toggle based on their needs. If the toggle is enable, the database privileges will set automatically for admin user.</td></tr><tr><td><strong>Database Privileges</strong></td><td>The limitation of user capability to manage databases as follows:<br>- SELECT<br>- INSERT<br>- DELETE<br>- Update<br>- DROP<br>- CREATE<br></td></tr></tbody></table>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.26%20User%20List.png" alt=""><figcaption><p>List of Users</p></figcaption></figure>

* Click on **Create New Database** button to add new database.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.27%20Create%20New%20Database.png" alt=""><figcaption><p>Create New Database</p></figcaption></figure>

* Fill in the **New Database** form.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.28%20Create%20New%20Database.png" alt=""><figcaption><p>Create New Database Form</p></figcaption></figure>

| Column            | Description                |
| ----------------- | -------------------------- |
| **Database Name** | Add name for new database. |

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.29%20Database%20List.png" alt=""><figcaption><p>Database List</p></figcaption></figure>

## Backups Tab

* **Backups** tab is purpose to create a copy of data store that can be **Restore** in the event of a primary data updated.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.30%20Backups%20Tab.png" alt=""><figcaption><p>Backups Tab</p></figcaption></figure>

* **Restore** is purpose to copying the backup data from secondary storage and restore it to it's original version before data updated.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.31%20Restore.png" alt=""><figcaption><p>Restore</p></figcaption></figure>

* If the user surely to restore their data store, confirm it by click on **OK** button, then click on **Restore** button.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.32%20Restore%20Backup%20Confirmation.png" alt=""><figcaption><p>Restore Backup Confirmation</p></figcaption></figure>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.33%20Restore%20Backup.png" alt=""><figcaption><p>Backup Information</p></figcaption></figure>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.34%20Restore%20Backup%20Confirmation.png" alt=""><figcaption><p>Restore Confirmation</p></figcaption></figure>

* If restoring backup is about to running there will be a notification dialog appears.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.35%20Restore%20Backup%20Notification.png" alt=""><figcaption><p>Restore Backup Notification</p></figcaption></figure>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.36%20Restore%20Backup%20Running.png" alt=""><figcaption><p>Running Restore Backup</p></figcaption></figure>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.37%20Restore%20Backup%20Finished.png" alt=""><figcaption><p>Restore Backup Finished</p></figcaption></figure>

## Firewall Tab

* **Firewall** is a tools use for database security access, by setting or add the trusted IP source to their device, user can get access to the database without any warning.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.38%20Firewall%20Tab.png" alt=""><figcaption><p>Firewall Tab</p></figcaption></figure>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.39%20Create%20Trusted%20Source.png" alt=""><figcaption><p>Create Trusted Source</p></figcaption></figure>

* Fill in the **Create Trusted Client Source Address** form, and then click the **Create** button.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.40%20Add%20IP%20Source.png" alt=""><figcaption><p>Add a Trusted IP Address</p></figcaption></figure>

<table><thead><tr><th width="182">Column</th><th>Description</th></tr></thead><tbody><tr><td><strong>Source</strong></td><td>IP Address of trusted source device.</td></tr><tr><td><strong>Description</strong></td><td>Description of the trusted source device. It's optional for user to fill in the description field. The description can contain up to 255 characters. The allowed characters are a - z , A - Z , 0-9 spaces , and ._ : / ( ) # , @ [ ] + = ; ! $*</td></tr></tbody></table>

* If IP Address succesfully added there will be a notification dialog appears.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.41%20Trusted%20Source%20Successfully%20Added%20Notification.png" alt=""><figcaption><p>Successful Notification</p></figcaption></figure>

* If user want to delete the trusted source, click on **Trash** icon.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.42%20Delete%20Trusted%20Source.png" alt=""><figcaption><p>Delete Trusted Source</p></figcaption></figure>

* Click on **OK** button to delete confirmation.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.43%20Delete%20Confirmation.png" alt=""><figcaption><p>Delete Confirmation</p></figcaption></figure>

* There will be notifications appear if the trusted source succesfully deleted.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.44%20Delete%20Successful%20Notification.png" alt=""><figcaption><p>Successful Notification</p></figcaption></figure>

## Settings Tab

* On this **Settings** tab, user can set up the data store informations like data store name, maintainance, and backup schedule.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.45%20Settings%20Tab.png" alt=""><figcaption><p>Settings Tab</p></figcaption></figure>

* Edit the field to update settings, and then click the **Save** button. **For Example**, the data store name will change from **College** to **University** and the schedule backup is enable as the incremental.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.46%20Update%20Data%20Store%20Name.png" alt=""><figcaption><p>Settings - Update Data Store Name</p></figcaption></figure>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.47%20Enable%20Incremental%20Backup%20Schedule.png" alt=""><figcaption><p>Settings - Enable Incremental Backup Schedule</p></figcaption></figure>

* There will be a notification if the settings of data store is succesfully updated.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.48%20Update%20Settings%20Successful%20Notification.png" alt=""><figcaption><p>Settings - Successful Notification</p></figcaption></figure>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.49%20Data%20Store%20Updated%20List.png" alt=""><figcaption><p>Data Store List</p></figcaption></figure>
