What is a data appliance?

[Update: June 13, 2019]

Information on Database appliance.

1. Overview

The Database appliance is a virtual appliance that enables quick production of a data-base environment within the cloud through the control panel.
“This can be readily installed to develop small-scale services, development environments, etc.

Fees

For information on fees, please refer to Service site.

Note

Even in the case of ref: Read replica <database-readreplica>, it is provided at the same cost as standard databases.

Specifications

The functions provided by the Database appliance are as follows.

Specs

Plan name Specs Data capacity Number of simultaneous connections
10GB plan 1-core 2GB memory 10GB 100
30GB plan 2-core 4GB memory 30GB 100
90GB plan 4-core 8GB memory 90GB JPY 125
240GB plan 8-core 16GB memory 240GB JPY 150
500GB plan 8-core 16GB memory 500GB JPY 150
1TB plan 8-core 16GB memory 1,000GB JPY 150

*Data capacity is the maximum value for storage capacity. In some cases, however, the value may differ from the actual storage capacity. Regardless database engine type, the number of simultaneous connections is set to the same default value.

Details

Behavior at the time of fault If a fault occurs, the system will automatically restart with an automatic recovery pro-gram. For details, please refer to How is operation performed when a fault occurs at the host server?. Estimated recovery time: approximately 10 to 15 min (until the completion of the starting of the appliance.)
RDBMS PostgreSQL or MariaDB
Setting of a DB password You can set the user name and password for DB user.
Port number This can be set arbitrarily.
Restriction on client IP It can be specified with an IP address.
Web interface MariaDB (phpMyAdmin)
PostgreSQL 10 and later (pgAdmin)
PostgreSQL 9 and later (phpPgAdmin)
Backup It is possible to obtain a database’s backup data either manually at random, or automati-cally at a specified time. Auto Backup is compatible with generation management (8 genera-tions). Backup data will be stored in separately from the above data so as not to decrease data capacity.
Connected switch Connection destination to which a global IP address is given Router + switch
View the log. Function for viewing the database’s system log from the control panel.
Resource monitor You can check the amount of memory and disk usage from the Activity screen .

Attention

The time required for backup differs depending on the amount of data capacity being stored. Please specify settings for frequency and time period according to your usage.

For specifications of each RDBMS, please refer to the following page.

2. Usage procedures

A Database appliance can be produced and set up as follows.

New creation

Select Database from the menu on the left, and click Add at the upper right of the screen.

By selecting Backup, the backup function will be enabled and backup setting items will be displayed.

Compulsory input items

  • Select the database “PostgreSQL” or “MariaDB.”
  • Default user name
  • Password of the “default user”
  • Port number (which can be specified arbitrarily. The default number is 5432 Post-greSQL 3306 MariaDB.)
  • Source network

If Restrict Source IP Address is selected, the input form will be displayed as follows. Enter an IP address, and click the pop-up for registration.

  • WEB UI

Indicate if you are using phpPgAdmin/phpMyadmin, by selecting Yes or No

  • Backup

The time for obtaining backup data is specified.

  • Connected switch

Connect to – router + switch.

Select from global IP addresses assigned to the router + switch.

Connect to – switch.

Enter a private IP address.

Arbitrary input items

  • Name
  • Explanation
  • Tag
  • Icon

If the List screen is displayed after clicking the Create button, Resource Status is being copied

When copying is complete, the resource status will change to Available.

The control panel display is not updated automatically. Click Reload on the upper left.

Details screen

一覧画面に表示されている対象データベースの行をダブルクリックすると、詳細画面に遷移します。

Information tab

You can view the database’s information.

Hint

When creating an appliance, tags (@postgres-10, @MariaDB-10.1, etc.) corre-sponding to the database engine and version are automatically assigned. This is done to ensure ease of understanding for the user. Deleting or changing tags does not affect the behavior of the appliance or control panel.

Settings tab

View database settings.

Backup tab

View a list of obtained and stored backup data.

Log tab

Confirmation is possible at the log. For details, please refer to :ref: Check log <data-base-about-log>.

