Skip to content

Article Selections

Apache ShardingSphere Enterprise User Case - Energy Monster

Energy Monster’s application of ShardingSphere-JDBC Energy Monster is a consumer tech company with the mission to energize everyday life. The company is the largest provider of mobile device charging services in Asia. As the company’s business concurrency volume is getting larger, the amount of data generated (users, orders, activities, etc.) increases each day. The traditional relational database has proven to be inadequate in supporting millions or tens of millions of data volumes in a single database or table.

Read more →

First Look at ShardingSphere 5.2.0 & In-Person Meetup on Massive Data Management Practices

One more day before ShardingSphere’s first in-person meetup in Beijing on September 3, 2022. Join us to learn about the best practices and technical highlights of Apache ShardingSphere’s latest release - version5.2.0. On Saturday, the first in-person Meetup of the ShardingSphere Community will be held in Beijing on Sep 3, 2022. Four technology experts from the developers’ community are invited to give you a detailed analysis of the following: How ShardingSphere can rapidly improve the data application ability of ordinary users driven by cloud scenarios. Comparison of data management effect between traditional data processing methods and ShardingSphere. Experience the ShardingSphere’s ecosystem simple operation in response to diverse e-commerce scenarios. The community will reveal and demo Apache ShardingSphere v5.2.0 at this meetup. The latest version has taken a giant leap forward in terms of its features, performance, testing, documentation, examples, etc.

Read more →

Book Release: “A Definitive Guide to Apache ShardingSphere” is Published Internationally

Recently, A Definitive Guide to Apache ShardingSphere, a technical book co-written by Pan Juan, Zhang Liang, and Yacine Si Tayeb, core members of Apache ShardingSphere, was officially launched internationally. As the first book that comprehensively introduces ShardingSphere and demos several design details and best practices, A Definitive Guide to Apache ShardingSphere was written by core contributors and the founder of the ShardingSphere project. “Many developers would like to have a complete document or book to understand the design concept of ShardingSphere and how to use it effectively. That’s exactly why we wrote this book,” said Pan Juan, one of the authors of A Definitive Guide to Apache ShardingSphere, in an interview with the publisher Packt.

Read more →

Database Plus’s Embracing the Cloud: ShardingSphere-on-Cloud Solution Released

As a follower of the Database Plus development concept, ShardingSphere has successfully passed production environment tests across multiple industries and gained popularity among community enthusiasts. As Kubernetes has become the de facto standard for container orchestration, the cloud-native concept has gone viral in the tech world. Apache ShardingSphere, as a database enhancement engine with an open ecosystem, has many similarities with Kubernetes in its design concept. So SphereEx took the lead in launching ShardingSphere-on-Cloud, its cloud solution for ShardingSphere. Database Plus’ trip to the Cloud has officially begun.

Read more →

DistSQL Applications: Building a Dynamic Distributed Database

Background Ever since the release of ShardingSphere 5.0.0, DistSQL has been providing strong dynamic management capabilities to the ShardingSphere ecosystem. Thanks to DistSQL, users have been empowered to do the following: Create logical databases online. Dynamically configure rules (i.e. sharding, data encryption, read/write splitting, database discovery, shadow DB, and global rules). Adjust storage resources in real-time. Switch transaction types instantly. Turn SQL logs on and off at any time. Preview the SQL routing results. At the same time, in the context of increasingly diversified scenarios, more and more DistSQL features are being created and a variety of valuable syntaxes have been gaining popularity among users. Overview This post takes data sharding as an example to illustrate DistSQL’s application scenarios and related sharding methods.

Read more →

User Case: China Unicom Digital Technology - Ensuring Stability, Efficiency, and Replicability at Scale

China Unicom Digital Tech is the subsidiary of China Unicom, a global leading telecommunication operator with over 310 million subscribers as of 2021. The company integrates with China Unicom’s capabilities such as cloud computing, Big Data, IoT, AI, blockchain, and security and touches on smart city, industrial internet, ecological protection, cultural tourism, and other fields. Unicom Digital Tech has accumulated a large number of industry benchmark cases and successfully provided customers with diverse and professional products & services.

Read more →

ShardingSphere Cloud Applications: An out-of-the-box ShardingSphere-Proxy Cluster

The Apache ShardingSphere v5.1.2 update introduces three new features, one of which allows using the ShardingSphere-Proxy chart to rapidly deploy a set of ShardingSphere-Proxy clusters in a cloud environment. This post takes a closer look at this feature. Background and Pain Points In a cloud-native environment, an application can be deployed in batches in multiple different environments. It is difficult to deploy it into a new environment by reusing the original YAML.

Read more →

ShardingSphere-Proxy Front-End Protocol Troubleshooting Guide and Examples

ShardingSphere-Proxy, positioned as a transparent database proxy, is one of Apache ShardingSphere’s access points. ShardingSphere-Proxy implements a database protocol that can be accessed by any client using or compatible with MySQL / PostgreSQL / openGauss protocols. The advantage of ShardingSphere-Proxy over ShardingSphere-JDBC is the support for heterogeneous languages and the operable entry point to the database cluster for DBAs. Similar to ShardingSphere’s SQL parsing module, establishing ShardingSphere-Proxy’s support for database protocols is a long-term process that requires developers to continuously improve the database protocol deployment.

Read more →

ShardingSphere-JDBC Driver Released: A JDBC Driver That Requires No Code Modifications

Background ShardingSphereDataSourceFactory is the most basic user API of Apache ShardingSphere JDBC, and it is used to transform users’ rule configuration objects and generate the standard implementation of the DataSource. It also provides YamlShardingSphereDataSourceFactory for YAML configuration, as well as the custom namespace for the Spring and Spring Boot Starter. DataSource is a standard Java JDBC interface. Engineers can use it to further create JDBC-compliant Connection, Statement, PreparedStatement, ResultSet, and other familiar standard objects. It is fully consistent with the implementation of the JDBC interface so there’s no difference when engineers use Apache ShardingSphere-JDBC or use a native JDBC. Additionally, it can also transparently interface with various ORM frameworks.

Read more →

ShardingSphere & Database Mesh

Some time ago, SphereEx, a startup formed by Apache ShardingSphere’s core contributor team, officially launched the Database Mesh 2.0 concept and its associated open source solution “Pisanix”, sparking discussion and reflection in the community about ShardingSphere and Database Mesh. Some community users might be wondering why would you go through the trouble of starting from scratch in a new field when you’re already part of a successful open source project like Apache ShardingSphere? Another question that can come to mind is whether with the cloud-native trend, ShardingSphere will gradually be incorporated into the Database Mesh concept in the future?

Read more →