Shulou(Shulou.com)06/01 Report--

ShardingSphere-distributed database middle tier

Official website address: http://shardingsphere.io/

Documentation support

Overview

ShardingSphere is an open source project for distributed database middleware solutions, including three independent products, namely Sharding-JDBC, Sharding-Proxy and Sharding-Sidecar. Together, they provide functions such as data fragmentation, distributed transactions and database orchestration, which are suitable for many situations such as Java isomorphism, heterogeneous languages and local clouds.

In order to make rational use of the computing and storage capacity of databases in distributed systems, ShardingSphere defines itself as middleware rather than a new database type. As the cornerstone of many enterprises, relational database still occupies a huge market share. Therefore, at this stage, we are more inclined to focus on its increment rather than complete subversion.

Sharding-JDBC

Sharding-JDBC defines itself as a lightweight Java framework that provides additional services at the Java JDBC layer.

Because the client connects directly to the database, it provides services in the form of jar without additional deployment and dependencies.

It can be seen as an enhanced JDBC driver that is fully compatible with JDBC and various ORM frameworks.

It is suitable for the direct use of any Java-based ORM framework, such as JPA, Hibernate, Mybatis, Spring JDBC templates or JDBC.

Based on any third-party database connection pool, such as DBCP, C3P0, BoneCP, Druid, HikariCP.

* supports any type of database JDBC standard: conforms to MySQL,Oracle and PostgreSQL status "doubt".

Sharding-Proxy

Sharding-Proxy defines itself as a transparent database agent, providing a database server that encapsulates the database binary protocol to support heterogeneous languages.

More DBA-friendly, the version of MySQL now available can manipulate data using any client access compatible with the MySQL protocol (such as MySQL command client, MySQL Workbench, and so on).

Completely transparent to the application and can be used directly as a MySQL.

It is suitable for any client that is compatible with MySQL protocol.

Sharding-Sidecar (TBD)

Sharding-Sidecar (TBD) defines itself as a cloud local database agent for a Kubernetes or Mesos environment and is responsible for all access to the database in the form of DaemonSet. Through decentralized and zero-cost solutions, it provides a grid layer that interacts with the database, that is, the database grid, also known as the database grid.

Database Mesh emphasizes how to connect distributed database access applications to databases. It focuses on interaction and effectively organizes the interaction between chaotic applications and databases. Applications and databases that access databases using database Mesh will form a large grid system, and you just need to put them in the appropriate location. They are all controlled by the grid layer.

Sharding-JDBCSharding-ProxySharding-SidecarDatabaseAnyMySQLMySQLConnections Cost NumberHighLowHighHeterogeneous LanguageJava OnlyAnyAnyPerformanceLow lossRelatively High lossLow lossDecentralizationYesNoNoStatic EntryNoYesNoHybrid Architecture

Sharding-JDBC adopts distributed architecture, which is suitable for high performance lightweight OLTP applications developed by Java.

Sharding-proxy provides static entry and heterogeneous language support, which is suitable for the management and operation of OLAP applications and sharded databases.

ShardingSphere is an ecosphere consisting of multiple endpoints. Through a registry's mixed use of sharding-jdbc and sharding-proxy and a unified sharding strategy, ShardingSphere can build applications suitable for various situations.

Architects have more freedom to adapt the system architecture to the architecture that best suits the current business.

Features data slicing Database sharding & Table sharding (sub-database sub-table) Read-write splitting: read-write separation Distributed primary key: distributed primary key distributed transaction XA transactionBASE transactionDatabase OrchestrationDynamic configurationFusing & DisablingTracingElastic scaling out (Planing) Roadmap

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.