What is a data appliance?¶
[Update: June 13, 2019]
Information on Database appliance.
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.
For information on fees, please refer to Service site.
Even in the case of ref: Read replica <database-readreplica>, it is provided at the same cost as standard databases.
The functions provided by the Database appliance are as follows.
|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.
|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 .|
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.
A Database appliance can be produced and set up as follows.
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
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¶
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.
You can view the database’s information.
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.
View database settings.
View a list of obtained and stored backup data.
Confirmation is possible at the log. For details, please refer to :ref: Check log <data-base-about-log>.
View the database appliance resource graph.
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
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.
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.
- Key icon locked: Old backup data will not be automatically deleted with generation management. Only backup data with subsequent creation dates will be deleted.
To lock backup data, click the key icon.
The Key icon is in the locked state indicates that locking is complete.
Restore backup data.¶
Backup data can be restored to the current database from the menu located on the right of the backup data list
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.
The database system and RDBMS can be verified from the Log tab’s screen.
Displays error alerts of high severity such as when a database fails to start correctly, etc.
You can perform power operation when an error is recorded in the FATAL 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.
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,
the above two logs will be produced on August 9.
- 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.