ShardingSphere 4.x Orchestration-Apm Integration
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.
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, ShardingSphere is only responsible for generating valuable data and submitting it to relevant systems through standard protocol. It can connect to APM systems in two ways.
The first way is to send performance tracing data by OpenTracing API. APM products facing OpenTracing protocol can all automatically connect to 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 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 SkyWalking team, ShardingSphere team has realized
ShardingSphere automatic monitor agent to automatically send application performance data to
- Method 1: inject Tracer provided by APM system through reading system parameters
Add startup arguments
Call initialization method
- Method 2: inject Tracer provided by APM through parameter
Notice: when using SkyWalking OpenTracing agent, you should disable the former ShardingSphere agent plug-in to avoid the conflict between them.
Use SkyWalking’s Automatic Agent
Please refer to SkyWalking Manual.
No matter in which way, it is convenient to demonstrate APM information in the connected system. Take SkyWalking for example:
Sharding-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 Sharding-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.