Shulou(Shulou.com)06/01 Report--

Amoeba for MySQL is committed to the distributed database front-end proxy layer of MySQL, which mainly acts as the query routing function when the application layer accesses MySQL, and focuses on the development of distributed database proxy. Located between Client and DB Server (s). Transparent to the client. It has load balancing, high availability, Query filtering, read-write separation, routing related query to the target database, and concurrent requests for merging results of multiple databases. On Amoeba, you can complete the functions of high availability, load balancing and data slicing of multiple data sources. At present, it is used in the production line of many enterprises.

So what is Amoeba for mysql to client programs? Let's just think of it as mysql, which is a virtual mysql that provides mysql protocols. The client connects to amoeba as if it were connected to mysql. See the following figure:

Amoeba for Aladdin

Similar to Amoeba for MySQL, the client must use the MySQL protocol to connect to Aladdin, and the reason for using the MySQL protocol is to rely on the extensive use of mysql and support for various development languages. The Aladdin backend can connect to various databases at the same time. As long as these databases provide jdbc drivers. The emergence of aladdin can solve the problem that enterprises can provide positive help in database consolidation. Users do not need to know what type of database and the physical address of the database are used at the back end. Aladdin analyzes the sql statements and obtains the corresponding tables and conditions to be queried, and then these rules are combined with these conditions to route to the relevant physical database.

Amoeba for MongoDB

With the increasing rise of NoSQL, mongoDB, as a nosql database, has received widespread attention because of its excellent performance. It can be said that mongoDB fills the gap between traditional relational database and traditional key database, and has both excellent characteristics. Amoeba for MongoDB will provide a completely autonomous and controllable segmentation method similar to Amoeba for MySQL, and try to accomplish the same auto sharding function. Based on the Amoeba framework, it has the same functions as heartbeat detection, load balancing, failover, query aggregation and so on, and retains the previous configuration. As long as you are familiar with the configuration of one of the amoeba products, it will be very easy to get started.

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.