| Line 55: | Line 55: | ||
If you want to access a database using "root", you must request an One Time Password (OTP)<ref>http://issue.basein.net</ref>. | If you want to access a database using "root", you must request an One Time Password (OTP)<ref>http://issue.basein.net</ref>. | ||
| + | You should bear in mind that accessing the Database should be only for the purpose of maintenance or fixing problems. | ||
=== References === | === References === | ||
Revision as of 17:51, 22 April 2021
Database Connection Properties
The imRAD use the MariaDB server[1]. If you run the show system mariadb command, it shows the version of the Database.
All Database Connection Properties are securely encrypted. If you want to see properties as plaintext, use the show database property command.
The imRAD consists of three types of Database Connection Properties.
| ID | Name | Description |
|---|---|---|
| 0 | MainDB | It is the properties for imRAD main database. If there are two systems for the purpose of the System Failover, one of them is the main system. In other words, an active system is the main system and it has the main database. |
| 2 | LocalDB | It is the properties for local database. |
| 3 | PeerDB | If you configure the System Failover, these properties are written. If not, no properties for the type 3 exist. |
Note that the leading five characters of the password are marked to * for the purpose of security.
LYSH@MyHostName# show database property 0 // Display the database connection properties of the MainDB (1) Host:127.0.0.1 Port:6710 User-id:lyon User-Password:*****y@nu24
Configuring Database Connection Properties
You can configure the host of Database Connection Properties. However, you don't need to configure because If you configure the System Failover, the properties for other types are set automatically. Therefore, If there's no problem, DO NOT configure the Database Connection Properties.
LYSH@MyHostName# configure configure# database property create 2 127.0.0.1 // Configuring the host of the LocalDB(2) to 127.0.0.1 configure# exit LYSH@MyHostName# show database properties 2 // Display the database connection properties of the LocalDB(2)
Configuring Database backup
You can configure to have the system can backup the database. Note that the imRAD is already enabled to backup the database. The default configuration is
- db_backup_interval=1
- db_backup_hour=3
- max_db_backup_file=5
The above configurations mean that the system backup the database at 3 o'clock every 1 day and remain only a recent 5 backup files. In other words, if there are more than 5 backup files after backup, the oldest one is removing.
LYSH@MyHostName# show system backup // view the current database backup configuration LYSH@MyHostName# configure configure# database backup enable // enable database backup configure# database backup disable // disable database backup configure# database backup hour 5 // Configure the starting hour of database backup configure# database backup interval 2 // Configure the database backup interval in days configure# database backup maxfile 3 // Configure the maximum number of database backup files to keep
If you type show files dbbackup, it lists all backup files.
Connect to Database(MariaDB)
You can access a database directly if necessary by the mysql command.
If you want to access a database using "root", you must request an One Time Password (OTP)[2].
You should bear in mind that accessing the Database should be only for the purpose of maintenance or fixing problems.