![]() |
![]() |
![]() |
||||||
| Solutions | Very Large Scale Database Cluster | |||
Very Large Scale Database ClusterThere are limitations on the largest possible database that can be managed by a single SQL Server. Once the application's data requirement grows beyond that size, data partition is necessary. Traditionally, partitioned database is referred to as "federated databases". The overall database image is represented by a set of SQL Servers, each managing a designated partition of the overall database. Federated databases gain in performance due to reduced dataset size managed by each SQL Server. They suffer reduced availability and increased management complexity. The service status of any SQL Server directly impacts the entire system's availability. There are at least three different ways we can apply DBx™ technology to enhance the federated databases:
Shifted replication of partitioned datasets can achieve significant performance advantages for update and read-only queries while maintaining the same high availability benefits. |
|||