1. Cloud Native Core Console Installation and Upgrade Guide
  2. cnDBTier Profiles

cnDBTier Profiles

This section includes information about cnDBTier profiles.

cnDBTier Profile 1

Table -6 cnDBTier Profile 1

Service / Component Per Pod Side Cars:db-backup-exec-service (DB Tier Sidecar)Service Mesh Sidecar (ASM, Istio/Envoy) Number of Pods (Replica) Total  
CPU Memory Storage CPU Memory CPU Memory Storage
Req Limit Req Limit PVC Count Req Limit Req Limit Req Limit Req Limit PVC Count
 

Management (MGMT STS )

  • k8 Resource Type: StatefulSet

  • Sidecar name: NA

  • svc: ndbmgmdsvc
 1 2 1 2 2 1 NA NA NA NA 2(mgmReplicaCount) 2 4 2 4 4 2

NDB Data Store (NDB STS )

  • k8 Resource Type: StatefulSet

  • Sidecar name: db-executor-svc

  • svc : ndbmtdsvc
 1 2 4 8 6 2 0.1 0.1 0.128 0.128

2

(ndbReplicaCount)

 2.2 4.2 8.256 16.256 12 4

Replication (SQL STS - mysqld)

  • k8 Resource Type: StatefulSet

  • Sidecar name: init-sidecar

  • svc : ndbmysqldsvc
 1 2 1 2 4 1 0.1 0.1 0.256 0.256

2

2/4/6

(Depending on GR setup of 2/3/4 site)

(ndbappReplicaCount)

 2.2 4.2 1.512 4.512 8 2

App Access (SQL STS - appmysqld)

  • k8 Resource Type StatefulSet

  • Sidecar name: init-sidecar

  • svc : ndbappmysqldsvc
 1 2 1 2 4 1 0.1 0.1 0.256 0.256

2

(apiReplicaCount)

 2.2 4.2 2.512 4.512 8 2

Monitor Service

  • Sidecar name: NA
  • k8 Resource Type: Deployment
  • svc: db-monitor-service
 0.5 1 0.5 1 0 0 NA NA NA NA 1 0.5 1 0.5 1 0 0

DBTier Connectivity Service

  • Sidecar name: NA
  • k8 Resource Type: Service
  • svc: mysql-connectivity-service
 0 0 0 0 0 0 NA NA NA NA 1 0 0 0 0 0 0

Replication Service

  • Sidecar name: init-discover-sql-ips
  • k8 Resource Type: Deployment
  • svc: db-replication-service
 1 2 2 4 16 1 0.2 0.2 0.5 0.5 1 1.2 2.2 2.5 4.5 16 1

Backup Manager Service

  • Sidecar name: NA
  • k8 Resource Type: Deployment
  • svc: db-backup-manager-svc
 0.5 1 0.5 1 0 0 NA NA NA NA 1 0.5 1 0.5 1 0 0
postUpgradeJob 0.1 0.1 0.256 0.256 0 0           0.1 0.1 0.256 0.256 0 0
preUpgradeJob 0.1 0.1 0.256 0.256 0 0           0.1 0.1 0.256 0.256 0 0

helm test

  • Sidecar name: NA
  • k8 Resource Type: Job

Note: This will be created only when "helm test" is performed

 0.1 0.1 0.256 0.256 0 0           0.1 0.1 0.256 0.256 0 0
                      12 8 8.4 16.176 17.176 22 11

Table -7 cnDBTier Profile 1 Ephemeral Storage

Service / Component Per Pod Side Cars:db-backup-exec-service (DB Tier Sidecar)Service Mesh Sidecar (ASM, Istio/Envoy) Number of Pods (Replica) Total
     
Ephemeral Storage Ephemeral Storage Ephemeral Storage
Req Limit Req Limit Req Limit

Management (MGMT STS )

  • k8 Resource Type: StatefulSet

  • Sidecar name: NA

  • svc: ndbmgmdsvc
 90Mi 100Mi NA NA 2(mgmReplicaCount) 180Mi 200Mi

