Dbproxy Introduction to Mastery Series (i):D bproxy overview

Dbproxy Overview

Dbproxy is to support sub-database sub-table, read and write separate middleware, blog content in addition to reading the official GitHub documents, but also attached to my personal test results, but understand a middleware, need to have a basic understanding of this middleware, convenient control.

The current middleware is actually a lot, there are mycat,sharding-jdbc,drdbs,kingshard and so on, each software has its own characteristics, But the industry is now recommending more than the Dbproxy. And from the U.S. team's research and development staff on the component's attitude, but also more pragmatic and relatively rigorous. If you have a study of this middleware, you can also contact me here to Exchange

1 Introduction

Dbproxy is a MySQL protocol-based data middle layer developed and maintained by the company's technical Engineering DBA team (Beijing). It has modified some bugs and added many features on the basis of the open source Atlas of Qihoo 360. currently dbproxy is widely used in the United States, including corporate payment, hotel tours, take-away, buy and other product lines, the company's internal development of Dbproxy to GitHub, open source and internal use consistent . Currently only MySQL (Percona) 5.5 and 5.6 are supported.

Main functions:

1. Read/write separation
2. Load Balancing from Library
3. IP filtering
4. Sub-table
5. DBA can smooth up and down line db
6. Automatically remove the DB for downtime
7. Complete monitoring Information
8. SQL filtering
9. From library traffic configuration

2 Dbproxy relative Yuchihu 360 company Open Source Atlas Improvements

1. Modified some bugs and added some feature, see Release Notes
   
2. Provides a wealth of monitoring information, a large number of parameters can be configured and support dynamic modification
3. The original modules such as logs are optimized for improved performance
4. The open source version is the current US review internal use version, and will always maintain the source code and its documentation

3 Dbproxy Detailed description

　　

1. Dbproxy Quick Start Tutorial
2. Dbproxy User Manual
3. Dbproxy Development Handbook
4. Dbproxy Architecture and Practice
5. Dbproxy Release Notes
6. Dbproxy Test Manual
7. FAQs
8. Dbproxy Development Code

Dbproxy Introduction to Mastery Series (i):D bproxy overview