Activity tab

View the database appliance resource graph.

Change settings.

Selecting Change Database at the upper right of the Details screen to change the creat-ed database’s settings.

Items that can be changed are as follows.

Password Change the password of the default user.
Port number Change the port number used for accessing the database.
Source network Set the source network that permits the access to the database.
WEB UI You can enable or disable the management window via a browser.
Backup execution hours (daily) Set the daily Auto Backup start time.

Changing settings may prompt the database to restart, temporarily severing the connec-tion. We appreciate your understanding

How to use WEB UI

When WEB UI is to be used, either at the time of creation or at an alternate time as specified from the Settings screen the Web Management window for RDBMS can be opened by clicking WEB UI’s address link displayed in the Settings tab.

As a self-signed certificate is used, a Certificate for Access window will appear when you access a site. Please ensure the site is correct before accessing.

A WEB UI screen compatible with the selected database engine will be displayed.

How to use backup data

Database back up data can be managed and operated through the Backup tab.

Provided management functions are as follows

Acquire backup data.

Backup data can be obtained arbitrarily by clicking the Add button located at the bottom right of the screen.

*The time required for acquiring backup data varies according to the volume of data stored in the database.
“Please refrain from accessing the data inside the database at the time of back-up data acquisition.

Lock backup data.

Backup data is acquired at a designated time every day. If the number of acquired back-up generations exceeds the number specified in Generation Management, the oldest backup data will be deleted after acquisition of new backup data.
“It is possible to protect old data from automatic deletion by using the key icon, displayed at the left of the backup data list.

  • Key icon unlocked: Old backup data will be automatically deleted with generation man-agement.
../../_images/database-20.png
  • Key icon locked: Old backup data will not be automatically deleted with generation management. Only backup data with subsequent creation dates will be deleted.
../../_images/database-21.png

To lock backup data, click the key icon.

../../_images/database-22.png

Click Execute.

../../_images/database-23.png

The Key icon is in the locked state indicates that locking is complete.

../../_images/database-24.png

Restore backup data.

Backup data can be restored to the current database from the menu located on the right of the backup data list

../../_images/database-25.png

At the time of restoration, backup data of the current state will be produced, with select backup data subsequently loaded onto the database.

*The time required for acquiring backup data varies according to the volume of data stored in the database. During the restoration of backup data, the database will be periodically inaccessable.

Delete backup data.

Backup data can be deleted from the right menu of the backup data list.

../../_images/database-26.png

How to confirm logs

The database system and RDBMS can be verified from the Log tab’s screen.

systemctl

System log information of the database.

FATAL

Displays error alerts of high severity such as when a database fails to start correctly, etc.

Note

You can perform power operation when an error is recorded in the FATAL log.

DBMS Log

Log output can be confirmed by the database software and can be downloaded in log file format. Select Download a Log File from the control panel.

Methods for writing a log file varies according to DB engine. For every DB engine, a log stores the most recent 10 backup generations.
If an 11th log file is produced, the earliest recorded log file will be deleted.

PostgreSQL

If PostgreSQL engine has been selected, a log will be stored under the file name date-time of acquisition. For PostgreSQL, a new log file is created daily at 00:00. If a file exceeds 10MB, a new log file will be created, and surplus data will be saved in the new file.

“Example: If the size of a log file for a database created at 10:02 on August 9 exceeds 10MB at 11:16,

 [postgresql-20170809-100218.log]
 [postgresql-20170809-111648.log]

the above two logs will be produced on August 9.

MariaDB

For MariaDB, daily log files are not produced. Only when the log mariadb.log exceeds 10MB, will a log file be created and saved under the file name date-time of acquisition.

Cautions

  • Due to the update necessary to extend the functions of the database appliance, the sys-tem may be suspended without notice.
  • Neither acquisition of backup data nor the restoration function guarantee data integrity.
  • The log function is to be used by users. We do not analyze data on behalf of users.
  • Time is synchronized when the database engine in the appliance is restarted. If there is a discrepancy in the time information in the database, please temporarily stop and then restart the appliance.