NDB Data Store (NDB STS )

  • k8 Resource Type: StatefulSet

  • Sidecar name: db-executor-svc

  • svc : ndbmtdsvc
 90Mi 100Mi 90Mi 100Mi

2

(ndbReplicaCount)

 360Mi 400Mi

Replication (SQL STS - mysqld)

  • k8 Resource Type: StatefulSet

  • Sidecar name: init-sidecar

  • svc : ndbmysqldsvc
 90Mi 100Mi 90Mi 100Mi

2

2/4/6

(Depending on GR setup of 2/3/4 site)

(ndbappReplicaCount)

 360Mi 400Mi

App Access (SQL STS - appmysqld)

  • k8 Resource Type StatefulSet

  • Sidecar name: init-sidecar

  • svc : ndbappmysqldsvc
 90Mi 100Mi 90Mi 100Mi

2

(apiReplicaCount)

 360Mi 400Mi

Monitor Service

  • Sidecar name: NA
  • k8 Resource Type: Deployment
  • svc: db-monitor-service
 90Mi 100Mi NA NA 1 90Mi 100Mi

DBTier Connectivity Service

  • Sidecar name: NA
  • k8 Resource Type: Service
  • svc: mysql-connectivity-service
 90Mi 100Mi NA NA 1 90Mi 100Mi

Replication Service

  • Sidecar name: init-discover-sql-ips
  • k8 Resource Type: Deployment
  • svc: db-replication-service
 90Mi 100Mi 90Mi 100Mi 1 180Mi 200Mi

Backup Manager Service

  • Sidecar name: NA
  • k8 Resource Type: Deployment
  • svc: db-backup-manager-svc
 90Mi 100Mi NA NA 1 90Mi 100Mi
postUpgradeJob              
preUpgradeJob              

helm test

  • Sidecar name: NA
  • k8 Resource Type: Job

Note: This will be created only when "helm test" is performed

             
Totals 11 1710Mi 1900Mi

cnDBTier Profile 2

Table -8 cnDBTier Profile 2

Service / Component Per Pod Side Cars:db-backup-exec-service (DB Tier Sidecar)Service Mesh Sidecar (ASM, Istio/Envoy) Number of Pods (Replica) Total
CPU Memory Storage CPU Memory CPU Memory Storage
Req Limit Req Limit PVC Count Req Limit Req Limit Req Limit Req Limit PVC Count
 

Management (MGMT STS )

  • k8 Resource Type: StatefulSet

  • Sidecar name: NA

  • svc: ndbmgmdsvc
 1 1 1 1 1 1 NA NA NA NA 2(mgmReplicaCount) 2 2 2 2 2 2

NDB Data Store (NDB STS )

  • k8 Resource Type: StatefulSet

  • Sidecar name: db-executor-svc

  • svc : ndbmtdsvc
 1 1 4 4 3 2 0.1 0.1 0.128 0.128

2

(ndbReplicaCount)

 2.2 2.2 8.256 8.256 6 4

Replication (SQL STS - mysqld)

  • k8 Resource Type: StatefulSet

  • Sidecar name: init-sidecar

  • svc : ndbmysqldsvc
 0.5 0.5 0.5 0.5 2 1 0.1 0.1 0.256 0.256

2

2/4/6

(Depending on GR setup of 2/3/4 site)

(ndbappReplicaCount)

 1.2 1.2 1.512 1.512 4 2

App Access (SQL STS - appmysqld)

  • k8 Resource Type StatefulSet

  • Sidecar name: init-sidecar

  • svc : ndbappmysqldsvc
 0.5 0.5 0.5 0.5 2 1 0.1 0.1 0.256 0.256

2

(apiReplicaCount)

 1.2 1.2 1.512 1.512 4 2

Monitor Service

  • Sidecar name: NA
  • k8 Resource Type: Deployment
  • svc: db-monitor-service
 0.2 0.2 0.5 0.5 0 0 NA NA NA NA 1 0.2 0.2 0.5 0.5 0 0

