Database Load Balancing
Database Load Balancing Software Overview
What is Database Load Balancing Software?Database Load Balancing Software is a mechanism for distributing load over a cluster of SQL databases. There are many ways of achieving this, of which the following are some of the best known:
- Replication: Replication involves distributing load to geographically dispersed servers and then synchronizing them at a set frequency like overnight.
- Log Shipping: Log shipping involves taking the transaction logs from the originating server, transferring them to the destination system, and restoring them automatically on a database that is in restore mode on the receiving server.
- Database Mirroring: Database mirroring can be used to mirror transactions to one standby server. In this case, the database on the standby server is in restore mode as in in the log shipping scenario. It's also possible to do snapshotting where a snapshot of the database at a moment in time which can then be used for reporting and analytics.
Database Load Balancing Products
ScaleArc for SQL Server (other versions available for MySQL and Oracle) is database load balancing software that promises to increase uptime, performance, and scale out for applications leveraging the Microsoft SQL Server database. The software drops in between applications and databases and...
ScaleArc for MySQL (other versions available for SQL Server and Oracle) is database load balancing software that promises to increase uptime, performance, and scale out for applications leveraging the MySQL database. The software drops in between applications and databases and directs queries...
The Hitachi Tiered Storage Manager (HTSM, formerly under the HiCommand brand name) is a database administration application providing storage service level control.