As of SQL Server 2008 R2, Microsoft has not released an official Server Load balancer component. It can only use other technical features of SQL Server or third-party components for DIY.
In previous articles, the editor also summarized some common implementation skills such as "sqlserver cluster", "sqlserver Data Synchronization", and "sqlserver failover. I will not explain it carefully today.
Today, we recommend that you use third-party components and tools, typically an ICX database route. Of course, I am not familiar with the manufacturers of these tools, so this article is obviously not an advertisement. Haha.
For a long time, SQL SERVER database servers have only "Hot Standby" solutions, but not "SERVER Load balancer" and "cluster" solutions. This solution improves the reliability of the system, but there are also some problems:
* In the face of large data volumes and a large number of database query requests, you can only vertically upgrade the server, but the cost of vertical increase is much higher than that of horizontal expansion.
* During Hot Backup, only one database server is working, and the other is idle for backup, resulting in a waste of investment.
* Non-real-time switching.
The emergence of database router software ICX provides a better cluster solution for database systems based on ms SQL Server. It can truly implement the number of SQL servers
The dynamic load balancing of the database Server improves the performance and speed. It can truly ensure uninterrupted service provision by the SQL Server database Server, when the server fails, the system switches to another server in real time to continue providing services. The switching time is "zero ".
The database router is a real-time concurrent Database Transaction Processing synchronous replicaset and Load balancer.
DATABASE router-ICX (I SEE X DATABASE SERVERS), that is, you can connect to N databases at the same time after ICX.
1. All database customers access the database through ICX.When accessing and querying the SQL Server database, ICX can allocate servers to provide services based on actual conditions, greatly improving service speed and optimizing performance, and implementing load balancing.
2. ICX can connect to multiple databases at the same time (2-16 databases, depending on the customer's specific needs). The contents of these databases are guaranteed by ICX at any time.
Consistent. That is to say, ICX adopts a new method of concurrent transaction processing to synchronize the transaction processing to the connected N databases, so that the system has multiple consistent
The latest logical database dataset. When one of the database servers fails, ICX can immediately switch to other servers to continue providing services. True
To achieve zero-time server switching, greatly improving security, and truly implement uninterrupted server services.