Introduction to key features of Mycat

Key features:

Support for SQL92 standards

Common SQL syntax that supports DB such as MySQL, Oracle, DB2, SQL Server, PostgreSQL, etc.

Comply with Mysql native protocol, cross-language, cross-platform, cross-database general middleware agent.

Automatic failover based on heartbeat, support for read-write separation, support for MySQL master-slave, and galera cluster clustering.

Support Galera for MySQL cluster, Percona Cluster or MariaDB cluster

Based on Nio implementation, effectively manage threads and solve the problem of high concurrency.

Support automatic routing and aggregation of multiple pieces of data, support common aggregation functions such as sum,count,max, and support paging across databases.

Support arbitrary join within a single library, support cross-library 2-table join, and even multi-table join based on caltlet.

It supports the slicing strategy of global table and ER relationship, and realizes efficient multi-table join query.

Support the multi-tenant scheme.

Support for distributed transactions (weak xa).

Support for XA distributed transactions (1.6.5).

Support global serial number to solve the problem of primary key generation in distributed environment.

Slicing rules are rich, plug-in development, easy to expand.

Powerful web, command line monitoring.

The frontend is supported as a general proxy for MySQL, and the backend JDBC supports Oracle, DB2, SQL Server, mongodb, and giant sequoia.

Support password encryption

Support service degradation

Support IP whitelist

Support SQL blacklist and sql injection attack interception

Support for prepare precompiled instructions (1.6)

Support for non-heap memory (Direct Memory) aggregate computing

Native protocol supporting PostgreSQL (1.6)

Support for mysql and oracle stored procedures, out parameters, multiple result set returns (1.6)

Support zookeeper coordination master-slave handover, zk sequence, configuration zkization (1.6)

Support for sub-tables in the library (1.6)

The cluster is based on ZooKeeper management, online upgrade, expansion, intelligent optimization, big data processing (2.0 development version).