# omycat

**Repository Path**: sunlightcode/omycat

## Basic Information

- **Project Name**: omycat
- **Description**: OMycat 基于 Mycat 搭建 Oracle 集群。OMycat builds Oracle cluster based on Mycat.
- **Primary Language**: Java
- **License**: GPL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2018-10-09
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### OMycat

OMycat is an Open-Source software, “a big database cluster” oriented to the enterprises. OMycat is an enforced database which is a replacement for MySQL and support transaction and ACID. Regarded as MySQL cluster of enterprise database, OMycat can take the place of expensive Oracle cluster. And as a new modern enterprise database product, OMycat is combined with the traditional database and new distributed data warehouse. In a word, OMycat is a fresh new middleware of database..

OMycat’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.

##### OMycat Key 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 multi-platform, easy deployment and implementation

##### OMycat adventage:

* Based on Ali open-source product Cobar, whose stability, reliability, excellent architecture and performance, as well as many mature use-case make OMycat have a good starting. Standing on the shoulders of giants, OMycat can be able to go farther.
* Extensively drawing on the best open-source projects and innovative ideas, which are integrated into the OMycat’s gene, make OMycat be ahead of the other current similar open-source projects, even beyond some commercial products.
* OMycat 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 OMycat.
* OMycat 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.

##### OMycat long-term plan:

* On the basis of MySQL’s support, OMycat add more support of commercial open-source database, including native support of PosteSQL, 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 reading and writing, OMycat automatically optimize 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 OMycat have data analysis capability