PostgreSQL is generally required for TDM projects only.
K2view supports PostgreSQL version 9.6 & 13.
PostgreSQL requires 100G storage.
PostgreSQL can be deployed in one of these ways:
For cloud deployments:
If using AWS: EC2: m5.xlarge
If using Azure VM: A8v2
If using GCP: e2-standard-4
For example, if you are implementing PostgreSQL as a PaaS, you can use the following:
For Local installation:
For Cloud installation:
Open the following ports on the Windows server:
Local administrator privileges are needed for the Fabric Studio installation.
Use a dedicated server for Fabric, and a separate, dedicated server for Kafka
For local installations:
For Cloud installation:
Cloud instances for SOR:
Cloud instances for non SOR:
For all installations, the FS configuration must be as follows:
Note:
Follow the following steps to setup a Linux Server:
Run the following as ROOT:
echo "fabric - nofile 100000" >> /etc/security/limits.conf
echo "fabric - nproc 50000" >> /etc/security/limits.conf
echo "kafka hard nofile 100000" >> /etc/security/limits.conf
echo "kafka soft nofile 100000" >> /etc/security/limits.conf
echo "kafka - nproc 50000" >> /etc/security/limits.conf
## update /etc/sysctl.conf ##
echo "## Added by K2view - GabiO" >> /etc/sysctl.conf
echo "vm.max_map_count = 1048575" >> /etc/sysctl.conf
echo "fs.file-max = 1000000" >> /etc/sysctl.conf
Open the following ports on the LINUX server, and make sure they are accessible outside the server:
| 22 | SSH, SCP |
| 2181, 2888, 3888 | Kafka Zookeeper |
| 9093, 9091, 9081, 7270 | Kafka |
| 3213, 9443, 5124, 6379, 7170, 7270 | K2View Fabric |
Install Cassandra under cassandra user.
For local installation:
For Cloud installation:
Cloud instances for SOR:
Cloud instances for non SOR:
For all installations, the FS configuration for SOR must be as follows:
Note:
For all installations, the FS configuration for non SOR must be as follows:
The above volume values should be modified in accordance with project scope and data retention requirements.
Follow these steps to setup the Linux Server:
Run the following as ROOT:
echo "root soft nproc unlimited" >> /etc/security/limits.conf
echo "cassandra - nofile 100000" >> /etc/security/limits.conf
echo "cassandra - nproc 50000" >> /etc/security/limits.conf
## update /etc/sysctl.conf ##
echo "## Added by K2view - GabiO" >> /etc/sysctl.conf
echo "vm.max_map_count = 1048575" >> /etc/sysctl.conf
echo "fs.file-max = 1000000" >> /etc/sysctl.conf
The following ports should be opened on the LINUX server and accessible outside the server:
| 22 | SSH, SCP |
| 9042, 9142, 7000, 7001, 7199, 7070 | cassandra |
| 8080 | cassandra-reaper |
PostgreSQL is generally required for TDM projects only.
K2view supports PostgreSQL version 9.6 & 13.
PostgreSQL requires 100G storage.
PostgreSQL can be deployed in one of these ways:
For cloud deployments:
If using AWS: EC2: m5.xlarge
If using Azure VM: A8v2
If using GCP: e2-standard-4
For example, if you are implementing PostgreSQL as a PaaS, you can use the following:
For Local installation:
For Cloud installation:
Open the following ports on the Windows server:
Local administrator privileges are needed for the Fabric Studio installation.
Use a dedicated server for Fabric, and a separate, dedicated server for Kafka
For local installations:
For Cloud installation:
Cloud instances for SOR:
Cloud instances for non SOR:
For all installations, the FS configuration must be as follows:
Note:
Follow the following steps to setup a Linux Server:
Run the following as ROOT:
echo "fabric - nofile 100000" >> /etc/security/limits.conf
echo "fabric - nproc 50000" >> /etc/security/limits.conf
echo "kafka hard nofile 100000" >> /etc/security/limits.conf
echo "kafka soft nofile 100000" >> /etc/security/limits.conf
echo "kafka - nproc 50000" >> /etc/security/limits.conf
## update /etc/sysctl.conf ##
echo "## Added by K2view - GabiO" >> /etc/sysctl.conf
echo "vm.max_map_count = 1048575" >> /etc/sysctl.conf
echo "fs.file-max = 1000000" >> /etc/sysctl.conf
Open the following ports on the LINUX server, and make sure they are accessible outside the server:
| 22 | SSH, SCP |
| 2181, 2888, 3888 | Kafka Zookeeper |
| 9093, 9091, 9081, 7270 | Kafka |
| 3213, 9443, 5124, 6379, 7170, 7270 | K2View Fabric |
Install Cassandra under cassandra user.
For local installation:
For Cloud installation:
Cloud instances for SOR:
Cloud instances for non SOR:
For all installations, the FS configuration for SOR must be as follows:
Note:
For all installations, the FS configuration for non SOR must be as follows:
The above volume values should be modified in accordance with project scope and data retention requirements.
Follow these steps to setup the Linux Server:
Run the following as ROOT:
echo "root soft nproc unlimited" >> /etc/security/limits.conf
echo "cassandra - nofile 100000" >> /etc/security/limits.conf
echo "cassandra - nproc 50000" >> /etc/security/limits.conf
## update /etc/sysctl.conf ##
echo "## Added by K2view - GabiO" >> /etc/sysctl.conf
echo "vm.max_map_count = 1048575" >> /etc/sysctl.conf
echo "fs.file-max = 1000000" >> /etc/sysctl.conf
The following ports should be opened on the LINUX server and accessible outside the server:
| 22 | SSH, SCP |
| 9042, 9142, 7000, 7001, 7199, 7070 | cassandra |
| 8080 | cassandra-reaper |