查看: 5840|回复: 0

[负载] MySQL Router

发表于 2015-12-25 14:36:57 | 显示全部楼层 |阅读模式

MySQLRouter is lightweight middleware that provides transparent routing between yourapplication and any backend MySQL Servers. It can be used for a wide variety ofuse cases, such as providing high availability and scalability by effectivelyrouting database traffic to appropriate backend MySQL Servers. The pluggablearchitecture also enables developers to extend MySQL Router for custom usecases.

Typically,a highly available MySQL setup consists of a single master and multiple slavesand it is up to the application to handle failover, in case the MySQL masterbecomes unavailable. Using MySQL Router, application connections will betransparently routed based on load balancing policy, without implementingcustom application code.

Load Balancing
MySQLRouter provides additional scalability and performance by distributing databaseconnections across a pool of servers. For example, if you have a replicated setof MySQL Servers, MySQL Router can distribute application connections to themin a round-robin fashion.

Pluggable Architecture
MySQLRouter's pluggable architecture allows MySQL developers to easily extend theproduct with additional features, as well as providing MySQL users with theability to create their own custom plugins providing endless possibilities.MySQL Router currently ships with a number of core plugins, including:
  • Connection     Routing plugin which does connection-based routing, meaning that it     forwards the MySQL packets to the backend server without inspecting or     modifying them, thus providing maximum throughput.
  • The Fabric Cache plugin     which provides transparent MySQL Fabric support to your applications for     additional High Availability, and data Sharding.

您需要登录后才可以回帖 登录 | 注册


QQ|申请友链|小黑屋|Archiver|手机版|MySQL社区 ( 京ICP备07012489号   
联系人:周生; 联系电话:13911732319

GMT+8, 2024-7-22 12:41 , Processed in 0.085838 second(s), 32 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表