DBProxy getting started to master series (1): DBProxy overview, dbproxy getting started to master

DBProxy getting started to master series (1): DBProxy overview, dbproxy getting started to master

DBProxy Overview

DBProxy is a middleware that supports database/table sharding and read/write splitting. In addition to reading the github official documentation, the blog content will also include my personal test results, but I understand a middleware, we need to have a basic understanding of this middleware to facilitate control.

There are actually a lot of current middleware, such as mycat, sharding-jdbc, DRDBS, and kingshard. Each software has its own characteristics. However, most of the currently recommended middleware in the industry is DBProxy. the attitude of R & D personnel of Meituan towards this component is more pragmatic and rigorous. If you are an expert on this middleware, contact me for discussion.

 

1 Overview

DBProxy is a MySQL-based Data Middle Layer developed and maintained by the DBA Team of the Technical Engineering Department (Beijing) of the comments company. Based on the open-source Atlas of Qihoo 360, it modified some bugs and added many features. At present, DBProxy is widely used in Meituan reviews, including Meituan payment, Hotel Tourism, takeout, Group Buying and other product lines. The company's internal development of DBProxy is fully transferred to github, and the open source and internal use are consistent. Currently, only MySQL (Percona) 5.5 and 5.6 are supported.

Main functions:

2 DBProxy compared with open source Atlas of Qihoo 360

3 DBProxy