SqlServerProxy, the ultimate tool for Server Load balancer horizontal scaling

MySQL has always been open-source and has produced many extension solutions, such as Amoeba, Atlas, Cobar, and MySQLProxy. Most of them are customized based on MySQL communication protocols, which makes us envy, however, Microsoft does not provide a similar solution, but now, with SqlServerProxy, it brings us the dawn that we can

MySQL has always been open-source and has produced many extension solutions, such as Amoeba, Atlas, Cobar, and MySQLProxy. Most of them are customized based on MySQL communication protocols, which makes us envy, however, Microsoft does not provide a similar solution, but now, with SqlServerProxy, it brings us the dawn that we can

MySQL has always been open-source and has produced many extension solutions, such as Amoeba, Atlas, Cobar, and MySQLProxy. Most of them are customized based on MySQL communication protocols, which makes us envy, but there is no way. Microsoft does not provide a similar solution, but now, with SqlServerProxy, it brings us the dawn and can be customized based on our own requirements.

Basic deployment architecture of SqlServerProxy

The feature of SqlServerProxy is to maximize the release of our skills. Only customized according to business needs can we meet our perfect expectations. The most important part of business demand customization is request distribution. Some have high real-time requirements and some have low requirements. A large and unified solution may not be able to meet these requirements. SqlServerProxy has a feature that provides a request Distribution implementation based on regular expression matching. You only need to modify the configuration file to easily meet the requirements. In addition, there are other features.

CompatibilityIt is transparent to applications and is compatible with all versions from SQL Server 2000 to SQL Server 2014 without version upgrade.

Built-in commandsAllows you to conveniently view SqlServerProxy history, real-time, single-Client Traffic, requests, and transactions.

Interface CustomizationBy default, the interface based on regular expression matching is insufficient for other reasons. You can implement specific interfaces and encapsulate your own obligation logic to maximize the Load Balancing Capability.

Compatibility is easy to understand. built-in commands are specific SQL statements that return internal statistics of SqlServerProxy. For example, if you execute "SELECT vt_active;" on the port listened by SqlServerProxy, the following list columns are returned:

Built-in command for viewing active sessions

A built-in command for viewing real-time traffic and requests is also provided, which is a useful command for viewing loads.

View real-time statistics commands

Then, you can focus on maximizing the Load Balancing Capability according to the business logic.

For details, including all available commands, you can download SqlServerProxy and view related documents.

However, SqlServerProxy does not currently have the built-in data sharding function. Data sharding needs to be related to specific services. It is estimated that it must be customized (contact me if necessary ).

Also, it can be seen that SqlServerProxy does not synchronize data. Data Synchronization depends on Database Replication and other technologies, but it shares the pressure on the master server and should speed up data synchronization, to the quasi-real-time data level.

The latest version of. NET Framework has been reduced to. NET 4 and now supports Windows XP and Windows Server 2003. For details, see the installation documentation.

: Http://www.projky.com/downloads/3a382709-d680-476c-853d-dc3af5c625de/SqlServerProxy.zip

This blog address: http://www.cnblogs.com/ProJKY/p/SqlServerProxy.html mailbox: projky@126.com hope you more advice.