kandi background
Explore Kits

Mycat-Server | OpenSource software | Database library

 by   MyCATApache Java Version: 1.6.76-release-2020-11-2 License: GPL-2.0

 by   MyCATApache Java Version: 1.6.76-release-2020-11-2 License: GPL-2.0

Download this library from

kandi X-RAY | Mycat-Server Summary

Mycat-Server is a Java library typically used in Database, Oracle applications. Mycat-Server has no bugs, it has no vulnerabilities, it has build file available, it has a Strong Copyleft License and it has medium support. You can download it from GitHub.
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.
Support
Support
Quality
Quality
Security
Security
License
License
Reuse
Reuse

kandi-support Support

  • Mycat-Server has a medium active ecosystem.
  • It has 9250 star(s) with 3895 fork(s). There are 681 watchers for this library.
  • It had no major release in the last 12 months.
  • There are 905 open issues and 777 have been closed. On average issues are closed in 97 days. There are 9 open pull requests and 0 closed requests.
  • It has a neutral sentiment in the developer community.
  • The latest version of Mycat-Server is 1.6.76-release-2020-11-2
Mycat-Server Support
Best in #Database
Average in #Database
Mycat-Server Support
Best in #Database
Average in #Database

quality kandi Quality

  • Mycat-Server has 0 bugs and 0 code smells.
Mycat-Server Quality
Best in #Database
Average in #Database
Mycat-Server Quality
Best in #Database
Average in #Database

securitySecurity

  • Mycat-Server has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
  • Mycat-Server code analysis shows 0 unresolved vulnerabilities.
  • There are 0 security hotspots that need review.
Mycat-Server Security
Best in #Database
Average in #Database
Mycat-Server Security
Best in #Database
Average in #Database

license License

  • Mycat-Server is licensed under the GPL-2.0 License. This license is Strong Copyleft.
  • Strong Copyleft licenses enforce sharing, and you can use them when creating open source projects.
Mycat-Server License
Best in #Database
Average in #Database
Mycat-Server License
Best in #Database
Average in #Database

buildReuse

  • Mycat-Server releases are available to install and integrate.
  • Build file is available. You can build the component from source.
  • Installation instructions, examples and code snippets are available.
Mycat-Server Reuse
Best in #Database
Average in #Database
Mycat-Server Reuse
Best in #Database
Average in #Database
Top functions reviewed by kandi - BETA

kandi has reviewed Mycat-Server and discovered the below as its top functions. This is intended to give you an instant insight into Mycat-Server implemented functionality, and help decide if they suit your requirements.

  • Create a PreparedStatement for CallableStatement .
  • start server
  • Checks if two arrays are equal
  • find route with css and conditions
  • Parse sql server select query .
  • Show direct memory .
  • Converts a FieldPacket to a FieldPacket
  • Converts a hexadecimal string into an array of bytes .
  • Parse aggregate .
  • Reload all configuration

Mycat-Server 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 multiple platforms, easy deployment and implementation

default

copy iconCopydownload iconDownload
INSERT INTO `travelrecord` (`id`,user_id) VALUES ('next value for MYCATSEQ_GLOBAL',"xxx");

配置:

copy iconCopydownload iconDownload
  --server.xml:是Mycat服务器参数调整和用户授权的配置文件。

  --schema.xml:是逻辑库定义和表以及分片定义的配置文件。

  --rule.xml:  是分片规则的配置文件,分片规则的具体一些参数信息单独存放为文件,也在这个目录下,配置文件修改需要重启MyCAT。

  --log4j.xml: 日志存放在logs/log中,每天一个文件,日志的配置是在conf/log4j.xml中,根据自己的需要可以调整输出级别为debug                           debug级别下,会输出更多的信息,方便排查问题。

  --autopartition-long.txt,partition-hash-int.txt,sequence_conf.properties, sequence_db_conf.properties 分片相关的id分片规则配置文件

  --lib	    MyCAT自身的jar包或依赖的jar包的存放目录。

  --logs        MyCAT日志的存放目录。日志存放在logs/log中,每天一个文件

配置server.xml

copy iconCopydownload iconDownload
<system>

	<property name="defaultSqlParser">druidparser</property>

</system>

<user name="mycat">

	<property name="password">mycat</property>

	<property name="schemas">user,pay</property>

</user>

编辑schema.xml

copy iconCopydownload iconDownload
<schema name="user" checkSQLschema="false" sqlMaxLimit="100" dataNode="user" />
<schema name="pay"  checkSQLschema="false" sqlMaxLimit="100" dataNode="pay" >
   <table name="order" dataNode="pay1,pay2" rule="rule1"/>
</schema>

<dataNode name="user" dataHost="host" database="user" />
<dataNode name="pay1" dataHost="host" database="pay1" />
<dataNode name="pay2" dataHost="host" database="pay2" />