DBTier Connectivity Service

  • Sidecar name: NA
  • k8 Resource Type: Service
  • svc: mysql-connectivity-service
 0 0 0 0 0 0 NA NA NA NA 1 0 0 0 0 0 0

Replication Service

  • Sidecar name: init-discover-sql-ips
  • k8 Resource Type: Deployment
  • svc: db-replication-service
 0.6 1 1 2 8 1 0.2 0.2 0.5 0.5 1 0.8 1.2 1.5 2.5 8 1

Backup Manager Service

  • Sidecar name: NA
  • k8 Resource Type: Deployment
  • svc: db-backup-manager-svc
 0.1 0.1 0.128 0.128 0 0 NA NA NA NA 1 0.1 0.1 0.128 0.128 0 0
postUpgradeJob 0.1 0.1 0.256 0.256 0 0           0.1 0.1 0.256 0.256 0 0
preUpgradeJob 0.1 0.1 0.256 0.256 0 0           0.1 0.1 0.256 0.256 0 0

helm test

  • Sidecar name: NA
  • k8 Resource Type: Job

Note: This will be created only when "helm test" is performed

 0.1 0.1 0.256 0.256 0 0           0.1 0.1 0.256 0.256 0 0
                      12 8 8.4 16.176 17.176 24 11

Table -9 cnDBTier Profile 2 Ephemeral Storage

Service / Component Per Pod Side Cars:db-backup-exec-service (DB Tier Sidecar)Service Mesh Sidecar (ASM, Istio/Envoy) Number of Pods (Replica) Total
           
  Ephemeral Storage   Ephemeral Storage   Ephemeral Storage
Req Limit Req Limit Req Limit

Management (MGMT STS )

  • k8 Resource Type: StatefulSet

  • Sidecar name: NA

  • svc: ndbmgmdsvc
 90Mi 100Mi NA NA 2(mgmReplicaCount) 180Mi 200Mi

NDB Data Store (NDB STS )

  • k8 Resource Type: StatefulSet

  • Sidecar name: db-executor-svc

  • svc : ndbmtdsvc
 90Mi 100Mi 90Mi 100Mi

2

(ndbReplicaCount)

 360Mi 400Mi

Replication (SQL STS - mysqld)

  • k8 Resource Type: StatefulSet

  • Sidecar name: init-sidecar

  • svc : ndbmysqldsvc
 90Mi 100Mi 90Mi 100Mi

2

2/4/6

(Depending on GR setup of 2/3/4 site)

(ndbappReplicaCount)

 360Mi 400Mi

App Access (SQL STS - appmysqld)

  • k8 Resource Type StatefulSet

  • Sidecar name: init-sidecar

  • svc : ndbappmysqldsvc
 90Mi 100Mi 90Mi 100Mi

2

(apiReplicaCount)

 360Mi 400Mi

Monitor Service

  • Sidecar name: NA
  • k8 Resource Type: Deployment
  • svc: db-monitor-service
 90Mi 100Mi NA NA 1 90Mi 100Mi

DBTier Connectivity Service

  • Sidecar name: NA
  • k8 Resource Type: Service
  • svc: mysql-connectivity-service
 90Mi 100Mi NA NA 1 90Mi 100Mi

Replication Service

  • Sidecar name: init-discover-sql-ips
  • k8 Resource Type: Deployment
  • svc: db-replication-service
 90Mi 100Mi 90Mi 100Mi 1 180Mi 200Mi

Backup Manager Service

  • Sidecar name: NA
  • k8 Resource Type: Deployment
  • svc: db-backup-manager-svc
 90Mi 100Mi NA NA 1 90Mi 100Mi
postUpgradeJob              
preUpgradeJob              

helm test

  • Sidecar name: NA
  • k8 Resource Type: Job

Note: This will be created only when "helm test" is performed

              
        Totals 12 1710Mi 1900Mi

Note:

In case of shared cnDBTier between Console and NF, Console DB Profile sizing needs to be included in NF DB Profile sizing.