| Line 51: | Line 51: | ||
=== Connect to Database(MariaDB) === | === Connect to Database(MariaDB) === | ||
You can access a database directly if necessary by the <code>mysql</code> command. | You can access a database directly if necessary by the <code>mysql</code> command. | ||
| − | If you want to access a database using "root", you must request an One Time Password (OTP) | + | If you want to access a database using "root", you must request an One Time Password (OTP)<ref>http://issue.basein.net</ref>. |
Revision as of 13:42, 20 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 dci 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 dci 0 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# dci create 2 127.0.0.1 configure# exit LYSH@MyHostName# show dci 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 configure# dci create 2 127.0.0.1 configure# exit LYSH@MyHostName# show dci 2
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].