<dataHost name="host" maxCon="1000" minCon="10" balance="0"
   writeType="0" dbType="mysql" dbDriver="native">
   <heartbeat>select 1</heartbeat>
   <!-- can have multi write hosts -->
   <writeHost host="hostM1" url="192.168.0.2:3306" user="root" password="root" />
   <writeHost host="hostM2" url="192.168.0.3:3306" user="root" password="root" />
</dataHost>

配置Mycat环境参数

copy iconCopydownload iconDownload
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://org.opencloudb/">
   <system>
	  <property name="defaultSqlParser">druidparser</property>
    </system> 
 </mycat:server>

配置Mycat逻辑库与用户

copy iconCopydownload iconDownload
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://org.opencloudb/">
<user name="mycat">
	<property name="password">mycat</property>
	<property name="schemas">TESTDB</property>
</user>
 </mycat:server>

配置逻辑库(schema)

copy iconCopydownload iconDownload
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">

<mycat:schema  xmlns:mycat="http://org.opencloudb/">
  <schema name="TESTDB" checkSQLschema="true" sqlMaxLimit="100" dataNode="dn1">
      <table name="t_user" dataNode="dn1,dn2" rule="sharding-by-mod2"/>
      <table name="ht_jy_login_log" primaryKey="ID" dataNode="dn1,dn2" rule="sharding-by-date_jylog"/>
  </schema>
  <dataNode name="dn1" dataHost="localhost1" database="mycat_node1"/>
  <dataNode name="dn2" dataHost="localhost1" database="mycat_node2"/>
  
  <dataHost name="localhost1" writeType="0" switchType="1" slaveThreshold="100" balance="1" dbType="mysql" maxCon="10" minCon="1" dbDriver="native">
    <heartbeat>show status like 'wsrep%'</heartbeat>
    <writeHost host="hostM1" url="127.0.0.1:3306" user="root" password="root" >
    </writeHost>  
  </dataHost>
</mycat:schema >

逻辑表配置

copy iconCopydownload iconDownload
      <table name="t_user" dataNode="dn1,dn2" rule="sharding-by-mod2"/>

配置分片(dataNode)

copy iconCopydownload iconDownload
  <dataNode name="dn1" dataHost="localhost1" database="mycat_node1"/>
  <dataNode name="dn2" dataHost="localhost1" database="mycat_node2"/>

配置物理库分片映射(dataHost)

copy iconCopydownload iconDownload
  <dataHost name="localhost1" writeType="0" switchType="1" slaveThreshold="100" balance="1" dbType="mysql" maxCon="10" minCon="1" dbDriver="native">
    <heartbeat>show status like 'wsrep%'</heartbeat>
    <writeHost host="hostM1" url="127.0.0.1:3306" user="root" password="root" >
    </writeHost>  
  </dataHost>

表切分规则

copy iconCopydownload iconDownload
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:rule SYSTEM "rule.dtd">

<mycat:rule  xmlns:mycat="http://org.opencloudb/">
  <tableRule name="sharding-by-hour">
    <rule>
      <columns>createTime</columns>
      <algorithm>sharding-by-hour</algorithm>
    </rule>
  </tableRule>
  
  <function name="sharding-by-hour" class="org.opencloudb.route.function.LatestMonthPartion">
    <property name="splitOneDay">24</property>
  </function>
   
</mycat:rule >

Community Discussions

Trending Discussions on Database
  • How to create or alter a DB schema dynamically (at run time) using Gramex FormHandler
  • What does stopping the runtime while uploading a dataset to Hub cause?
  • MongoDB query all documents contains ids that does not exist anymore in the collection
  • Is it possible to change the active user for a PostgreSQL connection?
  • null is not an object Sqlite + ReactNative expo Typescript
  • Indexing for GROUP BY in CosmosDB
  • Is there a way to implement cassandra "decimal" Datatype in Golang
  • How do I copy a big database table to another in ABAP?
  • Upgrade H2 version 2.0.202 from 1.4.200
  • What are the backend service for flutter?
Trending Discussions on Database

QUESTION

How to create or alter a DB schema dynamically (at run time) using Gramex FormHandler

Asked 2022-Apr-08 at 06:35

I want to be able to (at run time) create or alter a DB schema dynamically on a particular event (e.g. click of a button) using FormHandler microservice of Gramex.

ANSWER

Answered 2022-Apr-08 at 06:20

You can do it using queryfunction of FormHandler which can modify the query based on the query parameters passed in the url.

Refer the link below for more https://gramener.com/gramex/guide/formhandler/#formhandler-queryfunction

Source https://stackoverflow.com/questions/71792397

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install Mycat-Server

There are some compiled binary installation packages in Mycat-download project on github at Mycat-download.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

DOWNLOAD this Library from

Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
over 430 million Knowledge Items
Find more libraries
Reuse Solution Kits and Libraries Curated by Popular Use Cases

Save this library and start creating your kit

Explore Related Topics

Share this Page

share link
Compare Database Libraries with Highest Support
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
over 430 million Knowledge Items
Find more libraries
Reuse Solution Kits and Libraries Curated by Popular Use Cases

Save this library and start creating your kit

  • © 2022 Open Weaver Inc.