# [MyCAT](http://mycat.io/)
[![GitHub issues](https://img.shields.io/github/issues/MyCATApache/Mycat-Server.svg)](https://github.com/MyCATApache/Mycat-Server/issues)
[![GitHub forks](https://img.shields.io/github/forks/MyCATApache/Mycat-Server.svg)](https://github.com/MyCATApache/Mycat-Server/network)
[![GitHub stars](https://img.shields.io/github/stars/MyCATApache/Mycat-Server.svg)](https://github.com/MyCATApache/Mycat-Server/stargazers)
[![MyCAT](https://img.shields.io/badge/MyCAT-%E2%9D%A4%EF%B8%8F-%23ff69b4.svg)](http://mycat.io/)
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.
* [Getting Started](https://github.com/MyCATApache/Mycat-doc/tree/master/en)
* [尝试 MyCAT](https://github.com/MyCATApache/Mycat-doc/blob/master/MyCat_In_Action_%E4%B8%AD%E6%96%87%E7%89%88.doc)
## 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](https://github.com/alibaba/cobar), 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 features is enclosed in its commercial products and making open-source projects like a decoration.
## Roadmap
* On the basis of MySQL’s support, MyCAT add more support of commercial open-source database, including native support of PostgreSQL, FireBird and other open-source databases, as well as indirect support via JDBC of other non-open-source databases such as Oracle, DB2, SQL Server etc.
* More intelligent self-regulating properties, such as automatic statistical analysis of SQL, automatic creating and adjusting indexes. Based on the frequency of read and write, MyCAT automatically optimizes caching and backup strategies
* Achieve a more comprehensive monitoring and management
* Integrated with HDFS, provide SQL commands, load databases into HDFS for rapid analysis
* Integrated excellent open-source reporting tools to make MyCAT have data analysis capability
## Download
There are some compiled binary installation packages in Mycat-download project on github at [Mycat-download](https://github.com/MyCATApache/Mycat-download).
## Document
There are some documents in Mycat-doc project on github at [Mycat-doc](https://github.com/MyCATApache/Mycat-doc).
Mycat 简单demo,具体参考Mycat权威指南
官网 : mycat.io
qq官方群:106088787
Mycat权威指南官方下载:http://songwie.com/attached/file/mycat_1.5.2.pdf
wiki:<a href="https://github.com/MyCATApache/Mycat-Server/wiki"> wiki</a>
# Mycat前世今生
2013年阿里的Cobar在社区使用过程中发现存在一些比较严重的问题,及其使用限制,经过Mycat发起人第一次改良,第一代改良版——Mycat诞生。 Mycat开源以后,一些Cobar的用户参与了Mycat的开发,最终Mycat发展成为一个由众多软件公司的实力派架构师和资深开发人员维护的社区型开源软件。
2014年Mycat首次在上海的《中华架构师》大会上对外宣讲,更多的人参与进来,随后越来越多的项目采用了Mycat。
2015年5月,由核心参与者们一起编写的第一本官方权威指南《Mycat权威指南》电子版发布,累计超过500本,成为开源项目中的首创。
2015年10月为止,Mycat项目总共有16个Committer。
截至2015年11月,超过300个项目采用Mycat,涵盖银行、电信、电子商务、物流、移动应用、O2O的众多领域和公司。
截至2015年12月,超过4000名用户加群或研究讨论或测试或使用Mycat。
Mycat是基于开源cobar演变而来,我们对cobar的代码进行了彻底的重构,使用NIO重构了网络模块,并且优化了Buffer内核,增强了聚合,Join等基本特性,同时兼容绝大多数数据库成为通用的数据库中间件。1.4 版本以后 完全的脱离基本cobar内核,结合Mycat集群管理、自动扩容、智能优化,成为高性能的中间件。我们致力于开发高性能数据库中间而努力。永不收费,永不闭源,持续推动开源社区的发展。
Mycat吸引和聚集了一大批业内大数据和云计算方面的资深工程师,Mycat的发展壮大基于开源社区志愿者的持续努力,感谢社区志愿者的努力让Mycat更加强大,同时我们也欢迎社区更多的志愿者,特别是公司能够参与进来,参与Mycat的开发,一起推动社区的发展,为社区提供更好的开源中间件。
Mycat还不够强大,Mycat还有很多不足,欢迎社区志愿者的持续优化改进。
# 关键特性
支持SQL92标准
遵守Mysql原生协议,跨语言,跨平台,跨数据库的通用中间件代理。
基于心跳的自动故障切换,支持读写分离,支持MySQL主从,以及galera cluster集群。
支持Galera for MySQL集群,Percona Cluster或者MariaDB cluster
基于Nio实现,有效管理线程,高并发问题。
支持数据的多片自动路由与聚合,支持sum,count,max等常用的聚合函数。
支持单库内部任意join,支持跨库2表join,甚至基于caltlet的多表join。
支持通过全局表,ER关系的分片策略,实现了高效的多表join查询。
支持多租户方案。
支持分布式事务(弱xa)。
支持全局序列号,解决分布式下的主键生成问题。
分片规则丰富,插件化开发,易于扩展。
强大的web,命令行监控。
支持前端作为mysq通用代理,后端JDBC方式支持Oracle、DB2、SQL Server 、 mongodb 、巨杉。
支持密码加密
支持服务降级
支持IP白名单
支持SQL黑名单、sql注入攻击拦截
支持分表(1.6)
集群基于ZooKeeper管理,在线升级,扩容,智能优化,大数据处理(2.0开发版)。
# Mycat安装与使用
## 下载:
[https://github.com/MyCATApache/Mycat-download](https://github.com/MyCATApache/Mycat-download)
具体
没有合适的资源?快使用搜索试试~ 我知道了~
Mycat-Server.zip
共1124个文件
java:998个
xml:29个
txt:23个
需积分: 5 0 下载量 123 浏览量
2023-08-18
09:24:36
上传
评论
收藏 1.82MB ZIP 举报
温馨提示
Mycat-Server
资源推荐
资源详情
资源评论
收起资源包目录
Mycat-Server.zip (1124个子文件)
startup_nowrap.bat 618B
test_stand_select_perf.bat 607B
test_stand_update_perf.bat 606B
test_globaltable_insert_perf.bat 605B
test_stand_merge_sel_perf.bat 605B
test_globalseq_insert_perf.bat 596B
test_stand_insert_perf.bat 594B
testng-reports.css 5KB
testng.css 303B
schema.dtd 3KB
server.dtd 2KB
rule.dtd 1KB
collapseall.gif 157B
.gitignore 2KB
.gitignore 40B
index.html 9KB
Default test.html 2KB
emailable-report.html 1KB
toc.html 1KB
index.html 731B
testng.xml.html 722B
methods-alphabetical.html 217B
methods.html 217B
index.html 186B
main.html 119B
classes.html 95B
methods-not-run.html 50B
reporter-output.html 39B
groups.html 38B
RouterUtil.java 62KB
ManagerParseShow.java 60KB
DruidMysqlRouteStrategyTest.java 53KB
MycatSchemaStatVisitor.java 49KB
PureJavaCrc32.java 35KB
TimSort.java 34KB
MycatServer.java 32KB
UnsafeRowGrouper.java 31KB
XMLSchemaLoader.java 30KB
BytesToBytesMap.java 30KB
UTF8String.java 29KB
BytesTools.java 29KB
ErrorCode.java 29KB
ServerLoadDataInfileHandler.java 28KB
UTF8StringSuite.java 28KB
DruidSelectParser.java 28KB
DruidMycatRouteStrategy.java 28KB
SystemConfig.java 27KB
ServerParserTest.java 27KB
MultiNodeQueryHandler.java 27KB
GlobalTableUtil.java 26KB
JDBCConnection.java 25KB
MongoResultSet.java 25KB
SequoiaResultSet.java 25KB
UnsafeExternalSorter.java 23KB
RingBuffer.java 23KB
MysqlDefs.java 23KB
BinlogStream.java 22KB
AbstractBytesToBytesMapSuite.java 22KB
ServerParse.java 22KB
ManagerParserTest.java 21KB
PhysicalDBPool.java 20KB
NonBlockingSession.java 20KB
ServerParseSet.java 20KB
MySQLConnection.java 19KB
PhysicalDatasource.java 19KB
DataNodeMergeManager.java 17KB
UnsafeRow.java 17KB
DecryptUtil.java 17KB
FastByteOperations.java 17KB
DataNodeMemoryManager.java 16KB
SingleNodeHandler.java 16KB
FrontendConnection.java 15KB
StringUtil.java 15KB
ShareJoin.java 15KB
AbstractConnection.java 15KB
SwitchCommitListener.java 15KB
ByteBufferUtil.java 14KB
DDLRouteTest.java 14KB
MigrateHandler.java 14KB
UnsafeExternalSorterSuite.java 14KB
Platform.java 14KB
PostgreSQLBackendConnection.java 14KB
MycatSchemaStatVisitorTest.java 14KB
SequoiaSQLParser.java 14KB
MongoSQLParser.java 13KB
ServerParseSelect.java 13KB
PostgreSQLBackendConnectionHandler.java 13KB
RandomDataValueUtil.java 13KB
DistributedSequenceHandler.java 13KB
ShowDirectMemory.java 12KB
ParseUtil.java 12KB
MigrateUtilsTest.java 12KB
CalendarInterval.java 12KB
XMLServerLoader.java 12KB
DruidSelectOracleParser.java 12KB
RouteResultset.java 12KB
RowDataPacketGrouper.java 12KB
BinaryRowDataPacket.java 12KB
DataMigratorUtil.java 12KB
DruidUpdateParser.java 12KB
共 1124 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
hello_中年人
- 粉丝: 7
- 资源: 324
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功