Additional Information

This section describes the steps to configure database in on-premise and validate Kafka.

Configuring Database

Metering Microservice supports both MYSQL and MSSQL. By default, it is configured to connect with MSSQL.

To configure database:

• For MSSQL, modify the connection URL in the start-metering.sh/.bat file.
  • DATABASE_KEY=MSSQL
  • Username and password of MSSQL
  • MSSQL_CONNECTIONURL= jdbc:sqlserver://metering-db-service:1433;databaseName=metering

• For MYSQL, modify the following in the start-metering-mysql.sh/.bat file.

  • DATABASE_KEY=mysql
  • Username and password of MYSQL
  • MYSQL_CONNECTIONURL=jdbc:mysql://metering-db-service-np.metering.svc.cluster.local:3306

Validating Kafka

Check whether all the Kafka pods are up and running using the below commands.

kubectl get kakfatopics -n kafka
kubectl get pods -n kafka
kubectl delete kafkatopic -n kafka <topic-name>