linux installation of Damon database 8

PS. This test is only for the needs of the project, but a series of errors occurred when deploying and starting the program, which were recorded for future reference

Install Damon database

1. Introduction to DM8 Database

Dameng database management system is a high-performance database management system with completely independent intellectual property rights launched by Wuhan Dameng Company, referred to as DM. The latest version of Dameng database management system is version 8.0, referred to as DM8.

DM8 is a new generation of self-developed database launched by Dameng Company on the basis of summarizing the R&D and application experience of DM series products, adhering to the concept of openness, innovation, simplicity and practicality. DM8 absorbs the advantages of current advanced new technology ideas and mainstream database products, integrates the advantages of distributed, elastic computing and cloud computing, and makes large-scale improvements in flexibility, ease of use, reliability, and high security. The diversified architecture fully meets the needs of different scenarios, supports ultra-large-scale concurrent transaction processing and transaction-analysis hybrid business processing, dynamically allocates computing resources, and achieves more refined resource utilization and lower-cost investment. A database that meets the various needs of users, allowing users to focus more on business development.

2 Preparation of operating system environment

The system version used this time is CentOS Linux release 7.5.1804 (Core)

3. Upload the required documents

4. Create installation user dmdba and group dinstall, and set user password

[root@localhost ~]# groupadd dinstall
[root@localhost ~]# useradd -s /bin/bash -m -d /home/dmdba -g dinstall dmdba
[root@blocalhost ~]# passwd dmdba //You need to set a password here, which can be set to Admin12345

Enter twice successfully

5. Turn off SELinux

vi /etc/selinux/config

The red part is changed to disabled

6. Configure system resource limits for dmdba

cd /etc/security/limits.d
vi dmdba.conf

Put the following in it and save it

dmdba      soft    nofile  65536
dmdba      hard    nofile  65536
dmdba      soft    nproc   4096
dmdba      hard    nproc   63653
dmdba      soft    core  unlimited
dmdba      hard    core  unlimited

Press esc, then :wq! to save and exit

Log in to the system with the dmdba user and check whether the ulimit parameter takes effect: ulimit -a (Note: switch to the dmdba user for viewing)

su dmdba

7. Install DM8

Switch back to the root account, and the password for switching accounts is su

mkdir -p /opt/db/dm

chown -R dmdba:dinstall /opt/db/dm

chmod -R 775 /opt/db/dm

ll /opt/db

8. Unzip the file

cd /home/dm8
unzip     //If the error is reported here and no unzip is found, you need to use yum install unzip. If it is an offline environment, go to a binary package file for installation.

Mount the iso file, so that the iso image file can be accessed like a directory

mkdir -p /mnt/cdrom
mount /home/dm8/dm8_20220701_x86_rh6_64_ent/dm8_20220701_x86_rh6_64_ent_8.1.2.128.iso /mnt/cdrom

Copy the installer DMInstall.bin to the installation directory, and modify the user and group

cd /opt/db/dm
cp /mnt/cdrom/DMInstall.bin /opt/db/dm/

Next, execute the installer to install the database. There are two installation methods, one is graphical interface installation, and the other is command line installation.

Because this demo environment does not install a graphical interface when installing Linux, the command line is used to install it.

The graphical installation method is to execute the command: ./DMInstall.bin

The command line installation method is to execute the command: ./DMInstall.bin -i

To install DM, you must first switch to the dmdba user.

su - dmdba
cd /opt/db/dm
mkdir dmdbms

Start the installation, choose Chinese as the language, and do not enter the Key file first (there is no key file, it will expire after one year by default)

To set the time zone, select: [21]: GTM+08=China Standard Time, which is also the default option.

9. Start the installation

./DMInstall.bin -i

The following address is /opt/db/dm/dmdbms

After the installation is complete, you are prompted to execute the script with the root user

switch root user



10. Create a database instance

cd  /opt/db/dm/dmdbms/bin
./dminit PATH=/opt/db/dm/dmdbms/data DB_NAME=DMDB INSTANCE_NAME=DMDW PORT_NUM=5236

11 Script to register instance service

cd /opt/db/dm/dmdbms/script/root
./ -t dmserver -dm_ini /opt/db/dm/dmdbms/data/DMDB/dm.ini -p DMDW

12. Start the service

systemctl start DmServiceDMDW.service        //It takes a while here

Check whether the service process has been started (the green below means the startup is successful)

systemctl status DmServiceDMDW.service

12. Create a soft link

Dameng database provides a command line client tool disql (similar to oracle's sqlplus) for connecting to the database.

The disql tool is in the bin directory of the installation directory, you can add the bin directory to the environment variable PATH, and view the configuration file under the dmdba user

su dmdba
vi ~/.bash_profile
export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool   plug this in

take effect

source ~/.bash_profile

This way we can use the command to log in to the database anywhere


Switch root user to use soft connection

vi ~/.bash_profile

Insert the following data into the specified location

export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/opt/db/dm/dmdbms/bin"
export DM_HOME="/opt/db/dm/dmdbms"

export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool

take effect

source ~/.bash_profile

So far the Dameng database installation is complete

Tags: Linux

Posted by misteraven on Wed, 19 Oct 2022 11:07:39 +0300