Differences between the open source edition and the commercial edition #

Module	Level One Function	Level Two Function	Open Source Version	Commercial Version
Kernel Function	Dialect Compatibility	MySQL	√	√
		PostgreSQL	√	√
		Oracle	√	√
		SQL Server	√	√
		openGauss	√	√
		SQL 92/2003 standard	√	√
	SQL Extension	SQL Hint	√	√
		SQL dialect conversion	√	√
		DistSQL	√	√
	Distributed Transaction	XA transaction	√	√
		Flexible transaction	√	√
		Global transaction	×	√
	Query Optimizer	Native Query Optimization	√	√
	Query Optimizer	Federated query optimization	√	√
Plugin Function	Data Sharding	Basic sharding strategy	√	√
		Customized sharding strategy	×	√
		Automated sharding management	×	√
		Pre sharding capability	×	√
		Automatic data redistribution	×	√
		Distributed object	√	√
	Data Security (decryption)	Data storage encryption	√	√
		Open source encryption algorithm	√	√
		Commercial encryption algorithm	×	√
		Simple dense state calculation	√	√
		Complex dense state calculation	×	√
	Data Security (authority)	User Management	√	√
		Role Management	×	√
		Database table level authority control	×	√
		Row and column level authority control	×	√
		LDAP docking	×	√
		Third party authority docking	×	√
	Behavior Security (AUDIT)	User behavior audit (afterwards)	×	√
	Behavior Security (AUDIT)	Proactive audit (beforehand)	×	√
	Flexible Scheduling	Basic migration	√	√
		Distributed high performance migration	×	√
		Data consistency verification	√	√
		Enhanced flow switching and control	×	√
	Data Isolation	Test production data isolation	√	√
	Data Isolation	Test data traceability	√	×
Executive Function	Metadata Management	Online strong consistency change	×	√
	Metadata Management	DDL multi version control	×	√
	High Availability	Compute node high availability	√	√
		Storage node high availability	×	√
		Fault perception and self-healing	√	√
	Monitoring Diagnosis	Host level monitoring	×	√
		Component level monitoring	√	√
		Statement level monitoring (slow query)	√	√
		Enhance monitoring indicators	×	√
		Monitoring alarm docking	×	√
		Link tracking (APM)	√	√
Delivery Capability	Delivery of Products	ShardingSphere-JDBC	√	√
		ShardingSphere-Proxy	√	√
		SphereEx-Boot (command line management tool)	√	√
		SphereEx-Console (management console)	×	√
		Compatibility assessment tool	×	√
	Support mode	Community support	√	√
	Support mode	Business support	×	√
	Service Content	Problem solving	√	√
		Architecture consulting	×	√
		Training	×	√
		Remote fault support	×	√
		Field fault support	×	√
		Installation and upgrade services	×	√
		On-site support services	×	√