ShardingSphere-Proxy Database Protocol Interaction Explained

Database protocols are considered relatively unknown knowledge for most developers. Generally, users and developers use databases through off-the-shelf database clients and drivers, without manipulating database protocols directly. However, having some basic understanding of the features and processes of data

ShardingSphere-Proxy Database Protocol Interaction Explained

Database protocols are considered relatively unknown knowledge for most developers. Generally, users and developers use databases through off-the-shelf database clients and drivers, without manipulating database protocols directly. However, having some basic understanding of the features and processes of data

Dynamic Data Masking | ShardingSphere 5.3.1 Deep Dive

With increased focus placed on user data protection and the introduction of privacy laws or data protection regulations such as GDPR, being compliant in terms of digital personal privacy is now of paramount importance. Traditional applications generally lack personal data protection. Data masking enables data

A Distributed Database Load Balancing Architecture Based on ShardingSphere: Demo and User Case

This post introduces how to build a distributed database load-balancing architecture based on ShardingSphere, and the impact of introducing load balancing with a user case. Finally, a one-stop solution for Apache ShardingSphere distributed databases on the cloud will be presented and demonstrated at the end.

Leverage Terraform to Create an Apache ShardingSphere Proxy High Availability Cluster on AWS

For this ShardingSphere blog entry, we want you to take advantage of the benefits of IaC (Infrastructure as Code) by deploying and managing a ShardingSphere Proxy cluster the IaC way. With this in mind, we plan to use Terraform to create a ShardingSphere-Proxy high availability cluster with multiple availabil

Refactoring the DistSQL Syntax | ShardingSphere 5.3.0 Deep Dive

Background DistSQL (Distributed SQL) is ShardingSphere’s SQL-like functional language. Since we releasedversion 5.0.0-Beta, we’ve been iterating rapidly and providing users with features including rule management, cluster management, and metadata management. It was an incremental improvement proce

Fuzzy query for CipherColumn | ShardingSphere 5.3.0 Deep Dive

1. Background Apache ShardingSphere supports data encryption. By parsing users’ SQL input and rewriting the SQL according to the users’ encryption rules, the original data is encrypted and stored with ciphertext data in the underlying database at the same time. When a user queries the data, it onl

Use AWS CloudFormation to create ShardingSphere HA clusters

What’s AWS CloudFormation? AWS CloudFormation is an infrastructure as code (IaC) service that allows you to easily model, provision, and manage all the cloud services provided by AWS by custom templates. Traditionally, when we create a new architecture, we need to manually configure it in AWS step by st

ShardingSphere 5.3.0 is released: new features and improvements

After 1.5 months in development, Apache ShardingSphere 5.3.0 is released. Our community merged 687 PRs from contributors around the world. The new release has been improved in terms of features, performance, testing, documentation, examples, etc. The 5.3.0 release brings the following highlights: Support fuz

ShardingSphere-on-Cloud & Pisanix replace Sidecar for a true cloud-native experience

Background For a while, many of our blog posts have shown that ShardingSphere consists of three independent products: ShardingSphere-JDBC, ShardingSphere-Proxy, and ShardingSphere-Sidecar. As ShardingSphere has become increasingly popular, JDBC and Proxy have been used in numerous production environments, but