APM is the abbreviation for application performance monitoring. Currently, main APM functions lie in the performance diagnosis of distributed systems, including chain demonstration, application topology analysis and so on.
Apache ShardingSphere is not responsible for gathering, storing and demonstrating APM data, but sends the core information of SQL parsing and enforcement to APM to process. In other words, Apache ShardingSphere is only responsible for generating valuable data and submitting it to relevant systems through standard protocol. It can connect to APM systems in three ways.
The first way is to send performance tracing data by OpenTracing API. APM products facing OpenTracing protocol can all automatically connect to Apache ShardingSphere, like SkyWalking, Zipkin and Jaeger. In this way, users only need to configure the implementation of OpenTracing protocol at the start. Its advantage is the compatibility of all the products compatible of OpenTracing protocol, such as the APM demonstration system. If companies intend to implement their own APM systems, they only need to implement the OpenTracing protocol, and they can automatically show the chain tracing information of Apache ShardingSphere. Its disadvantage is that OpenTracing protocol is not stable in its development, has only a few new versions, and is too neutral to support customized products as native ones do.
The second way is to use SkyWalking’s automatic monitor agent.
Cooperating with Apache SkyWalking team,
Apache ShardingSphere team has realized
ShardingSphere automatic monitor agent to automatically send application performance data to
The third way is to send performance tracing data by OpenTelemetry. OpenTelemetry was merged by OpenTracing and OpenCencus in 2019. In this way, you only need to fill in the appropriate configuration in the agent configuration file according to OpenTelemetry SDK Autoconfigure Guide.
Add startup arguments
Call initialization method
Notice: when using SkyWalking OpenTracing agent, you should disable the former ShardingSphere agent plug-in to avoid the conflict between them.
Please refer to SkyWalking Manual.
Just fill in the configuration in
agent.yaml. For example, export Traces data to Zipkin.
OpenTelemetry: props: otel.resource.attributes: "service.name=shardingsphere-agent" otel.traces.exporter: "zipkin" otel.exporter.zipkin.endpoint: "http://127.0.0.1:9411/api/v2/spans"
No matter in which way, it is convenient to demonstrate APM information in the connected system. Take SkyWalking for example:
ShardingSphere-Proxy to visit two databases,
192.168.0.2:3306, and there are two tables in each one of them.
It can be seen from the picture that the user has accessed ShardingSphere-Proxy 18 times, with each database twice each time. It is because two tables in each database are accessed each time, so there are totally four tables accessed each time.
SQL parsing and implementation can be seen from the tracing diagram.
/Sharding-Sphere/parseSQL/ indicates the SQL parsing performance this time.
/Sharding-Sphere/executeSQL/ indicates the SQL parsing performance in actual execution.
Exception nodes can be seen from the tracing diagram.
/Sharding-Sphere/executeSQL/ indicates the exception results of SQL.
/Sharding-Sphere/executeSQL/ indicates the exception log of SQL execution.