Debezium server monitoring - posgresql connector metric expose

[Çağla Gökgöz]

Hello, i am trying to expose the postgresql connector metrics of debezium server without using docker. I reviewed the code on Github (https://github.com/debezium/debezium/blob/2.0/debezium-server/debezium-server-core/src/main/java/io/debezium/server/DebeziumMetrics.java ). How can I access the metrics here? How can I expose and monitor Snapshot metrics and Streaming metrics in postgresql connector on Debezium server? I have installed debezium server (https://debezium.io/documentation/reference/stable/operations/debezium-server.html). I don't have kafka-server-start.sh file so and I couldn't find where to specify jmx-exporter.jar path and config.yaml file.

[orhan yilmaz]

Hello,

you need to enable jmx to expose metrics via jmx interface.

after that you can use any jmx exporter to push that data to any metric server such as prometheus, influxdb etc

https://debezium.io/documentation/reference/stable/operations/monitoring.html

BR

Orhan YILMAZ
yilmazorhan [_] gmail [_] com

Çağla Gökgöz <cagla....@oredata.com>, 11 Ağu 2022 Per, 12:02 tarihinde şunu yazdı:

Hello, i am trying to expose the postgresql connector metrics of debezium server without using docker. I reviewed the code on Github (https://github.com/debezium/debezium/blob/2.0/debezium-server/debezium-server-core/src/main/java/io/debezium/server/DebeziumMetrics.java ). How can I access the metrics here? How can I expose and monitor Snapshot metrics and Streaming metrics in postgresql connector on Debezium server? I have installed debezium server (https://debezium.io/documentation/reference/stable/operations/debezium-server.html). I don't have kafka-server-start.sh file so and I couldn't find where to specify jmx-exporter.jar path and config.yaml file.

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/701dc0e0-b83b-4eab-a25a-6c6666aad07dn%40googlegroups.com.

[Chris Cranford]

Hi -

You simply need to pass a set of JMX options to the Java JVM process that runs Debezium Server.  Debezium Server includes a run.sh/run.bat file and this file has a special shell variable you can set to pass this information, called JAVA_OPTS.  So in order to expose JMX on this process, you would simply do the following, syntax is for Linux but a similar syntax is needed for Windows:

    export JAVA_OPTS="-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=9010 -Dcom.sun.management.jmxremote.rmi.port=9010 -Dcom.sun.management.jmxremote.local.only=false -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false"

Once that has been done and you have restarted Debezium Server, you should be able to use jconsole or any JMX tool to connect to the application on port 9010.

Chris

On 8/11/22 05:02, Çağla Gökgöz wrote:

Hello, i am trying to expose the postgresql connector metrics of debezium server without using docker. I reviewed the code on Github (https://github.com/debezium/debezium/blob/2.0/debezium-server/debezium-server-core/src/main/java/io/debezium/server/DebeziumMetrics.java ). How can I access the metrics here? How can I expose and monitor Snapshot metrics and Streaming metrics in postgresql connector on Debezium server? I have installed debezium server (https://debezium.io/documentation/reference/stable/operations/debezium-server.html). I don't have kafka-server-start.sh file so and I couldn't find where to specify jmx-exporter.jar path and config.yaml file.