Simple Installation

Installation on a Single Node

This section takes openEuler system as an example to introduce how to install MogDB on a single node.

Create directory, user, group, and authorize them.

groupadd dbgrp -g 2000
useradd omm -g 2000 -u 2000
mkdir -p /opt/software/mogdb
chown -R omm:dbgrp /opt/software/mogdb

Decompress the MogDB package to the installation directory.

su - omm
cd /opt/software/mogdb/
tar -jxf MogDB-x.x.x-openEuler-64bit.tar.gz -C /opt/software/mogdb/

Go to the simpleInstall directory.
```
cd /opt/software/mogdb/simpleInstall
```
Run the install.sh -w command to install MogDB.
```
sh install.sh  -w Enmo@123 &&source ~/.bashrc
```
NOTE:
- -w: initializes the database password (specified by gs_initdb). This parameter is mandatory for security purposes.
- -p: specifies the MogDB port number. If the port number is not specified, the default value 5432 is used.
- -h|--help: displays usage instructions.
- After the installation, the database name is sgnode (specified by gs_initdb).
- During installation, if error "the maximum number of SEMMNI is not correct, the current SEMMNI is xxx. Please check it." occurs, run the following command with root user permissions.
```
sysctl -w kernel.sem="250 85000 250 330"
```
- The installation path of the database directory is /opt/software/mogdb/data/single_node, in which /opt/software/mogdb is the decompression path and data/single_node is the newly created database node directory.
- After the installation, the database postgres is generated by default. It can be connected upon first connection.

After the installation is complete, check whether the process is normal by using ps and gs_ctl.

ps ux | grep mogdb
gs_ctl query -D /opt/software/mogdb/data/single_node

Run the ps command to display information similar to the following:

omm      24209 11.9  1.0 1852000 355816 pts/0  Sl   01:54   0:33 /opt/software/mogdb/bin/mogdb -D /opt/software/mogdb/single_node
omm      20377  0.0  0.0 119880  1216 pts/0    S+   15:37   0:00 grep --color=auto mogdb

Run the gs_ctl command to display information similar to the following:

gs_ctl query ,datadir is /opt/software/mogdb/data/single_node
HA state:
    local_role                     : Normal
    static_connections             : 0
    db_state                       : Normal
    detail_information             : Normal

Senders info:
    No information

 Receiver info:
No information

Use MogDB

-- Configure PATH
echo "PATH=/opt/software/mogdb/bin:\$PATH" >> /home/omm/.bash_profile
source ~/.bash_profile
-bash: ulimit: open files: cannot modify limit: Operation not permitted
(The default setting fd available size exceeds the system setting, you can ignore the setting)

-- Login to MogDB
gsql -d postgres -p 5432 -r
gsql ((MogDB x.x.x build 56189e20) compiled at 2022-01-07 18:47:53 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

mogdb=#

Installation on Primary/Standby Nodes

This section takes openEuler system as an example to introduce how to install MogDB on primary/standby nodes.