Storage Planning of TigerGraph DB

TigerGraph DB is a powerful and high-performance graph database that excels in processing and analyzing complex relationships within vast datasets. To ensure optimal functionality and performance, proper storage planning is crucial. In this blog post, we will delve into the ideal allocation of disk types and storage types for TigerGraph DB.

Below disk/mounts provides the information for ideal allocation of disk types and storage types for TigerGraph DB to function properly. 

Disk/mount allocation:

Mount	Disk Type	Usage	Owner	Comments
/home/tigergraph	Attached SSD	Home directory for tigergraph user	tigergraph:tigergraph
/tigergraph/app	Attached SSD	To store Tigergraph DB binaries	tigergraph:tigergraph
/tigergraph/data	Attached SSD	To store Tigergraph Data	tigergraph:tigergraph
/tigergraph/kafka	Attached SSD	To store Tigergraph Kafka data	tigergraph:tigergraph	As Kafka is write intensive, create a soft link to this from /tigergraph/data/kafka
/tigergraph/logs	Attached SSD	To store Tigergraph DB logs	tigergraph:tigergraph	Can be a SAN storage but it is better to have Attached SSD as there are many components that actively writes logs.
/tigergraph/tmp	Attached SSD	To store Tigergraph DB temporary files	tigergraph:tigergraph
/tigergraph/backup	Any	To store backup	tigergraph:tigergraph	Depends on organization requirement. Usually requires 3X of data directory
/tigergraph/fileoutput	Attached SSD	To store output files from GSQL query	tigergraph:tigergraph
/tigergraph/toolbox	Any	To store general files for monitoring, log collection etc.	tigergraph:tigergraph	Described in file staging location for more details.

Below are the details for file staging locations for backup and scripts from above mount points described.

Staging type	Location	Owner
Backup staging	/tigergraph/backup/staging	tigergraph:tigergraph
Scripts	/tigergraph/toolbox/scripts	tigergraph:tigergraph
Support collection	/tigergraph/toolbox/support_collection	tigergraph:tigergraph
UDF files	/tigergraph/toolbox/udf	tigergraph:tigergraph
UDF files backup	/tigergraph/toolbox/udf_backup	tigergraph:tigergraph
Python binaries	/tigergraph/toolbox/oel7python38	tigergraph:tigergraph
Downloads	/tigergraph/toolbox/downloads	tigergraph:tigergraph

The above can be created with the below command.

mkdir -p /tigergraph/backup/staging /tigergraph/toolbox/scripts /tigergraph/toolbox/support_collection /tigergraph/toolbox/udf /tigergraph/toolbox/udf_backup /tigergraph/toolbox/oel7python38 /tigergraph/toolbox/downloads

***