Overview
ShardingSphere-Proxy is a transparent database proxy compatible with MySQL and PostgreSQL, working as a distributed database server to provide data sharding, distributed transactions, read/write splitting, HA, query federation features, and more.
- Transparent to applications, it can be used directly as MySQL/PostgreSQL.
- Compatible with MySQL-based databases, such as MariaDB, and PostgreSQL-based databases, such as openGauss.
- Applicable to any client compatible with MySQL/PostgreSQL protocol, such as MySQL Command Client, MySQL Workbench, etc.
ShardingSphere-Proxy provides the following features:
-
Data sharding - provides a distributed database solution that can scale computing and storage horizontally
-
Distributed transaction - guarantees the HA of your distributed database cluster with Operator on Kubernetes, and the native HA of your existing data sources.
-
Read/write splitting -provides a complete, transparent, secure, and low-cost data encryption solution.
-
High availability.
-
Data migration.
-
Query federation.
-
Data encryption.
-
Shadow database.
Highlights
- Data Sharding and Distributed Transactions: scale computing and storage horizontally, with a hybrid engine based on XA and BASE transactions.
- Read/write Splitting and High Availability: flexible read/write splitting and read access load balancing, while guaranteeing the HA of your distributed database cluster with Operator on Kubernetes, and the native HA of your existing data sources.
- Data Migration, Query Federation, Data Encryption and Shadow Database: provides migration while simultaneously performing data sharding; a complete data encryption solution, and shadow database for full-link online load testing scenarios.
Details
Typical total price
$0.085/hour
Pricing
- ...
Instance type | Product cost/hour | EC2 cost/hour | Total/hour |
|---|---|---|---|
t2.nano | $0.00 | $0.006 | $0.006 |
t2.micro AWS Free Tier | $0.00 | $0.012 | $0.012 |
t2.small | $0.00 | $0.023 | $0.023 |
t2.medium | $0.00 | $0.046 | $0.046 |
t2.large | $0.00 | $0.093 | $0.093 |
t2.xlarge | $0.00 | $0.186 | $0.186 |
t2.2xlarge | $0.00 | $0.371 | $0.371 |
t3.nano | $0.00 | $0.005 | $0.005 |
t3.micro AWS Free Tier | $0.00 | $0.01 | $0.01 |
t3.small | $0.00 | $0.021 | $0.021 |
Additional AWS infrastructure costs
Type | Cost |
|---|---|
EBS General Purpose SSD (gp2) volumes | $0.10/per GB/month of provisioned storage |
Vendor refund policy
Apache ShardingSphere packaged by SphereEx is available free of charge.
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
New Features
Kernel: Add new data masking, dynamic data masking features, and built-in data masking algorithms Change Data Capture: Support for CDC feature DistSQL: Add masking rule related DistSQL Enhancements
Kernel: Cluster mode avoids secondary refresh of metadata Kernel: SHOW COMPUTE NODES supports displaying the version number of each instance Kernel: System database add cluster information table Kernel: Standalone mode persistent metadata supports MySQL Kernel: SQL HINT performance improvement Kernel: Restore routing to the specified database with Hint Encrypt: Supports underscore wildcards for Encrypt CharDigestLikeEncryptAlgorithm Kernel: Support SQL federation SELECT NULLS LAST/FIRST statement Kernel: Refactor encrypt integration test logic and add more test cases Kernel: Add salt props for MD5MaskAlgorithm, MD5EncryptAlgorithm Kernel: Refactor ShardingConditionEngine to support SPI configuration DistSQL: Support defining column level QUERY_WITH_CIPHER_COLUMN when CREATE ENCRYPT RULE DistSQL: Add algorithm type check for CREATE SHARDING TABLE RULE Bug Fixes
Fix the problem of ZooKeeper cluster error reporting when ShardingSphere connects to Kubernetes Kernel: Fix use Consul in cluster mode start up failure DB Discovery: Close heartbeat job when drop discovery rule Kernel: Fix wrong decide result when execute same sharding condition subquery with SQL federation Kernel: Fix priority problem of UNION, INTERSECT, EXCEPT set operation in SQL Federation for PostgreSQL and openGuass dialect Kernel: Fix create view index out of range exception when view contains set operator Kernel: Add XA resource exceeds length check Kernel: Fix transaction support for spring requires_new Encrypt: Fix AESEncryptAlgorithm decrypt exception when config char type with PostgreSQL and openGauss Encrypt: Fix abnormal expansion result for shorthand when encrypt subquery contains an alias Kernel: Fix unsigned flag of column metadata was not serialized Kernel: Fix PostgreSQL / openGauss select fetch parsing issue to support federation execution engine Proxy: Fix packet sequence ID may be incorrect if error occurred in MySQL Proxy Proxy: Fix error occur in Proxy when using PostgreSQL composite type Proxy: Set proper column definition flag for MySQL COM_STMT_PREPARE Proxy: When querying PG metadata through Proxy and the result set is empty, the labels are lost
Additional details
Usage instructions
The default directory where Apache Shardingsphere will be installed in is /opt/shardingsphere-proxy. Once the instance is running, access your instance via SSH using the username 'ec2-user' and your Amazon private key. The default server administrator is 'root'.
Please check the documentation at https://shardingsphere.apache.org/document/5.3.1/en/user-manual/shardingsphere-proxy/startup/bin/ for information on how to get started.
For additional setup instructions and frequently asked questions please go to https://shardingsphere.apache.org/document/5.3.1/en/faq/ .
Resources
Vendor resources
Support
Vendor support
SphereEx provides technical consulting for installation and setup issues at tech-c@sphere-ex.com and through our support center documentation at
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Similar products
