Shulou(Shulou.com)05/31 Report--

How to use and configure Mysql KingShard middleware, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

Kingshard

Main functions: 1. Separation of reading and writing. two。 Sub-tables across nodes. 3. Support transparent MySQL connection pooling without having to create a new connection every time. 4. Support client-side IP access control. 5. Smooth online DB or offline DB, without perception of front-end applications. 6. Load balancing among multiple slave,slave is supported through weights. 7. Support for forced reading of the main library. 8. Support for sending sql to a specific node. 9. Transactions are supported on a single node, but not across multiple node. 10. Functions such as count,sum,max and min across node are supported. 11. Supports the join operation of a single split table, that is, supports the join operation of a separate table and another undivided table. twelve。 Order by,limit and other operations are supported. 13. Supports the prepare feature of mysql in the mainstream language (java,php,python,C/C++,Go) SDK. 14. The maximum number of connections to the backend DB is supported. 15. Support SQL log and slow log output.

Mark for a moment

Http://git.oschina.net/flikecn/kingshard/blob/master/README_ZH.md?dir=0&filepath=README_ZH.md&oid=587ed1d27a89c8b2f6ff05ef9a6681189e14b1d9&sha=fd5931b9ad64295797cdc1b81f1c95c8d276cca5

The experimental environment is under the directory of simulator 56

/ usr/local/Applications/Go/src/github.com/flike/kingshard

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.