Prerequisites

Supported platforms and operating systems

OpenSQL 3.0 can be installed and operated on the following hardware and operating system environments

HW/SW	CPU	OS	Binary Bits
GNU	x86	Oracle Linux 8 Oracle Linux 9 Rocky Linux 8 Rocky Linux 9	64bits

---

System software requirements

To compile and run OpenSQL 3.0, the following system software and library packages must be installed in advance.

Package name	Version
make	4.2.1
gcc	8.5.0
gcc-c++	8.5.0
clang	18.1.8
clang-devel	18.1.8
llvm	18.1.8
llvm-devel	18.1.8
llvm-libs	18.1.8
libstdc++-devel	8.5.0
zlib	1.2.11
readline	7.0
gettext	0.19.8.1
gettext-libs	0.19.8.1
libxslt	1.1.32
libicu	60.3
libicu-devel	60.3
openssl	1.1.1k
python3-libs	3.6.8
platform-python	3.6.8
perl-libs	5.26.3
perl-IO-Tty	1.12
perl-IPC-Run	0.99

---

Standard architecture configuration

OpenSQL 3.0 recommends a 3-Node, 2-Node configuration to provide high availability, as follows

3-Node Configuration

This is the classic configuration for high availability, providing redundancy between nodes and automatic failover.

3-Node Configuration

2-Node Configuration

High availability can also be achieved with a configuration that uses only two nodes, but requires an additional witness node to maintain quorum.

2-Node Configuration

Minimum configuration requirements of witness node

On-promise

Item	Min. specification	Recommended specification
CPU	2	4 core or more
RAM	8GB	16 GB or more
Disk type	SSD	NVMe SSD
Disk IOPS	500 IOPS	3000 IOPS or more
Disk bandwidth	25MB/s	100MB/s or more
Disk capacity	50GB	100GB or more
Networks	1Gbps	10Gbps or more

Cloud

Provider	Type	vCPUs	Memory (GB)	Max. concurrent IOPS	Disk bandwidth (MB/s)
AWS	m4.large	2	8	3600	56.25
GCE	n1-standard-2 + 50GB PD SSD	2	7.5	1500	25

For more information about configuration, you may refer to https://etcd.io/docs/v3.5/op-guide/hardware/

This manual provides example configurations of applications that are installed on each node based on a 3-Node configuration. Each server contains the main components required for a cluster configuration and is the foundation for configuring a highly available environment for OpenSQL 3.0.

Servers	Components	IP Address
node1	PostgreSQL, Patorni, etcd	178.176.0.2
node2	PostgreSQL, Patorni, etcd, Openproxy	178.176.0.3
node3	PostgreSQL, Patorni, etcd, Openproxy	178.176.0.4

The above configuration is an example. The actual IP address and deployment configuration can be adjusted based on user's environment.