awesome-repositories.com
Blog
awesome-repositories.com

Descoperă cele mai bune repository-uri open source cu căutare AI.

ExploreazăCăutări recomandateAlternative open-sourceSoftware self-hostedBlogHartă site
ProiectDespreCum realizăm clasamentulPresăServer MCP
LegalConfidențialitateTermeni
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
·
MyCATApache avatar

MyCATApache/Mycat-Server

0
View on GitHub↗

Mycat Server

Mycat-Server is a MySQL database middleware system that functions as a sharding proxy, distributed database coordinator, and high availability manager. It acts as a proxy layer that routes SQL traffic between applications and multiple backend MySQL database instances to enable horizontal scaling.

The system coordinates distributed transactions, generates global unique sequences to prevent primary key collisions, and executes distributed join queries across multiple database shards. It includes a load balancer that performs read-write splitting by directing traffic between primary and slave nodes.

The project covers broader capabilities in traffic management, such as connection lifecycle monitoring and protocol translation. It also implements security measures including IP-based access control and multi-tenant data isolation, alongside heartbeat-based health monitoring for automatic failover.

Căutare AI

Explorează mai multe repository-uri excelente

Descrie ce ai nevoie în limbaj simplu — AI-ul sortează mii de proiecte open source selectate în funcție de relevanță.

Start searching with AI

Features

  • Database Sharding - Provides a sharding architecture that distributes relational data across multiple physical nodes for horizontal scaling.
  • MySQL Proxy Middleware - Functions as a proxy layer routing SQL traffic between applications and multiple backend MySQL instances.
  • Data Sharding - Distributes relational data across physical database nodes using configurable rules to enable horizontal scaling.
  • Read and Write Splitting - Directs write operations to primary nodes and read operations to slave nodes to optimize resource utilization.
  • Sharding Proxies - Implements a network layer that distributes data across multiple database instances using specific sharding logic.
  • Database Proxying - Provides a middleware layer that routes and optimizes database queries between applications and storage nodes.
  • Distributed Transaction Coordinators - Coordinates transactions across multiple database nodes to ensure data consistency using shared protocols.
  • Distributed Transaction Management - Maintains data integrity across multiple databases in distributed environments using coordination protocols.
  • Unique Identifier Generators - Generates globally unique primary keys across distributed environments to prevent data collisions.
  • Database Query Joins - Executes complex join queries across multiple database shards using global tables and sharding strategies.
  • High Availability Configurations - Ensures service continuity and data redundancy across distributed database clusters through automatic failover.
  • Statement Routing - Translates prepared queries into standard SQL to identify the correct backend destination for routing.
  • Replica Load Balancers - Distributes query traffic across a cluster of database replicas to optimize resource utilization.
  • Reference Table Replication - Optimizes distributed joins by replicating small reference tables across all cluster nodes to enable local execution.
  • Heartbeat Monitors - Uses periodic heartbeat signals to track node availability and trigger automatic failover for high availability.
  • Protocol Translation - Translates a single client database protocol into various backend dialects to route traffic across distributed nodes.
  • Master Node Health Monitors - Tracks node availability via heartbeats to trigger automatic failover and maintain continuous service access.
9,529 stele·3,816 fork-uri·Java·GPL-2.0·4 vizualizări

Istoric stele

Graficul istoricului de stele pentru mycatapache/mycat-serverGraficul istoricului de stele pentru mycatapache/mycat-server

Întrebări frecvente

Ce face mycatapache/mycat-server?

Mycat-Server is a MySQL database middleware system that functions as a sharding proxy, distributed database coordinator, and high availability manager. It acts as a proxy layer that routes SQL traffic between applications and multiple backend MySQL database instances to enable horizontal scaling.

Care sunt principalele funcționalități ale mycatapache/mycat-server?

Principalele funcționalități ale mycatapache/mycat-server sunt: Database Sharding, MySQL Proxy Middleware, Data Sharding, Read and Write Splitting, Sharding Proxies, Database Proxying, Distributed Transaction Coordinators, Distributed Transaction Management.

Care sunt câteva alternative open-source pentru mycatapache/mycat-server?

Alternativele open-source pentru mycatapache/mycat-server includ: pgdogdev/pgdog — pgdog is a PostgreSQL sharding proxy, distributed SQL router, and connection pooler. It is designed to enable… apache/shardingsphere — ShardingSphere is a distributed SQL database middleware that provides sharding, read-write splitting, and distributed… doocs/advanced-java — This project is a comprehensive Java backend engineering guide and technical reference focused on high-concurrency… rethinkdb/rethinkdb — RethinkDB is a distributed, document-oriented database designed to store and manage JSON-formatted data across… flike/kingshard — Kingshard is a MySQL database proxy and sharding middleware that routes SQL traffic between clients and multiple… vonng/ddia — This project serves as a comprehensive technical reference for the architecture and design of data-intensive…

Alternative open-source pentru Mycat Server

Proiecte open-source similare, clasificate după numărul de funcționalități comune cu Mycat Server.
  • pgdogdev/pgdogAvatar pgdogdev

    pgdogdev/pgdog

    3,361Vezi pe GitHub↗

    pgdog is a PostgreSQL sharding proxy, distributed SQL router, and connection pooler. It is designed to enable horizontal data distribution by splitting tables and indices across multiple independent servers to scale storage and processing capacity. The project distinguishes itself through online resharding capabilities, using logical replication to move data between shards without application downtime. It supports multiple routing strategies, including hash, list, and range-based query routing, and manages distributed atomic transactions using a two-phase commit process to ensure consistency

    Rustload-balancerpoolerpostgresql
    Vezi pe GitHub↗3,361
  • apache/shardingsphereAvatar apache

    apache/shardingsphere

    20,737Vezi pe GitHub↗

    ShardingSphere is a distributed SQL database middleware that provides sharding, read-write splitting, and distributed transaction management for relational databases. It functions as a layer that intercepts SQL queries to distribute data across multiple physical database instances for horizontal scaling. The project is distinguished by its ability to operate as either a standalone transparent database proxy or via direct integration as a JDBC driver. It features a SQL dialect translator that parses queries into abstract syntax trees to convert syntax between different database engines, enabli

    Java
    Vezi pe GitHub↗20,737
  • doocs/advanced-javaAvatar doocs

    doocs/advanced-java

    78,987Vezi pe GitHub↗

    This project is a comprehensive Java backend engineering guide and technical reference focused on high-concurrency design, distributed systems, and microservices architecture. It provides detailed strategies for decomposing monolithic applications, managing service discovery, and implementing the architectural patterns required for scalable backend environments. The repository distinguishes itself through an extensive collection of big data algorithmic references and database scaling strategies. It covers memory-efficient techniques for analyzing massive datasets, such as Top-K element extrac

    Javaadvanced-javadistributed-search-enginedistributed-systems
    Vezi pe GitHub↗78,987
  • rethinkdb/rethinkdbAvatar rethinkdb

    rethinkdb/rethinkdb

    26,996Vezi pe GitHub↗

    RethinkDB is a distributed, document-oriented database designed to store and manage JSON-formatted data across scalable clusters. It utilizes a custom log-structured storage engine with B-Tree indexing to ensure high-performance disk I/O and data persistence. The system maintains high availability through automatic sharding and replication, employing a primary-replica voting consensus mechanism to handle node failures and ensure consistent cluster operations. A defining characteristic of the platform is its reactive changefeed engine, which allows applications to subscribe to live data update

    C++
    Vezi pe GitHub↗26,996
Vezi toate cele 30 alternative pentru Mycat Server→