MyCATApache /Mycat-Server

★ 9,496⑂ 3,791👁 649⑃ 1,226● 1,725▤ 7
JavaGPL-2.0Created 2014-12-04
Download: Mycat-server-1.6.7.6-test1.6.76-release-2020-11-2 ↓22020-11-02
+1
Daily
9,496
stars
3,791
forks
649
watchers
1,226
prs
1,725
issues
7
releases

README

Mycat1

官网:  http://mycatone.top


gitee
github

提交代码,可以开issue,写清楚代码改动或者联系qq:1019100252

mycat1.6权威指南
yuque
pdf


客户端连接配置 
gitee
github


  

Mycat志愿者开发群:332702697,106088787






MyCAT is an Open-Source software, “a large database cluster” oriented to enterprises. MyCAT is an enforced database which is a replacement for MySQL and supports transaction and ACID. Regarded as MySQL cluster of enterprise database, MyCAT can take the place of expensive Oracle cluster. MyCAT is also a new type of database, which seems like a SQL Server integrated with the memory cache technology, NoSQL technology and HDFS big data. And as a new modern enterprise database product, MyCAT is combined with the traditional database and new distributed data warehouse. In a word, MyCAT is a fresh new middleware of database.

Mycat’s target is to smoothly migrate the current stand-alone database and applications to cloud side with low cost and to solve the bottleneck problem caused by the rapid growth of data storage and business scale.

2020年1月1日合拼了一个PR,优化PartionByLong的分片算法,数据不均衡的问题,所以该分片算法与此前的PartionByLong的数据分布不一致,即1.675之后与之前的版本不兼容
MyCAT1.6不支持一个SQL包含多个语句

旧Mycat升级fastjson,把pom.xml中fastjson的版本更改即可

1.6的bug:
批处理插入,多语句,堆外合拼,请大家要避开这些功能

全局序列号语法

sql
INSERT INTO travelrecord (id,user_id) VALUES ('next value for MYCATSEQ_GLOBAL',"xxx");


更新Druid 1.1.10版本的分支独立维护在
gitee
github



 Getting Started 
 gitee
 github

 尝试 MyCAT 
 gitee
 github

 Features

 Supports SQL 92 standard
 Supports MySQL cluster, used as a Proxy
 Supports JDBC connection with ORACLE, DB2, SQL Server, simulated as normal MySQL Server connection
 Supports MySQL cluster, percona cluster or mariadb cluster, providing high availability of data fragmentation clusters
 Supports automatic failover and high availability
 Supports separation of read and write, dual-master with multi-slave, single-master with multi-master of MySQL model
 Supports global table, automatically fragment data into multiple nodes for efficient relational query
 Supports the unique fragmentation strategy based on ER-relation for efficient relational query
 Supports multiple platforms, easy deployment and implementation

 Advantage

 Based on Alibaba's open-source project Cobar github,gitee, whose stability, reliability, excellent architecture and performance, as well as many mature use-cases make MyCAT have a good starting. Standing on the shoulders of giants, MyCAT feels confident enough to go farther.
 Extensively drawing on the best open-source projects and innovative ideas, which are integrated into the Mycat’s gene, make MyCAT be ahead of the other current similar open-source projects, even beyond some commercial products.
 MyCAT behind a strong technical team whose participants are experienced more than five years including some senior software engineer, architect, DBA, etc. Excellent technical team to ensure the product quality of Mycat.
 MyCAT does not rely on any commercial company. It’s unlike some open-source projects whose important 

Top issues

Latest release

Mycat-server-1.6.7.6-test 1.6.76-release-2020-11-2 2020-11-02
Mycat-server-1.6.7.6-test

日期倒序排列

1.2618 支持语法 SHOW full TABLES FROM TESTDB WHERE table_type = 'BASE TABLE'; [by funnyAnt]

2.2622 解决prepare因不支持mysql unsigned 类型导致的超出short范围报错 [by funnyAnt]

3.2619 PartitionByMod路由函数支持string参数 [by funnyAnt]

4.2590 应用端连接池发送的select 1,select 1 from dual心跳语句,直接在mycat层回包,不透传给mysql,防止影响性能 [by funnyAnt]

5.2598 修复Prepared Statement Id溢出Bug [by funnyAnt]

6.2591 prepare语句里面设置blob字段值,第一次执行的blob值会带入第二次执行的值里面 [by funnyAnt]

7.2589 批量Insert丢数据问题 [by funnyAnt]

8.2594 insert操作,当语句中有插入的值为转义符问题 [by naturelq]

9.2588 合并结果集时,偶现NPE异常 [by funnyAnt]

10.258

Snapshot: 2026-11-16T09:23:14Z · Data license Apache-2.0 · JSON