APM

Background

APM is the abbreviation of Application Performance Monitoring. Currently its core function is the performance diagnosis of distributed system, including call chain demonstration, application topology analysis, etc.

Sharding-Sphere Team work with SkyWalking Team to introduce an automatic monitor agent of Sharding-Sphere to send tracing data of Sharding-Sphere to SkyWalking.

Usage

Using SkyWalking

Please refer to SkyWalking Manual

Using OpenTracing

If user want to use other APM systems which support OpenTracing, just use sharding-sphere API to work with those APM systems.

Notices: When using SkyWalking’s OpenTracing monitor agent, disabling the original Sharding-Sphere monitor agent plugin is necessary to avoid conflicting with each other.

UI

Application schema

The application is a SpringBoot application, using Sharding-Sphere to access two databases of ds_0 and ds_1, each owns two tables in database.

Topology diagram

The topology diagram

Although the user accesses the application once, each database is accessed twice. This is because this visit involves two splitting tables in each database, four tables in total.

Tracking diagram

The topology diagram

Four visits in total in this figure.

/SJDBC/TRUNK/*: Represents the overall execution performance of this SQL.

The logical execution node

/SJDBC/BRANCH/*: Represents the performance of the actual SQL.

The actual access node