DistSQL, which stands for Distributed SQL, is a specialized operating language exclusive to Apache ShardingSphere. This language provides users with a simplified and powerful dynamic management system that allows them to operate ShardingSphere like a traditional database. One of the key benefits of using DistSQL is the ability to define…

Apache ShardingSphere-on-Cloud sub-project ShardingSphere-on-Cloud is a sub-project of Apache ShardingSphere for cloud solutions, covering verything from automated deployment scripts to virtual machines in AWS, GCP, AliCloud, Huawei Cloud cloud environments such as CloudFormation Stack templates, Terraform and more. The project also covers tools such as Helm Charts, Operator, and automatic horizontal scaling in…

Before 5.3.0, ShardingSphere-JDBC supported Java API, YAML, Spring Boot Starter, and Spring Namespace. However, compatibility with Spring has brought the following challenges to the community: Many configuration files need to be adjusted when adding or updating API, which causes a heavy workload. The community needs to maintain lots of configuration…

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 database protocols can help developers provide some ideas to identify troubleshooting problems…

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 returned by production databases to…

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. ShardingSphere-based distributed database load balancing architecture ShardingSphere Load Balancing Architecture Essentials

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 availability zones. Background Terraform …

Thank you for sharing! We love to her from first hand experience about ShardingSphere applications 👏

Background DistSQL (Distributed SQL) is ShardingSphere’s SQL-like functional language. Since we released version 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 process including many steps. At the same time, DistSQL is still releatively young. The ShardingSphere…