+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
#112Mycat的使用情况统计汇总73 comments · 2015-01-23#1870致命缺陷!37 comments · 2018-06-08#23031.6.6.1 connect with MySQL8,ERROR 1184 (HY000): Invalid DataSource:032 comments · 2019-09-05#2039Mycat-Eye 添加mycat失败29 comments · 2018-10-26#2846cannot be cast to com.alibaba.druid.sql.dialect......18 comments · 2021-09-08#1745mysql连接异常及mycat报sql timeout问题18 comments · 2018-01-11#2483mycat 不支持分库分表?17 comments · 2020-05-29#2840此版本Mycat-server-1.6.7.6-release.jar不支持MySQL MAX()函数16 comments · 2021-08-30
Latest release
Mycat-server-1.6.7.6-test 1.6.76-release-2020-11-2 2020-11-02Mycat-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